Database Backend Is Not Running

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
jomann
Development Lead
Posts: 611
Joined: Mon Apr 22, 2013 10:06 am
Location: Nagios Enterprises

Re: Database Backend Is Not Running

Post by jomann »

This is a known issue with 5.4 - there will be a fix in 5.4.1 but if you don't want to see the red mark then you can edit the following:

/usr/local/nagiosxi/cron/sysstat.php

Around line 142 you will see:

Code: Select all

# Check if we are on a systemctl or not and if we are checking ndo2db
if (file_exists('/usr/lib/systemd')) {
    if ($darr["daemon"] == 'ndo2db') {
        $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
    }
}
Comment that part out, save, and wait for the cron to run again and it should show the proper status.

(Here is what you should make it look like)

Code: Select all

# Check if we are on a systemctl or not and if we are checking ndo2db
/*
if (file_exists('/usr/lib/systemd')) {
    if ($darr["daemon"] == 'ndo2db') {
        $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
    }
}
*/
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

jomann wrote:This is a known issue with 5.4 - there will be a fix in 5.4.1 but if you don't want to see the red mark then you can edit the following:

/usr/local/nagiosxi/cron/sysstat.php

Around line 142 you will see:

Code: Select all

# Check if we are on a systemctl or not and if we are checking ndo2db
if (file_exists('/usr/lib/systemd')) {
    if ($darr["daemon"] == 'ndo2db') {
        $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
    }
}
Comment that part out, save, and wait for the cron to run again and it should show the proper status.

(Here is what you should make it look like)

Code: Select all

# Check if we are on a systemctl or not and if we are checking ndo2db
/*
if (file_exists('/usr/lib/systemd')) {
    if ($darr["daemon"] == 'ndo2db') {
        $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
    }
}
*/
Hi

I made the changes and still I am facing the same issue.

Code: Select all

 tail -25 /usr/local/nagios/var/ndo2db.debug
109=1.00000
162=xi_timeperiod_24x7
262=XIWIZARD:0:switch
999


[1484283001.283140] [001.2] [pid=28273] Handling: 54=0
[1484283001.283169] [001.2] [pid=28273] Handling: 98=0.00000
[1484283001.283202] [001.2] [pid=28273] Handling: 71=0.00000
[1484283001.283232] [001.2] [pid=28273] Handling: 42=0.24284
[1484283001.283262] [001.2] [pid=28273] Handling: 113=0
[1484283001.283291] [001.2] [pid=28273] Handling: 45=0
[1484283001.283320] [001.2] [pid=28273] Handling: 103=1
[1484283001.283368] [001.2] [pid=28273] Handling: 91=1
[1484283001.283403] [001.2] [pid=28273] Handling: 78=0
[1484283001.283433] [001.2] [pid=28273] Handling: 37=
[1484283001.283479] [001.2] [pid=28273] Handling: 11=check_xi_host_ping!3000.0!80%!5000.0!100%
[1484283001.283515] [001.2] [pid=28273] Handling: 86=5.00000
[1484283001.283546] [001.2] [pid=28273] Handling: 109=1.00000
[1484283001.283577] [001.2] [pid=28273] Handling: 162=xi_timeperiod_24x7
[1484283001.283609] [001.2] [pid=28273] Handling: 262=XIWIZARD:0:switch
[1484283001.283640] [001.2] [pid=28273] Handling: 999
[1484283001.283700] [002.0] [pid=28273] INSERT INTO nagios_hoststatus SET instance_id='1', host_object_id='316', status_update_time=FROM_UNIXTIME(1484283001), output='OK - 209\.29\.4\.234: rta 46\.805ms, lost 0%', long_output='', perfdata='rta=46\.805ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=53\.568ms;;;; rtmin=45\.010ms;;;;', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1484283001), next_check=FROM_UNIXTIME(1484283301), check_type='0', last_state_change=FROM_UNIXTIME(1481223386), last_hard_state_change=FROM_UNIXTIME(1481223386), last_hard_state='0', last_time_up=FROM_UNIXTIME(1484283001), last_time_down=FROM_UNIXTIME(1481223386), last_time_unreachable=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.242840', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_host='1', modified_host_attributes='0', event_handler='', check_command='check_xi_host_ping!3000\.0!80%!5000\.0!100%', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='131' ON DUPLICATE KEY UPDATE instance_id='1', host_object_id='316', status_update_time=FROM_UNIXTIME(1484283001), output='OK - 209\.29\.4\.234: rta 46\.805ms, lost 0%', long_output='', perfdata='rta=46\.805ms;3000\.000;5000\.000;0; pl=0%;80;100;; rtmax=53\.568ms;;;; rtmin=45\.010ms;;;;', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1484283001), next_check=FROM_UNIXTIME(1484283301), check_type='0', last_state_change=FROM_UNIXTIME(1481223386), last_hard_state_change=FROM_UNIXTIME(1481223386), last_hard_state='0', last_time_up=FROM_UNIXTIME(1484283001), last_time_down=FROM_UNIXTIME(1481223386), last_time_unreachable=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.242840', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_host='1', modified_host_attributes='0', event_handler='', check_command='check_xi_host_ping!3000\.0!80%!5000\.0!100%', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='131'
[1484283001.284660] [002.0] [pid=28273] INSERT INtO nagios_customvariablestatus SET instance_id='1', object_id='316',status_update_time=FROM_UNIXTIME(1484283001), has_been_modified='0', varname='XIWIZARD', varvalue='switch' ON DUPLICATE KEY UPDATE instance_id='1', object_id='316',status_update_time=FROM_UNIXTIME(1484283001), has_been_modified='0', varname='XIWIZARD', varvalue='switch'
[1484283001.284859] [001.2] [pid=28273] Handling:

