Database Backend Is Not Running

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Database Backend Is Not Running

Post by ssax »

I'm wondering if your init script wasn't updated, please attach this file:

Code: Select all

/etc/init.d/ndo2db
Thank you
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

ssax wrote:I'm wondering if your init script wasn't updated, please attach this file:

Code: Select all

/etc/init.d/ndo2db
Thank you
Hi Team,

Please find the attached ndo2db file.
You do not have the required permissions to view the files attached to this post.
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

raamardhani7 wrote:
ssax wrote:I'm wondering if your init script wasn't updated, please attach this file:

Code: Select all

/etc/init.d/ndo2db
Thank you
Hi Team,

Please find the uploaded the ndo2db file from different server and it looks it is running fine.

Code: Select all

service ndo2db status
ndo2db (pid 24205) is running...
But on the portal we are still seeing the database backend in red. I ran the repair database script.

Code: Select all

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...
Stopping nagios: done.
Starting nagios: done.

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

Code: Select all

Running pre-flight check on configuration data...

Checking objects...
        Checked 374 services.
        Checked 122 hosts.
        Checked 3 host groups.
        Checked 8 service groups.
        Checked 20 contacts.
        Checked 2 contact groups.
        Checked 131 commands.
        Checked 23 time periods.
        Checked 0 host escalations.
        Checked 0 service escalations.
Checking for circular paths...
        Checked 122 hosts
        Checked 0 service dependencies
        Checked 0 host dependencies
        Checked 23 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 9
Total Errors:   0

Things look okay - No serious problems were detected during the pre-flight check
RET: 0
Running configuration check...
Stopping nagios: done.
Starting nagios: done.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Database Backend Is Not Running

Post by rkennedy »

Please run the following -

Code: Select all

rm -f /usr/local/nagios/var/ndo.sock
systemctl start ndo2db.service
systemctl status ndo2db.service
That should bring it back up, if it doesn't, please show us the output from these commands -

Code: Select all

mysql -V
cat /usr/local/nagiosxi/var/xi-sys.cfg | grep mysqld
Former Nagios Employee
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

rkennedy wrote:Please run the following -

Code: Select all

rm -f /usr/local/nagios/var/ndo.sock
systemctl start ndo2db.service
systemctl status ndo2db.service
That should bring it back up, if it doesn't, please show us the output from these commands -

Code: Select all

mysql -V
cat /usr/local/nagiosxi/var/xi-sys.cfg | grep mysqld
Hi Team,

We are still having the same issue. Please find the update asked for.

Code: Select all

 mysql -V
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Code: Select all

cat /usr/local/nagiosxi/var/xi-sys.cfg | grep mysqld
mysqld='mysqld'
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: Database Backend Is Not Running

Post by dwhitfield »

Please submit a ticket ([email protected]) and reference this thread. Please let us know when you have done so, and we will close this thread.

Also, please note that 5.4.1 will be out the week after next (if not sooner), and there will be a fix.
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

dwhitfield wrote:Please submit a ticket ([email protected]) and reference this thread. Please let us know when you have done so, and we will close this thread.

Also, please note that 5.4.1 will be out the week after next (if not sooner), and there will be a fix.
Hi Team,

I have sent a mail to the customer forum. thanks.
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Database Backend Is Not Running

Post by rkennedy »

Ticket has been received, closing this thread out.
Former Nagios Employee
Locked