should cactid be creating rrds?

[jzehnder]

Hello,

So I was not able to ever get a response out of poller.php. I ran it manually, strace'd it, double-checked permissions, it just never did anything other than,

-bash-3.00$ php poller.php
Content-type: text/html
X-Powered-By: PHP/4.3.9

-bash-3.00$


So I switched to cactid. This actually does something, it gathers data, it updates the db with said data it does not however create the rrds. I am wondering if it supposed to be creating the rrds or if that is a function that exists with the poller.php only.

thanks in advance

[iYRe]

Hi

I believe it should be. I am experiencing the same problem myself.

When i execute cmd.php or poller.php i get no output, however when I execute cactid i do.
No rrd's are generated, permissions checked, and i can create files in rrd/ under my cactiuser etc.

Its v.wierd.
cactid output

Code: Select all

CACTID: Using cactid config file [/etc/cactid.conf]
CACTID: DEBUG: MySQL Query ID '1': 'SELECT value FROM settings WHERE name = 'path_webroot''
CACTID: DEBUG: MySQL Query ID '1': OK
CACTID: DEBUG: MySQL Query ID '2': 'SELECT value FROM settings WHERE name = 'path_cactilog''
CACTID: DEBUG: MySQL Query ID '2': OK
CACTID: DEBUG: The path_php_server variable is 
CACTID: DEBUG: The path_cactilog variable is /usr/share/cacti/site/log/cacti.log
CACTID: DEBUG: MySQL Query ID '3': 'SELECT value FROM settings WHERE name = 'log_destination''
CACTID: DEBUG: MySQL Query ID '3': OK
CACTID: DEBUG: The log_destination variable is 1 (FILE)
CACTID: DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'path_php_binary''
CACTID: DEBUG: MySQL Query ID '4': OK
CACTID: DEBUG: The path_php variable is /usr/bin/php
CACTID: DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'availability_method''
CACTID: DEBUG: MySQL Query ID '5': OK
CACTID: DEBUG: The availability_method variable is 2
CACTID: DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
CACTID: DEBUG: MySQL Query ID '6': OK
CACTID: DEBUG: The ping_recovery_count variable is 3
CACTID: DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
CACTID: DEBUG: MySQL Query ID '7': OK
CACTID: DEBUG: The ping_failure_count variable is 2
CACTID: DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_method''
CACTID: DEBUG: MySQL Query ID '8': OK
CACTID: DEBUG: The ping_method variable is 2
CACTID: DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_retries''
CACTID: DEBUG: MySQL Query ID '9': OK
CACTID: DEBUG: The ping_retries variable is 1
CACTID: DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'ping_timeout''
CACTID: DEBUG: MySQL Query ID '10': OK
CACTID: DEBUG: The ping_timeout variable is 400
CACTID: DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_perror''
CACTID: DEBUG: MySQL Query ID '11': OK
CACTID: DEBUG: The log_perror variable is 1
CACTID: DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pwarn''
CACTID: DEBUG: MySQL Query ID '12': OK
CACTID: DEBUG: The log_pwarn variable is 1
CACTID: DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'log_pstats''
CACTID: DEBUG: MySQL Query ID '13': OK
CACTID: DEBUG: The log_pstats variable is 1
CACTID: DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'max_threads''
CACTID: DEBUG: MySQL Query ID '14': OK
CACTID: DEBUG: The threads variable is 1
CACTID: DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'poller_interval''
CACTID: DEBUG: MySQL Query ID '15': OK
CACTID: DEBUG: The polling interval is the system default
CACTID: DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
CACTID: DEBUG: MySQL Query ID '16': OK
CACTID: DEBUG: The number of concurrent processes is 1
CACTID: DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'script_timeout''
CACTID: DEBUG: MySQL Query ID '17': OK
CACTID: DEBUG: The script timeout is 25
CACTID: DEBUG: MySQL Query ID '18': 'SELECT value FROM settings WHERE name = 'php_servers''
CACTID: DEBUG: MySQL Query ID '18': OK
CACTID: DEBUG: The number of php script servers to run is 1
CACTID: DEBUG: MySQL Query ID '19': 'SELECT action FROM poller_item WHERE action=2 LIMIT 1'
CACTID: DEBUG: MySQL Query ID '19': OK
CACTID: DEBUG: StartHost='-1', EndHost='-1', TotalPHPScripts='0'
CACTID: DEBUG: The PHP Script Server is Not Required
CACTID: DEBUG: MySQL Query ID '20': 'SELECT value FROM settings WHERE name = 'max_get_size''
CACTID: DEBUG: MySQL Query ID '20': OK
CACTID: DEBUG: The Maximum SNMP OID Get Size is 10
CACTID: CACTID: Version 0.8.6i starting
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: CACTID: Initializing Net-SNMP API
CACTID: DEBUG: SNMP Header Version is 5.2.2
CACTID: DEBUG: SNMP Library Version is 5.2.2
CACTID: CACTID: Initializing PHP Script Server(s)
CACTID: DEBUG: MySQL Query ID '21': 'SELECT id FROM host WHERE disabled='' ORDER BY id'
CACTID: DEBUG: MySQL Query ID '21': OK
CACTID: DEBUG: Initial Value of Active Threads is 0
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '22': 'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout FROM poller_item WHERE host_id=0 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '22': OK
CACTID: Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: The Value of Active Threads is 0
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '23': 'SELECT id, hostname, snmp_community, snmp_username, snmp_password, snmp_version, snmp_port, snmp_timeout, status, status_event_count, status_fail_date, status_rec_date, status_last_error, min_time, max_time, cur_time, avg_time, total_polls, failed_polls, availability  FROM host WHERE id=1'
CACTID: DEBUG: MySQL Query ID '23': OK
CACTID: Host[1] SNMP Result: Device does not require SNMP
CACTID: Host[1] No host availability check possible for '127.0.0.1'
CACTID: DEBUG: MySQL Insert ID '0': 'update host set status='3', status_event_count='0', status_fail_date='0000-00-00 00:00:00', status_rec_date='0000-00-00 00:00:00', status_last_error='', min_time='0.000000', max_time='0.000000', cur_time='0.000000', avg_time='0.000000', total_polls='3', failed_polls='0', availability='100.0000' where id='1''
CACTID: DEBUG: MySQL Insert ID '0': OK
CACTID: DEBUG: MySQL Query ID '24': 'SELECT data_query_id, action, op, assert_value, arg1 FROM poller_reindex WHERE host_id=1'
CACTID: DEBUG: MySQL Query ID '24': OK
CACTID: DEBUG: MySQL Query ID '25': 'SELECT action, hostname, snmp_community, snmp_version, snmp_username, snmp_password, rrd_name, rrd_path, arg1, arg2, arg3, local_data_id, rrd_num, snmp_port, snmp_timeout FROM poller_item WHERE host_id=1 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '25': OK
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[3] SCRIPT: perl /usr/share/cacti/site/scripts/linux_memory.pl MemFree:, output: 236676
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[4] SCRIPT: perl /usr/share/cacti/site/scripts/linux_memory.pl SwapFree:, output: 2931852
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[5] SCRIPT: perl /usr/share/cacti/site/scripts/loadavg_multi.pl, output: 1min:0.00 5min:0.00 10min:0.00
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[8] SCRIPT: perl /usr/share/cacti/site/scripts/query_unix_partitions.pl  get available /dev/sda1, output: 17441168
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[9] SCRIPT: perl /usr/share/cacti/site/scripts/query_unix_partitions.pl  get available /dev/sda3, output: 45472612
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[8] SCRIPT: perl /usr/share/cacti/site/scripts/query_unix_partitions.pl  get used /dev/sda1, output: 810360
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[9] SCRIPT: perl /usr/share/cacti/site/scripts/query_unix_partitions.pl  get used /dev/sda3, output: 140748
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[7] SCRIPT: perl /usr/share/cacti/site/scripts/unix_processes.pl, output: 87
CACTID: Host[1] DEBUG: The POPEN returned the following File Descriptor 6
CACTID: Host[1] DS[6] SCRIPT: perl /usr/share/cacti/site/scripts/unix_users.pl , output: 3
CACTID: DEBUG: MySQL Insert ID '1': 'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (3,'mem_buffers','2007-07-03 12:23:59','236676'),(4,'mem_swap','2007-07-03 12:23:59','2931852'),(5,'','2007-07-03 12:23:59','1min:0.00 5min:0.00 10min:0.00'),(8,'hdd_free','2007-07-03 12:23:59','17441168'),(9,'hdd_free','2007-07-03 12:23:59','45472612'),(8,'hdd_used','2007-07-03 12:23:59','810360'),(9,'hdd_used','2007-07-03 12:23:59','140748'),(7,'proc','2007-07-03 12:23:59','87'),(6,'users','2007-07-03 12:23:59','3')'
CACTID: DEBUG: MySQL Insert ID '1': OK
CACTID: Host[1] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: The Value of Active Threads is 0
CACTID: DEBUG: MySQL Insert ID '2': 'replace into settings (name,value) values ('date',NOW())'
CACTID: DEBUG: MySQL Insert ID '2': OK
CACTID: DEBUG: MySQL Insert ID '3': 'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
CACTID: DEBUG: MySQL Insert ID '3': OK
CACTID: DEBUG: Thread Cleanup Complete
CACTID: DEBUG: PHP Script Server Pipes Closed
CACTID: DEBUG: Allocated Variable Memory Freed
CACTID: CACTID: Net-SNMP API Shutdown Completed
CACTID: DEBUG: MYSQL Free & Close Completed
CACTID: Time: 0.3928 s, Threads: 1, Hosts: 2

