Huge problem with Spine [urgent please help]

mdherens · Post by **mdherens** » Fri Jul 10, 2009 4:09 am

Hi everybody!

I really need your help for this.

I have a new install of Cacti. The CMD poller works fine but I really need to make Spine work as soon as possible and I don't understand what seems to be the problem. Permissions don't seem to be the problem. I have checked everyone.

when I go into the cacti log file, here is what I get:

07/10/2009 10:30:05 AM - SYSTEM STATS: Time:5.2946 Method:spine Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:13 RRDsProcessed:9
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\11.rrd --template cpu 1247214603:0
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\10.rrd --template cpu 1247214603:0
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\9.rrd --template proc 1247214603:49
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\8.rrd --template users 1247214603:2
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\12.rrd --template traffic_in:traffic_out 1247214603:9677014:11322470
07/10/2009 10:30:05 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:05 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\13.rrd --template 5min_cpu 1247214603:6
07/10/2009 10:30:04 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:04 AM - SPINE: Poller[0] Time: 3.9530 s, Threads: 1, Hosts: 3
07/10/2009 10:30:04 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\14.rrd --template traffic_out:traffic_in 1247214603:925025217:21685905
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: MYSQL Free & Close Completed
07/10/2009 10:30:04 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:04 AM - SPINE: Poller[0] SPINE: Net-SNMP API Shutdown Completed
07/10/2009 10:30:04 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\15.rrd --template traffic_out:traffic_in 1247214603:3232395249:2492965823
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: Allocated Variable Memory Freed
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: PHP Script Server Pipes Closed
07/10/2009 10:30:04 AM - CMDPHP: Poller[0] ERROR: Detected RRDtool Crash attempting to perform write
07/10/2009 10:30:04 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\16.rrd --template traffic_out:traffic_in 1247214603:2494827882:1337741397
07/10/2009 10:30:04 AM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SS[0] Script Server Shutdown Started
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: Thread Cleanup Complete
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'replace into settings (name,value) values ('date',NOW())'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (13,'5min_cpu','2009-07-10 10:30:03','6'),(14,'traffic_in','2009-07-10 10:30:03','21685905'),(14,'traffic_out','2009-07-10 10:30:03','925025217'),(15,'traffic_in','2009-07-10 10:30:03','2492965823'),(15,'traffic_out','2009-07-10 10:30:03','3232395249'),(16,'traffic_in','2009-07-10 10:30:03','1337741397'),(16,'traffic_out','2009-07-10 10:30:03','2494827882')'
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[16] SNMP: v2: 10.48.90.4, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 2494827882
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[16] SNMP: v2: 10.48.90.4, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 1337741397
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[15] SNMP: v2: 10.48.90.4, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 3232395249
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[15] SNMP: v2: 10.48.90.4, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 2492965823
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[14] SNMP: v2: 10.48.90.4, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 925025217
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[14] SNMP: v2: 10.48.90.4, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 21685905
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] DS[13] SNMP: v2: 10.48.90.4, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, value: 6
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=3'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=3'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=3 and rrd_next_step <=0 ORDER by snmp_port'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=3 AND rrd_next_step < 0 GROUP BY snmp_port'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='4143074581' WHERE host_id='3' AND data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0''
07/10/2009 10:30:04 AM - SPINE: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for '10.48.90.4'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=3'
07/10/2009 10:30:04 AM - SPINE: Poller[0] DEBUG: SQL:'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='0.000000', max_time='2.950000', cur_time='0.000000', avg_time='1.023272', total_polls='40', failed_polls='0', availability='100.0000' WHERE id='3''
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[3] SNMP Result: Host responded to SNMP
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout, max_oids, availability_method, ping_method, ping_port, ping_timeout, ping_retries, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability FROM host WHERE id=3'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (11,'cpu','2009-07-10 10:30:03','0'),(10,'cpu','2009-07-10 10:30:03','0'),(9,'proc','2009-07-10 10:30:03','49'),(8,'users','2009-07-10 10:30:03','2'),(12,'traffic_out','2009-07-10 10:30:03','11322470'),(12,'traffic_in','2009-07-10 10:30:03','9677014')'
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[12] SNMP: v2: localhost, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.16777219, value: 9677014
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[12] SNMP: v2: localhost, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.16777219, value: 11322470
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[8] SNMP: v2: localhost, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, value: 2
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[9] SNMP: v2: localhost, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, value: 49
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[10] SS[0] SERVER: C:\apache2\htdocs\cacti\scripts\ss_host_cpu.php ss_host_cpu localhost 2 2:161:500:1:10:armagedon:::MD5::DES: get usage 0, output: 0
07/10/2009 10:30:03 AM - PHPSVR: Poller[0] DEBUG: INC: 'C:\apache2\htdocs\cacti\scripts\ss_host_cpu.php' FUNC: 'ss_host_cpu' PARMS: 'localhost 2 2:161:500:1:10:armagedon:::MD5::DES: get usage 0'
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] DS[11] SS[0] SERVER: C:\apache2\htdocs\cacti\scripts\ss_host_cpu.php ss_host_cpu localhost 2 2:161:500:1:10:armagedon:::MD5::DES: get usage 1, output: 0
07/10/2009 10:30:03 AM - PHPSVR: Poller[0] DEBUG: INC: 'C:\apache2\htdocs\cacti\scripts\ss_host_cpu.php' FUNC: 'ss_host_cpu' PARMS: 'localhost 2 2:161:500:1:10:armagedon:::MD5::DES: get usage 1'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=2'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=2'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=2 and rrd_next_step <=0 ORDER by snmp_port'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=2 AND rrd_next_step < 0 GROUP BY snmp_port'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='353318' WHERE host_id='2' AND data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0''
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='353318' WHERE host_id='2' AND data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0''
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_reindex SET assert_value='353318' WHERE host_id='2' AND data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0''
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] RECACHE: Processing 3 items in the auto reindex cache for 'localhost'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=2'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'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='0.000000', max_time='16.000030', cur_time='0.000000', avg_time='2.198748', total_polls='48', failed_polls='0', availability='100.0000' WHERE id='2''
07/10/2009 10:30:03 AM - SPINE: Poller[0] Host[2] SNMP Result: Host responded to SNMP
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id, hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context, snmp_port, snmp_timeout, max_oids, availability_method, ping_method, ping_port, ping_timeout, ping_retries, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability FROM host WHERE id=2'
07/10/2009 10:30:03 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 0
07/10/2009 10:30:02 AM - SPINE: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_step-300 WHERE rrd_next_step < 0 and host_id=0'
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SQL:'UPDATE poller_item SET rrd_next_step=rrd_next_step-300 WHERE host_id=0'
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout, snmp_auth_protocol, snmp_priv_passphrase, snmp_priv_protocol, snmp_context FROM poller_item WHERE host_id=0 and rrd_next_step <=0 ORDER by snmp_port'
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT snmp_port, count(snmp_port) FROM poller_item WHERE host_id=0 AND rrd_next_step < 0 GROUP BY snmp_port'
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: The Value of Active Threads is 1
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: In Poller, About to Start Polling of Host
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: Valid Thread to be Created
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: Initial Value of Active Threads is 0
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 3 ORDER BY id'
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SS[0] Confirmed PHP Script Server running
07/10/2009 10:30:02 AM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is spine
07/10/2009 10:30:02 AM - PHPSVR: Poller[0] DEBUG: FILENM: C:\apache2\htdocs\cacti\script_server.php
07/10/2009 10:30:02 AM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/apache2/htdocs/cacti
07/10/2009 10:30:02 AM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/spine
07/10/2009 10:30:02 AM - PHPSVR: Poller[0] DEBUG: SERVER: spine
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server Child FORK Success
07/10/2009 10:30:02 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server About to FORK Child Process
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server Routine Starting
07/10/2009 10:30:01 AM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.4.1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.4.1
07/10/2009 10:30:01 AM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: MySQL is Thread Safe!
07/10/2009 10:30:01 AM - SPINE: Poller[0] Version 0.8.7b starting
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 10
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The PHP Script Server is Required
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: StartHost='0', EndHost='3', TotalPHPScripts='1'
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 0 AND 3 LIMIT 1'
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The script timeout is 25
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The threads variable is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
07/10/2009 10:30:01 AM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 2
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: The availability_method variable is 2
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: The path_php variable is c:/php/php.exe
07/10/2009 10:30:00 AM - SPINE: Poller[0] DEBUG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
07/10/2009 10:30:00 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/spine/spine.exe, ARGS: 0 3]

