Page 1 of 1
Message: A database connection error has been detected
Posted: Thu Aug 20, 2015 11:23 am
by 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
Re: Message: A database connection error has been detected,
Posted: Thu Aug 20, 2015 11:26 am
by hsmith
/usr/local/nagiosxi/scripts/repair_databases.sh
Did you try doing this?
Re: Message: A database connection error has been detected,
Posted: Thu Aug 20, 2015 11:56 am
by 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]#
Re: Message: A database connection error has been detected,
Posted: Thu Aug 20, 2015 12:34 pm
by hsmith
daniel.c.marcos.jr wrote: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?
Re: Message: A database connection error has been detected
Posted: Thu Aug 20, 2015 12:52 pm
by 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
Re: Message: A database connection error has been detected
Posted: Thu Aug 20, 2015 4:03 pm
by hsmith
daniel.c.marcos.jr wrote: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?