Page 1 of 1
DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 4:54 am
by pouda
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
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 5:54 am
by pouda
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
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 8:56 am
by scottwilkerson
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
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 9:00 am
by pouda
yes for sure !!
have you got a skype id ? it would be faster for solving this issue before week end ...
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 9:09 am
by scottwilkerson
I don't have skype but if you open a support ticket we I could try to remote in and take a look
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 9:11 am
by pouda
ok no problem, let me know how to open a new support ticket ?
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 9:13 am
by scottwilkerson
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 9:16 am
by pouda
i've just sent an email
Re: DB connection failed on 3 nagios XI server
Posted: Fri May 04, 2012 10:20 am
by scottwilkerson
Resolved.
For completeness of others that may find this thread, the problem was caused by yum removing required php packages when trying to upgrade.