[iYRe]

bump

I still cant get any output from cmd.php, poller.php and no rrd's are created.

I'm at my wits end.

Note, I have set up a working cacti on another machine...

[jzehnder]

bump

I still cant get any output from cmd.php, poller.php and no rrd's are created.

I'm at my wits end.

Note, I have set up a working cacti on another machine...

Sounds like you are in the same situation as me. Everything seems fine sa far as perms go, no output from anything except cactid and that doesnt create rrds. It is worth nothing that cacti does not run cactid every 5 minutes as said in documentation, it only works when I run it manually.

Machine info,

[root@library ~]# uname -a
Linux library.music.com 2.6.9-34.0.2.ELsmp #1 SMP Mon Jul 17 21:41:41 CDT 2006 i686 i686 i386 GNU/Linux
[root@library ~]# cat /etc/redhat-release
Red Hat Enterprise Linux release 4 (Manifestdestiny Respin 1)
[root@library ~]# rrdtool -V
RRDtool 1.2.18 Copyright 1997-2007 by Tobias Oetiker <tobi@oetiker.ch>
[root@library ~]# php -v
PHP 4.3.9 (cgi) (built: Jul 25 2006 17:06:22)

[rony]

Just to make this extremely clear!

You run poller.php.

Poller.php is responsible for calling either cmd.php or cactid, which ever you have configured in your Cacti settings. Poller.php is responsable for creating and updating the rrdtool files, not cmd.php or cactid.

