Graphs disappeared ...sigh.. someone help please

caseth2001 · Post by **caseth2001** » Mon Jul 09, 2007 10:30 am

I made a post previously, stating that the graphs contained no data. I hit F5 to refresh the page and the graphs disappeared leaving me wiith the empty boxes with red X's. Someone please help..thx

BSOD2600 · Post by **BSOD2600** » Mon Jul 09, 2007 12:42 pm

Read through http://forums.cacti.net/viewtopic.php?t=11747

caseth2001 · Post by **caseth2001** » Tue Jul 10, 2007 9:25 am

BSOD can you please review the attached txt file...which contains the data from the troubleshooting guide.

BSOD2600 · Post by **BSOD2600** » Tue Jul 10, 2007 2:03 pm

Looks like cacti has never collected any data from that Pix. In that device, click on verbose query for the snmp interfaces data query -- does it return data? I'm not familiar with the pix firewall, but would it be blocking Cacti from mass querying it?

caseth2001 · Post by **caseth2001** » Tue Jul 10, 2007 2:15 pm

Yes it returned the following information, assuming i went to the right place.

Data Query Debug Information

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ Located input field 'ifIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.1'
+ Found item [ifIndex='1'] index: 1 [from value]
+ Found item [ifIndex='2'] index: 2 [from value]
+ Located input field 'ifOperStatus' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.8'
+ Found item [ifOperStatus='Up'] index: 1 [from value]
+ Found item [ifOperStatus='Up'] index: 2 [from value]
+ Located input field 'ifDescr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
+ Found item [ifDescr='PIX Firewall outside interface'] index: 1 [from value]
+ Found item [ifDescr='PIX Firewall inside interface'] index: 2 [from value]
+ Located input field 'ifName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'
+ Located input field 'ifAlias' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.18'
+ Located input field 'ifType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.3'
+ Found item [ifType='ethernetCsmacd(6)'] index: 1 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 2 [from value]
+ Located input field 'ifSpeed' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.5'
+ Found item [ifSpeed='100000000'] index: 1 [from value]
+ Found item [ifSpeed='100000000'] index: 2 [from value]
+ Located input field 'ifHwAddr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.6'
+ Found item [ifHwAddr='00:09:B7:F7:65:7C'] index: 1 [from value]
+ Found item [ifHwAddr='00:09:B7:F7:65:7D'] index: 2 [from value]
+ Located input field 'ifIP' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.4.20.1.2'
+ Found item [ifIP='172.23.100.2'] index: 2 [from regexp oid parse]
+ Found item [ifIP='213.52.201.162'] index: 1 [from regexp oid parse]
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/cacti/resource/snmp_queries/interface.xml'

BSOD2600 · Post by **BSOD2600** » Wed Jul 11, 2007 11:40 am

Alright, thats good.

Turn the logging level to debug for a polling cycle and then look through it for when cacti polls that Pix. What does it return for the interfaces?

caseth2001 · Post by **caseth2001** » Wed Jul 11, 2007 1:22 pm

im sry can you be more specific please. i went to "system utilities" > "view cacti log file" > and set the log filter to "debug" ..is this correct? If so, it didnt return anything. If this is not what your talking about ...can you please be more specific. im a n00b obviously. thanks in advance.

BSOD2600 · Post by **BSOD2600** » Wed Jul 11, 2007 2:34 pm

Settings | logging level.

caseth2001 · Post by **caseth2001** » Wed Jul 11, 2007 4:17 pm

okay i verified that the "poller logging level" was already set to debug. ive attached the screenshot...so theres no dicrepancies. Now where do i go to validate the data returned?

BSOD2600 · Post by **BSOD2600** » Wed Jul 11, 2007 11:14 pm

If the logging level is truly set to debug, then you should see the data that was returned by the snmp polling in there. Look for cacti polling that specific device...

caseth2001 · Post by **caseth2001** » Thu Jul 12, 2007 9:17 am

where exactly do i need to look for this information. in the cacti log file? also...should i be using "cactid" or "cmd.php" to poll? please advise.

caseth2001 · Post by **caseth2001** » Thu Jul 12, 2007 9:29 am

attached is the cacti.log file.

caseth2001 · Post by **caseth2001** » Thu Jul 12, 2007 9:32 am