Code: Select all

 # Check if we are on a systemctl or not and if we are checking ndo2db
         /*
        if (file_exists('/usr/lib/systemd')) {
            if ($darr["daemon"] == 'ndo2db') {
                $cmdline = sprintf("systemctl status %s", $darr["daemon"]);
            }
        }
         */
Please advise. thanks.
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 »

How long did you wait before posting? It will take some time for subsys to get the update.

If you waited a significant amount of time, can you post the output of ll /usr/local/nagiosxi/cron/?
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

dwhitfield wrote:How long did you wait before posting? It will take some time for subsys to get the update.

If you waited a significant amount of time, can you post the output of ll /usr/local/nagiosxi/cron/?
Hi Team,

Please find the output.

Code: Select all

ll /usr/local/nagiosxi/cron/
total 180
-rwxr-xr-x. 1 nagios nagios  1390 Jan  4 22:59 cleaner.php
-rwxr-xr-x. 1 nagios nagios 42991 Jan  4 22:59 cmdsubsys.php
-rwxr-xr-x. 1 nagios nagios   216 Jul 19 15:59 cookie.txt
-rwxr-xr-x. 1 nagios nagios 14446 Jan  4 22:59 dbmaint.php
-rwxrwxrwx. 1 nagios nagios 26313 Jan  4 22:59 deadpool.php
-rwx------. 1 nagios nagios  3714 Jan  4 22:59 event_handler.php
-rwxr-xr-x. 1 nagios nagios  4884 Jan  4 22:59 eventman.php
-rwxr-xr-x. 1 nagios nagios  1613 Jan  4 22:59 feedproc.php
-rwxr-xr-x. 1 nagios nagios  1830 Jan  4 22:59 nom.php
-rwxr-xr-x. 1 nagios nagios 21701 Jan  4 22:59 perfdataproc.php
-rwxr-xr-x. 1 nagios nagios 21618 Jan  4 22:59 recurringdowntime.pl
-rwxr-xr-x. 1 nagios nagios  1435 Jan  4 22:59 reportengine.php
-rwxr-xr-x. 1 nagios nagios 10802 Jan 13 04:48 sysstat.php

Code: Select all

