Page 3 of 3
Re: Nagios XI Dashboard is not loading data.
Posted: Mon Jan 16, 2017 10:26 am
by dwhitfield
Fantastic. We await word.
Re: Nagios XI Dashboard is not loading data.
Posted: Wed Feb 22, 2017 1:39 am
by 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 *
Re: Nagios XI Dashboard is not loading data.
Posted: Wed Feb 22, 2017 1:31 pm
by 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