You should be getting output from poller.php, what does your cacti.log say?

[jzehnder]

Just to make this extremely clear!

You run poller.php.

Poller.php is responsible for calling either cmd.php or cactid, which ever you have configured in your Cacti settings. Poller.php is responsable for creating and updating the rrdtool files, not cmd.php or cactid.

You should be getting output from poller.php, what does your cacti.log say?

As stated above by both of us, poller.php has no output unfortunately. It does not update the log either. An strace of it shows it not even attempting to write to the log.

[iYRe]

Yep, thats exactly what I get.

root@graphsrv:~# /usr/share/cacti/site/poller.php
root@graphsrv:~#

[iYRe]

on further investigation it appears that poller.php isnt executing cactid. If I try and run cmd.php I get no output either, so I am wondering if I have some weird PHP problem?

PHP Version 5.2.3
Configure Command './configure' '--with-mysql' '--with-apxs2=/usr/bin/apxs2' '--with-gettext' '--with-iconv' '--enable-mbstring' '--with-gd' '--with-jpeg-dir=/usr/' '--with-zlib-dir=/usr/lib' '--with-xml=/usr/' '--with-dom' '--with-kerberos' '--enable-ftp' '--with-mcal=/usr' '--with-openssl' '--with-config-file-path=/etc/php5/apache' '--with-mime-magic' '--with-png-dir=/usr/'

Apache 2. Ubuntu 6.10.

anything else anyone can use to help debug this?

[iYRe]

Solution...

make sure the CLi version of php and the version compiled for apache are the same :s

I had 5.1.3 as Cli, and 5.2.3 which I had compiled and was using through apache.

Packages tend to install to a higher path than the one used when hand compiling.

fix0red.

[jzehnder]

that did the trick, thanks.

[Daveyboy]

Solution...

make sure the CLi version of php and the version compiled for apache are the same :s

I had 5.1.3 as Cli, and 5.2.3 which I had compiled and was using through apache.

Packages tend to install to a higher path than the one used when hand compiling.

fix0red.

I have ;
root@cacti:/usr/share/cacti# php -v
PHP 5.1.2 (cli) (built: May 22 2007 20:23:21)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

and from phpinfo;
Apache/2.0.55 (Ubuntu) PHP/5.1.2
PHP Version 5.1.2

but still no rrd files in the rra directory after running poller.php with cmd.php or cactid

[iYRe]

do you get any output from any of them with your logging set to "high" ?

[Daveyboy]

do you get any output from any of them with your logging set to "high" ?

nope. see this post for further info http://forums.cacti.net/viewtopic.php?p=105038#105038