[root@lussvpnagiosdb01 scripts]# ps -ef | grep -i ndo2db
nagios   10832     1  0 18:44 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   13783 10832  0 18:46 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   13785 13783  2 18:46 ?        00:00:02 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
root     14849 22624  0 18:48 pts/0    00:00:00 grep -i ndo2db
nagios   28188     1  0 04:49 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   28446     1  0 04:49 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
[root@lussvpnagiosdb01 scripts]# kiall -9 /usr/local/nagios/etc/ndo2db.cfg
-bash: kiall: command not found
[root@lussvpnagiosdb01 scripts]# killall -9 /usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagios/etc/ndo2db.cfg: no process killed
[root@lussvpnagiosdb01 scripts]# killall -9 ndo2db
[root@lussvpnagiosdb01 scripts]# ps -ef | grep -i ndo2db
root     16190 22624  0 18:49 pts/0    00:00:00 grep -i ndo2db
[root@lussvpnagiosdb01 scripts]# service ndo2db status
ndo2db is not running but subsystem locked
[root@lussvpnagiosdb01 scripts]# cd /usr/local/nagios/var
[root@lussvpnagiosdb01 var]# ls
archives       nagios.configtest  nagios.log    ndo2db.debug.old  ndo2db.pid  ndo.sock  objects.cache     perfdata.log   rw                spool  status.dat
host-perfdata  nagios.lock        ndo2db.debug  ndo2db.lock       ndomod.tmp  npcd.log  objects.precache  retention.dat  service-perfdata  stats
[root@lussvpnagiosdb01 var]# rm -rf ndo2db.lock
[root@lussvpnagiosdb01 var]# service ndo2db start
Starting ndo2db: done.
[root@lussvpnagiosdb01 var]# service ndo2db status
ndo2db is not running but subsystem locked
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Database Backend Is Not Running

Post by tgriep »

Try deleting the ndo.sock file from that folder and see if you can start ndo2db by running

Code: Select all

service ndo2db start
If it doesn't, look in the /var/log/messages file for any errors and post them here.
Be sure to check out our Knowledgebase for helpful articles and solutions!
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

tgriep wrote:Try deleting the ndo.sock file from that folder and see if you can start ndo2db by running

Code: Select all

service ndo2db start
If it doesn't, look in the /var/log/messages file for any errors and post them here.
Hi Tom,

Tried this, but could not fix the issue.

Code: Select all

[root@lussvpnagiosdb01 var]# rm -rf ndo.sock
[root@lussvpnagiosdb01 var]# ls
archives       nagios.configtest  nagios.log    ndo2db.debug.old  ndomod.tmp  objects.cache     perfdata.log   rw                spool  status.dat
host-perfdata  nagios.lock        ndo2db.debug  ndo2db.pid        npcd.log    objects.precache  retention.dat  service-perfdata  stats
[root@lussvpnagiosdb01 var]# service ndo2db start
Starting ndo2db: done.
[root@lussvpnagiosdb01 var]# service ndo2db restart
ndo2db was not running... could not stop
Starting ndo2db: done.
[root@lussvpnagiosdb01 var]# ls
archives       nagios.configtest  nagios.log    ndo2db.debug.old  ndo2db.pid  ndo.sock  objects.cache     perfdata.log   rw                spool  status.dat
host-perfdata  nagios.lock        ndo2db.debug  ndo2db.lock       ndomod.tmp  npcd.log  objects.precache  retention.dat  service-perfdata  stats
[root@lussvpnagiosdb01 var]# ls
archives       nagios.configtest  nagios.log    ndo2db.debug.old  ndo2db.pid  ndo.sock  objects.cache     perfdata.log   rw                spool  status.dat
host-perfdata  nagios.lock        ndo2db.debug  ndo2db.lock       ndomod.tmp  npcd.log  objects.precache  retention.dat  service-perfdata  stats
[root@lussvpnagiosdb01 var]# ps -ef | grep -i ndo2db
nagios   17210     1  0 Jan13 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   21284     1  0 19:50 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   21486     1  0 19:50 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   21790     1  0 19:51 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
root     22483 15207  0 19:51 pts/0    00:00:00 grep -i ndo2db
nagios   27518     1  0 11:16 ?        00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   31602 27518  0 17:18 ?        00:00:09 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   31603 31602  0 17:18 ?        00:01:17 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
[root@lussvpnagiosdb01 var]# service nagios^C
[root@lussvpnagiosdb01 var]# ps -ef | grep -i nagios.cfg
root     22594 15207  0 19:51 pts/0    00:00:00 grep -i nagios.cfg
nagios   31595     1  0 17:18 ?        00:00:19 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios   31618 31595  0 17:18 ?        00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
[root@lussvpnagiosdb01 var]# killall -9 ndo2db
[root@lussvpnagiosdb01 var]# ps -ef | grep -i ndo2db
root     22819 15207  0 19:51 pts/0    00:00:00 grep -i ndo2db
[root@lussvpnagiosdb01 var]# rm -rf ndo2db.lock ndo.sock
[root@lussvpnagiosdb01 var]# service ndo2db start
Starting ndo2db: done.
[root@lussvpnagiosdb01 var]# service ndo2db stop
ndo2db was not running... could not stop
[root@lussvpnagiosdb01 var]# service ndo2db restart
ndo2db was not running... could not stop
Starting ndo2db: done.

