Nagios Database Backend failed to start

[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

[hsmith]

Hi Igor,

Is this XI5?

What is the output of this command?

Code: Select all

service mysqld status

[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.

[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

[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.

Code: Select all

service ndo2db start

Try that out and let us know if you need anymore help.

[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

[tgriep]

Could you post the ndo2dn.cfg file so we can review it?

Code: Select all

/usr/local/nagios/etc/ndo2db.cfg

[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

[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