[SOLVED] Probably NTFS rights problem

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

[SOLVED] Probably NTFS rights problem

Post by Brainscanner »

Hello alltogether,

I've had Cacti working. Then some days ago I changed some ntfs rights settings (yes, I admit it: wasted them). Nothing changed in the permissions of the smtp-system-service. Since then I have been experiencing the following problem:

completely working:
- network interface statistics
- iis statistics

not working
- hdd stats
- phyiscal and virtual memory stats

"Not working" means that their graphs don't contain any data (all 0-values). Making the graph and READING the necessary data doesn't seem to be the reason, because I can see data until the day I probably wasted the settings (weekly graph).

I tried to stick to the settings from "Cacti-Security.cmd".

Just an excerpt from the log-file (warnings only):

Code: Select all

12/04/2007 10:00:04 PM - PCOMMAND: Poller[0] Host[3] WARNING: Recache Event Detected for Host 
12/04/2007 10:00:02 PM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:02 PM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[22] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[21] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[20] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[19] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[18] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[17] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[14] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[13] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[12] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[7] WARNING: Result from CMD not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[6] WARNING: Result from CMD not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[5] WARNING: Result from CMD not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[4] WARNING: Result from CMD not valid. Partial Result: 
12/04/2007 10:00:01 PM - CMDPHP: Poller[0] Host[1] DS[3] WARNING: Result from CMD not valid. Partial Result:
Does anyone have a suggestion? I'm happy to provide more infos if requested.
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Time to switch to debugging mode. Please read and follow http://forums.cacti.net/viewtopic.php?t=11747

snmp errors are possibly something simple as a device needing reindexing (click the green circle next to data queries). cmd errors are possibly because cacti can't read some files. Debugging info will reveal more details.
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

Well, that's answering at warp 9,9 ;-)

I'm still going through the other things you wrote. I'm afraid I'm still getting the cmd errors after reindexing.

Just one walkthrough in debug mode:

PART 1 (too big to fit in one post):

Code: Select all

12/04/2007 10:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1" 
12/04/2007 10:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1" 
12/04/2007 10:34: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='15'" 
12/04/2007 10:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'" 
12/04/2007 10:34:14 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version" 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_recache','RecacheTime:4.6554 HostsRecached:1')" 
12/04/2007 10:34:12 PM - RECACHE STATS: RecacheTime:4.6554 HostsRecached:1 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_command where poller_id=0" 
12/04/2007 10:34:12 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache successful. 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '9'" 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '9'" 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where host_id = '3' and snmp_query_id = '9'" 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_reindex (host_id,data_query_id,action,op,assert_value,arg1) values (3,9,0,'<','62044190','.1.3.6.1.2.1.1.3.0')" 
12/04/2007 10:34:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_reindex where host_id=3 and data_query_id=9" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=9" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (data_input,snmp_query) where data_input.id=snmp_query.data_input_id and snmp_query.id=9" 

12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select reindex_method, sort_field from host_snmp_query where host_id=3 and snmp_query_id=9" 

12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_port, snmp_timeout from host where id=3" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host_snmp_query set sort_field = 'hrProcessorFrwID', title_format = 'CPU#|query_hrProcessorFrwID|' where host_id = '3' and snmp_query_id = '9'" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=9 and field_name='hrProcessorFrwID'" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=9" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=9" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,9,'hrProcessorFrwID','0','0','')" 
12/04/2007 10:34:11 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from host_snmp_cache where host_id=3 and snmp_query_id=9" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=9" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (snmp_query,data_input) where snmp_query.data_input_id=data_input.id and snmp_query.id=9" 
12/04/2007 10:34:10 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache for Host, data query #9 
12/04/2007 10:34:10 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache successful. 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '8'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '8'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where host_id = '3' and snmp_query_id = '8'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_reindex (host_id,data_query_id,action,op,assert_value,arg1) values (3,8,0,'<','62043800','.1.3.6.1.2.1.1.3.0')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_reindex where host_id=3 and data_query_id=8" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=8" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (data_input,snmp_query) where data_input.id=snmp_query.data_input_id and snmp_query.id=8" 

12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select reindex_method, sort_field from host_snmp_query where host_id=3 and snmp_query_id=8" 

12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_port, snmp_timeout from host where id=3" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host_snmp_query set sort_field = 'hrStorageDescr', title_format = '|query_hrStorageDescr|' where host_id = '3' and snmp_query_id = '8'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=8 and field_name='hrStorageAllocationUnits'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=8 and field_name='hrStorageDescr'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=8 and field_name='hrStorageIndex'" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=8" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=8" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageAllocationUnits','65536','5','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageAllocationUnits','65536','4','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageAllocationUnits','0','3','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageAllocationUnits','4096','2','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageAllocationUnits','0','1','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageDescr','Physical Memory','5','')" 
12/04/2007 10:34:10 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageDescr','Virtual Memory','4','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageDescr','D:','3','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageDescr','C: Label: Serial Number 4019646','2','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageDescr','A:','1','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageIndex','5','5','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageIndex','4','4','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageIndex','3','3','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageIndex','2','2','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values (3,8,'hrStorageIndex','1','1','')" 
12/04/2007 10:34:09 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from host_snmp_cache where host_id=3 and snmp_query_id=8" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=8" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (snmp_query,data_input) where snmp_query.data_input_id=data_input.id and snmp_query.id=8" 
12/04/2007 10:34:08 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache for Host, data query #8 
12/04/2007 10:34:08 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache successful. 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (25,3,0,'192.168.198.2', 'public','1','500', '','','161', 'traffic_out','C:\\Inetpub\\wwwroot\\Php\\cacti\\rra\\firewall_traffic_in_25.rrd', '2','.1.3.6.1.2.1.2.2.1.16.65538','','')" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=25" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host.id, host.hostname, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, host.disabled from host where host.id=3" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=121" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (25,3,0,'192.168.198.2', 'public','1','500', '','','161', 'traffic_in','C:\\Inetpub\\wwwroot\\Php\\cacti\\rra\\firewall_traffic_in_25.rrd', '2','.1.3.6.1.2.1.2.2.1.10.65538','','')" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=25" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host.id, host.hostname, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, host.disabled from host where host.id=3" 

12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=120" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=13 and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=25" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=87 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:08 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_item where local_data_id=25" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host_id,snmp_query_id,snmp_index from data_local where id=25" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_input.id, data_input.type_id, data_template_data.id as data_template_data_id, data_template_data.data_template_id, data_template_data.active from (data_template_data,data_input) where data_template_data.data_input_id=data_input.id and data_template_data.local_data_id=25" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (24,3,0,'192.168.198.2', 'public','1','500', '','','161', 'traffic_out','C:\\Inetpub\\wwwroot\\Php\\cacti\\rra\\firewall_traffic_in_24.rrd', '2','.1.3.6.1.2.1.2.2.1.16.1179654','','')" 

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

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host.id, host.hostname, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, host.disabled from host where host.id=3" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=119" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_item (local_data_id,host_id,action,hostname, snmp_community,snmp_version,snmp_timeout,snmp_username,snmp_password,snmp_port,rrd_name,rrd_path, rrd_num,arg1,arg2,arg3) values (24,3,0,'192.168.198.2', 'public','1','500', '','','161', 'traffic_in','C:\\Inetpub\\wwwroot\\Php\\cacti\\rra\\firewall_traffic_in_24.rrd', '2','.1.3.6.1.2.1.2.2.1.10.1179654','','')" 

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

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host.id, host.hostname, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, host.disabled from host where host.id=3" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_template_rrd.data_source_name, data_template_data.name from (data_template_rrd,data_template_data) where data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_rrd.id=118" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=13 and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=86 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_item where local_data_id=24" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select host_id,snmp_query_id,snmp_index from data_local where id=24" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_input.id, data_input.type_id, data_template_data.id as data_template_data_id, data_template_data.data_template_id, data_template_data.active from (data_template_data,data_input) where data_template_data.data_input_id=data_input.id and data_template_data.local_data_id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_snmp_cache.snmp_index from host_snmp_cache where host_snmp_cache.field_name='ifDescr' and host_snmp_cache.field_value='Interne RAS-Serverschnittstelle des Einwahlclients' and host_snmp_cache.host_id='3' and host_snmp_cache.snmp_query_id='1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select snmp_query_id from snmp_query_graph where id='13'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=87 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.id from data_template_data where data_template_data.local_data_id=25" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from data_local where id=25" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update data_template_data set name_cache='Firewall - Traffic - 88.66.42.71/WAN (PPP/SLIP) ' where local_data_id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_name,field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and snmp_index='1179654'" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select data_local.host_id, data_local.snmp_query_id, data_local.snmp_index, data_template_data.name from (data_template_data,data_local) where data_template_data.local_data_id=data_local.id and data_local.id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update data_local set snmp_query_id='1',snmp_index='1179654' where id='24'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_snmp_cache.snmp_index from host_snmp_cache where host_snmp_cache.field_name='ifDescr' and host_snmp_cache.field_value='WAN (PPP/SLIP) Interface' and host_snmp_cache.host_id='3' and host_snmp_cache.snmp_query_id='1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select snmp_query_id from snmp_query_graph where id='13'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=86 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.id from data_template_data where data_template_data.local_data_id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from data_local where id=24" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from data_local where host_id = '3' and snmp_query_id = '1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_snmp_cache.snmp_index from host_snmp_cache where host_snmp_cache.field_name='ifDescr' and host_snmp_cache.field_value='Interne RAS-Serverschnittstelle des Einwahlclients' and host_snmp_cache.host_id='3' and host_snmp_cache.snmp_query_id='1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select snmp_query_id from snmp_query_graph where id='13'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=87 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.id from (graph_templates_item,data_template_rrd,data_template_data) 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=14 limit 0,1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=14" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update graph_templates_graph set title_cache='Internet Line - Firewall - Traffic - (WAN (PPP/SLIP) )' where local_graph_id=13" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_name,field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and snmp_index='1179654'" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from host where id=3" 

