[SOLVED] What's wrong with my cacti installation?

[classen]

I did a fresh install of 8.7g
applied all patches
installed PIA 2.9 (beta2 I think)
I did not do anything to my cacti MySQL db.
updated all plugins to their latest versions.
granted ALL permission (including GRANT) to cactiuser on the cacti database.

nectar - I can send a test report, but the daily reports at 2:00am never gets sent.
rrdclean - the rrd files get moved into the plugin_rrdclean_action table, but never get deleted.
syslog - The syslog_incoming table contains numerous syslog entries, but NONE of them ever show up in the cacti syslog tab.

There must be some fundamental problem with my cacti install that is preventing all of these plugins from fully functioning.

Heeeeeeeeeeeeeelp

[noname]

>> installed PIA 2.9 (beta2 I think)

Use latest 2.9 from here.
http://www.cacti.net/downloads/pia/
Overwrite existing files by using 'files-0.8.7g/'.

And try this:
% php cli/repair_database.php

[classen]

that didn't help.
bummer.

I upgraded MySQL from 5.0.77 to 5.1.58 and uninstalled/reinstalled the troublesome plugins without any success.

[noname]

Hmm..
To make sure, is your poller working regularly by cron?

[classen]

Yes spine poller is working correctly and updating every 60 seconds:

Code: Select all

08/31/2011 12:15:21 PM - SYSTEM THOLD STATS: Time:0.0239 Tholds:6 Hosts:0
08/31/2011 12:15:13 PM - SYSTEM STATS: Time:10.8639 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1482 RRDsProcessed:830
08/31/2011 12:14:16 PM - SYSTEM THOLD STATS: Time:0.0240 Tholds:6 Hosts:0
08/31/2011 12:14:08 PM - SYSTEM STATS: Time:7.5307 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1486 RRDsProcessed:831
08/31/2011 12:14:01 PM - SYSTEM THOLD STATS: Time:0.0034 Tholds:0 Hosts:0
08/31/2011 12:14:01 PM - SYSTEM THOLD STATS: Time:0.0217 Tholds:7 Hosts:0
08/31/2011 12:13:12 PM - SYSTEM STATS: Time:11.1696 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1486 RRDsProcessed:831
08/31/2011 12:13:02 PM - SYSTEM STATS: Time:60.6016 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1484 RRDsProcessed:831
08/31/2011 12:11:28 PM - SYSTEM THOLD STATS: Time:0.0198 Tholds:6 Hosts:0
08/31/2011 12:11:08 PM - SYSTEM STATS: Time:6.2349 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1483 RRDsProcessed:831
08/31/2011 12:10:34 PM - SYSTEM THOLD STATS: Time:0.0228 Tholds:6 Hosts:0
08/31/2011 12:10:14 PM - SYSTEM STATS: Time:12.4650 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1482 RRDsProcessed:830
08/31/2011 12:09:28 PM - SYSTEM THOLD STATS: Time:0.0222 Tholds:6 Hosts:0
08/31/2011 12:09:09 PM - SYSTEM STATS: Time:7.6908 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1486 RRDsProcessed:831
08/31/2011 12:08:19 PM - SYSTEM THOLD STATS: Time:0.0243 Tholds:7 Hosts:0
08/31/2011 12:08:08 PM - SYSTEM STATS: Time:6.0371 Method:spine Processes:4 Threads:12 Hosts:75 HostsPerProcess:19 DataSources:1486 RRDsProcessed:831
08/31/2011 12:07:39 PM - SYSTEM THOLD STATS: Time:0.0047 Tholds:0 Hosts:0

It seems to me that the mysql tables associated with the various plugins are getting populated correctly, but whatever mechanism is used to retrieve the information is never triggered or does not complete properly. The fact that numerous plugins do not function as they are supposed to indicates to me that there is a deeper problem with my cacti installation.

I'm sorry I don't really have any new information to add that might help the troubleshooting process. I tend to get a bit burned out on cacti after spending 6 or 7 hours trying to fix a single problem and having no success. So I go away for a few weeks until I get motivated for another round or squash-the-cacti-bugs.

[classen]

HOLY CR4P!!!! I finally figured it out

It turns out there was a CentOS distributed version of php residing in /usr/bin

I had installed my hand-rolled php into /usr/local/bin

Unfortunately php appears to be hard coded into various scripts throughtout the cacti and plugin files.

I deleted /usr/bin/php and made a symbolic link to my good version of php

ln -s /usr/local/bin/php /usr/bin/php

now all my plugins are working! yeah!

perhaps these are some of the culprits?

Code: Select all

$ grep -r "/usr/bin/php" cli/*
cli/add_data_query.php:#!/usr/bin/php -q
cli/add_device.php:#!/usr/bin/php -q
cli/add_graphs.php:#!/usr/bin/php -q
cli/add_graph_template.php:#!/usr/bin/php -q
cli/add_perms.php:#!/usr/bin/php -q
cli/add_tree.php:#!/usr/bin/php -q

and

Code: Select all

$ grep -r "/usr/bin/php" plugins/*
plugins/mactrack/poller_mactrack.php:#!/usr/bin/php -q
plugins/nectar/poller_nectar.php:#!/usr/bin/php -q
plugins/syslog/template/cacti_graph_template_localhost_syslog_messages.xml:             <input_string>/usr/bin/php -q <path_cacti>/plugins/syslog/syslog_counter.php</input_string>
plugins/weathermap/docs/pages/cacti-plugin.html:*/5 * * * *   cactiuser  /usr/bin/php   /your/cacti/path/plugins/weathermap/weathermap-cacti-rebuild.php
plugins/weathermap/weathermap:#!/usr/bin/php