CMDPHP: Poller[0] DEBUG: SQL Cell Error

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

Moderators: Developers, Moderators

Post Reply
brewcrew
Posts: 2
Joined: Thu Mar 23, 2006 1:50 pm

CMDPHP: Poller[0] DEBUG: SQL Cell Error

Post by brewcrew »

Hi, I finally got my system up and running (partially). I used BSOD2600's install guide (which was great), but amd having a few issues post-install. I'm trying to gather SNMP data from a Cisco switch, am getting SNMP data, but no data on the graphs (they're just empty). I double checked all permissions as per installation instructions (and several posts in this forum), and all checks out OK. The RRD files do appear in /cacti/rra/, but they have not changed or updated. Poller appears to be running OK (as Administrator).


Operating System: W2K3 SP1
Webserver: IIS 6
Cacti: cacti-0.8.6h (patched)
Cactid: cacti-cactid-0.8.6g
MySQL: mysql-4.1.18-win32
PHP: php-5.1.2-Win32
RRDTool: rrdtool-cygwin-1.2.12
Net-SNMP: net-snmp-5.3.0.1-1.win32
Cygwin: 2.510.2.2

I have data from /cacti/log/cacti.log attached below....

Please help!



03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:18: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'"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
03/23/2006 03:18: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 from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id=43"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_id from graph_templates_graph where local_graph_id=43"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:18: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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:18: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 from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id=43"

03/23/2006 03:18: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=43 group by rra.id order by rra.timespan"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,steps,name from rra where id=1"

03/23/2006 03:18: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=43 LIMIT 0,1"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_graph.height, graph_templates_graph.width from graph_templates_graph where graph_templates_graph.local_graph_id=43"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='title_font' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:18: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'"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:18: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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:18: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=43 limit 0,1"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"

03/23/2006 03:18: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.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=43"

03/23/2006 03:18: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, 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=43 order by graph_templates_item.sequence"
03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

03/23/2006 03:18:27 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=40"

03/23/2006 03:18:27 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1143055107 --end=1143141207 --title="testme" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2006/03/22 15\:18\:27 To 2006/03/23 15\:13\:27\c" COMMENT:" \n" --vertical-label="up here" --slope-mode DEF:a="c\:/Inetpub/wwwroot/cacti/rra/1st_floor_closet_v283b07cp3m13208_traffic_in_40.rrd":traffic_in:AVERAGE AREA:a#F5F800:"this is me" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:23:58 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'"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"

03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
03/23/2006 03:23:58 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=43"

03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_id from graph_templates_graph where local_graph_id=43"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:23:58 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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:23:58 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=43"

03/23/2006 03:23:58 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=43 group by rra.id order by rra.timespan"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,steps,name from rra where id=1"

03/23/2006 03:23:58 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=43 LIMIT 0,1"
03/23/2006 03:23:58 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_graph.height, graph_templates_graph.width from graph_templates_graph where graph_templates_graph.local_graph_id=43"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:23:59 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'"
03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:23:59 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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:23:59 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=43 limit 0,1"
03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=43"

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

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

03/23/2006 03:23:59 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=40"

03/23/2006 03:23:59 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1143055438 --end=1143141538 --title="testme" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2006/03/22 15\:23\:58 To 2006/03/23 15\:18\:58\c" COMMENT:" \n" --vertical-label="up here" --slope-mode DEF:a="c\:/Inetpub/wwwroot/cacti/rra/1st_floor_closet_v283b07cp3m13208_traffic_in_40.rrd":traffic_in:AVERAGE AREA:a#F5F800:"this is me" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
03/23/2006 03:29:10 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=43"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select local_graph_id from graph_templates_graph where local_graph_id=43"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:29:10 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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:29:10 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=43"

03/23/2006 03:29:10 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=43 group by rra.id order by rra.timespan"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,steps,name from rra where id=1"

03/23/2006 03:29:10 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=43 LIMIT 0,1"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_templates_graph.height, graph_templates_graph.width from graph_templates_graph where graph_templates_graph.local_graph_id=43"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='7'"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"

03/23/2006 03:29:10 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=43 group by graph_templates_graph.local_graph_id"
03/23/2006 03:29:10 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=43 limit 0,1"
03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=43"

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

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='axis_font' and user_id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='legend_font' and user_id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select value from settings_graphs where name='unit_font' and user_id=1"

03/23/2006 03:29:10 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=40"

03/23/2006 03:29:10 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph - --imgformat=PNG --start=1143055750 --end=1143141850 --title="testme" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 COMMENT:"From 2006/03/22 15\:29\:10 To 2006/03/23 15\:24\:10\c" COMMENT:" \n" --vertical-label="up here" --slope-mode DEF:a="c\:/Inetpub/wwwroot/cacti/rra/1st_floor_closet_v283b07cp3m13208_traffic_in_40.rrd":traffic_in:AVERAGE AREA:a#F5F800:"this is me" GPRINT:a:LAST:"Current\:%8.2lf %s" GPRINT:a:AVERAGE:"Average\:%8.2lf %s" GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

1) install the patches for cacti
2) ignore the SQL Cell Error errors. The devs have added extra debugging code and turned up that...cacti works fine with them.
3) the rrd files not getting updated, even when running the scheduled task as admin is a big problem. sure you've specified the correct path to rrdtool in cacti's settings? you might want to try using FileMon during a cacti polling cycle and see what is getting denied for rrdtool.exe.
Top
brewcrew
Posts: 2
Joined: Thu Mar 23, 2006 1:50 pm

Post by brewcrew »

Verified Patches (missed one)

RRD Files are still not being created / updated. Checked poller process using FileMon, noting turned up Denied. Funny thing is, I have 3 devices that I had created that are working / updating fine, but if I try to add a new device, it will not create the RRD file. SNMP query comes back OK when creating the device.

Any suggestions?

Thanks[/quote]
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

1) No denied in Filemon? Well what does rrdtool try to do when it attempts to create that missing rrd file?
2) Is there a CACTI2RRD entry in your cacti.log file for that missing rrd file?
3) Is cacti returning valid data for that data source, which does not have an rrd file? Enable debugging logging to find out.
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 2 guests