Cacti

I found more details on the error and a "solution" but unsure what changed. When a new graph is being created, here is the debug in the logs. /usr/local/bin/rrdtool create /www/htdocs-cacti/rra/switch01_dist_corp_net_traffic_in_1592.rrd --step 300 DS:traffic_in:COUNTER:600::100000000 DS:tr...

I had issues with the version of mySQL I was running. I upgraded to my SQL 4.1.22. I can now create graphs for existing hosts, but the graphs do not build. When I try to edit a graph and click save, I get the following error. Notice: Undefined variable: local_graph_id in /www/htdocs-cacti/graphs.php...

Oh my, yes, I am running MySQL 3.23.40. I guess I didn't check that when I upgraded to the new version. I will work on upgrading mySQL. I apologize for wasting your time due to my lack of reading the upgrade notes.

Here is what occurs when I run it from the command line mysql. ERROR 1064: You have an error in your SQL syntax near '(snmp_index AS unsigned) LIMIT 0,30' at line 1 I am running mysql cacti -u cactiuser -p and then I am running: SELECT host_id, snmp_query_id, snmp_index, MAX(CASE WHEN field_name=ifA...

Here is the log detail with the updated log data based on the permission changes for the log file. 12/01/2009 09:58:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host_id, snmp_query_id, snmp_index, MAX(CASE WHEN field_name='ifAlias' THEN field_value ELSE NULL END...

I have increased the poller log level from LOW to DEBUG and DEVEL. When I did the verbose query, I didn't see any new data on the cacti.log file. I did not see anywhere else to increase the logging level. Am I missing something here?

It doesn't appear so. + Running data query [1]. + Found type = '3' [snmp query]. + Found data query XML file at '/www/htdocs-cacti/resource/snmp_queries/interface.xml' + XML file parsed ok. + Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1' + Index found at OID: '1.3.6.1.2.1.2.2.1.1....

Running on Red Hat Linux release 7.1 (Seawolf) I downloaded the source directly from cacti.net. I was on an older version and upgraded. Everything polls fine, just can no longer add new devices or graphs. Date Wed, 25 Nov 2009 14:11:38 -0500 Cacti Version 0.8.7e Cacti OS unix SNMP Version NET-SNMP v...

I have a bunch of devices and have upgraded to 0.8.7e. When I tried to add a new graph to an existing device, I get "This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information." I have run the de...

Alright, I figured out the problem. For some reason calling the snmpd.conf file was the issue. As soon as I just started snmpd with no options everything worked. How strange. I looked for duplicate snmpd.conf files and found none. Anyhow everything works like a charm now.

Oh yea, I am running RH 7.2 and the latest net-snmp.