guess it didnt attach..here it is again...bah..its pasted below

***************************************************************07/09/2007 05:03:43 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:03:43 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:03:43 PM - 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='8'"
07/09/2007 05:03:43 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:03:43 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:03:45 PM - 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'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_snmp'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_graph'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_graph'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_export'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_export'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_verbosity'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_verbosity'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pstats'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pstats'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pwarn'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pwarn'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_perror'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_perror'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='versions_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='versions_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_version'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
07/09/2007 05:03:45 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:03:53 PM - 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'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_enabled'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_enabled'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_type'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_type'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='concurrent_processes'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='concurrent_processes'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='cactid_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='cactid_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='max_threads'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='max_threads'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='php_servers'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='php_servers'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='script_timeout'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='script_timeout'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='max_get_size'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='max_get_size'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='availability_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='availability_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='availability_method'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='availability_method'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_method'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_method'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_timeout'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_timeout'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_retries'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_retries'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='updown_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='updown_header'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_failure_count'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_failure_count'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_recovery_count'"
07/09/2007 05:03:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_recovery_count'"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:03 PM - 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'"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_enabled', 'on')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_type', '2')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('concurrent_processes', '1')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('max_threads', '1')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('php_servers', '1')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('script_timeout', '25')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('max_get_size', '10')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('availability_method', '2')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('ping_method', '1')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('ping_timeout', '400')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('ping_retries', '1')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('ping_failure_count', '2')"
07/09/2007 05:04:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('ping_recovery_count', '3')"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:04 PM - 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'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_enabled'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_enabled'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_type'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_type'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='concurrent_processes'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='concurrent_processes'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='cactid_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='cactid_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='max_threads'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='max_threads'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='php_servers'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='php_servers'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='script_timeout'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='script_timeout'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='max_get_size'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='max_get_size'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='availability_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='availability_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='availability_method'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='availability_method'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_method'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_method'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_timeout'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_timeout'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_retries'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_retries'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='updown_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='updown_header'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_failure_count'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_failure_count'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='ping_recovery_count'"
07/09/2007 05:04:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='ping_recovery_count'"
07/09/2007 05:04:09 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:09 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:09 PM - 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='4'"
07/09/2007 05:04:09 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:04:09 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:04:09 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM graph_tree ORDER BY name"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:10 PM - 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='4'"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_tree where id=1"

07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select sort_type from graph_tree where id='1'"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.graph_tree_id, graph_tree_items.local_graph_id, graph_tree_items.host_id, graph_tree_items.order_key, graph_tree_items.sort_children_type, graph_templates_graph.title_cache as graph_title, CONCAT_WS('',description,' (',hostname,')') as hostname from graph_tree_items left join graph_templates_graph on (graph_tree_items.local_graph_id=graph_templates_graph.local_graph_id and graph_tree_items.local_graph_id>0) left join host on (host.id=graph_tree_items.host_id) where graph_tree_items.graph_tree_id=1 order by graph_tree_id, graph_tree_items.order_key"
07/09/2007 05:04:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT graph_tree_id, order_key FROM graph_tree_items WHERE host_id='0' AND local_graph_id='0' AND graph_tree_id='1'"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:13 PM - 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='7'"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) where graph_tree_items.graph_tree_id=1 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:13 PM - 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='7'"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) where graph_tree_items.graph_tree_id=1 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=11"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=11"

07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=1"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host.description from (graph_tree_items,host) where graph_tree_items.host_id=host.id and graph_tree_items.id=11"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_local,graph_templates,graph_templates_graph) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.graph_template_id=graph_templates.id and graph_local.host_id=8 group by graph_templates.id order by graph_templates.name"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=32 and graph_local.host_id=8 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=0 and graph_local.host_id=8 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
07/09/2007 05:04:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:13 PM - 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='7'"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=8 group by graph_templates_graph.local_graph_id"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=8 limit 0,1"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from (graph_templates_item,data_template_data_rra,data_template_rrd,data_template_data,rra) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_data.id=data_template_data_rra.data_template_data_id and data_template_data_rra.rra_id=rra.id and graph_templates_item.local_graph_id=8 group by rra.id order by rra.timespan"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=8 order by graph_templates_item.sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='title_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=11"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=11"

