Here is what is in the log file:


01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:24:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:24:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:38 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:23:18 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:22:58 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:22:57 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='20'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
01/29/2008 09:22:37 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
01/29/2008 09:22:17 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"



I have tried the NAN debug guide but have not found an answer.

That'S only GUI logging. Nothing shown from the poller. Crontab is ok? Which is your poller (cmd.php or spine?). What happens, if running
Reinhard

[root@localhost html]# php -q poller.php --force --debug
01/29/2008 11:07:06 AM - SYSTEM STATS: Time:14.2344 Method:cmd.php Processes:10 Threads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0
[root@localhost html]# PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/plugins/syslog/syslog_process.php on line 196


Here is the Crontab

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/



# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

Please make sure to setup cacti as given by http://docs.cacti.net/node/441, e.g. crontab. Second, the error message stems from the syslog plugin. For the moment, please deactivate it and retry the command above
Reinhard

php -q poller.php --force --debug
01/30/2008 08:53:59 AM - SYSTEM STATS: Time:14.2556 Method:cmd.php Processes:10 Threads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0

That's all? Or did you suppress the first lines that I expected to appear? In this case, please use cacti debug mode as given by second link of my signature to get more information
Reinhard

01/31/2008 02:01:52 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '3 00', Time Since Last: '111', Max Runtime '298', Poller Runs: '1'
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 0 15]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 17 27]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 28 34]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 35 42]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 43 48]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 49 65]
01/31/2008 02:01:52 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 66 73]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 76 82]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 83 90]
01/31/2008 02:01:53 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/cmd.php 91 95]
Waiting on 10/10 pollers.
Waiting on 8/10 pollers.
Waiting on 6/10 pollers.
Waiting on 5/10 pollers.
Waiting on 4/10 pollers.
Waiting on 3/10 pollers.
Waiting on 2/10 pollers.
Waiting on 1/10 pollers.
01/31/2008 02:02:01 PM - SYSTEM STATS: Time:9.2393 Method:cmd.php Processes:10 T hreads:N/A Hosts:59 HostsPerProcess:6 DataSources:600 RRDsProcessed:0
Loop Time is: 9.2477400302887
Sleep Time is: 290.74878001213
Total Time is: 9.2512199878693
01/31/2008 02:02:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces s [CMD: /usr/bin/php, ARGS: -q /var/www/html/plugins/discovery/findhosts.php]

Here is what I get when running
php -q cmd.php 47 47





01/31/2008 02:15:21 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1017', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (421, 'hdd_used', '2008-01-31 14:15:21', '0')'
01/31/2008 02:15:21 PM - PHPSVR: Poller[0] DEBUG:

Please run this SQL manually from mysql cli and post results. Surely, your filesysstem is not filled up and the database is not broken?
Reinhard

After a upgrade to 0.8.7a, schedules of loading of channels are not drawn. In a file cacti-error.log the mistake:
[Fri Feb 8 17:46:14 2008] [error] PHP Warning: Division by zero in /etc/httpd/htdocs/sites/cacti/lib/api_poller.php on line 119
is given. Somebody can help me?

I had the same problem Poller[0] ERROR: A DB Exec Failed!, Error:'1017', SQL blablab.a.

I tried to run the same SQL as in log file into mysql client but the poller_ouput table was missing. I checked my filesystem and it was true

A normal cacti installation should have 145 files in /var/lib/mysql/cacti. On the broken cacti server I had only 143 files, two of them were missing and guess what... poller_output was the problem.

My lazy solution was to copy pooler_output.* from another server then run an delete all from poller_output SQL query... and it worked.

Recently I found that this problem was caused by an forced reset of my cacti machine.

I found I had a time sync issue. This fixed my hard drive space graphing but the network graphing is still spotty.

[quote="nevrax"]

My lazy solution was to copy pooler_output.* from another server then run an [i]delete all from poller_output[/i] SQL query... and it worked.

[/quote]


Perfect solution for me as well

thx!

I have the same problem and I found that poller_output.frm is present in my server and my guess is poller_output.MYD and poller_output.MYI are missing. I dont know from where I can get these files to paste them on my server.

Any help is appreciated
Pali

Cacti does not deal with the MySQL files itself. It requires the table poller_output. If anything goes wrong, a "repair table" is the first solution. This turns out to be a more MySQL related issue, then
Reinhard