DB connection failed on 3 nagios xi server

pouda · Post by **pouda** » Fri May 04, 2012 4:54 am

Hello,

I've a big problem with 3 of my nagios xi servers

i've upgraded mysql to 5.5 and php to 5.3 and i saw that nagios was not able to support them so i removed them and rolling back to previous versions

mysql is running well and i can access to database using phpmyadin and psql is started properly too BUT

i have this error message when i connection on http://ipdadress/nagiosxi

dberror.jpg

i think that maybe a php config file is wrong ?

Can you help ? it's really urgent

pouda · Post by **pouda** » Fri May 04, 2012 5:54 am

it's not a php file problem,

so i checked :

users in mysql db > seem ok

service ndo2db give me this message when i try to restart it

Code: Select all

[root@nagiosrs nagiosxi]# service ndo2db restart
ndo2db was not running... could not stop
Starting ndo2db:Support for the specified database server is either not yet supported, or was not found on your system.
 done.

I don' t know if it's normal or not ...

i removed mysql and php and installed once again this services my version are
PHP Version 5.1.6
Mysql Version 5.0.95

scottwilkerson · Post by **scottwilkerson** » Fri May 04, 2012 8:56 am

The error you are displaying in the webpage are for the postgres database.

There is definitely a problem with the mysql databases too..

Are mysql & postgresql running?

Code: Select all

service mysqld status
service postgresql status

pouda · Post by **pouda** » Fri May 04, 2012 9:00 am

yes for sure !!

have you got a skype id ? it would be faster for solving this issue before week end ...

scottwilkerson · Post by **scottwilkerson** » Fri May 04, 2012 9:09 am

I don't have skype but if you open a support ticket we I could try to remote in and take a look

pouda · Post by **pouda** » Fri May 04, 2012 9:11 am

ok no problem, let me know how to open a new support ticket ?

scottwilkerson · Post by **scottwilkerson** » Fri May 04, 2012 9:13 am

Send email to xisupport@nagios.com

pouda · Post by **pouda** » Fri May 04, 2012 9:16 am

i've just sent an email

scottwilkerson · Post by **scottwilkerson** » Fri May 04, 2012 10:20 am

Resolved.

For completeness of others that may find this thread, the problem was caused by yum removing required php packages when trying to upgrade.

Nagios Support Forum

DB connection failed on 3 nagios xi server

DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server

Re: DB connection failed on 3 nagios xi server