RRD Error, need help solving config.

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
bmcwhirt
Posts: 8
Joined: Sun Apr 01, 2012 12:23 am

RRD Error, need help solving config.

Post by bmcwhirt »

I have Cacti set up and running but some where I must have an error.

In my era/*.rrd files there is nothing but '?????' so I imagine something is wrong with the red command or something.

OS: FreeBSD 9.0
Cacti: Version 0.8.7i from ports
RRD: 1.4.5 from ports
Spine: 0.8.7h from ports

This is my first Cacti install so I don't know what else you may need, so just ask.

Thanks
Bryan
Top
bmcwhirt
Posts: 8
Joined: Sun Apr 01, 2012 12:23 am

Re: RRD Error, need help solving config.

Post by bmcwhirt »

Ok, I'm still getting 0 data and in fact it seems the cron job either does not work or isn't running.

*/5 * * * * cacti /usr/local/bin/php /usr/local/share/cacti/poller.php > /dev/null 2>1

Is what is in my cron, If I run it manually it seems to only update one of my .rrd files not all of them but after several house of waiting non of them is being updated automatically. It is 10:55am and the last update to any of them was at 1:57am

Something strange is going on and Im not sure what.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Re: RRD Error, need help solving config.

Post by gandalf »

Please use spine-087i for latest cacti. If this is not yet available via ports, please compile from source.
Reroute the poller output to some file to find out, what's happening here
R.
Top
bmcwhirt
Posts: 8
Joined: Sun Apr 01, 2012 12:23 am

Re: RRD Error, need help solving config.

Post by bmcwhirt »

I don't see an option int the configure script for setting the config location as FreeBSD does not use /etc it uses /usr/locale/etc at /etc isn't accessible to most applications.

After compiling from source spine keeps trying to access the config in /etc and it doesn't have permission to access /etc even if I move the config file there. I was also told that the reason spine 0.8.7i isn't in the ports are there are compatibility issues in FBSD.


I went ahead and redirected the poller. It's generating no output at all when run from cron.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Re: RRD Error, need help solving config.

Post by gandalf »

Please increase verbosity level, then
R.
Top
bmcwhirt
Posts: 8
Joined: Sun Apr 01, 2012 12:23 am

Re: RRD Error, need help solving config.

Post by bmcwhirt »

This is the debug from graph mode.

Code: Select all

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='Cisco 3660 - Traffic - Fa0/0' \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label='bits per second' \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="/usr/local/share/cacti/rra/cisco_3660_traffic_in_8.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/cisco_3660_traffic_in_8.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00FF:"Inbound"  \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s"  \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:cdefe#002A97FF:"Outbound"  \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n" 
RRDTool Says:
OK
I set the debug level to developer and with spine I get noting in the cacti logs at all.
I set it back to cmd.php and this is what I get after 20 minuets.

Code: Select all

