PHP Warning: mysqli_real_connect():

[markmerchant]

After ESX crash yesterday Nagios DB does not restart. How do I recover? Thx.

Code: Select all

tail -5 ./nagiosxi/var/nom.log
	PHP Warning:  mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /app/nagiosxi/html/db/adodb/drivers/adodb-mysqli.inc.php on line 125
	PHP Warning:  mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /app/nagiosxi/html/db/adodb/drivers/adodb-mysqli.inc.php on line 125
	PHP Warning:  mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /app/nagiosxi/html/db/adodb/drivers/adodb-mysqli.inc.php on line 125
	PHP Warning:  mysqli_real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /app/nagiosxi/html/db/adodb/drivers/adodb-mysqli.inc.php on line 125

ps -ef | grep msql
	mysql    11950     1  0 13:06 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
	mysql    12184 11950  0 13:06 ?        00:00:08 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
	nagios   12455  5111  0 13:20 pts/0    00:00:00 grep --color=auto -i sql

uname -a
	 Linux xxxnagios01.td.afg 3.10.0-693.11.1.el7.x86_64 #1 SMP Fri Oct 27 05:39:05 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux

Nagios XI 5.4.10

[scottwilkerson]

first run the repair script here's a doc outlining the procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf

then verify mysqld is running

Code: Select all

service mysqld status

[markmerchant]

./repair_databases.sh
DATABASE: nagios
TABLE:

service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2018-04-05 13:35:02 EDT; 2min 8s ago
Process: 14690 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 14657 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 14688 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─14688 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─14924 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/my...

Apr 05 13:35:00 cvglpnagios01.td.afg systemd[1]: Starting MariaDB database ...
Apr 05 13:35:00 cvglpnagios01.td.afg mariadb-prepare-db-dir[14657]: Databas...
Apr 05 13:35:00 cvglpnagios01.td.afg mariadb-prepare-db-dir[14657]: If this...
Apr 05 13:35:00 cvglpnagios01.td.afg mysqld_safe[14688]: 180405 13:35:00 my...
Apr 05 13:35:00 cvglpnagios01.td.afg mysqld_safe[14688]: 180405 13:35:00 my...
Apr 05 13:35:02 cvglpnagios01.td.afg systemd[1]: Started MariaDB database s...
Hint: Some lines were ellipsized, use -l to show in full.

[scottwilkerson]

did the repair finish?

If so is the UI working now?

[markmerchant]

Appears to finish, but lockfile remains.

UI status
Database Backend
ndo2db is not running
Actions

[scottwilkerson]

lets restart ndo2db

Code: Select all

service ndo2db restart

[markmerchant]

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

[markmerchant]

service ndo2db start; service ndo2db status
Starting ndo2db (via systemctl): [ OK ]
ndo2db is not running

[markmerchant]

This worked:

rm -rf /usr/local/nagios/var/ndo*; service ndo2db start

[scottwilkerson]

Excellent, glad to hear it is resolved