<h3>Databse Error</h3>A database connection error has been d

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Nags007
Posts: 58
Joined: Wed Mar 08, 2017 12:32 pm

<h3>Databse Error</h3>A database connection error has been d

Post by Nags007 »

Hi Team,

I am trying to install Nagios XI on redhat 6.8.

[nagiosxi]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)

When i run the ./fullinstall, i am facing the issue with Database CONNECTION Error

<h3>Databse Error</h3>A database connection error has been detected, please follow the repair prompt below. If the issue persists,
please contact Nagios support.<p>Run the following from the CLI as root to attempt to repair the DB:
<br><pre>/usr/local/nagiosxi/scripts/repair_databases.sh</pre></p>Installing/updating XI wizards...


1. I have run the script file as per above message : /usr/local/nagiosxi/scripts/repair_databases.sh

2. Following databases got repaired.

nagios.
nagiosxi.
nagiosql.

nagios database repair succeeded
nagiosql database repair succeeded
nagiosxi database repair succeeded


3. Again i run the ./fullinstall

4. still i am facing the same DB connection error.

i am facing the issue with Database CONNECTION Error
======================================================================================================================
<h3>Databse Error</h3>A database connection error has been detected, please follow the repair prompt below. If the issue persists,
please contact Nagios support.<p>Run the following from the CLI as root to attempt to repair the DB:
<br><pre>/usr/local/nagiosxi/scripts/repair_databases.sh</pre></p>Installing/updating XI wizards...
======================================================================================================================


5. MYSQL DB is running fine.

[root@ nagiosxi]# service mysqld status
mysqld (pid 40834) is running...

[root@ nagiosxi]# service ndo2db status
ndo2db (pid 40897) is running...

[root@ nagiosxi]# service mariadb status
mariadb: unrecognized service


[root@nagiosxi]# mysql -u nagiosxi -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| nagiosxi |
| test |
+--------------------+
3 rows in set (0.00 sec)

============================================

please find the attached log file.

Your help is highly appreciated.

Thank you,
Nag.
You do not have the required permissions to view the files attached to this post.
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: <h3>Databse Error</h3>A database connection error has be

Post by tmcdonald »

I will be closing this thread as we are already addressing your install issues in another: https://support.nagios.com/forum/viewto ... 85#p215185

Once again, please do not open multiple threads for the same issue.
Former Nagios employee
Locked