Graph Management - No Data Sources to Choose From

[fmangeant]

On my test system (see versions in my signature), I have this problem with fresh installation of 0.8.6h + patches and 0.8.6i-beta. After the first login, without any modification to the templates, graph miss the data sources.

Do you me to start over a new installation and upload the database ?

[reset]

i'm greenhorn with cacti. My first used version is 0.8.6h

[jjhuff]

That check box in the template is checked on nearly all of my graphs. I tried changing it on one, but it didn't make any difference.

Also, the issue is present on graphs using both data queries and normal DIMs.

thanks!

[reset]

i found in script rrd.php, line 535 is a view which returns null in a few neccesary fields

/* lets make that sql query... */
$graph_items = db_fetch_assoc("select
graph_templates_item.id as graph_templates_item_id,
graph_templates_item.cdef_id,
graph_templates_item.text_format,
graph_templates_item.value,
graph_templates_item.hard_return,
graph_templates_item.consolidation_function_id,
graph_templates_item.graph_type_id,
graph_templates_gprint.gprint_text,
colors.hex,
data_template_rrd.id as data_template_rrd_id,
data_template_rrd.local_data_id,
data_template_rrd.rrd_minimum,
data_template_rrd.rrd_maximum,
data_template_rrd.data_source_name,
data_template_rrd.local_data_template_rrd_id
from graph_templates_item
left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)
left join colors on (graph_templates_item.color_id=colors.id)
left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id)
where graph_templates_item.local_graph_id=$local_graph_id
order by graph_templates_item.sequence");

[reset]

it doesn't select necessary templates, there should be problem.

[rony]

I will be looking at this issue tonight.

[TheWitness]

Reset, you issue is different. Tony, can you please split this topic. Frag, we need dumps prior to (when it was Ok) and after you upgraded. In addition, intclude the id's of the problematic Graph instances...

TheWitness

[Fred]

Frag, we need dumps prior to (when it was Ok) and after you upgraded. In addition, intclude the id's of the problematic Graph instances...

I think you were talking to me here. Frag is approximately equal to Fred.

Problem is, I don't know when the database was okay. I don't generally make changes to existing graphs. Only changes I need to make are usually to add devices/graphs. So, I can't get you a dump from when it was okay.

As far as which instances are problematic, I have yet to find one that isn't problematic. None of the graphs have data sources, whether they're old or new. Again, the graphs work fine until I try to change them.

Did any of you clear the checkbox in the Graph Template to automatically name the Graph in an effort to change the names of your graphs?

This checkbox is cleared for some templates, and checked for others.

Are these problems associated with Data Query related Graph Templates or simple SNMP/Script type Graph Templates.

Both. Appears to be affecting every single graph.

[reset]

is anywhere a documentation / scheme of dB and Cacti application? I will look on my problem.

[rony]

Well.....

First, Fred, you are running 0.8.6g, you should consider upgrading, but not until you run a check and repair on your database.

All of you experinceing this problem need to run a check and repair. Check out the mysqlcheck utility.

Also, what version of mysql and php are you using. Also, what Distro are you running? Did you install Cacti from Source (tar.gz), RPM from cacti.net, or the distros package system?

I need to know the above information, because, I can't replicate this issue on my developement environment.

[gandalf]

i tried to make tamplate graphs few times, steps:

1) data input methods
2) data templates
3) data source
5) host template
6) device
7) graph template
graph management

without templates graphs works fine, but i want to use template, because i have many data sources and bla bla

You may have a look at the second to last link of my signature. You'll find there a walkthrough on how to generate own templates and stuff. IMHO, this procedure should work for you. If not, please advise, which step fails
Reinhard

[Fred]

Also, what version of mysql and php are you using. Also, what Distro are you running? Did you install Cacti from Source (tar.gz), RPM from cacti.net, or the distros package system?

I'm running php 4.4.2, mysql 4.1.20, on a Gentoo machine. Installed cacti from the Gentoo ebuild.

First, Fred, you are running 0.8.6g, you should consider upgrading, but not until you run a check and repair on your database.

Ran a check and repair on the database. Everything registered 'OK'. Went ahead and completed the upgrade to 0.8.6h. Problem persists.

[rony]

Gentoo... Um...

What version of ADODB is installed?

[fmangeant]

Hi Tony

I'm using Gentoo Linux too...

This morning I tried to reproduice this "bug", by reinstalling from scratch Cacti 0.8.6g patched, 0.8.6h patched and 0.8.6i beta, but I did not have the problem anymore...

AFAIK, ADOdb is not installed by Gentoo, so Cacti is using the version in lib/adodb

[Fred]

What version of ADODB is installed?

Hmm... Difficult to say. The 'adodb' package from Gentoo was not installed on my system. The only references to adodb (via 'slocate adodb') were the ones in {cacti_dir}/lib/adodb/.