SQL Errors and no grpahs

[Dia]

Hello All,

I am new to installing Cacti on Windows, using PHP, using MySQL and have followed BSOD2600 installation instructions (assuming i did follow correctly? =). I have install Cacti 0.8.6h, Cactid 0.8.6g, RRDtool-cygwin-1.2.12, php-4.4.2, net-snmp5.3.0.1, mysql-5.0.19.

Here is log from debug mode. I let it run 2 polling schedules.

05/02/2006 11:00:17 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/02/2006 11:00:17 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/02/2006 11:00:17 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'"
05/02/2006 11:00:17 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
05/02/2006 11:00:17 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/02/2006 11:00:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/02/2006 11:00:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/02/2006 11:00:15 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'"
05/02/2006 11:00:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
05/02/2006 11:00:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.4138 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:0 RRDsProcessed:0')"
05/02/2006 11:00:02 AM - SYSTEM STATS: Time:1.4138 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:0 RRDsProcessed:0
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/02/2006 11:00:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
05/02/2006 11:00:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
05/02/2006 11:00:01 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
05/02/2006 11:00:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= )"
05/02/2006 11:00:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= ORDER by host_id"
05/02/2006 11:00:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= ORDER by id"
05/02/2006 11:00:00 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 8]
05/02/2006 11:00:00 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
05/02/2006 11:00:00 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/inetpub/wwwroot/cacti')"
05/02/2006 11:00:00 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
05/02/2006 11:00:00 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.6135 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:0 RRDsProcessed:0')"
05/02/2006 10:55:02 AM - SYSTEM STATS: Time:1.6135 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:0 RRDsProcessed:0
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= )"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= ORDER by host_id"
05/02/2006 10:55:02 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= ORDER by id"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_version'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='versions_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='versions_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_perror'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_perror'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pwarn'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pwarn'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pstats'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pstats'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_verbosity'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_verbosity'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_export'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_export'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_graph'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_graph'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_snmp'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
05/02/2006 10:55:01 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'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
05/02/2006 10:55:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 8]
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/inetpub/wwwroot/cacti')"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
05/02/2006 10:55:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"

Any help for this newbie would greatly be appreciated.

Thanks in advance.

Dia

[BSOD2600]

Do you have anything created to be polled?
Do you have anything in the poller cache?
If you run the scheduled task under an admin account, does stuff work?

[Dia]

Yes, I have 4 Windows Servers to be polled.
No, nothing shows up when I open the poller cache.

C:\Documents and Settings\Administrator>php c:\inetpub\wwwroot\cacti\poller.php
X-Powered-By: PHP/4.4.2
Content-type: text/html

05/02/2006 10:40:50 AM - SYSTEM STATS: Time:1.0705 Method:cmd.php Processes:1 Th
reads:N/A Hosts:5 HostsPerProcess:5 DataSources:0 RRDsProcessed:0

thanks.

[BSOD2600]

Hmm, weird.

Try this:
mysql -u root -p cacti
>truncate table poller_output;
>quit

[Dia]

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>mysql -u root -p cacti
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3433 to server version: 5.0.19-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> truncate table poller_output;
Query OK, 0 rows affected (0.00 sec)

mysql>

[ernestcashstar]

I'm experiencing the same problems as Dia. ie. nothing showing up when i open up the poll cache. Can anyone help?

[ahardman]

I am running cacti Version 0.8.6h(patched) on fedora core 3. I had simular errors on my box after it had been running for about 2 months. I repatched the server, and the output messages said that the patches were already installed, and the errors went away. I am hoping they don't come back. The only errors were the sql errors. The Poller(cactid) seemed to still be polling and the RRDtool showed no errors. No data was written while the server was broke.