Page 1 of 1

NagiosXI 5.5.7 : Database Backend error....

Posted: Thu Nov 22, 2018 7:51 am
by vishfx
Hi Nagios Team,

NagiosXI 5.5.7 ( installed from nagiosxi repo)
OS: RHEL 7.5

Seeing the Database Backend Error:
db_err.PNG
n2dodb & maridb seems to be up.

Code: Select all

-bash-4.2$ sudo /usr/bin/systemctl status ndo2db
● ndo2db.service - Nagios Data Out Daemon
   Loaded: loaded (/usr/lib/systemd/system/ndo2db.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2018-11-22 06:37:08 CST; 10min ago
     Docs: http://www.nagios.org/documentation
  Process: 38066 ExecStopPost=/bin/rm -f /usr/local/nagios/var/ndo2db.lock (code=exited, status=0/SUCCESS)
  Process: 38277 ExecStartPre=/bin/rm -f /usr/local/nagios/var/ndo.sock (code=exited, status=0/SUCCESS)
  Process: 38275 ExecStartPre=/bin/rm -f /usr/local/nagios/var/ndo2db.lock (code=exited, status=0/SUCCESS)
 Main PID: 38280 (ndo2db)
   CGroup: /system.slice/ndo2db.service
           ├─38280 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
           ├─38317 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
           └─38318 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f

Nov 22 06:45:41 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming timedevents.
Nov 22 06:45:41 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming systemcommands.
Nov 22 06:45:41 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming servicechecks.
Nov 22 06:45:41 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming hostchecks.
Nov 22 06:45:41 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming eventhandlers.
Nov 22 06:46:44 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming timedevents.
Nov 22 06:46:44 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming systemcommands.
Nov 22 06:46:44 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming servicechecks.
Nov 22 06:46:44 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming hostchecks.
Nov 22 06:46:44 ausulnxipwb01.us.dell.com ndo2db[38318]: Trimming eventhandlers.

Code: Select all

-bash-4.2$ ps axuwww | grep maria
mysql     35557  4.4  1.2 4794128 201384 ?      Sl   06:31   0:48 /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

Kindly assist.

Re: NagiosXI 5.5.7 : Database Backend error....

Posted: Mon Nov 26, 2018 9:19 am
by scottwilkerson
Lets run the following

Code: Select all

/usr/bin/systemctl sop ndo2db
rm -f /usr/local/nagios/var/ndo2db.lock /usr/local/nagios/var/ndo.sock
/usr/bin/systemctl start ndo2db
/usr/bin/systemctl restart nagios

Re: NagiosXI 5.5.7 : Database Backend error....

Posted: Tue Nov 27, 2018 12:15 am
by vishfx
Thanks it works now.

Re: NagiosXI 5.5.7 : Database Backend error....

Posted: Tue Nov 27, 2018 8:49 am
by scottwilkerson
vishfx wrote:Thanks it works now.
great!

Locking