Nagios Support Forum

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.

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.