Page 1 of 1
Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 2:23 pm
by castroi
Hello,
I have my Database Backend Service which stopped running.
I am running Nagios XI version 5.2.0 .
Could you please assist?
PS: My previous post was
https://support.nagios.com/forum/viewto ... 35#p158472 before i got proper access.
Thank you
Igor
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 2:30 pm
by hsmith
Hi Igor,
Is this XI5?
What is the output of this command?
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 2:49 pm
by castroi
Hello,
We found out that Nagios XI is running out of space:
[lxadmin@ymq-lpnagapp1 /]$ sudo df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_linuxos-lv_root
107G 1.8G 100G 2% /
tmpfs 3.9G 0 3.9G 0% /dev/shm
/dev/mapper/vg_linuxos-lv_boot
291M 104M 173M 38% /boot
/dev/mapper/vg_linuxos-lv_home
2.5G 340M 2.1G 15% /home
/dev/mapper/vg_linuxos-lv_tmp
504M 34M 446M 7% /tmp
/dev/mapper/vg_linuxos-lv_usr
3.0G 2.9G 764K 100% /usr
/dev/mapper/vg_linuxos-lv_var
3.0G 879M 2.0G 31% /var
/dev/mapper/vg_linuxos-lv_varlog
1008M 459M 499M 48% /var/log
[lxadmin@ymq-lpnagapp1 /]$
I ll try to fix it and let you know.
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 2:50 pm
by castroi
Hello,
Yes it is XI 5.2.0 latest one.
[lxadmin@ymq-lpnagapp1 local]$ service mysqld status
mysqld (pid 24453) is running...
[lxadmin@ymq-lpnagapp1 local]$
Issue is probably due to space. I am trying to adjust lvm.
igor
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 2:59 pm
by tgriep
One place to look to free up space is the Nagios backups in /store/backups/nagiosxi folder.
If you have some old backups that you can remove, that is a quick way to gain storage.
After freeing up some space, the mysql database needs to be repaired by running the following in a shell as root.
Code: Select all
cd /usr/local/nagiosxi/scripts
./repair_databases.sh
After that you can start the ndo2db process by running the following.
Try that out and let us know if you need anymore help.
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 4:52 pm
by castroi
Hello,
It seems that i have still some issue :
---------
- recovering (with sort) MyISAM-table 'tbl_variabledefinition.MYI'
Data records: 47
- Fixing index 1
Starting mysqld: [ OK ]
/usr/local/nagiosxi/scripts
===============
REPAIR COMPLETE
===============
ndo2db was not running... could not stop
Starting ndo2db:Error processing config file '/usr/local/nagios/etc/ndo2db.cfg'.
done.
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.
[lxadmin@ymq-lpnagapp1 scripts]$ sudo service ndo2db start
Starting ndo2db:Error processing config file '/usr/local/nagios/etc/ndo2db.cfg'.
done.
[lxadmin@ymq-lpnagapp1 scripts]$
Igor
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 5:00 pm
by tgriep
Could you post the ndo2dn.cfg file so we can review it?
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 8:11 pm
by castroi
Hello,
It seems it is empty :
[lxadmin@ymq-lpnagapp1 ~]$ sudo cat /usr/local/nagios/etc/ndo2db.cfg
[lxadmin@ymq-lpnagapp1 ~]$
[lxadmin@ymq-lpnagapp1 ~]$ sudo ls -al /usr/local/nagios/etc/ndo2db.cfg
-rw-rw-r-- 1 apache nagios 0 Jul 4 20:16 /usr/local/nagios/etc/ndo2db.cfg
[lxadmin@ymq-lpnagapp1 ~]$
Igor
Re: Nagios Database Backend failed to start
Posted: Mon Oct 26, 2015 9:06 pm
by castroi
Hello,
I have checked
https://support.nagios.com/forum/viewto ... =6&t=32714 and did the same.
I restored my backup from last friday and it is working fine.
You can close this thread.
thank you,
Igor