So from what I can see the polling data is working fine but it can't write the rrd files.
I tried to run the poller manually and I received these messages from PHP:

07/09/2009 08:49:41 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\14.rrd --template traffic_out:traffic_in 1247165380:862799083:17038418 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:41 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\3\13.rrd --template 5min_cpu 1247165380:5 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:42 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\12.rrd --template traffic_in:traffic_out 1247165379:5647245:8772512 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:44 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\8.rrd --template users 1247165379:2 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:45 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\9.rrd --template proc 1247165379:48 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:46 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\10.rrd --template cpu 1247165379:0 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:47 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\apache2\htdocs\cacti\rra\2\11.rrd --template cpu 1247165379:0 PHP Warning: fwrite(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 136 PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57
07/09/2009 08:49:49 PM - SYSTEM STATS: Time:12.8696 Method:spine Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:13
RRDsProcessed:9
PHP Warning: pclose(): 66 is not a valid stream resource in C:\apache2\htdocs\cacti\lib\rrd.php on line 57

I've looked into it as much as I could but I don't know squad about PHP...

Something else is also strange: when I try to repair the MYSQL database I'm being sent this:

C:\apache2\htdocs\cacti\cli>php repair_database.php
Repairing All Cacti Database Tables
PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 79
Repairing Table -> ''PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 80
Failed
PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 79
Repairing Table -> ''PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 80
Failed

Ireceive a lot of lines lines exactly like these ones ;(

Versions of everything
windows 2000 server
Cacti Version 0.8.7d
SNMP Version NET-SNMP version: 5.4.2.1
PHP Version 5.2.9-2
Webserver: Apache2.2
MySQL: 5.0.77
RRDTool (Cygwin or Win32 version): 1-2.15
Cygwin (cygwin1.dll version): 1.5.20
Plugin Architecture: none

I've been stuck on this problem for 2 days and I could really use your help

Thanks,

Marianne

mdherens · Post by **mdherens** » Mon Jul 13, 2009 6:02 am

I found out how to solve Spine problem by re re re reading the installation manual ! The issue came from the dll files in rrdtool and spine directory.

I still have the other issue: when I try to repair the database I get lots of messages saying :

PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 79
Repairing Table -> ''PHP Notice: Undefined index: Tables_in_cactiDB in C:\apache2\htdocs\cacti\cli\repair_database.php on line 80
Failed

I installed phpmyadmin and it pointed out that I did not have the extension for mcrypt so I installed it but I still can't retrieve the status of the mysql table using the cacti interface : system utilities/technical support.

Any idea ?

BSOD2600 · Post by **BSOD2600** » Mon Jul 13, 2009 12:13 pm

Try running the following instead

Code: Select all

mysqlcheck --auto-repair --databases cacti

mdherens · Post by **mdherens** » Tue Jul 14, 2009 3:42 am

thanks it worked perfectly !

I have another question concerning the interactions between plugins. I noticed that when I enable thold and aggregate, aggregate stop working (the aggregate graphs continue working but I can't create a new one). When I go to graph management, I select the graphs I want to aggregate (from the same template of course) and I click on "create aggregate graph" then the next page that is being loaded only shows a grey square.
I found an easy work around by disabling the thold plugon when I want to create aggregate graphs but it is still a bit unconvenient.

Any idea on what might be causing this ?

this is my configuration:
windows 2000 server
Apache 2.2.11
PHP 5.2.9
Cygwin 1.5.25
Cacti 0.8.7d
RRDtool 1.2.15
MySQL 5.0.77
NET-SNMP 5.4.2.1
Spine
plugins: aggregate, discovery, loginmod, monitor, settings, superlinks, thold

Thanks for your help !

M

mcutting · Post by **mcutting** » Tue Jul 14, 2009 4:38 am

This is a bug with the released version of THOLD. If you get the latest version out of SVN, the issue is resolved.

If you can't get into SVN, let me know, and I'll post a working version here.

Regds

mdherens · Post by **mdherens** » Tue Jul 14, 2009 4:46 am

This is probably a stupid question but what is SVN ? How do I install/change it ? I am quite sure I have the last version of Thold.

Thanks,

regards,

M

mcutting · Post by **mcutting** » Tue Jul 14, 2009 4:50 am

SVN = Subversion

Not that easy to setup if you're not familiar with it. In view of this, here you go...

mdherens · Post by **mdherens** » Wed Jul 15, 2009 7:31 am

Thanks for your help. I tried to install this version of the thold plugin.
So I copied the thold directory into the plugins directory, I activated it in the global.php file and imported thold.sql.

Unfortunetely, it did not resolve my problem concerning aggregate and the plugin thold did not work either (even enabled). When I try to create a threshold, it says record updated but does not do anything.

Is there anything I might have missed ?

cheers,

M

mcutting · Post by **mcutting** » Wed Jul 15, 2009 8:36 am

This version of THOLD does not use the global.php file to activate the plugin - that's the old way of doing things.

for this to work, you need at least PIA2.4, and to have imported the pa.sql file into your cacti database.

I know this works, because I use this very version of THOLD, and AGGREGATE also.

Huge problem with Spine [urgent please help]

Huge problem with Spine [urgent please help]

Who is online