Nagios XI Dashboard is not loading data.

[dwhitfield]

Fantastic. We await word.

[cstg-infra]

The nagios user has following sudo permissions on the server:

[nagios@eems-monitor ~]sudo -l
Matching Defaults entries for nagios on this host:
env_keep=*, timestamp_timeout=30, syslog=local2

User nagios may run the following commands on this host:
(root) NOPASSWD: /usr/local/bin/loginstamp
(root) NOPASSWD: /usr/bin/vncserver-service
(root) NOPASSWD: /usr/local/nagiosxi/scripts/upgrade_to_latest.sh, /usr/bin/tail -100 /var/log/httpd/error_log, /usr/bin/tail -100 /var/log/messages, /usr/bin/tail -100 /var/log/mysqld.log,
/usr/local/nagiosxi/scripts/manage_services.sh *, /etc/init.d/nagios *, /etc/init.d/ndo2db *, /etc/init.d/npcd *, /etc/init.d/snmptt restart, /usr/bin/nmap *, /usr/local/nagiosxi/scripts/change_timezone.sh,
/usr/local/nagiosxi/scripts/repair_databases.sh, /usr/local/nagiosxi/scripts/reset_config_perms.sh, /usr/local/nagiosxi/scripts/repairmysql.sh *
(root) NOPASSWD: /router/contrib/bin/lsafe
(root) NOPASSWD: /sw/packages/wit/current/bin/witmount
(root) NOPASSWD: /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh
(root) NOPASSWD: /usr/local/nagiosxi/scripts/manage_services.sh *, /etc/init.d/nagios *, /etc/init.d/ndo2db *, /etc/init.d/npcd *, /etc/init.d/snmptt restart, /usr/bin/nmap *,
/usr/local/nagiosxi/scripts/change_timezone.sh, /usr/local/nagiosxi/scripts/repair_databases.sh, /usr/local/nagiosxi/scripts/upgrade_to_latest.sh, /usr/bin/tail -100 /var/log/httpd/error_log, /usr/bin/tail
-100 /var/log/messages, /usr/bin/tail -100 /var/log/mysqld.log, /usr/local/nagiosxi/scripts/repairmysql.sh *, /usr/local/nagiosxi/scripts/reset_config_perms.sh,
/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh, (root) /usr/bin/php /usr/local/nagiosxi/html/includes/components/autodiscovery/scripts/autodiscover_new.php *

[ssax]

Hmm, it doesn't look like NDO2DB is working properly, please run these commands:

Code: Select all

service npcd stop
service nagios stop
killall -9 nagios
service ndo2db stop
killal
service mysqld restart
rm -rf /usr/local/nagios/var/rw/nagios.cmd
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
pkill -9 -u nagios
service postgresql restart
service ndo2db start
service nagios start
service npcd start

Then send me the output of these commands AND attach an updated profile.

Code: Select all

ipcs -q
service nagios status
service ndo2db status

I also noticed that you don't have the pwd entries in your /usr/local/nagiosxi/html/config.inc.php file, did you remove them?

They should be:

Code: Select all

$cfg['db_info'] = array(
    "nagiosxi" => array(
        "dbtype" => 'pgsql',
        "dbserver" => '',
        "user" => 'nagiosxi',
        "pwd" => 'n@gweb',
        "db" => 'nagiosxi',
        "dbmaint" => array( // variables affecting maintenance of db
            "max_auditlog_age" => 30, // max time (in DAYS) to keep audit log entries
            "max_commands_age" => 480, // max time (minutes) to keep commands
            "max_events_age" => 480, // max time (minutes) to keep events
            "optimize_interval" => 60, // time (in minutes) between db optimization runs
            "repair_interval" => 0, // time (in minutes) between db repair runs
        ),
    ),
    "ndoutils" => array(
        "dbtype" => 'mysql',
        "dbserver" => 'localhost',
        "user" => 'ndoutils',
        "pwd" => 'n@gweb',
        "db" => 'nagios',
        "dbmaint" => array( // variables affecting maintenance of ndoutils db

            "max_externalcommands_age" => 7, // max time (in DAYS) to keep external commands
            "max_logentries_age" => 90, // max time (in DAYS) to keep log entries
            "max_statehistory_age" => 730, // max time (in DAYS) to keep state history information
            "max_notifications_age" => 90, // max time (in DAYS) to keep notifications
            "max_timedevents_age" => 5, // max time (minutes) to keep timed events
            "max_systemcommands_age" => 5, // max time (minutes) to keep system commands
            "max_servicechecks_age" => 5, // max time (minutes) to keep service checks
            "max_hostchecks_age" => 5, // max time (minutes) to keep host checks
            "max_eventhandlers_age" => 5, // max time (minutes) to keep event handlers
            "optimize_interval" => 60, // time (in minutes) between db optimization runs
            "repair_interval" => 0, // time (in minutes) between db repair runs
        ),
    ),
    "nagiosql" => array(
        "dbtype" => 'mysql',
        "dbserver" => 'localhost',
        "user" => 'nagiosql',
        "pwd" => 'n@gweb',
        "db" => 'nagiosql',
        "dbmaint" => array( // variables affecting maintenance of db
            "max_logbook_age" => 480, // max time (minutes) to keep log book records
            "optimize_interval" => 60, // time (in minutes) between db optimization runs
            "repair_interval" => 0, // time (in minutes) between db repair runs
        ),
    ),
);

Try adding them back in and see if that works.


Thank you