Code: Select all

tail -30 ndo2db.debug
[1484596390.601486] [001.2] [pid=23242] Queue Message: 00000
42=0.36609
113=0
45=0
103=1
93=1
80=0
37=
11=check_tcp!22!!!!!!!
86=5.00000
109=1.00000
209=24x7
999


[1484596390.601493] [001.2] [pid=23242] Handling: 71=0.00000
[1484596390.601510] [001.2] [pid=23242] Handling: 42=0.36609
[1484596390.601527] [001.2] [pid=23242] Handling: 113=0
[1484596390.601544] [001.2] [pid=23242] Handling: 45=0
[1484596390.601561] [001.2] [pid=23242] Handling: 103=1
[1484596390.601578] [001.2] [pid=23242] Handling: 93=1
[1484596390.601595] [001.2] [pid=23242] Handling: 80=0
[1484596390.601612] [001.2] [pid=23242] Handling: 37=
[1484596390.601629] [001.2] [pid=23242] Handling: 11=check_tcp!22!!!!!!!
[1484596390.601646] [001.2] [pid=23242] Handling: 86=5.00000
[1484596390.601663] [001.2] [pid=23242] Handling: 109=1.00000
[1484596390.601680] [001.2] [pid=23242] Handling: 209=24x7
[1484596390.601697] [001.2] [pid=23242] Handling: 999
[1484596390.601723] [002.0] [pid=23242] INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='398', status_update_time=FROM_UNIXTIME(1484596390), output='TCP OK - 0\.364 second response time on 10\.135\.6\.1 port 22', long_output='', perfdata='time=0\.363621s;;;0\.000000;10\.000000', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1484596390), next_check=FROM_UNIXTIME(1484596690), check_type='0', last_state_change=FROM_UNIXTIME(1484484208), last_hard_state_change=FROM_UNIXTIME(1483473557), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1484596390), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1484484208), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.366090', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_tcp!22!!!!!!!', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='125' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='398', status_update_time=FROM_UNIXTIME(1484596390), output='TCP OK - 0\.364 second response time on 10\.135\.6\.1 port 22', long_output='', perfdata='time=0\.363621s;;;0\.000000;10\.000000', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1484596390), next_check=FROM_UNIXTIME(1484596690), check_type='0', last_state_change=FROM_UNIXTIME(1484484208), last_hard_state_change=FROM_UNIXTIME(1483473557), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1484596390), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(0), last_time_critical=FROM_UNIXTIME(1484484208), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.366090', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_tcp!22!!!!!!!', normal_check_interval='5.000000', retry_check_interval='1.000000', check_timeperiod_object_id='125'
[1484596390.602010] [001.2] [pid=23242] Handling:

Code: Select all

ls -al
total 4840
drwxrwxr-x.  6 nagios nagios    4096 Jan 16 19:53 .
drwxr-xr-x. 10 root   root      4096 Aug 11 07:24 ..
drwxrwxr-x.  2 nagios nagios   12288 Jan 15 23:59 archives
-rw-r--r--.  1 nagios nagios    2120 Jan 16 19:53 host-perfdata
-rw-r--r--.  1 nagios nagios    1124 Jan 16 17:18 nagios.configtest
-rw-r--r--.  1 nagios nagios       6 Jan 16 17:18 nagios.lock
-rwxr-xr-x.  1 nagios nagios  981242 Jan 16 19:53 nagios.log
-rw-r--r--.  1 nagios nagios  422528 Jan 16 19:53 ndo2db.debug
-rw-r--r--.  1 nagios nagios 1000766 Jan 16 19:53 ndo2db.debug.old
-rw-r--r--.  1 nagios nagios       6 Jan 16 19:52 ndo2db.lock
-rw-r--r--.  1 nagios nagios       0 Jan 16 19:52 ndo2db.pid
-rw-r--r--.  1 nagios nagios       0 Jan 16 17:18 ndomod.tmp
srwxr-xr-x.  1 nagios nagios       0 Jan 16 19:52 ndo.sock
-rwxr-xr-x.  1 nagios nagios   29385 Jan 14 15:38 npcd.log
-rwxr-xr-x.  1 nagios nagios  487159 Jan 16 17:18 objects.cache
-rwxr-xr-x.  1 nagios nagios  487159 Jan 16 17:18 objects.precache
-rwxr-xr-x.  1 nagios nagios   28151 Jan 14 15:38 perfdata.log
-rw-------.  1 nagios nagios  719365 Jan 16 19:18 retention.dat
drwxr-sr-x.  2 nagios nagcmd    4096 Jan 16 17:18 rw
-rw-r--r--.  1 nagios nagios    4649 Jan 16 19:53 service-perfdata
drwxr-xr-x.  5 nagios nagios    4096 Jun 15  2016 spool
drwxr-xr-x.  2 nagios nagios    4096 Jan 16 19:53 stats
-rw-rw-r--.  1 nagios nagios  718422 Jan 16 19:53 status.dat

