poller erros, no graphs being generated, libsql.so error

[aron]

hi all i upgrade to version j from h today and im getting errors.

if i run poller.php i get this.

[root@mrtg cacti]# /usr/bin/php poller.php
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0


if i run cmd.php i get this

[root@mrtg cacti]# php cmd.php
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
Content-type: text/html
X-Powered-By: PHP/4.3.9


and in cacti itself i have these errors in the logs.

03/02/2007 10:42:54 AM - SYSTEM STATS: Time:293.5310 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:338 RRDsProcessed:0
03/02/2007 10:43:02 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/02/2007 10:43:55 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/02/2007 10:43:55 AM - SYSTEM STATS: Time:293.4997 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:338 RRDsProcessed:0
03/02/2007 10:44:02 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/02/2007 10:44:55 AM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/02/2007 10:44:55 AM - SYSTEM STATS: Time:292.7911 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:338 RRDsProcessed:0
03/02/2007 10:45:01 AM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating

before the upgrade it worked fine, but somone hacked it , thats why i updated

please help.

cheers aron.

[TheWitness]

Sounds like the postgress module. You need to comment it out of you php.ini file.

TheWitness

[aron]

you mean this

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links. -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
pgsql.ignore_notice = 0

; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0

[TheWitness]

Look for the word "extensions". You may have an early enough version that you don't have the ability to add/remove extensions. If you made the package on your own in that case, you did something wrong.

If you got it from a distro, then they missed a dependency.

TheWitness

[aron]

all i can find

; Directory in which the loadable extensions (modules) reside.
extension_dir = /usr/lib/php4

cheers aron.

[aron]

ok think i might have rooted it

first i decided to run

wget ftp://ftp.nluug.nl/pub/os/Linux/distr/C ... 1.i386.rpm
rmp -Uvh rh-postgresql-libs-7.3.18-1.i386.rpm

that got rid of the

PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0

but still wasn't working so i ran a repair on the database in case it was corrupted.

mysqlcheck --databases --repair cacti

produced all [ok]

now if i run poller i get

[root@mrtg cacti]# /usr/bin/php poller.php

just sits there and does nothing

and for cmd.php

[root@mrtg cacti]# /usr/bin/php cmd.php
Content-type: text/html
X-Powered-By: PHP/4.3.9

and the cacti logs

03/02/2007 12:26:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/02/2007 12:25:55 PM - SYSTEM STATS: Time:293.4771 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:334 RRDsProcessed:0
03/02/2007 12:25:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/02/2007 12:25:02 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/02/2007 12:24:54 PM - SYSTEM STATS: Time:293.5009 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:334 RRDsProcessed:0
03/02/2007 12:24:54 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
03/02/2007 12:24:01 PM - PHPSVR: Poller[0] ERROR: Input Expected, Script Server Terminating
03/02/2007 12:23:55 PM - SYSTEM STATS: Time:293.1318 Method:cmd.php Processes:1 Threads:N/A Hosts:22 HostsPerProcess:22 DataSources:334 RRDsProcessed:0
03/02/2007 12:23:55 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.

would be better if i dump the database and start from scratch.

chhers aron

[aron]

ok iv removed (uninstalled) that rpm and now im back with the original error.

cant find the line you making refrence to in my php.ini file, its odd as it worked fine with the previous version. all i did was follow the upgrade procedure in the doc foler of the package.

im re-uploading all the files, incase something went wrong.

cheers aron.

[aron]

reverted back to version h and works no problems.

hmm

cheers aron.

[TheWitness]

What version of PHP are your running and did you apply the patches from the Web site? That was likely your issue.

TheWitness

[aron]

PHP Version 4.3.9

and when you say the patch i ran/installed/followed the upgrade instructions from here

http://www.cacti.net/download_cacti.php downloaded the linux version and followed the doc in regards to upgrading.

iv just relised something should i be follow the steps here once i upgrade cacti to version j.

http://www.cacti.net/download_patches.php

cheers aron.