RRD files not created...

[Aurelgadjo]

Hello,

I have the last verison of cacti (0.8.7a).
The crontab job is launched with the root user (i've tryed with www-data too).
I'm under linux debian etch up to date.
(i'm french, excuse me for my english (and correct me if you have time) )

And... The rrd files are never created. For example, i have deleted all graphes. And i create "New Graphs" > "Create: Unix - Load Average".
When i go on "Graph management" > "Localhost - Load Average", i have :

RRDTool Says:

ERROR: opening '/var/www/cacti/rra/localhost_load_1min_9.rrd': No such file or directory

Screenshot : http://www.enregistrersous.com/images2/ ... 145246.png

And the logfile is normal (i think ?)

Code: Select all

 12/30/2007 02:53:01 PM - SYSTEM STATS: Time:0.1692 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:53:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:52:01 PM - SYSTEM STATS: Time:0.1309 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:52:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:51:01 PM - SYSTEM STATS: Time:0.1311 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:51:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:50:01 PM - POLLER: Poller[0] NOTE: Poller Int: '60', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '5'
12/30/2007 02:50:01 PM - SYSTEM STATS: Time:0.1386 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:50:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:50:01 PM - POLLER: Poller[0] -1199022362.26 seconds
12/30/2007 02:50:01 PM - SYSTEM STATS: Time:299.0189 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:50:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:48:01 PM - SYSTEM STATS: Time:0.1300 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:48:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:47:01 PM - SYSTEM STATS: Time:0.1307 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:47:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:46:01 PM - SYSTEM STATS: Time:0.1399 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:46:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:45:02 PM - POLLER: Poller[0] NOTE: Poller Int: '60', Cron Int: '300', Time Since Last: '301', Max Runtime '298', Poller Runs: '5'
12/30/2007 02:45:01 PM - SYSTEM STATS: Time:0.1363 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:45:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:45:01 PM - POLLER: Poller[0] -1199022061.92 seconds
12/30/2007 02:45:01 PM - SYSTEM STATS: Time:299.0890 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:0 RRDsProcessed:0
12/30/2007 02:45:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:43:01 PM - SYSTEM STATS: Time:0.1293 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:43:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:42:01 PM - SYSTEM STATS: Time:0.1399 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:42:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:41:01 PM - SYSTEM STATS: Time:0.1319 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:41:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:40:01 PM - POLLER: Poller[0] NOTE: Poller Int: '60', Cron Int: '300', Time Since Last: '299', Max Runtime '298', Poller Runs: '5'
12/30/2007 02:40:01 PM - SYSTEM STATS: Time:0.1425 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:40:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:40:01 PM - POLLER: Poller[0] -1199021762.47 seconds
12/30/2007 02:40:01 PM - SYSTEM STATS: Time:299.2497 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:40:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:38:01 PM - SYSTEM STATS: Time:0.1654 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:38:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:37:01 PM - SYSTEM STATS: Time:0.1312 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:37:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:36:01 PM - SYSTEM STATS: Time:0.1334 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:36:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:35:02 PM - POLLER: Poller[0] NOTE: Poller Int: '60', Cron Int: '300', Time Since Last: '301', Max Runtime '298', Poller Runs: '5'
12/30/2007 02:35:01 PM - SYSTEM STATS: Time:0.1381 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:35:01 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:35:00 PM - POLLER: Poller[0] -1199021461.61 seconds
12/30/2007 02:35:00 PM - SYSTEM STATS: Time:299.3250 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:35:00 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
12/30/2007 02:33:03 PM - SYSTEM STATS: Time:0.1400 Method:cmd.php Processes:1 Threads:N/A Hosts:2 HostsPerProcess:2 DataSources:1 RRDsProcessed:0
12/30/2007 02:33:03 PM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.

Thanks to have read

[vens]

Same problem here!

i have upgraded my rrdtool to 1.2.26 just in case. I am running cacti ver.0.8.7.a.

i keep getting the message

ERROR: opening

Code: Select all

'/srv/www/htdocs/cacti/rra/desktop_udplndatagrams_12.rrd': No such file or directory

some help would be much appreciated!

Thank you!

[yip623]

I face the same problem from the flash installation.

I found it is continuously run the statement, until timeout
01/11/2008 10:25:01 AM - 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"
01/11/2008 10:25:01 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"


Log:
01/11/2008 10:20:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'
01/11/2008 10:20:00 AM - SYSTEM STATS: Time:299.0446 Method:cmd.php Processes:10 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:11 RRDsProcessed:0
01/11/2008 10:20:00 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.


SHELL> php poller.php
Waiting on 3/3 pollers.
Waiting on 3/3 pollers.
....
Waiting on 3/3 pollers.
01/11/2008 10:20:00 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
01/11/2008 10:20:00 AM - SYSTEM STATS: Time:299.0446 Method:cmd.php Processes:10 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:11 RRDsProcessed:0
Warning: pclose(): 64 is not a valid stream resource in /opt/app/snp/cacti/cacti-0.8.7a/lib/rrd.php on line 57
01/11/2008 10:20:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '300', Max Runtime '298', Poller Runs: '1'

SHELL> php cmd.php
01/11/2008 10:24:08 AM - CMDPHP: Poller[0] Host[6] PING: Host is alive
01/11/2008 10:24:08 AM - CMDPHP: Poller[0] Host[6] RECACHE: Processing 2 items in the auto reindex cache for '192.168.2.42'.
01/11/2008 10:24:08 AM - CMDPHP: Poller[0] Host[6] DS[36] SNMP: v2: 192.168.2.42, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, output: 0
.....


Anyone has experience sharing?
Thanks so much

[davebassjunkie]

Have you tried creating the RRD files manually?

Click on Data Sources, select any data source then click "Turn On Data Source Debug Mode".

Copy and paste the command output it gives you into the shell and hit enter. The most common problem I have found is that the last section of the RRD create command has a trailing \. Not sure how to fix this so it creates them automatically - I had to create all of my data sources manually. After they are created, make sure you chown them to the user cacti is running under.

Only other thing I can suggest is to be patient, I had to wait up to a day in some cases for certain hosts to have their RRD files created, thought it was the same problem, but no it was just taking a while.

[yip623]

Thank you so much for your quick response.

It is failed to create graph by running rrdtool command.
Eventually, I have created rra successfully by "php cmd.php", and changed the ownership

But it still not update the graph autonatically by the cron job of poller.php.
Log:
01/11/2008 12:34:54 PM - SYSTEM STATS: Time:292.8034 Method:cmd.php Processes:10 Threads:N/A Hosts:3 HostsPerProcess:1 DataSources:14 RRDsProcessed:0
01/11/2008 12:34:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.

Simply testing by:
SHELL> php poller.php
...
Waiting on 3/3 pollers.
Waiting on 3/3 pollers.
Waiting on 3/3 pollers
...

I really have no idea how to figure out the problem.
can I change the crontab by:
*/5 * * * * /usr/bin/php /cacti/poller.php >> /cacti/log/poller.cron.log 2>> /cacti/log/poller.cron.err

Is it any side-effect of this method?

[davebassjunkie]

Have you tried running Spine instead of the PHP poller?

[yip623]

Thank you for your suggest.
I am running cactid, but without graph update.

But I may find some hints for this issue.
I have captured from the poller error.

/opt/app/snp/cacti/cactid-0.8.6i/bin/cactid: error while loading shared libraries: libmysqlclient.so.15: cannot open shared object file: No such file or directory

Because the MySQL was compiled manually under /opt/app/snp/mysql/mysql-5.0.45/, suppose cacti should use mysql client under /opt/app/snp/mysql/mysql-5.0.45/bin/mysql.
But I doubt that it may be using the system bundled mysql /usr/bin/mysql, and get this error.


I have compiled cactid by the follws:
./configure --prefix=/opt/app/snp/cacti/cactid-0.8.6i --with-mysql=/opt/app/snp/mysql/mysql-5.0.45

Is it my assumption correct?
If so , how can I fix it?

[yip623]

The problem was solved.
Create a link for libmysqlclient.so.15

For my environment:
OS: Redhat 4 update 4 x86_64
MySQL: /opt/app/snp/mysql/mysql-5.0.45


ln -s /opt/app/snp/mysql/mysql-5.0.45/lib/libmysqlclient.so.15 /usr/lib64/libmysqlclient.so.15


davebassjunkie, thank you so much for your kindly support!