moved cacti - graphs not updating

[kamina]

I moved my cacti installation to another host yesterday, and the graphs are no longer being updated. I don't know what's wrong, maby someone can help?

Moving process:

Make a cacti installation (same version of cacti and mysql)
dumb mysql databases on old host and import them to the new one
copy rra, scrip and resource folders to the new host
copy the cron script to the new host

When I put graphs to debug mode on the new host it says they are ok. Also when I look at the device list they are listed as ok, it manges to poll snmp from them fine.

from cron log

Code: Select all

Nov 17 09:30:01 vault.sulake.com crond[3253]: (cacti) CMD (php /var/www/cacti/poller.php &>/dev/null)
Nov 17 09:30:01 vault.sulake.com crond[3254]: (cacti) CMD (php /var/www/cacti/poller.php > /dev/null 2>&1)
Nov 17 09:35:01 vault.sulake.com crond[4654]: (cacti) CMD (php /var/www/cacti/poller.php > /dev/null 2>&1)
Nov 17 09:35:01 vault.sulake.com crond[4655]: (cacti) CMD (php /var/www/cacti/poller.php &>/dev/null)
Nov 17 09:40:01 vault.sulake.com crond[6059]: (cacti) CMD (php /var/www/cacti/poller.php > /dev/null 2>&1)
Nov 17 09:40:01 vault.sulake.com crond[6061]: (cacti) CMD (php /var/www/cacti/poller.php &>/dev/null)

Any idea why the entries are duplicates?

Code: Select all

# cat /etc/crontab 
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

*/5 * * * * cacti php /var/www/cacti/poller.php > /dev/null 2>&1

Any idea what's going wrong? I would prefere to keep all the only information in the new installation...

edit:

Actually the hosts did not have the exact same version:

new host
# rpm -q cacti
cacti-0.8.6i-1.el4.rf

# rpm -q rrdtool
rrdtool-1.2.15-1.el4.rf

old host
$ rpm -q cacti
cacti-0.8.6h-1.2.el4.rf

$ rpm -q rrdtool
rrdtool-1.2.15-1.el4.rf

During setup I selected "new install", not upgrade...

edit2:

Seems there is some problem with mysql, as the log is filling up with:

Code: Select all

 11/17/2006 11:50:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (516, 'hdd_used', '2006-11-17 11:50:43', '138716')"
11/17/2006 11:50:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (516, 'hdd_free', '2006-11-17 11:50:43', '3688164')"
11/17/2006 11:50:44 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (515, 'hdd_used', '2006-11-17 11:50:43', '8159976')"

stuff like this...

[kamina]

No need to worry about this now... A workfriend deleted /etc/passwd on the server which kind of complicated things.

edit:

/etc/passwd is fixed, so now bck to the original problem

[kamina]

I tried to connect to mysql as the user specified, and copy paste one of the inserts into the database by hand, and it worked just fine. So it should not be a question of rights (as long as cacti is using the database settings in include/config.php

[gandalf]

Did you copy the needed php.ini's settings as well (e.g. memory settings)? How big is your "poller_output" table?
Reinhard