Post MySQL upgrade blues/graphs not updating

[saiyr]

Sorry, I'm somewhat new at this.

I recently upgraded a RHEL3 server from MySQL 3.23 to 4.1. I seem to have smoothed out most of the details after recompiling cactid and upgrading server/client/libraries/headers in MySQL, but I've still got one major problem. The graphs no longer update. The cron was left untouched, and the logs show it running the poller every 5 minutes, but the graphs don't update unless I manually run php poller.php.

I'm guessing it has to do with permissions, but I have no idea where I'd have messed up. The cronjob runs as cactiuser and I've been running it as root, which could have messed it up somewhere. All of the rra's are cactiuser.cactiuser u+rw, rra and log are u+rwx cactiuser.root, and cactid is cactiuser.root u+rx.

Anyone have any ideas? I looked a little bit through some threads and didn't find much.

[rony]

Turn you "Poller Logging Level" to debug and post one polling cycle of the poller from cacti.log.

[saiyr]

Turn you "Poller Logging Level" to debug and post one polling cycle of the poller from cacti.log.

I'm not sure if you meant the entire file (it's 800 lines), so I'll just attach it instead of putting it in a post.

[TheWitness]

The only issue I can see is some interface data sources not being updated correctly. You should likely run poller.php from a command line and post that output as well. Again, in debug mode.

TheWitness

[saiyr]

The only issue I can see is some interface data sources not being updated correctly. You should likely run poller.php from a command line and post that output as well. Again, in debug mode.

TheWitness

That's actually what I did. The cronjob doesn't generate any output in logs or update the .rra files. The cron log, however, does say that it's running...

[TheWitness]

Redirect the crons output to a log file or look at the existing cron log and you will find your problems there...

TheWitness

[saiyr]

I tracked down a few problems...I installed the shared-compat libraries for MySQL to fix Apache2's complaining. Redirecting the output of the cron to a file told me that it was running an older version of PHP, and I noticed two older versions. For some reason, the cron was executing an older version of the PHP, while executing it in the shell uses the newest version. However, now the output from the cron is blank, and it still doesn't work.