Graph shows, but allways empty

Zarnick · Post by **Zarnick** » Fri Jul 20, 2007 11:26 am

Hello, I've installed cacti, and I'm on the verge of going crazy, as I can get the graphs works(although always when I add a new graph, I have to go to the web directory, and run poller.php manually, and then change the permissions of the newly generated graphs, and yes, the cron is working) but all the graphs show absolutely no data at all.
Now, the SNMP querys as far as I know are working, since I user mrtg, and it works just fine.
Anyone has any suggestion on at least nowing if something is wrong?
The logs (even in debug mode) doesn't shows any errors.

Thanks a lot.

Post by **gandalf** » Fri Jul 20, 2007 1:16 pm

Please follow second link of my signature for dbugging
Reinhard

Zarnick · Post by **Zarnick** » Fri Jul 20, 2007 2:17 pm

I'm sorry, I must have been having some difficulties with my browser.....I....can't see your signature.

Edit:Sorry...I managed to see it(I was logged out)....I'll take a look at it.

Zarnick · Post by **Zarnick** » Fri Jul 20, 2007 3:34 pm

ok, so I've checked up everything, and all seems to be in order....
even running manually the script, it returns data.
I've changed the MySQL user to root, just to be sure, but at least for now, everything is as it was....empty

Post by **gandalf** » Sat Jul 21, 2007 7:11 am

Please post a screenshot of any graph. From my HowTo, you should be able to run the poller in DEBUG mode for a single target. Please provide cacti output from such a run
Reinhard

Zarnick · Post by **Zarnick** » Mon Jul 23, 2007 7:35 am

Sorry for taking so long.
Here it is the log

Code: Select all

07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * FROM host     WHERE (disabled = ''     AND id >= 1     AND id <= 1)     ORDER by id"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "     SELECT * from poller_item     WHERE (host_id >= 1     AND host_id <= 1)     ORDER by host_id"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "    SELECT count(*)    FROM poller_item    WHERE (action=2    AND (host_id >= 1    AND host_id <= 1))"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] SNMP: Host responded to SNMP
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '0000-00-00 00:00:00',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = '',  min_time = '2.30000',  max_time = '80.15000',  cur_time = '30.19',  avg_time = '17.444002',  total_polls = '10',  failed_polls = '0',  availability = '100'  where hostname = '10.0.0.1'"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select     poller_reindex.data_query_id,     poller_reindex.action,     poller_reindex.op,     poller_reindex.assert_value,     poller_reindex.arg1     from poller_reindex     where poller_reindex.host_id=1"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] RECACHE: Processing 2 items in the auto reindex cache for '10.0.0.1'.
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='33715740' where host_id='1' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='33715741' where host_id='1' and data_query_id='2' and arg1='.1.3.6.1.2.1.1.3.0'"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[34] SNMP: v2: 10.0.0.1, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, output: 1
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'users', '2007-07-23 09:22:32', '1')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[28] CMD: perl /var/www/localhost/htdocs/cacti/scripts/linux_memory.pl MemFree:, output: 5492
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (28, 'mem_buffers', '2007-07-23 09:22:32', '5492')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[35] SNMP: v2: 10.0.0.1, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, output: 72
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (35, 'proc', '2007-07-23 09:22:32', '72')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[29] CMD: perl /var/www/localhost/htdocs/cacti/scripts/linux_memory.pl SwapFree:, output: 920524
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (29, 'mem_swap', '2007-07-23 09:22:32', '920524')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[30] CMD: perl /var/www/localhost/htdocs/cacti/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (30, '', '2007-07-23 09:22:32', '1min:0.00 5min:0.00 10min:0.00')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[31] CMD: perl /var/www/localhost/htdocs/cacti/scripts/unix_users.pl , output: 1
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (31, 'users', '2007-07-23 09:22:32', '1')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[32] SNMP: v2: 10.0.0.1, dsname: hdd_free, oid: .1.3.6.1.4.1.2021.9.1.7.1, output: 52912364
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'hdd_free', '2007-07-23 09:22:32', '52912364')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[32] SNMP: v2: 10.0.0.1, dsname: hdd_used, oid: .1.3.6.1.4.1.2021.9.1.8.1, output: 5690960
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'hdd_used', '2007-07-23 09:22:32', '5690960')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[33] SNMP: v2: 10.0.0.1, dsname: hdd_used, oid: .1.3.6.1.4.1.2021.9.1.8.2, output: 164904
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'hdd_used', '2007-07-23 09:22:32', '164904')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[33] SNMP: v2: 10.0.0.1, dsname: hdd_free, oid: .1.3.6.1.4.1.2021.9.1.7.2, output: 18301216
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'hdd_free', '2007-07-23 09:22:32', '18301216')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Host[1] DS[27] CMD: perl /var/www/localhost/htdocs/cacti/scripts/unix_processes.pl, output: 75
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (27, 'proc', '2007-07-23 09:22:32', '75')"
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] Time: 0.2368 s, Theads: N/A, Hosts: 1
07/23/2007 09:22:32 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"

And the image

Thanks for the help.

Post by **gandalf** » Mon Jul 23, 2007 10:06 am

Does this occur for every disk graph of that target? In this case, please refer to http://docs.cacti.net/node/411 for setting up snmp
Reinhard

Zarnick · Post by **Zarnick** » Mon Jul 23, 2007 10:38 am

It shows for every single graph.
and Yes, the net-snmp is installed correctly, since I can run all the perl scripts, and snmpwalk etc etc etc.
And MRTG works fine.

Post by **gandalf** » Mon Jul 23, 2007 10:53 am

Well, I was focused on snmpd.conf settings for DISK reporting. They are ok when running from cli?
Reinhard

Zarnick · Post by **Zarnick** » Tue Jul 24, 2007 6:57 am

Yes, they are ok.
This thing is happening for all the graphs, not just the disk graph.
Load average etc...

Post by **gandalf** » Tue Jul 24, 2007 1:24 pm

Oh, now I understand.
In this case, it would be best to focus on a certain host that shows those errors. Best bet would be not to choose localhost but some remote target. Find that host in the DEVICE list and select it. Find the id of that host in the URL, then.
Now start debugging as given in my debug howto. You will execute the first steps with success, cause the logs already show that polling is fine: the scripts/snmp request do return data.
Either it is a problem when storing data (e.g. rrdtool update not performed or not successful), e.g. due to lack of write permission or a graphing problem. Please report results of each step of my howto
Reinhard

Cacti

Graph shows, but allways empty

Graph shows, but allways empty

Who is online