07/09/2007 05:04:14 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe fetch C:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_11.rrd AVERAGE -s 1183928653 -e 1184015053 -r 300
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/09/2007 05:04:14 PM - 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='7'"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from (graph_templates_item,data_template_data_rra,data_template_rrd,data_template_data,rra) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_data.id=data_template_data_rra.data_template_data_id and data_template_data_rra.rra_id=rra.id and graph_templates_item.local_graph_id=7 group by rra.id order by rra.timespan"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='title_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"

07/09/2007 05:04:14 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe fetch C:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_10.rrd AVERAGE -s 1183928653 -e 1184015053 -r 300
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1183928653 --end=1184015053 --title="London - PIX506e - Traffic - 213.52.201.162 (PIX Firewall ou)" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2007/07/08 17\:04\:13 To 2007/07/09 17\:04\:13\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode DEF:a="C\:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_10.rrd":traffic_in:AVERAGE DEF:b="C\:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_10.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdeff=b,8,* AREA:cdefa#00CF00:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s" COMMENT:"Total In\: 0 bytes\n" LINE1:cdeff#002A97:"Outbound" GPRINT:cdeff:LAST:"Current\:%8.2lf %s" GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s" COMMENT:"Total Out\: 0 bytes"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=11"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"

07/09/2007 05:04:14 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"

07/09/2007 05:04:14 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1183928653 --end=1184015053 --title="London - PIX506e - Traffic - 172.23.100.2 (PIX Firewall in)" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2007/07/08 17\:04\:13 To 2007/07/09 17\:04\:13\c" COMMENT:" \n" --vertical-label="bits per second" --slope-mode DEF:a="C\:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_11.rrd":traffic_in:AVERAGE DEF:b="C\:/Inetpub/wwwroot/cacti/rra/london_pix506e__traffic_in_11.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdeff=b,8,* AREA:cdefa#00CF00:"Inbound" GPRINT:cdefa:LAST:" Current\:%8.2lf %s" GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s" COMMENT:"Total In\: 0 bytes\n" LINE1:cdeff#002A97:"Outbound" GPRINT:cdeff:LAST:"Current\:%8.2lf %s" GPRINT:cdeff:AVERAGE:"Average\:%8.2lf %s" GPRINT:cdeff:MAX:"Maximum\:%8.2lf %s" COMMENT:"Total Out\: 0 bytes"
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '3': 'SELECT value FROM settings WHERE name = 'path_php_binary''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '3': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The path_php variable is c:/php/php.exe
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'availability_method''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '4': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The availability_method variable is 2
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '5': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The ping_recovery_count variable is 3
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '6': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The ping_failure_count variable is 2
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_method''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '7': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The ping_method variable is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_retries''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '8': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The ping_retries variable is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_timeout''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '9': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The ping_timeout variable is 400
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'log_perror''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '10': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The log_perror variable is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_pwarn''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '11': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The log_pwarn variable is 0
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pstats''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '12': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The log_pstats variable is 0
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'max_threads''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '13': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The threads variable is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'poller_interval''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '14': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The polling interval is the system default
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '15': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The number of concurrent processes is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'script_timeout''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '16': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The script timeout is 25
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'php_servers''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '17': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The number of php script servers to run is 1
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': 'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 8 AND 8 LIMIT 1'
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '18': OK
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: StartHost='8', EndHost='8', TotalPHPScripts='0'
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: The PHP Script Server is Not Required
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': 'SELECT value FROM settings WHERE name = 'max_get_size''
07/09/2007 05:05:35 PM - CACTID: Poller[0] DEBUG: MySQL Query ID '19': OK
07

BSOD2600 · Post by **BSOD2600** » Thu Jul 12, 2007 1:32 pm

Next time post an attachment of the log. You should be using cmd.php for now too.

Your log file doesn't contain any polling data, only stuff related to graphing which we don't care about. Try changing the logging level to low, click save. Then change it back to debug and click save. Clear the log file. Then wait until the polling task completes and look in the log file again.

caseth2001 · Post by **caseth2001** » Thu Jul 12, 2007 3:51 pm

k...i followed your instructions.

Cacti

Graphs disappeared ...sigh.. someone help please

Graphs disappeared ...sigh.. someone help please

Output from tests

logging level

logging level

polling

cacti.log

guess it didnt attach

results

Who is online