Trouble with Cactid (No graph update)

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
proxyo
Posts: 11
Joined: Wed Apr 20, 2005 9:07 am
Location: France

Trouble with Cactid (No graph update)

Post by proxyo »

Hy,

I'm running the lastest version of cacti with the cactid poller, on a debian sarge 2.6.8 with rrdtool 1.2 and a recently version of net-snmp,
near this installation on the same server, i've a monitoring solution based on nagios (Oreon -> front end to nagios) it already use net snmp and rrdtools with no trouble,

So when i want to use the cactid poller i've this in my 'poller-perf.php'

Code: Select all

Description: Christophe
Status: Up
Hostname: 192.168.0.102
Last poller start : 10.36.06 am
Last Poller End: 10:36:06 am
Ds Total : 90
Duration Total: 177.5
DS Per run: 18
Duration Per Run: 35.5
Duration Per DS: 1,97
When i want to run manually cactid i've this :

Code: Select all

/usr/local/cacti/include# php /usr/local/cacti/poller.php
04/20/2006 10:47:14 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/cactid/cactid, ARGS:  0 0]
04/20/2006 10:47:15 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/cactid/cactid, ARGS:  2 2]
Waiting on 2/2 pollers.
Waiting on 1/2 pollers.
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_traffic_in_33.rrd --template traffic_in:traffic_out 1145522835:5577276:5577276
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_traffic_in_34.rrd --template traffic_in:traffic_out 1145522835:81322591:12730706
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawuser_18.rrd --template ucd_ssCpuRawUser 1145522835:727236
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawnice_16.rrd --template ucd_ssCpuRawNice 1145522835:249743
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawsystem_17.rrd --template ucd_ssCpuRawSystem 1145522835:56372
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawidle_15.rrd --template ucd_ssCpuRawIdle 1145522835:8242869
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memshared_29.rrd --template ucd_memShared 1145522835:0
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_membuffer_27.rrd --template ucd_memBuffer 1145522835:123040
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memcached_28.rrd --template ucd_memCached 1145522835:288012
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memtotalreal_23.rrd --template ucd_memTotalReal 1145522835:1027292
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memtotalreal_30.rrd --template ucd_memTotalReal 1145522835:1027292
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memavailreal_22.rrd --template ucd_memAvailReal 1145522835:307888
04/20/2006 10:47:18 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memavailreal_26.rrd --template ucd_memAvailReal 1145522835:307888
04/20/2006 10:47:18 AM - SYSTEM STATS: Time:4.3410 Method:cactid Processes:2 Threads:5 Hosts:2 HostsPerProcess:1 DataSources:15 RRDsProcessed:13
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
OK u:0.04 s:0.01 r:2.07
I don't think the snmp command are executate... i'm looking for this with ethereal...

Cacti Log file say:

Code: Select all

 04/20/2006 10:48:22 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/20/2006 10:48:22 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/20/2006 10:48:22 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'"
