Poller stops working after plugin implementation

[blubberdink]

Hello,

I'm running Cacti 0.8.6j build by RPM on RedHat AS4.
I applied the patch "cacti-plugin-arch" and the THOLD plugin afther that.

This seems to work fine but now the poller doesn't collect data anymore.

This is what is in the cacti logfile:


07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/var/www/cacti')"
07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
07/10/2007 03:55:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 0 203]
07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 203) ORDER by id"
07/10/2007 03:55:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * from poller_item WHERE (host_id >= 0 AND host_id <= 203) ORDER by host_id"
07/10/2007 03:55:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: " SELECT count(*) FROM poller_item WHERE (action=2 AND (host_id >= 0 AND host_id <= 203))"
07/10/2007 03:55:02 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] DEBUG: GETCWD: /var/www/cacti
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: /var/www/cacti
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] DEBUG: FILENM: /var/www/cacti/script_server.php
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
07/10/2007 03:55:02 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
07/10/2007 03:55:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
07/10/2007 03:55:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
07/10/2007 03:55:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/10/2007 03:55:02 PM - 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) LIMIT 10000"
07/10/2007 03:55:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/10/2007 03:55:03 PM - 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) LIMIT 10000"
07/10/2007 03:55:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/10/2007 03:55:04 PM - 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) LIMIT 10000"
07/10/2007 03:55:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/10/2007 03:55:05 PM - 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 poll


And the process doesn't terminate.

Is this a common problem?
i think there is something wrong in my database but don't know where to look for it.

Any help would be great.

Regards,

Bart Lubberdink

[blubberdink]

The problem seems a general thing in the database.

I reinstalled the cacti source with my old database and RRD's

the problem still exists.

Regards...

[TheWitness]

PHP is segfaulting "Input Expected - Script Server...". Why? I do not know. Is the UI working? If so, how many devices? What PHP version? What is your PHP memory limit set to? Sometimes PHP segfaults when your database either has bad permissions, or is not setup.

TheWitness

[blubberdink]

Hello,

The problem is not depending on the amount of devices.

I dit e clean install, with a clean new database.
After aplying the plugin patch and the plugin THOLD i added one device
as a Generic SNMP enabled host.

Afther that action, the poller gets the error.

My php version is 4.3.9

Regards,
Bart Lubberdink

ps, with only localhost as device (default device) the poller works fine!