Upgraded to 0.8.6h, graphs no longer created

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Upgraded to 0.8.6h, graphs no longer created

Post by mek1 »

Hi,

I just upgraded to Version 0.8.6h. It went ok without any errors. Now when iI i go to the cacti interface all the graphs are there but no data is being drawn. This started exactly after the upgrade was complete.

Any ideas?

this cacti is installed on linux, btw.

thank you
matt
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

From what version did you upgrade from?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

version 6F
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

If i need to downgrade, will the upgraded database cause problems? I hope it doesn't come to that but the old version is waiting in the wings...

thanks
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Does the debug log give you any indication of a problem?

Is apache error log giving you anything of concern?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

here's the debug:

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="3Com_BB - Traffic - Port1 PIX" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/usr/share/cacti/site/rra/3com_bb_traffic_in_154.rrd":traffic_in:AVERAGE \
DEF:b="/usr/share/cacti/site/rra/3com_bb_traffic_in_154.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#CDCFC4:"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#4668E4:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"Total In\: 0 bytes\n" \
COMMENT:"Total Out\: 0 bytes"

RRDTool Says:

OK


There are no visible apache errors on the site either. thanks
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

No, wrong debug...

The cacti.log in the log directory.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

woops,

interesting there is nothing in the log file.
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Remember to set the log level to debug and then look. :)
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

ok, got it. Here's what i have after 10mins

06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_snmp'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_graph'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_graph'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_export'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_export'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='poller_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='poller_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_verbosity'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_verbosity'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pstats'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pstats'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_pwarn'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_pwarn'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_perror'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_perror'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='versions_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='versions_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_version'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_version'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='rrdtool_version'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='rrdtool_version'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_ver'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_ver'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_community'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_community'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_username'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_username'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_password'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_password'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_timeout'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_timeout'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_port'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_port'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

and a bit more with some different lines...

06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_snmp'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='log_destination'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='log_destination'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='logging_header'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='logging_header'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/19/2006 11:21:28 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/19/2006 11:21:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id, user_auth.username, full_name, realm, policy_graphs, DATE_FORMAT(max(time),'%M %e %Y %H:%i:%s') as time from user_auth left join user_log on (user_auth.id = user_log.user_id) group by id"
06/19/2006 11:21:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/19/2006 11:21:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/19/2006 11:21:26 AM - 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='1'"
06/19/2006 11:21:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/19/2006 11:21:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/19/2006 11:21:24 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/19/2006 11:21:24 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/19/2006 11:21:24 AM - 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'"
06/19/2006 11:21:24 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/19/2006 11:21:24 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='remove_verification'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='remove_verification'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='other_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='other_header'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select value from settings where name='snmp_retries'"
06/19/2006 11:08:16 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select value from settings where name='snmp_retries'"
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Clear the log, and wait for one polling cycle to occur. Then post it.

That brings up a good question, is the poller running?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

it is enabled, or at least it is checked.

new data:

06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_tree_items.id, graph_tree_items.title, graph_tree_items.local_graph_id, graph_tree_items.rra_id, graph_tree_items.order_key, graph_templates_graph.title_cache as title_cache from (graph_tree_items,graph_local) left join graph_templates_graph on (graph_tree_items.local_graph_id=graph_templates_graph.local_graph_id and graph_tree_items.local_graph_id>0) left join host on (host.id=graph_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_tree_items.graph_tree_id=23 and graph_local.id=graph_templates_graph.local_graph_id and graph_tree_items.order_key like '001___000000000000000000000000000000000000000000000000000000000000000000000000000000000000' and graph_tree_items.local_graph_id>0 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))) group by graph_tree_items.id order by graph_tree_items.order_key"
06/19/2006 11:23:04 AM - 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=536"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select name from graph_tree where id=23"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select title,local_graph_id,host_id from graph_tree_items where id=536"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select order_key,title,host_id,host_grouping_type from graph_tree_items where id=536"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_id from user_auth_perms where user_id=1 and type=2 and item_id=23"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_trees from user_auth where id=1"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from graph_tree where id=23"
06/19/2006 11:23:04 AM - 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"
06/19/2006 11:23:04 AM - 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=15 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"
06/19/2006 11:23:04 AM - 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=17 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"
06/19/2006 11:23:04 AM - 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=20 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"
06/19/2006 11:23:04 AM - 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=16 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"
06/19/2006 11:23:04 AM - 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=19 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"
06/19/2006 11:23:04 AM - 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=22 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"
06/19/2006 11:23:04 AM - 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=18 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"
06/19/2006 11:23:04 AM - 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=21 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"
06/19/2006 11:23:04 AM - 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=23 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"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select policy_hosts from user_auth where id=1"
06/19/2006 11:23:04 AM - 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"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where realm_id=8 and user_id=1"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where id=1"
06/19/2006 11:23:04 AM - 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'"
06/19/2006 11:23:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

I have this feeling your poller is not running. There are no poller related entries in that log.

Ensure that the poller is being execute from cron every 5 minutes.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
mek1
Cacti User
Posts: 55
Joined: Tue Mar 21, 2006 11:31 am

Post by mek1 »

here is what my cron entry looks like:

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

the php file does exist in that folder as well
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 3 guests