Windows All-In-One Installer [Cacti 1.2.24] [Updated 2023-03-09]
Moderators: Developers, Moderators
Please consider reading http://www.catb.org/~esr/faqs/smart-questions.html before posting next time.
Any errors in the windows event log? iis web logs?
What happens when you run: php C:\inetpub\wwwroot\cacti\poller.php from the commandline?
Any errors in the windows event log? iis web logs?
What happens when you run: php C:\inetpub\wwwroot\cacti\poller.php from the commandline?
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
-
- Posts: 1
- Joined: Wed Jul 23, 2008 5:28 pm
I've gone through all the ntfs file permissions. All are set correctly!
Here is my log file and the error messages.
I'm runninf win 2003 sp2 with your installer:
I get no graphs. Please help, my head is about to explode.
Thanks:
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="localhost - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE \
AREA:a#F51D30FF:"Running Processes" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf"
RRDTool Says:
ERROR: opening 'C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd': No such file or directory
-------
log file
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/11/2008 02:13:22 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='5'"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_template_graph_id from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where id=37"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:22 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=7"
08/11/2008 02:13:22 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=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id,graph_templates.name from graph_templates order by name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,CONCAT_WS('',description,' (',hostname,')') as name from host order by description,hostname"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where graph_template_id=29 and local_graph_id=0"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from graph_template_input where graph_template_id=29 order by column_name,name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.color_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=72 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.task_item_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=71 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,hex from colors order by hex desc"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=2 order by name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/11/2008 02:13:32 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='5'"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_template_graph_id from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where id=37"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:32 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=7"
08/11/2008 02:13:32 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=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id,graph_templates.name from graph_templates order by name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,CONCAT_WS('',description,' (',hostname,')') as name from host order by description,hostname"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where graph_template_id=29 and local_graph_id=0"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from graph_template_input where graph_template_id=29 order by column_name,name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.color_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=72 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.task_item_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=71 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,hex from colors order by hex desc"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=2 order by name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
Here is my log file and the error messages.
I'm runninf win 2003 sp2 with your installer:
I get no graphs. Please help, my head is about to explode.
Thanks:
RRDTool Command:
c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="localhost - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE \
AREA:a#F51D30FF:"Running Processes" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf"
RRDTool Says:
ERROR: opening 'C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd': No such file or directory
-------
log file
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/11/2008 02:13:22 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='5'"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_template_graph_id from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where id=37"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:22 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=7"
08/11/2008 02:13:22 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=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id,graph_templates.name from graph_templates order by name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,CONCAT_WS('',description,' (',hostname,')') as name from host order by description,hostname"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where graph_template_id=29 and local_graph_id=0"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from graph_template_input where graph_template_id=29 order by column_name,name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.color_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=72 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.task_item_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=71 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,hex from colors order by hex desc"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=2 order by name"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:22 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/11/2008 02:13:32 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='5'"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_template_graph_id from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where id=37"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:32 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=7"
08/11/2008 02:13:32 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=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id,graph_templates.name from graph_templates order by name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,CONCAT_WS('',description,' (',hostname,')') as name from host order by description,hostname"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from graph_templates_graph where graph_template_id=29 and local_graph_id=0"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from graph_template_input where graph_template_id=29 order by column_name,name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host_id from graph_local where id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.color_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=72 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_item.task_item_id, graph_templates_item.id from (graph_templates_item,graph_template_input_defs) where graph_template_input_defs.graph_template_item_id=graph_templates_item.local_graph_template_item_id and graph_template_input_defs.graph_template_input_id=71 and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,hex from colors order by hex desc"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=2 order by name"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/11/2008 02:13:32 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
evoluman & cahonis: Neither of your problems are directly with the installer. Please create new posts for your problems.
cahonis: Search your system for duplicate php.ini files. Delete all except for the one in c:\php\. Go through all the installation guide for PHP/IIS, and click the OK dialog to every window (so it'll re-set the settings).
Another option is http://support.microsoft.com/kb/820129, and change AllowRestrictedChars to 1.
evoluman: Did you wait 5 min for the rrd files to get created? Your log file is useless since it doesn't contain any data from when the cacti poller ran. Please read the steps in http://forums.cacti.net/viewtopic.php?t=11747
cahonis: Search your system for duplicate php.ini files. Delete all except for the one in c:\php\. Go through all the installation guide for PHP/IIS, and click the OK dialog to every window (so it'll re-set the settings).
Another option is http://support.microsoft.com/kb/820129, and change AllowRestrictedChars to 1.
evoluman: Did you wait 5 min for the rrd files to get created? Your log file is useless since it doesn't contain any data from when the cacti poller ran. Please read the steps in http://forums.cacti.net/viewtopic.php?t=11747
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
no data on graphs
I used the beta installer and evrything has worked fine except that there is no data on the graphs. The rrd files in the rra folder all have lots of data and they range in size from 102 kb to 1371 kb and I know there is no mysql problem. Please help.....
- Attachments
-
- screenshot.pdf
- (53.85 KiB) Downloaded 190 times
*sigh*
Neither of you read my post...Neither of your problems are directly with the installer. Please create new posts for your problems.
evoluman, follow the troubleshooting steps in http://forums.cacti.net/viewtopic.php?t=11747
Neither of you read my post...Neither of your problems are directly with the installer. Please create new posts for your problems.
evoluman, follow the troubleshooting steps in http://forums.cacti.net/viewtopic.php?t=11747
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
I think my problem occurs because I did not install the cacti website to the default location (C:\Inetpub\wwwroot\cacti) under the default website.
I installed it to D:\cacti and into it's own website (cacti) on port 8081.
Re-installed to the default locations and worked first time.
Is there a reason why it wouldn't work if not instaled into the default locations?
I installed it to D:\cacti and into it's own website (cacti) on port 8081.
Re-installed to the default locations and worked first time.
Is there a reason why it wouldn't work if not instaled into the default locations?
graphs with no data
Hi,
Please take a look at my log file. I've been trying to debug for a log time.
I kow its not an rrd issue or mysql issue or ntfs (the task is running thoriugh the admin account). the rrd files are being created. Im attaching that as well.
I've even cacelled all the graphs other that one localhost cpu usage.
Any help would be great5ly appruciated.
By the way I used your installer to setup everything. and I have a win 2003 with sp2
--------
log:
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) where graph_tree_items.graph_tree_id=1 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host.description from (graph_tree_items,host) where graph_tree_items.host_id=host.id and graph_tree_items.id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_local,graph_templates,graph_templates_graph) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.graph_template_id=graph_templates.id and graph_local.host_id=2 group by graph_templates.id order by graph_templates.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=29 and graph_local.host_id=2 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=0 and graph_local.host_id=2 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from (graph_templates_item,data_template_data_rra,data_template_rrd,data_template_data,rra) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_data.id=data_template_data_rra.data_template_data_id and data_template_data_rra.rra_id=rra.id and graph_templates_item.local_graph_id=7 group by rra.id order by rra.timespan"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1218837267 --end=1218839067 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2008/08/15 14\:54\:27 To 2008/08/15 15\:24\:27\c" COMMENT:" \n" --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='8'"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
08/15/2008 03:25:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',1218839100)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Inetpub/wwwroot/cacti')"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
08/15/2008 03:25:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 0]
08/15/2008 03:25:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 2 2]
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 0) ORDER by id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0) ORDER by host_id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 0)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 0)"
08/15/2008 03:25:00 PM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 2 AND id <= 2) ORDER by id"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 2 AND host_id <= 2 AND rrd_next_step <= 0) ORDER by host_id"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 2 AND host_id <= 2 AND rrd_next_step <= 0)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 2 AND host_id <= 2)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 2 AND host_id <= 2)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: FILENM: C:\Inetpub\wwwroot\cacti\script_server.php
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] PING: Host is alive
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '2008-08-08 13:50:03', status_rec_date = '2008-08-12 14:19:59', status_last_error = 'Host did not respond to SNMP', min_time = '0.00000', max_time = '171.99993', cur_time = '0.19', avg_time = '2.65605399393', total_polls = '1184', failed_polls = '195', availability = '83.5304054054' where hostname = 'localhost'"
08/15/2008 03:25:01 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=2"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] RECACHE: Processing 3 items in the auto reindex cache for 'localhost'.
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_traffic.php' FUNC: 'ss_protocol_traffic' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[17] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[17] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_traffic.php ss_protocol_traffic localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (17, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_tcp.php' FUNC: 'ss_protocol_tcp' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[15] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[15] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_tcp.php ss_protocol_tcp localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (15, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_ip.php' FUNC: 'ss_protocol_ip' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[16] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[16] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_ip.php ss_protocol_ip localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (16, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='16' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='15' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_ipinhdrerrors_16.rrd --template 1218839101:U
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_tcpactiveopens_15.rrd --template 1218839101:U
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_snmpinpkts_17.rrd --template 1218839101:U
08/15/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] Time: 5.4678 s, Theads: N/A, Hosts: 1
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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) "
08/15/2008 03:25:06 PM - SYSTEM STATS: Time:6.3554 Method:cmd.php Processes:2 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:3 RRDsProcessed:3
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:6.3554 Method:cmd.php Processes:2 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:3 RRDsProcessed:3')"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
Please take a look at my log file. I've been trying to debug for a log time.
I kow its not an rrd issue or mysql issue or ntfs (the task is running thoriugh the admin account). the rrd files are being created. Im attaching that as well.
I've even cacelled all the graphs other that one localhost cpu usage.
Any help would be great5ly appruciated.
By the way I used your installer to setup everything. and I have a win 2003 with sp2
--------
log:
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key, graph_tree_items.host_id, graph_tree_items.host_grouping_type, host.description as hostname from graph_tree_items left join host on (host.id=graph_tree_items.host_id) left join user_auth_perms on (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) where graph_tree_items.graph_tree_id=1 and !(user_auth_perms.user_id is not null and graph_tree_items.host_id > 0) and graph_tree_items.local_graph_id = 0 order by graph_tree_items.order_key"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=1) where user_auth_perms.user_id is null order by graph_tree.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select host.description from (graph_tree_items,host) where graph_tree_items.host_id=host.id and graph_tree_items.id=8"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates.id, graph_templates.name from (graph_local,graph_templates,graph_templates_graph) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.graph_template_id=graph_templates.id and graph_local.host_id=2 group by graph_templates.id order by graph_templates.name"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=29 and graph_local.host_id=2 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.title_cache, graph_templates_graph.local_graph_id from (graph_local,graph_templates_graph) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_local.id=graph_templates_graph.local_graph_id and graph_local.graph_template_id=0 and graph_local.host_id=2 and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) order by graph_templates_graph.title_cache"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_graph.local_graph_id from (graph_templates_graph,graph_local) left join host on (host.id=graph_local.host_id) left join graph_templates on (graph_templates.id=graph_local.graph_template_id) left join user_auth_perms on ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=1) OR (host.id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=1) OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=1)) where graph_templates_graph.local_graph_id=graph_local.id and ((user_auth_perms.type != 1 OR user_auth_perms.type is null) AND ((user_auth_perms.type != 3) OR (user_auth_perms.type is null)) AND ((user_auth_perms.type != 4) OR (user_auth_perms.type is null))) and graph_templates_graph.local_graph_id=7 group by graph_templates_graph.local_graph_id"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=7 limit 0,1"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from (graph_templates_item,data_template_data_rra,data_template_rrd,data_template_data,rra) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and data_template_data.id=data_template_data_rra.data_template_data_id and data_template_data_rra.rra_id=rra.id and graph_templates_item.local_graph_id=7 group by rra.id order by rra.timespan"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.slope_mode, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.scale_log_units, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=7"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, graph_templates_item.alpha, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=7 order by graph_templates_item.sequence"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe info C:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
08/15/2008 03:24:27 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1218837267 --end=1218839067 --title="localhost - Processes" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2008/08/15 14\:54\:27 To 2008/08/15 15\:24\:27\c" COMMENT:" \n" --vertical-label="processes" --slope-mode --font TITLE:10: --font AXIS:8: --font LEGEND:8: --font UNIT:8: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/localhost_proc_10.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Processes" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINTMAX:"Maximum\:%8.0lf"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='8'"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/15/2008 03:24:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
08/15/2008 03:25:00 PM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('poller_lastrun',1218839100)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/Inetpub/wwwroot/cacti')"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "TRUNCATE TABLE poller_time"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
08/15/2008 03:25:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 0]
08/15/2008 03:25:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 2 2]
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 0 AND id <= 0) ORDER by id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0) ORDER by host_id"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 0 AND rrd_next_step <= 0)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <= 0)"
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 0 AND host_id <= 0)"
08/15/2008 03:25:00 PM - POLLER: Poller[0] NOTE: There are no items in your poller for this polling cycle!
08/15/2008 03:25:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: " SELECT * FROM host WHERE (disabled = '' AND id >= 2 AND id <= 2) ORDER by id"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM poller_item WHERE (host_id >= 2 AND host_id <= 2 AND rrd_next_step <= 0) ORDER by host_id"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) FROM poller_item WHERE (action=2 AND host_id >= 2 AND host_id <= 2 AND rrd_next_step <= 0)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 2 AND host_id <= 2)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (rrd_next_step < 0 AND host_id >= 2 AND host_id <= 2)"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item where rrd_next_step<=0"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: FILENM: C:\Inetpub\wwwroot\cacti\script_server.php
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] PING: Host is alive
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '2008-08-08 13:50:03', status_rec_date = '2008-08-12 14:19:59', status_last_error = 'Host did not respond to SNMP', min_time = '0.00000', max_time = '171.99993', cur_time = '0.19', avg_time = '2.65605399393', total_polls = '1184', failed_polls = '195', availability = '83.5304054054' where hostname = 'localhost'"
08/15/2008 03:25:01 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=2"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] RECACHE: Processing 3 items in the auto reindex cache for 'localhost'.
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='8' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='U' where host_id='2' and data_query_id='9' and arg1='.1.3.6.1.2.1.1.3.0'"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_traffic.php' FUNC: 'ss_protocol_traffic' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[17] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[17] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_traffic.php ss_protocol_traffic localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (17, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_tcp.php' FUNC: 'ss_protocol_tcp' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[15] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[15] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_tcp.php ss_protocol_tcp localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (15, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: INC: 'C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_ip.php' FUNC: 'ss_protocol_ip' PARMS: 'localhost public 0 161 500'
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: PHP Script File to be included, does not exist
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] WARNING: Function does not exist
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[16] WARNING: Result from SERVER not valid. Partial Result: WARNING: Function do
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] Host[2] DS[16] SERVER: C:/Inetpub/wwwroot/cacti/scripts/ss_protocol_ip.php ss_protocol_ip localhost public 0 161 500 , output: U
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (16, '', '2008-08-15 15:25:01', 'U')"
08/15/2008 03:25:01 PM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='16' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='15' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='' and time='2008-08-15 15:25:01'"
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_ipinhdrerrors_16.rrd --template 1218839101:U
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_tcpactiveopens_15.rrd --template 1218839101:U
08/15/2008 03:25:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\localhost_snmpinpkts_17.rrd --template 1218839101:U
08/15/2008 03:25:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:05 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] Time: 5.4678 s, Theads: N/A, Hosts: 1
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
08/15/2008 03:25: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) "
08/15/2008 03:25:06 PM - SYSTEM STATS: Time:6.3554 Method:cmd.php Processes:2 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:3 RRDsProcessed:3
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:6.3554 Method:cmd.php Processes:2 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:3 RRDsProcessed:3')"
08/15/2008 03:25:06 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
1) you should be using cacti 0.8.7b.
2) you should post your question on the weather map forum
2) you should post your question on the weather map forum
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Thank for all recommend.BSOD2600 wrote:1) you should be using cacti 0.8.7b.
2) you should post your question on the weather map forum
HELP - Vista!
Hey guys,
I'm right now getting a bit depressed for having lost my whole day trying to install cacti on my own, until I found the great installer.
And everything went well, until the part with the "post-install".
The problem is, that I have Windows Vista and
1. there is no Scheduled Task where I can check the properties which are described in the first point of the post-installation.
and 2. - unfortunately, when I open the IIS Manager, I cannot click anywhere on the Default Website properties - see here: http://www.fileshack.us/get_file.php?id ... enannt.jpg
What can I do to configure the installation correctly on Vista?
Fast help would be appreciated
So thanks in advance!!!
Greetings from Germany
I'm right now getting a bit depressed for having lost my whole day trying to install cacti on my own, until I found the great installer.
And everything went well, until the part with the "post-install".
The problem is, that I have Windows Vista and
1. there is no Scheduled Task where I can check the properties which are described in the first point of the post-installation.
and 2. - unfortunately, when I open the IIS Manager, I cannot click anywhere on the Default Website properties - see here: http://www.fileshack.us/get_file.php?id ... enannt.jpg
What can I do to configure the installation correctly on Vista?
Fast help would be appreciated
So thanks in advance!!!
Greetings from Germany
Hmm, the installer wasn't tested / intended for Vista because it is vastly different from previous versions of Windows. You're going to need to follow my installation guide (in signature) as a filler for the portions which the installer was unable to complete.
1) The installation guide contains instructions on how to set up the scheduled task.
2) Follow the Windows 2003 portions of the guide for IIS / PHP configuration, since it appears Vista (aka IIS 7) is close to that.
1) The installation guide contains instructions on how to set up the scheduled task.
2) Follow the Windows 2003 portions of the guide for IIS / PHP configuration, since it appears Vista (aka IIS 7) is close to that.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 0 guests