04/20/2006 10:48:22 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
04/20/2006 10:48:22 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/20/2006 10:48:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/20/2006 10:48:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/20/2006 10:48:16 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'"
04/20/2006 10:48:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
04/20/2006 10:48:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_version'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='versions_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='versions_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_perror'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_perror'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pwarn'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pwarn'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pstats'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pstats'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_verbosity'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_verbosity'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_export'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_export'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_graph'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_graph'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_snmp'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
04/20/2006 10:48: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'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
04/20/2006 10:48:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:4.3575 Method:cactid Processes:2 Threads:5 Hosts:2 HostsPerProcess:1 DataSources:15 RRDsProcessed:13')"
04/20/2006 10:48:06 AM - SYSTEM STATS: Time:4.3575 Method:cactid Processes:2 Threads:5 Hosts:2 HostsPerProcess:1 DataSources:15 RRDsProcessed:13
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memavailreal_26.rrd --template ucd_memAvailReal 1145522883:313488
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memavailreal_22.rrd --template ucd_memAvailReal 1145522883:313488
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memtotalreal_30.rrd --template ucd_memTotalReal 1145522883:1027292
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memtotalreal_23.rrd --template ucd_memTotalReal 1145522883:1027292
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memcached_28.rrd --template ucd_memCached 1145522883:288012
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_membuffer_27.rrd --template ucd_memBuffer 1145522883:123060
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_memshared_29.rrd --template ucd_memShared 1145522883:0
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawidle_15.rrd --template ucd_ssCpuRawIdle 1145522883:8247547
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawsystem_17.rrd --template ucd_ssCpuRawSystem 1145522883:56395
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawnice_16.rrd --template ucd_ssCpuRawNice 1145522883:249743
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_ucd_sscpurawuser_18.rrd --template ucd_ssCpuRawUser 1145522883:727304
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_traffic_in_34.rrd --template traffic_in:traffic_out 1145522883:81345087:12733240
04/20/2006 10:48:06 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/christophe_traffic_in_33.rrd --template traffic_in:traffic_out 1145522883:5577276:5577276
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='26' and rrd_name='ucd_memAvailReal' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='22' and rrd_name='ucd_memAvailReal' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='30' and rrd_name='ucd_memTotalReal' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='23' and rrd_name='ucd_memTotalReal' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='28' and rrd_name='ucd_memCached' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='27' and rrd_name='ucd_memBuffer' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='29' and rrd_name='ucd_memShared' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='15' and rrd_name='ucd_ssCpuRawIdle' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='ucd_ssCpuRawSystem' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='16' and rrd_name='ucd_ssCpuRawNice' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='18' and rrd_name='ucd_ssCpuRawUser' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='34' and rrd_name='traffic_out' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='33' and rrd_name='traffic_out' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='34' and rrd_name='traffic_in' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='33' and rrd_name='traffic_in' and time='2006-04-20 10:48:03'"
04/20/2006 10:48:06 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)limit 2000"
04/20/2006 10:48:06 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
04/20/2006 10:48:06 AM - CACTID: Poller[0] Time: 3.0980 s, Threads: 5, Hosts: 2
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: MYSQL Free & Close Completed
04/20/2006 10:48:06 AM - CACTID: Poller[0] CACTID: Net-SNMP API Shutdown Completed
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: Allocated Variable Memory Freed
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: PHP Script Server Pipes Closed
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: Thread Cleanup Complete
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '6': OK
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '6': 'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '5': OK
04/20/2006 10:48:06 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '5': 'replace into settings (name,value) values ('date',NOW())'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 0
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '4': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '4': 'INSERT INTO poller_output (local_data_id,rrd_name,time,output) VALUES (33,'traffic_in','2006-04-20 10:48:03','5577276'),(34,'traffic_in','2006-04-20 10:48:03','81345087'),(33,'traffic_out','2006-04-20 10:48:03','5577276'),(34,'traffic_out','2006-04-20 10:48:03','12733240'),(18,'ucd_ssCpuRawUser','2006-04-20 10:48:03','727304'),(16,'ucd_ssCpuRawNice','2006-04-20 10:48:03','249743'),(17,'ucd_ssCpuRawSystem','2006-04-20 10:48:03','56395'),(15,'ucd_ssCpuRawIdle','2006-04-20 10:48:03','8247547'),(29,'ucd_memShared','2006-04-20 10:48:03','0'),(27,'ucd_memBuffer','2006-04-20 10:48:03','123060'),(28,'ucd_memCached','2006-04-20 10:48:03','288012'),(23,'ucd_memTotalReal','2006-04-20 10:48:03','1027292'),(30,'ucd_memTotalReal','2006-04-20 10:48:03','1027292'),(22,'ucd_memAvailReal','2006-04-20 10:48:03','313488'),(26,'ucd_memAvailReal','2006-04-20 10:48:03','313488')'
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[26] SNMP: v1: 192.168.0.102, dsname: ucd_memAvailReal, oid: .1.3.6.1.4.1.2021.4.6.0, value: 313488
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[22] SNMP: v1: 192.168.0.102, dsname: ucd_memAvailReal, oid: .1.3.6.1.4.1.2021.4.6.0, value: 313488
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[30] SNMP: v1: 192.168.0.102, dsname: ucd_memTotalReal, oid: .1.3.6.1.4.1.2021.4.5.0, value: 1027292
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[23] SNMP: v1: 192.168.0.102, dsname: ucd_memTotalReal, oid: .1.3.6.1.4.1.2021.4.5.0, value: 1027292
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[28] SNMP: v1: 192.168.0.102, dsname: ucd_memCached, oid: .1.3.6.1.4.1.2021.4.15.0, value: 288012
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[27] SNMP: v1: 192.168.0.102, dsname: ucd_memBuffer, oid: .1.3.6.1.4.1.2021.4.14.0, value: 123060
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[29] SNMP: v1: 192.168.0.102, dsname: ucd_memShared, oid: .1.3.6.1.4.1.2021.4.13.0, value: 0
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[15] SNMP: v1: 192.168.0.102, dsname: ucd_ssCpuRawIdle, oid: .1.3.6.1.4.1.2021.11.53.0, value: 8247547
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[17] SNMP: v1: 192.168.0.102, dsname: ucd_ssCpuRawSystem, oid: .1.3.6.1.4.1.2021.11.52.0, value: 56395
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[16] SNMP: v1: 192.168.0.102, dsname: ucd_ssCpuRawNice, oid: .1.3.6.1.4.1.2021.11.51.0, value: 249743
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[18] SNMP: v1: 192.168.0.102, dsname: ucd_ssCpuRawUser, oid: .1.3.6.1.4.1.2021.11.50.0, value: 727304
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[34] SNMP: v1: 192.168.0.102, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 12733240
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[33] SNMP: v1: 192.168.0.102, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 5577276
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[34] SNMP: v1: 192.168.0.102, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 81345087
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] DS[33] SNMP: v1: 192.168.0.102, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 5577276
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '25': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '25': '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 FROM poller_item WHERE host_id=2 ORDER BY arg1'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '3': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '3': 'update poller_reindex set assert_value='7148669' where host_id='2' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0''
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '2': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '2': 'update poller_reindex set assert_value='7148669' where host_id='2' and data_query_id='6' and arg1='.1.3.6.1.2.1.1.3.0''
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '1': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '1': 'update poller_reindex set assert_value='7148669' where host_id='2' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0''
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] RECACHE: Processing 3 items in the auto reindex cache for '192.168.0.102'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '24': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '24': 'SELECT data_query_id,action,op,assert_value,arg1 FROM poller_reindex WHERE host_id=2'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '0': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '0': 'update host set status='3',status_event_count='0', status_fail_date='2006-04-20 10:06:04',status_rec_date='2006-04-20 10:29:00',status_last_error='SNMP not performed due to setting or ping result.,',min_time='0.168090',max_time='2170.030000',cur_time='0.177150',avg_time='104.464918',total_polls='414',failed_polls='4',availability='99.0338' where id='2''
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[2] PING: Result UDP: Host is Alive
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: The UDP Ping return_code was -1, errno was 111, total_time was 177.1450
04/20/2006 10:48:05 AM - CACTID: Poller[0] WARNING: Falling back to UDP Ping due to not running asroot. Please use "chmod xxx0 /usr/bin/cactid" to resolve.
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '23': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '23': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,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'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 2
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/20/2006 10:48:05 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:05 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/20/2006 10:48:05 AM - CACTID: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': '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 FROM poller_item WHERE host_id=0 ORDER BY arg1'
04/20/2006 10:48:05 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:05 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: Initial Value of Active Threads is 0
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': 'SELECT id FROM host WHERE disabled='' AND id BETWEEN 2 AND 2 ORDER BY id'
04/20/2006 10:48:05 AM - CACTID: Poller[0] CACTID: Initializing PHP Script Server
04/20/2006 10:48:05 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)limit 2000"
04/20/2006 10:48:05 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
04/20/2006 10:48:05 AM - CACTID: Poller[0] Time: 3.1006 s, Threads: 5, Hosts: 1
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MYSQL Free & Close Completed
04/20/2006 10:48:05 AM - CACTID: Poller[0] CACTID: Net-SNMP API Shutdown Completed
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: Allocated Variable Memory Freed
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: PHP Script Server Pipes Closed
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: Thread Cleanup Complete
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '1': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '1': 'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '0': OK
04/20/2006 10:48:05 AM - CACTID: Poller[0] DEBUG: MySQL Insert ID '0': 'replace into settings (name,value) values ('date',NOW())'
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 0
04/20/2006 10:48:04 AM - CACTID: Poller[0] Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': OK
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '22': '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 FROM poller_item WHERE host_id=0 ORDER BY arg1'
04/20/2006 10:48:04 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:04 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 1
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: Initial Value of Active Threads is 0
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': OK
04/20/2006 10:48:04 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '21': 'SELECT id FROM host WHERE disabled='' AND id BETWEEN 0 AND 0 ORDER BY id'
04/20/2006 10:48:04 AM - CACTID: Poller[0] CACTID: Initializing PHP Script Server
04/20/2006 10:48:04 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)limit 2000"
04/20/2006 10:48:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
04/20/2006 10:48:04 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
04/20/2006 10:48:03 AM - CACTID: Poller[0] CACTID: Initializing Net-SNMP API
04/20/2006 10:48:03 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:03 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:03 AM - CACTID: Poller[0] CACTID: Version 0.8.6f starting
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 60
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '20': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '20': 'SELECT value FROM settings WHERE name = 'max_get_size''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The PHP Script Server is Not Required
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: StartHost='2', EndHost='2', TotalPHPScripts='0'
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': 'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 2 AND 2 LIMIT 1'
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The number of php script servers to run is 10
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': 'SELECT value FROM settings WHERE name = 'php_servers''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The script timeout is 25
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'script_timeout''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The number of concurrent processes is 2
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The polling interval is the system default
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'poller_interval''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The threads variable is 5
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'max_threads''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The log_pstats variable is 1
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'log_pstats''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The log_pwarn variable is 1
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pwarn''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The log_perror variable is 1
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_perror''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The ping_timeout variable is 400
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'ping_timeout''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The ping_retries variable is 2
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_retries''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The ping_method variable is 2
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_method''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The ping_failure_count variable is 2
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The ping_recovery_count variable is 3
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The availability_method variable is 3
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'availability_method''
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: The path_php variable is /usr/bin/php
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': OK
04/20/2006 10:48:03 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'path_php_binary''
04/20/2006 10:48:03 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/cactid/cactid, ARGS: 2 2]
04/20/2006 10:48:02 AM - CACTID: Poller[0] CACTID: Initializing Net-SNMP API
04/20/2006 10:48:02 AM - CACTID: Poller[0] MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:02 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/20/2006 10:48:02 AM - CACTID: Poller[0] CACTID: Version 0.8.6f starting
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 60
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '20': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '20': 'SELECT value FROM settings WHERE name = 'max_get_size''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The PHP Script Server is Not Required
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: StartHost='0', EndHost='0', TotalPHPScripts='0'
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': 'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 0 AND 0 LIMIT 1'
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The number of php script servers to run is 10
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': 'SELECT value FROM settings WHERE name = 'php_servers''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The script timeout is 25
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'script_timeout''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The number of concurrent processes is 2
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The polling interval is the system default
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'poller_interval''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The threads variable is 5
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'max_threads''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The log_pstats variable is 1
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'log_pstats''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The log_pwarn variable is 1
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pwarn''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The log_perror variable is 1
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_perror''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The ping_timeout variable is 400
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'ping_timeout''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The ping_retries variable is 2
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_retries''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The ping_method variable is 2
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_method''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The ping_failure_count variable is 2
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The ping_recovery_count variable is 3
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The availability_method variable is 3
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'availability_method''
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: The path_php variable is /usr/bin/php
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': OK
04/20/2006 10:48:02 AM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'path_php_binary''
04/20/2006 10:48:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/cactid/cactid, ARGS: 0 0]
04/20/2006 10:48:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
04/20/2006 10:48:01 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/local/cacti')"
04/20/2006 10:48:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
04/20/2006 10:48:01 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
Poller cache and snmp cache seem to be good...

So I don't understand why the graph aren't update, I think mi config is great...

So if anybody can help me...

Thanx...
:wink:

Proxyo


PS: If my english is not well, sorry, i'm french ... :lol:
Top
phrawzty
Posts: 12
Joined: Fri Apr 21, 2006 3:01 pm
Location: Montreal, Canada

Post by phrawzty »

Have you tried polling the remote host(s) manually using snmpwalk? If you don't see any SNMP activity from Cacti, you should first ensure that snmp communication is working in the first place. :)
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Please be more precise in what's failing. From the last DEBUG log, you'll notice, that snmp returns results (for at least SOME data sources) and that there's some rrdtool update. So the rrd files (or at least: some of them) get updated. There are quite a lot possible errors. So please give us host or data template or graph template that's failing. A screenshot may help as well
Reinhard
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 0 guests