12/04/2007 10:34:07 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 from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id=13" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update graph_local set snmp_query_id='1',snmp_index='1179654' where id=13" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_snmp_cache.snmp_index from host_snmp_cache where host_snmp_cache.field_name='ifDescr' and host_snmp_cache.field_value='WAN (PPP/SLIP) Interface' and host_snmp_cache.host_id='3' and host_snmp_cache.snmp_query_id='1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select snmp_query_id from snmp_query_graph where id='13'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id=86 and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.id from (graph_templates_item,data_template_rrd,data_template_data) 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=13 limit 0,1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=13" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from graph_local where host_id = '3' and snmp_query_id = '1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_reindex (host_id,data_query_id,action,op,assert_value,arg1) values (3,1,0,'<','62043045','.1.3.6.1.2.1.1.3.0')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_reindex where host_id=3 and data_query_id=1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (data_input,snmp_query) where data_input.id=snmp_query.data_input_id and snmp_query.id=1" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select reindex_method, sort_field from host_snmp_query where host_id=3 and snmp_query_id=1" 

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select hostname, snmp_community, snmp_version, snmp_username, snmp_password, snmp_port, snmp_timeout from host where id=3" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host_snmp_query set sort_field = 'ifDescr', title_format = '|query_ifDescr|' where host_id = '3' and snmp_query_id = '1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifIP'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifHwAddr'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifSpeed'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifType'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifAlias'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifName'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifDescr'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifOperStatus'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select field_value from host_snmp_cache where host_id=3 and snmp_query_id=1 and field_name='ifIndex'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIP','192.168.198.2','65540','.1.3.6.1.2.1.4.20.1.2.192.168.198.2')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIP','192.168.1.1','65541','.1.3.6.1.2.1.4.20.1.2.192.168.1.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIP','169.254.9.23','65539','.1.3.6.1.2.1.4.20.1.2.169.254.9.23')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIP','127.0.0.1','1','.1.3.6.1.2.1.4.20.1.2.127.0.0.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIP','88.66.42.71','1179654','.1.3.6.1.2.1.4.20.1.2.88.66.42.71')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifHwAddr','00:53:45:00:00:00','1179654','.1.3.6.1.2.1.2.2.1.6.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifHwAddr','00:0C:29:CE:33:24','65541','.1.3.6.1.2.1.2.2.1.6.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifHwAddr','00:0C:29:CE:33:1A','65540','.1.3.6.1.2.1.2.2.1.6.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifHwAddr','44:45:53:54:51:00','65539','.1.3.6.1.2.1.2.2.1.6.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifHwAddr','','1','.1.3.6.1.2.1.2.2.1.6.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifSpeed','1000000000','1179654','.1.3.6.1.2.1.2.2.1.5.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifSpeed','1000000000','65541','.1.3.6.1.2.1.2.2.1.5.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifSpeed','1000000000','65540','.1.3.6.1.2.1.2.2.1.5.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifSpeed','100000000','65539','.1.3.6.1.2.1.2.2.1.5.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifSpeed','10000000','1','.1.3.6.1.2.1.2.2.1.5.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifType','ppp(23)','1179654','.1.3.6.1.2.1.2.2.1.3.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifType','ethernetCsmacd(6)','65541','.1.3.6.1.2.1.2.2.1.3.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifType','ethernetCsmacd(6)','65540','.1.3.6.1.2.1.2.2.1.3.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifType','ethernetCsmacd(6)','65539','.1.3.6.1.2.1.2.2.1.3.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifType','softwareLoopback(24)','1','.1.3.6.1.2.1.2.2.1.3.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifDescr','WAN (PPP/SLIP) Interface','1179654','.1.3.6.1.2.1.2.2.1.2.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifDescr','VMware Accelerated AMD PCNet Adapter #2','65541','.1.3.6.1.2.1.2.2.1.2.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifDescr','VMware Accelerated AMD PCNet Adapter','65540','.1.3.6.1.2.1.2.2.1.2.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifDescr','Kerio VPN adapter','65539','.1.3.6.1.2.1.2.2.1.2.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifDescr','Interne Loopback-Schnittstelle des 127.0.0-Netzwerks','1','.1.3.6.1.2.1.2.2.1.2.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifOperStatus','Up','1179654','.1.3.6.1.2.1.2.2.1.8.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifOperStatus','Up','65541','.1.3.6.1.2.1.2.2.1.8.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifOperStatus','Up','65540','.1.3.6.1.2.1.2.2.1.8.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifOperStatus','Up','65539','.1.3.6.1.2.1.2.2.1.8.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifOperStatus','Up','1','.1.3.6.1.2.1.2.2.1.8.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIndex','1179654','1179654','.1.3.6.1.2.1.2.2.1.1.1179654')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIndex','65541','65541','.1.3.6.1.2.1.2.2.1.1.65541')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIndex','65540','65540','.1.3.6.1.2.1.2.2.1.1.65540')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIndex','65539','65539','.1.3.6.1.2.1.2.2.1.1.65539')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into host_snmp_cache (host_id,snmp_query_id,field_name,field_value,snmp_index,oid) values ('3','1','ifIndex','1','1','.1.3.6.1.2.1.2.2.1.1.1')" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from host_snmp_cache where host_id='3' and snmp_query_id='1'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select xml_path from snmp_query where id=1"
Last edited by Brainscanner on Tue Dec 04, 2007 4:38 pm, edited 1 time in total.
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

PART 2:

Code: Select all

12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select hostname,snmp_community,snmp_version,snmp_username,snmp_password,snmp_port,snmp_timeout from host where id='3'" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_input.type_id from (snmp_query,data_input) where snmp_query.data_input_id=data_input.id and snmp_query.id=1" 
12/04/2007 10:34:07 PM - PCOMMAND: Poller[0] Host[3] RECACHE: Re-cache for Host, data query #1 
12/04/2007 10:34:07 PM - PCOMMAND: Poller[0] Host[3] WARNING: Recache Event Detected for Host 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_command.action, poller_command.command from poller_command where poller_command.poller_id=0" 
12/04/2007 10:34:07 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/progra~1/php/php.exe, ARGS: -q C:/Inetpub/wwwroot/Php/cacti/poller_commands.php] 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output" 
12/04/2007 10:34:07 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:12.8818 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:55 RRDsProcessed:46')" 
12/04/2007 10:34:07 PM - SYSTEM STATS: Time:12.8818 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:55 RRDsProcessed:46 
12/04/2007 10:34:07 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\firewall_traffic_in_25.rrd --template traffic_in:traffic_out 1196804046:U:U 
12/04/2007 10:34:07 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\firewall_traffic_in_24.rrd --template traffic_in:traffic_out 1196804046:U:U 
12/04/2007 10:34:07 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_unlock_53.rrd --template iis_request_unlock 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_trace_52.rrd --template iis_request_trace 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_search_51.rrd --template iis_request_search 1196804034:2122 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_put_50.rrd --template iis_request_put 1196804034:190 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_propp_49.rrd --template iis_request_propp 1196804034:58 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_propf_48.rrd --template iis_request_propf 1196804034:839 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_post_47.rrd --template iis_request_post 1196804034:388 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_other_46.rrd --template iis_request_other 1196804034:2633 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_option_45.rrd --template iis_request_option 1196804034:17 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_move_44.rrd --template iis_request_move 1196804034:3 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_mkcol_43.rrd --template iis_request_mkcol 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_lock_42.rrd --template iis_request_lock 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_head_41.rrd --template iis_request_head 1196804034:3 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_get_40.rrd --template iis_request_get 1196804034:5580 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_attemps_con_31.rrd --template iis_attemps_con 1196804034:2450 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_attemps_log_32.rrd --template iis_attemps_log 1196804034:9808 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_con_cur_total_33.rrd --template iis_con_cur_total 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_con_cur_ano_34.rrd --template iis_con_cur_ano 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_con_cur_no_ano_35.rrd --template iis_con_cur_no_ano 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_byte_received_36.rrd --template iis_byte_received 1196804034:11976161 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_byte_sent_37.rrd --template iis_byte_sent 1196804034:57953728 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_copy_38.rrd --template iis_request_copy 1196804034:0 
12/04/2007 10:34:06 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_iis_request_delete_39.rrd --template iis_request_delete 1196804034:0 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='25' and rrd_name='traffic_out' and time='2007-12-04 22:34:06'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='25' and rrd_name='traffic_in' and time='2007-12-04 22:34:06'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='24' and rrd_name='traffic_out' and time='2007-12-04 22:34:06'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='24' and rrd_name='traffic_in' and time='2007-12-04 22:34:06'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='53' and rrd_name='iis_request_unlock' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='52' and rrd_name='iis_request_trace' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='51' and rrd_name='iis_request_search' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='50' and rrd_name='iis_request_put' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='49' and rrd_name='iis_request_propp' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='48' and rrd_name='iis_request_propf' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='47' and rrd_name='iis_request_post' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='46' and rrd_name='iis_request_other' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='45' and rrd_name='iis_request_option' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='44' and rrd_name='iis_request_move' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='43' and rrd_name='iis_request_mkcol' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='42' and rrd_name='iis_request_lock' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='41' and rrd_name='iis_request_head' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='40' and rrd_name='iis_request_get' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='31' and rrd_name='iis_attemps_con' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='32' and rrd_name='iis_attemps_log' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='33' and rrd_name='iis_con_cur_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='34' and rrd_name='iis_con_cur_ano' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='35' and rrd_name='iis_con_cur_no_ano' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='36' and rrd_name='iis_byte_received' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='37' and rrd_name='iis_byte_sent' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='38' and rrd_name='iis_request_copy' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='39' and rrd_name='iis_request_delete' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) " 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Time: 11.8936 s, Theads: N/A, Hosts: 4 
12/04/2007 10:34:06 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (25,'traffic_out','2007-12-04 22:34:06','U')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[25] SNMP: v1: 192.168.198.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65538, output: U 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (25,'traffic_in','2007-12-04 22:34:06','U')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[25] SNMP: v1: 192.168.198.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65538, output: U 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[25] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (24,'traffic_out','2007-12-04 22:34:06','U')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[24] SNMP: v1: 192.168.198.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1179654, output: 1357352298 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (24,'traffic_in','2007-12-04 22:34:06','U')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] DS[24] SNMP: v1: 192.168.198.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1179654, output: 1025851524 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] NOTICE: Spike Kill in Effect for '192.168.198.2'. 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='62042593' where host_id='3' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '3:9')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] ASSERT: '62093301<62042593' failed. Recaching host '192.168.198.2', data query #9 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] NOTICE: Spike Kill in Effect for '192.168.198.2'. 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='62042589' where host_id='3' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '3:8')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] ASSERT: '62093300<62042589' failed. Recaching host '192.168.198.2', data query #8 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] NOTICE: Spike Kill in Effect for '192.168.198.2'. 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='62042582' where host_id='3' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '3:1')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] ASSERT: '62093296<62042582' failed. Recaching host '192.168.198.2', data query #1 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 3 items in the auto reindex cache for '192.168.198.2'. 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=3" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '2007-11-27 06:15:21', status_rec_date = '2007-11-26 09:15:01', status_last_error = 'Host did not respond to SNMP', min_time = '2.10000', max_time = '945.15000', cur_time = '2.92', avg_time = '10.655634926602', total_polls = '5745', failed_polls = '159', availability = '97.232375979112' where hostname = '192.168.198.2'" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (53, 'iis_request_unlock', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[53] SNMP: v1: 127.0.0.1, dsname: iis_request_unlock, oid: .1.3.6.1.4.1.311.1.7.3.1.31.0, output: 0 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (52, 'iis_request_trace', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[52] SNMP: v1: 127.0.0.1, dsname: iis_request_trace, oid: .1.3.6.1.4.1.311.1.7.3.1.23.0, output: 0 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (51, 'iis_request_search', '2007-12-04 22:33:54', '2122')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[51] SNMP: v1: 127.0.0.1, dsname: iis_request_search, oid: .1.3.6.1.4.1.311.1.7.3.1.29.0, output: 2122 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (50, 'iis_request_put', '2007-12-04 22:33:54', '190')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[50] SNMP: v1: 127.0.0.1, dsname: iis_request_put, oid: .1.3.6.1.4.1.311.1.7.3.1.21.0, output: 190 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (49, 'iis_request_propp', '2007-12-04 22:33:54', '58')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[49] SNMP: v1: 127.0.0.1, dsname: iis_request_propp, oid: .1.3.6.1.4.1.311.1.7.3.1.28.0, output: 58 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (48, 'iis_request_propf', '2007-12-04 22:33:54', '839')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[48] SNMP: v1: 127.0.0.1, dsname: iis_request_propf, oid: .1.3.6.1.4.1.311.1.7.3.1.27.0, output: 839 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (47, 'iis_request_post', '2007-12-04 22:33:54', '388')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[47] SNMP: v1: 127.0.0.1, dsname: iis_request_post, oid: .1.3.6.1.4.1.311.1.7.3.1.19.0, output: 388 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (46, 'iis_request_other', '2007-12-04 22:33:54', '2633')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[46] SNMP: v1: 127.0.0.1, dsname: iis_request_other, oid: .1.3.6.1.4.1.311.1.7.3.1.32.0, output: 2633 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (45, 'iis_request_option', '2007-12-04 22:33:54', '17')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[45] SNMP: v1: 127.0.0.1, dsname: iis_request_option, oid: .1.3.6.1.4.1.311.1.7.3.1.17.0, output: 17 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (44, 'iis_request_move', '2007-12-04 22:33:54', '3')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[44] SNMP: v1: 127.0.0.1, dsname: iis_request_move, oid: .1.3.6.1.4.1.311.1.7.3.1.24.0, output: 3 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (43, 'iis_request_mkcol', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[43] SNMP: v1: 127.0.0.1, dsname: iis_request_mkcol, oid: .1.3.6.1.4.1.311.1.7.3.1.26.0, output: 0 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (42, 'iis_request_lock', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[42] SNMP: v1: 127.0.0.1, dsname: iis_request_lock, oid: .1.3.6.1.4.1.311.1.7.3.1.30.0, output: 0 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (41, 'iis_request_head', '2007-12-04 22:33:54', '3')" 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] Host[1] DS[41] SNMP: v1: 127.0.0.1, dsname: iis_request_head, oid: .1.3.6.1.4.1.311.1.7.3.1.20.0, output: 3 
12/04/2007 10:34:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (40, 'iis_request_get', '2007-12-04 22:33:54', '5580')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[40] SNMP: v1: 127.0.0.1, dsname: iis_request_get, oid: .1.3.6.1.4.1.311.1.7.3.1.18.0, output: 5580 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (39, 'iis_request_delete', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[39] SNMP: v1: 127.0.0.1, dsname: iis_request_delete, oid: .1.3.6.1.4.1.311.1.7.3.1.22.0, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (38, 'iis_request_copy', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[38] SNMP: v1: 127.0.0.1, dsname: iis_request_copy, oid: .1.3.6.1.4.1.311.1.7.3.1.25.0, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (37, 'iis_byte_sent', '2007-12-04 22:33:54', '57953728')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[37] SNMP: v1: 127.0.0.1, dsname: iis_byte_sent, oid: .1.3.6.1.4.1.311.1.7.3.1.2.0, output: 57953728 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (36, 'iis_byte_received', '2007-12-04 22:33:54', '11976161')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[36] SNMP: v1: 127.0.0.1, dsname: iis_byte_received, oid: .1.3.6.1.4.1.311.1.7.3.1.4.0, output: 11976161 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (35, 'iis_con_cur_no_ano', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[35] SNMP: v1: 127.0.0.1, dsname: iis_con_cur_no_ano, oid: .1.3.6.1.4.1.311.1.7.3.1.8.0, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'iis_con_cur_ano', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[34] SNMP: v1: 127.0.0.1, dsname: iis_con_cur_ano, oid: .1.3.6.1.4.1.311.1.7.3.1.7.0, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'iis_con_cur_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[33] SNMP: v1: 127.0.0.1, dsname: iis_con_cur_total, oid: .1.3.6.1.4.1.311.1.7.3.1.13.0, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (32, 'iis_attemps_log', '2007-12-04 22:33:54', '9808')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[32] SNMP: v1: 127.0.0.1, dsname: iis_attemps_log, oid: .1.3.6.1.4.1.311.1.7.3.1.16.0, output: 9808 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (31, 'iis_attemps_con', '2007-12-04 22:33:54', '2450')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[31] SNMP: v1: 127.0.0.1, dsname: iis_attemps_con, oid: .1.3.6.1.4.1.311.1.7.3.1.15.0, output: 2450 
12/04/2007 10:34:05 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_hdd_total_28.rrd --template hdd_total:hdd_used 1196804034:0:0 
12/04/2007 10:34:05 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_hdd_total_29.rrd --template hdd_total:hdd_used 1196804034:0:0 
12/04/2007 10:34:05 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_hdd_total_30.rrd --template hdd_total:hdd_used 1196804034:0:0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='28' and rrd_name='hdd_used' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='28' and rrd_name='hdd_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='29' and rrd_name='hdd_used' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='29' and rrd_name='hdd_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='30' and rrd_name='hdd_used' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='30' and rrd_name='hdd_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (30, 'hdd_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[30] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get total 8, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='8'" 
12/04/2007 10:34:05 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get total 8' 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (30, 'hdd_used', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[30] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get used 8, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='8'" 
12/04/2007 10:34:05 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get used 8' 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (29, 'hdd_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[29] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get total 7, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='7'" 
12/04/2007 10:34:05 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get total 7' 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (29, 'hdd_used', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[29] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get used 7, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='7'" 
12/04/2007 10:34:05 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get used 7' 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (28, 'hdd_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[28] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get total 4, output: 0 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='4'" 
12/04/2007 10:34:05 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get total 4' 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (28, 'hdd_used', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:05 PM - CMDPHP: Poller[0] Host[1] DS[28] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get used 4, output: 0 
12/04/2007 10:34:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:03 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_hdd_total_27.rrd --template hdd_total:hdd_used 1196804034:0:0 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='27' and rrd_name='hdd_used' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='27' and rrd_name='hdd_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='4'" 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:03 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get used 4' 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (27, 'hdd_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:03 PM - CMDPHP: Poller[0] Host[1] DS[27] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get total 2, output: 0 
12/04/2007 10:34:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:34:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='2'" 
12/04/2007 10:34:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get total 2' 
12/04/2007 10:34:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (27, 'hdd_used', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:34:01 PM - CMDPHP: Poller[0] Host[1] DS[27] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get used 2, output: 0 
12/04/2007 10:34:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:34:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:59 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_hdd_total_26.rrd --template hdd_used:hdd_total 1196804034:0:0 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='26' and rrd_name='hdd_total' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='26' and rrd_name='hdd_used' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='2'" 
12/04/2007 10:33:59 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get used 2' 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (26, 'hdd_used', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:33:59 PM - CMDPHP: Poller[0] Host[1] DS[26] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get used 2, output: 0 
12/04/2007 10:33:58 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:33:58 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:57 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:33:57 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:57 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='2'" 
12/04/2007 10:33:57 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get used 2' 
12/04/2007 10:33:57 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (26, 'hdd_total', '2007-12-04 22:33:54', '0')" 
12/04/2007 10:33:57 PM - CMDPHP: Poller[0] Host[1] DS[26] SERVER: C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php ss_host_disk 127.0.0.1 1 1:161:500:public:::MD5::[None] get total 2, output: 0 
12/04/2007 10:33:56 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:33:56 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_user_22.rrd --template cpu_user 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_system_21.rrd --template cpu_system 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_nice_20.rrd --template cpu_nice 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_user_19.rrd --template cpu_user 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_system_18.rrd --template cpu_system 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_nice_17.rrd --template cpu_nice 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_user_14.rrd --template cpu_user 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_system_13.rrd --template cpu_system 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_cpu_nice_12.rrd --template cpu_nice 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_traffic_in_9.rrd --template traffic_out:traffic_in 1196804034:158038110:7656712 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\server_traffic_in_8.rrd --template traffic_out:traffic_in 1196804034:2062150042:1504256319 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\localhost_proc_7.rrd --template proc 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\localhost_users_6.rrd --template users 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\localhost_load_1min_5.rrd --template 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\localhost_mem_swap_4.rrd --template mem_swap 1196804034:U 
12/04/2007 10:33:55 PM - POLLER: Poller[0] CACTI2RRD: e:/progra~1/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\Php\cacti\rra\localhost_mem_buffers_3.rrd --template mem_buffers 1196804034:U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='22' and rrd_name='cpu_user' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='21' and rrd_name='cpu_system' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='20' and rrd_name='cpu_nice' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='19' and rrd_name='cpu_user' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='18' and rrd_name='cpu_system' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='cpu_nice' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='14' and rrd_name='cpu_user' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='13' and rrd_name='cpu_system' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='12' and rrd_name='cpu_nice' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='traffic_in' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='9' and rrd_name='traffic_out' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_in' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='8' and rrd_name='traffic_out' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='7' and rrd_name='proc' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='6' and rrd_name='users' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='5' and rrd_name='' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='4' and rrd_name='mem_swap' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select field_value from host_snmp_cache where host_id=1 and field_name='hrStorageAllocationUnits' and snmp_index='2'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='3' and rrd_name='mem_buffers' and time='2007-12-04 22:33:54'" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000" 
12/04/2007 10:33:55 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php' FUNC: 'ss_host_disk' PARMS: '127.0.0.1 1 1:161:500:public:::MD5::[None] get total 2' 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (22, 'cpu_user', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[22] SNMP: v1: 127.0.0.1, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[22] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (21, 'cpu_system', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[21] SNMP: v1: 127.0.0.1, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[21] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (20, 'cpu_nice', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[20] SNMP: v1: 127.0.0.1, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[20] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (19, 'cpu_user', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[19] SNMP: v1: 127.0.0.1, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[19] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (18, 'cpu_system', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[18] SNMP: v1: 127.0.0.1, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[18] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (17, 'cpu_nice', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[17] SNMP: v1: 127.0.0.1, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[17] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (14, 'cpu_user', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[14] SNMP: v1: 127.0.0.1, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[14] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (13, 'cpu_system', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[13] SNMP: v1: 127.0.0.1, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[13] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (12, 'cpu_nice', '2007-12-04 22:33:54', 'U')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[12] SNMP: v1: 127.0.0.1, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, output: U 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[12] WARNING: Result from SNMP not valid. Partial Result: 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (9, 'traffic_in', '2007-12-04 22:33:54', '7656712')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[9] SNMP: v1: 127.0.0.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.6, output: 7656712 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (9, 'traffic_out', '2007-12-04 22:33:54', '158038110')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[9] SNMP: v1: 127.0.0.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.6, output: 158038110 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (8, 'traffic_in', '2007-12-04 22:33:54', '1504256319')" 
12/04/2007 10:33:55 PM - CMDPHP: Poller[0] Host[1] DS[8] SNMP: v1: 127.0.0.1, dsname: traffic_in, oid&
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Yea, I'm bored and not feeling motivated to study for finals....

Anyways, next time you post logs, please do so as attachments.

On quick glance over your logs, I didn't see any cmd scripts not returning any data. What is DS[3] through DS[7] ? click on those links in the log file to see what it points to.

Reindexing will only fix those SNMP errors, which I see you still have a few. Most seem to be traffic graphs, which likely is due in invalid indexes.
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

BSOD2600 wrote:Yea, I'm bored and not feeling motivated to study for finals....

Anyways, next time you post logs, please do so as attachments.

On quick glance over your logs, I didn't see any cmd scripts not returning any data. What is DS[3] through DS[7] ? click on those links in the log file to see what it points to.

Reindexing will only fix those SNMP errors, which I see you still have a few. Most seem to be traffic graphs, which likely is due in invalid indexes.
Sorry sorry, my mistake.

Code: Select all

DS[3] - Linux Memory Free
DS[4] - Linux Memory Free Swap
DS[5] - Unix Load Average
DS[6] - Unix Logged in Users
DS[7] - Unix Processes
Well, after all that I did some stupid deleting and trying to recreate data sources, what totaly failed. As I see it, I'm not getting anywhere tonight. I should better get some sleep now and will look over this again tomorrow.

Thank you very much for your help so far! Maybe until tomorrow!
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Yea, those are for linux systems and don't work against windows. Sounds like you didn't read my installation guide ;-) 'cause if you did, you would've deleted the default device that cacti installs and avoided this little problem.
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

BSOD2600 wrote:Yea, those are for linux systems and don't work against windows. Sounds like you didn't read my installation guide ;-) 'cause if you did, you would've deleted the default device that cacti installs and avoided this little problem.
Hm, well, I think I did follow the installation manual when I initially set it up (http://bsod2600.home.comcast.net/install_windows.html). Maybe I did skip this part by mistake.

Right now I did some tidying up. There are no more errors in the log. I could successfully read and graph the partitions infos from another machine. But not from the local machine.

Remote system:

Code: Select all

1) SNMP - Get Mounted Partitions 	(Verbose Query) 	Uptime Goes Backwards 	Success [15 Items, 5 Rows]
Local system:

Code: Select all

1) SNMP - Get Mounted Partitions 	(Verbose Query) 	Uptime Goes Backwards 	Success [0 Items, 0 Rows]
I'll compare both machines' ntfs permissions later this day, but when I did so yesterday (quick check) they seemed pretty equal.

Verbose query:

Code: Select all

+ Running data query [8].
+ Found type = '6 '[script query].
+ Found data query XML file at 'C:/Inetpub/wwwroot/Php/cacti/resource/script_server/host_disk.xml'
+ XML file parsed ok.
+ Executing script for list of indexes 'c:\progra~1\php\php.exe -q C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php 127.0.0.1 1 1:161:500:public:::MD5::[None] index'
+ Executing script query 'c:\progra~1\php\php.exe -q C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php 127.0.0.1 1 1:161:500:public:::MD5::[None] query index'
+ Executing script query 'c:\progra~1\php\php.exe -q C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php 127.0.0.1 1 1:161:500:public:::MD5::[None] query description'
+ Executing script query 'c:\progra~1\php\php.exe -q C:\Inetpub\wwwroot\Php\cacti\scripts\ss_host_disk.php 127.0.0.1 1 1:161:500:public:::MD5::[None] query sau'
+ Found data query XML file at 'C:/Inetpub/wwwroot/Php/cacti/resource/script_server/host_disk.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/Php/cacti/resource/script_server/host_disk.xml'
+ Found data query XML file at 'C:/Inetpub/wwwroot/Php/cacti/resource/script_server/host_disk.xml'
But all this has one good thing: I was forced to spend a little more time with Cacti's configuration and its terms.

By the way: I have the same problem with cpu information.
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Go to the snmp service and enabled all of the agents. Restart the service. See if disk and cpu return data.
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

I'm afraid they were already activated. But I did uncheck/check all, saved the service and restarted it. Still no change :-(
Attachments
service.gif
service.gif (6.71 KiB) Viewed 5565 times
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

hmm ok. snmpwalk .1.3.6.1.2.1.25.2.3 for the localhost and see if it returns anything. If not, does that device return any snmp data at all?
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

Hm, because I didn't get snmpwalk running, I tried another snmp client and told it to give me all subitems of the snmp path you posted.

That's the result of both machines, so they are both providing the requested data.

Code: Select all

1.3.6.1.2.1.25.2.3.1.1.1	1	2	3	4	5	6	7	8
1.3.6.1.2.1.25.2.3.1.2.11.3.6.1.2.1.25.2.1.5
1.3.6.1.2.1.25.2.3.1.3.1	A:\	C:\ Label:System  Serial Number xxxxx	D:\ Label:Daten  Serial Number xxxxx	E:\ Label:Temp  Serial Number xxxxx	F:\	G:\	Virtual Memory	Physical Memory
1.3.6.1.2.1.25.2.3.1.4.1	0	4096	4096	4096	0	0	65536	65536
1.3.6.1.2.1.25.2.3.1.5.1	0	11490483	732380927	66651668	0	0	128366	65521
1.3.6.1.2.1.25.2.3.1.6.1	0	3573126	272193882	8817564	0	0	38100	51954
1.3.6.1.2.1.25.2.3.1.7.1	0	0	0	0	0	0	0	01.3.6.1.2.1.25.2.3.1.1.1	1	2	3	4	5
1.3.6.1.2.1.25.2.3.1.2.11.3.6.1.2.1.25.2.1.5
1.3.6.1.2.1.25.2.3.1.3.1	A:\	C:\ Label:  Serial Number xxxxx	D:\	Virtual Memory	Physical Memory
1.3.6.1.2.1.25.2.3.1.4.1	0	4096	0	65536	65536
1.3.6.1.2.1.25.2.3.1.5.1	0	1046225	0	20064	8183
1.3.6.1.2.1.25.2.3.1.6.1	0	961025	0	3866	6748
1.3.6.1.2.1.25.2.3.1.7.1	0	0	0	0	0
This should be the correct command, should'nt it?

Code: Select all

E:\Programme\Net-SNMP\bin>snmpwalk 127.0.0.1 1.3.6.1.2.1.25.2.3
Cannot find module (NOTIFICATION-LOG-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (DISMAN-EVENT-MIB): At line 1 in (none)
snmpwalk: Timeout
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Brainscanner wrote:This should be the correct command, should'nt it?
Almost. Try: snmpwalk -v 1 -c public 127.0.0.1 .1.3.6.1.2.1.25.2.3

Does any snmp query from cacti work against the 'local system' ?
Top
Brainscanner
Posts: 24
Joined: Tue Oct 16, 2007 2:59 am

Post by Brainscanner »

That is one weird problem...

Code: Select all

E:\Programme\Net-SNMP\bin>snmpwalk -v 1 -c public 127.0.0.1 .1.3.6.1.2.1.25.2.3
Cannot find module (NOTIFICATION-LOG-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (DISMAN-EVENT-MIB): At line 1 in (none)
Timeout: No Response from 127.0.0.1
Especially since it does work from within cacti.

Just to make that clear: This is the machine, on which the webserver with cacti is running. And it's supposed to retrieve data from itself.

The smtp service is configured to allow localhost connections.
Attachments
snmp service.gif
snmp service.gif (15.32 KiB) Viewed 5501 times
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Brainscanner wrote:Especially since it does work from within cacti.
It does? You showed the 'SNMP - Get Mounted Partitions' query didn't work on the localhost. There is no logical reason why cacti's snmp query would work and snmpwalk would not.

Only thing I could think of is a firewall app blocking the queries.
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 1 guest