Poller path is invalid

[unter_hosen]

Hi Gandalf (lvm)

Im getting this in the log every 40 seconds

Code: Select all

11/24/2006 09:39:54 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  
11/24/2006 09:39:54 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
11/24/2006 09:39:54 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
11/24/2006 09:39:54 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
11/24/2006 09:39:54 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  
11/24/2006 09:39:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  
11/24/2006 09:39:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
11/24/2006 09:39:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
11/24/2006 09:39:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
11/24/2006 09:39:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  
11/24/2006 09:39:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  
11/24/2006 09:39:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
11/24/2006 09:39:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
11/24/2006 09:39:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
11/24/2006 09:39:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  
11/24/2006 09:38:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  
11/24/2006 09:38:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
11/24/2006 09:38:53 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
11/24/2006 09:38:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
11/24/2006 09:38:53 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  
11/24/2006 09:38:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"  
11/24/2006 09:38:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"  
11/24/2006 09:38:52 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"  
11/24/2006 09:38:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"  
11/24/2006 09:38:52 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"  

Then I am getting this...

Code: Select all

11/24/2006 09:40:04 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step=rrd_step-60 WHERE (rrd_next_step < 0 and host_id >= 0 and host_id <= 7)"  
11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "UPDATE poller_item SET rrd_next_step=rrd_next_step-60 WHERE (host_id >= 0 and host_id <= 7)"  
11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 7) AND rrd_next_step<=0)"  
11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 7 and rrd_next_step<=0) ORDER by host_id"  
11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 7) ORDER by id"  
11/24/2006 09:40:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) limit 10000"  
11/24/2006 09:40:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"  
11/24/2006 09:40:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"  
11/24/2006 09:40:02 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/cacti/cmd.php 0 7]  

This is what I am getting with regard to poller_output table

Code: Select all

11/24/2006 09:40:04 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) limit 10000" 

The poller cache is showing 3 items

2 for the same interface................. in this instance fa0.10 and 1 for cpu usage.

Debug on graph says this...

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ROUTER - Traffic - Fa0.10" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/var/www/cacti/rra/router_traffic_in_30.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/cacti/rra/router_traffic_in_30.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"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#002A97:"Outbound"  \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s"  \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s" 
RRDTool Says:

OK

Data source debug say this

Code: Select all

Data Source Debug

/usr/bin/rrdtool create \
/var/www/cacti/rra/router_traffic_in_30.rrd \
--step 300  \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

With regards to step 5 of the NaN debugging I am not seeing any

rrdtool update <filename> --template ...

The file router_traffic_in_30.rrd does exist, however I was expecting to see a router_traffic_out_30.rrd also, but there is not one.

I have no idea whats going wrong with my cacti, im 90% sure its because im useless.

[gandalf]

Let me parse your posts one by one

Hi again

Worked out what my error was, i had changed the poller to cactid which is why it was saying that the path was invalid. Now that is fixed I am seeing this in the cacti.log

11/10/2006 12:51:34 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
11/10/2006 12:51:35 AM - SYSTEM STATS: Time:1.1438 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0

any ideas?

That's ugly. Log entry says, you're using cmd.php, but you say it should be cactid. Please configure all entries under "Settings" as needed: provide the fully qualified ds name for cactid and select cactid as a poller.
You may run cactid from cli as a test, e.g. ./cactid --verbosity=5 0 10 (assuming you have at least one device with id's between 0 and 10)

Reinhard

[gandalf]

I am now getting nans on my graphs.............................................

arrghhh

if anyone can point me in the right direction that would be great. i have had a look at lvm's NaN debugging thing, but didnt understand a lot of it which is half of my problem.

Many Thanks in advance


Martin

For some usage tips and hints, please refer to the very first link of my signature. Perhaps it is a good idea to walk some of those examples to get used to cacti and it's lingo
Reinhard

[gandalf]

Hi TheWitness

Thanks so much for the reply, I will do the things you suggested and get back to you. Another issue that has arisen is that i am using your 1 minute polling "hack" (for want of a better word) and the information does not get passed to the poller cache unless i add a standard 5 minute graph???? which is very strange, but thats another issue to get sorted after the poller is working automatically....

I would suggest to get cacti running without any extensions first. This will ease debugging
Reinhard

[gandalf]

ok found them, they are in /usr/share/cacti/site

So your cacti installation was split into two parts. Some linux distros do such ugly things. So please check, that all Settings->Paths entries are correct. And please report, where cacti's web code and where the rra files are located (<path_rra> is derived from <path_cacti>, there's no explicit Settings entry for that)

Reinhard

[gandalf]

I have managed to get Ubuntu up and running with MySQL, PHP, Apache2, Webmin etc

Please refer to http://forums.cacti.net/viewtopic.php?t=10534 for Ubuntu installation help
Reinhard