Code: Select all

grep ndo2dn /var/log/messages
Jan 16 13:51:31 lussvpnagiosdb01 ndo2db: Trimming timedevents.
Jan 16 13:51:31 lussvpnagiosdb01 ndo2db: Trimming systemcommands.
Jan 16 13:51:31 lussvpnagiosdb01 ndo2db: Trimming servicechecks.
Jan 16 13:51:31 lussvpnagiosdb01 ndo2db: Trimming hostchecks.
Jan 16 13:51:31 lussvpnagiosdb01 ndo2db: Trimming eventhandlers.
Jan 16 13:51:46 lussvpnagiosdb01 nagios: ndomod: Please check remote ndo2db log, database connection or SSL Parameters
Jan 16 13:52:19 lussvpnagiosdb01 ndo2db: Trimming timedevents.
Jan 16 13:52:19 lussvpnagiosdb01 ndo2db: Trimming systemcommands.
Jan 16 13:52:19 lussvpnagiosdb01 ndo2db: Trimming servicechecks.
Jan 16 13:52:19 lussvpnagiosdb01 ndo2db: Trimming hostchecks.
Jan 16 13:52:19 lussvpnagiosdb01 ndo2db: Trimming eventhandlers.
Jan 16 13:53:20 lussvpnagiosdb01 ndo2db: Trimming timedevents.
Jan 16 13:53:20 lussvpnagiosdb01 ndo2db: Trimming systemcommands.
Jan 16 13:53:20 lussvpnagiosdb01 ndo2db: Trimming servicechecks.
Jan 16 13:53:20 lussvpnagiosdb01 ndo2db: Trimming hostchecks.
Jan 16 13:53:20 lussvpnagiosdb01 ndo2db: Trimming eventhandlers.
Could you please advise, what can be done here. thanks.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Database Backend Is Not Running

Post by tgriep »

Can you post this file from the XI server so we can view it?

Code: Select all

/usr/local/nagiosxi/cron/sysstat.php
Thanks.
Be sure to check out our Knowledgebase for helpful articles and solutions!
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

tgriep wrote:Can you post this file from the XI server so we can view it?

Code: Select all

/usr/local/nagiosxi/cron/sysstat.php
Thanks.
Hi Tom,

Please find the file attached.
You do not have the required permissions to view the files attached to this post.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Database Backend Is Not Running

Post by tgriep »

Can you login to the XI server in a console, run the following commands and post the output?

Code: Select all

su nagios
/etc/init.d/ndo2db status
echo $?
Can you upload the following file here as well?

Code: Select all

/usr/local/nagiosxi/var/sysstat.log
Thanks.
Be sure to check out our Knowledgebase for helpful articles and solutions!
raamardhani7
Posts: 459
Joined: Tue Jun 02, 2015 12:36 am

Re: Database Backend Is Not Running

Post by raamardhani7 »

tgriep wrote:Can you login to the XI server in a console, run the following commands and post the output?

Code: Select all

su nagios
/etc/init.d/ndo2db status
echo $?
Can you upload the following file here as well?

Code: Select all

/usr/local/nagiosxi/var/sysstat.log
Thanks.
Hi Tom,

Please find the output asked.

Code: Select all

[root@lussvpnagiosdb01 var]# su nagios
[nagios@lussvpnagiosdb01 var]$ /etc/init.d/ndo2db status
ndo2db is not running but subsystem locked
[nagios@lussvpnagiosdb01 var]$ echo $?
1
[nagios@lussvpnagiosdb01 var]$
You do not have the required permissions to view the files attached to this post.
Locked