Solaris 10 - poller

[geoffb]

Folks- please forgive the possible dufus question, but this is odd..and I can't figure it out (I am the dufus..)

Solaris 10, php 5.2.0, Apache 2.2.3, MySQL 5.0 64bit w/32bit client+libs cactid/cacti from 0_8_6 branch via svn. No restrictions on php functions, vars, no suhosin (turned off for debugging). Global zone (no socket restrictions, for you Solaris-ites).

The problem - the poller won't run to successful completion, by 'run' I mean: Invoking 'php poller.php ' by hand returns with no errors, but the exec of rrd threads and so on never happen, as it never comes back out of include/config.php successfully.

The db_connect() in include/config.php never returns with success. Simple you say, check your configs.. not exactly.

Tracing shows it never actually connects to the MySQL socket (mysql log - full logging on). Further poking shows the _pconnect in adodb's mysql driver never returns true (leading to mysql_pconnect() . No error messages anywhere in any logs. The args passed in are all correct (user, pass, database name etc). 6 requests in the poller cache. The cache rebuilds successfully.

However, for example, cactid run by hand runs to completion , SNMP query data are logged to MySQL, NetSNMP is happy etc. This only proves that MySQL has valid data, requests and so forth, but also that it was loaded from the UI side and we can talk to it.

Cacti talks to MySQL, ie in adding devices, SNMP request/response is fine, but.. (I know the logic of poller->cactid and their being two separate critters, separate configs).

Debug shows routine UI keep alives only, _nothing_ else, no poller associated events, even when it is hand invoked, only this minimal UI traffic:

CMDPHP: Poller[0] DEBUG: SQL Assoc: \"select realm_id from user_auth_realm where user_id=1\" and so forth

If I run cactid by hand, tons of successful output, OID city. MySQL logs fat and happy. For this debug session, only one device configured. Zero output for poller.

Wonder why the UI calls MySQL fine and cmd and poller's subs don't try ? This sure looks like a permission or execution mode problem, but it's odd that no errno's or errs are being coughed up. Odd..most odd.

I am going to get down and peer in to the code some more, thought a kind soul might have seen this before and save me a few hours(days).

thanks all ! Appreciate your thinking about this one.

geoff

[geoffb]

Groan - last time I used a precompiled version of PHP (!) that I didn't specifically compile for a specific machine. (Yah, like I have said this 82 times before). Trying to save 10 min cost a day.

The 'Coolstack' bundled (actually rather tepid) PHP 5.2.0 on Solaris has no mysql compiled in, loading mysql.so in php.ini seems not to work at all.

Nice.

adodb-mysql.inc.php has @ error hiding on, removing that, why.. of course. No mysql_pconnect being found.

No fault of cacti. Now where'd I leave that dunce cap...

g