04/03/2012 03:15:59 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/local/bin/rrdtool graph - --imgformat=PNG --start=1333394157 --end=1333480557 --title='Switch 1 - Traffic - Fa0/36' --rigid --base=1000 --height=100 --width=300 --alt-autoscale-max --lower-limit=0 --no-legend COMMENT:"From 2012/04/02 15\:15\:57 To 2012/04/03 15\:15\:57\c" COMMENT:" \n" --vertical-label='bits per second' --slope-mode --font TITLE:7: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/local/share/cacti/rra/3/21.rrd":traffic_in:AVERAGE DEF:b="/usr/local/share/cacti/rra/3/21.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00FF:"" LINE1:cdefe#002A97FF:""
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:59 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "SELECT * FROM host WHERE id=3"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='custom_fonts' and user_id=1"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: 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=18 order by graph_templates_item.sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select graph_local.id AS local_graph_id, 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=18"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from graph_templates_item LEFT JOIN data_template_rrd ON (graph_templates_item.task_item_id=data_template_rrd.id) LEFT JOIN data_template_data ON (data_template_rrd.local_data_id=data_template_data.local_data_id) LEFT JOIN data_template_data_rra ON (data_template_data.id=data_template_data_rra.data_template_data_id) LEFT JOIN rra ON (data_template_data_rra.rra_id=rra.id) where graph_templates_item.local_graph_id=18 AND data_template_rrd.local_data_id != 0 group by rra.id order by rra.timespan"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: 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=18 limit 0,1"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: 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=18 group by graph_templates_graph.local_graph_id"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: 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'"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"
04/03/2012 03:15:58 PM - WEBLOG: Poller[0] CACTI2RRD: /usr/local/bin/rrdtool graph - --imgformat=PNG --start=1333394157 --end=1333480557 --title='Cisco 3660 - Traffic - Se1/0:0' --rigid --base=1000 --height=100 --width=300 --alt-autoscale-max --lower-limit=0 --no-legend COMMENT:"From 2012/04/02 15\:15\:57 To 2012/04/03 15\:15\:57\c" COMMENT:" \n" --vertical-label='bits per second' --slope-mode --font TITLE:7: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="/usr/local/share/cacti/rra/cisco_3660_traffic_in_10.rrd":traffic_in:AVERAGE DEF:b="/usr/local/share/cacti/rra/cisco_3660_traffic_in_10.rrd":traffic_out:AVERAGE CDEF:cdefa=a,8,* CDEF:cdefe=b,8,* AREA:cdefa#00CF00FF:"" LINE1:cdefe#002A97FF:""
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "SELECT * FROM host WHERE id=2"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=8"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=9"
04/03/2012 03:15:58 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select type,value from cdef_items where id=7"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select name,data_source_path from data_template_data where local_data_id=10"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='custom_fonts' and user_id=1"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='default_datechar' and user_id=1"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select value from settings_graphs where name='default_date_format' and user_id=1"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: 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"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select graph_local.id AS local_graph_id, 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"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select rra.id, rra.steps, rra.rows, rra.name, rra.timespan, data_template_data.rrd_step from graph_templates_item LEFT JOIN data_template_rrd ON (graph_templates_item.task_item_id=data_template_rrd.id) LEFT JOIN data_template_data ON (data_template_rrd.local_data_id=data_template_data.local_data_id) LEFT JOIN data_template_data_rra ON (data_template_data.id=data_template_data_rra.data_template_data_id) LEFT JOIN rra ON (data_template_data_rra.rra_id=rra.id) where graph_templates_item.local_graph_id=7 AND data_template_rrd.local_data_id != 0 group by rra.id order by rra.timespan"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: 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"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: 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"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Row: "select policy_graphs,policy_hosts,policy_graph_templates from user_auth where id=1"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: 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'"
04/03/2012 03:15:57 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id, username AS name FROM user_auth ORDER BY name"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_password'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_password'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_user'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_user'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_passive'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_passive'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_port'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_port'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_host'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_host'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_ftp_sanitize'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_ftp_sanitize'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_hdr_ftp'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_hdr_ftp'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_daily'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_daily'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_hourly'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_hourly'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='path_html_export_skip'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='path_html_export_skip'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_timing'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_timing'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_hdr_timing'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_hdr_timing'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_temporary_directory'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_temporary_directory'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='path_html_export'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='path_html_export'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_hdr_paths'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_hdr_paths'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_num_columns'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_num_columns'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_default_width'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_default_width'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_default_height'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_default_height'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_thumb_options'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_thumb_options'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_tree_expand_hosts'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_tree_expand_hosts'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_user_id'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_user_id'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_tree_isolation'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_tree_isolation'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_tree_options'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_tree_options'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_presentation'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_presentation'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_type'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_type'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='export_hdr_general'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='export_hdr_general'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select username from user_auth where id=1"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='0'"
04/03/2012 03:14:45 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_recovery_count'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_recovery_count'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_failure_count'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_failure_count'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='updown_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='updown_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_retries'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_retries'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_timeout'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_timeout'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_port'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_port'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='ping_method'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='ping_method'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='availability_method'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='availability_method'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='availability_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='availability_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='max_get_size'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='max_get_size'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='script_timeout'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='script_timeout'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='php_servers'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='php_servers'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='max_threads'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='max_threads'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='spine_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='spine_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='process_leveling'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='process_leveling'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='concurrent_processes'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='concurrent_processes'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='cron_interval'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='cron_interval'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_interval'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_interval'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_type'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_type'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_enabled'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_enabled'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_header'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select username from user_auth where id=1"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='0'"
04/03/2012 03:14:42 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='deletion_verification'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='deletion_verification'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='reindex_method'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='reindex_method'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='other_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='other_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_retries'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_retries'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_port'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_port'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_timeout'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_timeout'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_priv_protocol'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_priv_protocol'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_priv_passphrase'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_priv_passphrase'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_auth_protocol'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_auth_protocol'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_password'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_password'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_username'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_username'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_community'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_community'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_ver'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_ver'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='rrdtool_version'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='rrdtool_version'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='snmp_version'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='snmp_version'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='versions_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='versions_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_perror'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_perror'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_pwarn'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_pwarn'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_pstats'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_pstats'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_verbosity'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_verbosity'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='poller_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='poller_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_export'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_export'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_graph'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_graph'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_snmp'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_snmp'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='log_destination'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='log_destination'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='logging_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select value from `cacti`.`settings` where name='logging_header'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select username from user_auth where id=1"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from user_auth where username='0'"
04/03/2012 03:13:08 PM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select cacti from version"
The graphs still show nothing in them. Checking the RRD files time stamps shows they have not been touched.
Top
bmcwhirt
Posts: 8
Joined: Sun Apr 01, 2012 12:23 am

Re: RRD Error, need help solving config.

Post by bmcwhirt »

I think I should also mention this:

Log of the cron shows that the cron job is run.
Cron job is run by user cacti.
All files are cacti:cacti rw
Webserver runs as user www and I added www to group cacti

When I issue: sudo -u cacti/usr/local/bin/php /usr/local/share/cacti/poller.php I get log entries. When cron runs the process I do not.
When either sudo or cron runs the red files the rra directory are not touched. The directories and all files in raw are rw for cacti:cacti.

I've checked the sys long, cron log and web server logs and I can find no errors that reflect permission issues but thats my first guess since the red files are not being written not the log file when run from the cron.
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest