Message: A database connection error has been detected

[daniel.c.marcos.jr]

Hi,

I am encountering an error in nagiosxi gui after I updated our php from 5.3 to 5.4. Can you help us?

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh

[hsmith]

/usr/local/nagiosxi/scripts/repair_databases.sh

Did you try doing this?

[daniel.c.marcos.jr]

Thank you for your reply

yes. kindly see below for the screenshot. however the error still appears


===============
REPAIR COMPLETE
===============
+ /usr/local/nagiosxi/scripts/manage_services.sh restart ndo2db
Stopping ndo2db: done.
Starting ndo2db: done.
+ /usr/local/nagiosxi/scripts/manage_services.sh restart nagios
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
+ rm -f /usr/local/nagiosxi/scripts/repair_databases.lock
[root@HOFVA1226 nagiosxi]#

[hsmith]

Thank you for your reply

yes. kindly see below for the screenshot. however the error still appears


===============
REPAIR COMPLETE
===============
+ /usr/local/nagiosxi/scripts/manage_services.sh restart ndo2db
Stopping ndo2db: done.
Starting ndo2db: done.
+ /usr/local/nagiosxi/scripts/manage_services.sh restart nagios
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
+ rm -f /usr/local/nagiosxi/scripts/repair_databases.lock
[root@HOFVA1226 nagiosxi]#

Can you post a screenshot of the GUI, and describe what you are doing at the time that you encounter this error please?

[daniel.c.marcos.jr]

I attached the screenshot of my nagiosxi gui.


Below are the steps run by my colleague.

yum remove php-cli.x86_64 php-common.x86_64 php-mysql.x86_64 php-pdo.x86_64 php-xml.x86_64
yum install scl-utils
yum install rhscl-php54-*.noarch.rpm
yum install php54

[hsmith]

I attached the screenshot of my nagiosxi gui.


Below are the steps run by my colleague.

yum remove php-cli.x86_64 php-common.x86_64 php-mysql.x86_64 php-pdo.x86_64 php-xml.x86_64
yum install scl-utils
yum install rhscl-php54-*.noarch.rpm
yum install php54

How was XI installed? Did you use the fullinstall script, or download one of the prebuilt VMs? What are you running this on? (CentOS6/7/RHEL...)

Was there a particular reason for removing all of the php components that way vs yum update -y?