Nagios Support Forum

/usr/local/nagiosxi/scripts/reset_config_perms.sh

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond start

ls -lR /usr/local/nagios/ > /tmp/support.txt

/usr/local/nagiosxi/scripts/reset_config_perms.sh

Then please follow the following article, section on how to fix the sudoers entries.
https://support.nagios.com/kb/article/n ... es-34.html

# grep NAGIOS /tmp/nagiosxi.sudoers | sha256sum
02bbaec27094faad6d4aa9ed633500e2504ca4bc1a00c31b786c9c32e25dad08  -
# grep NAGIOS /etc/sudoers | sha256sum
02bbaec27094faad6d4aa9ed633500e2504ca4bc1a00c31b786c9c32e25dad08  -

Finally, run the following commands:

Code: Select all

service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond start

If the instrcutions above don't work run the following command and upload the support.txt file from the /tmp/ folder.

Code: Select all

ls -lR /usr/local/nagios/ > /tmp/support.txt

/var/log/mariadb/mariadb.log
/var/log/mysqld.log

checking time / date on systems
grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
echo "SELECT NOW();" | mysql -u root -pnagiosxi -h nagiosxi-prod-mysql-multiaz.cissnim4uwgq.us-east-1.rds.amazonaws.com
php -r "echo date('r').PHP_EOL;"
strings /etc/localtime | tail -1

npolovenko wrote: Let's compare time/timezones on your nagios server and the remote mysql server. Run these commands on the Nagios server and show me the output.

Code: Select all

## checking time / date on systems
grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
echo "SELECT NOW();" | mysql -u root -pnagiosxi -h my-RDS-FQDN
php -r "echo date('r').PHP_EOL;"
strings /etc/localtime | tail -1

% grep "date.timezone" /etc/php.ini
; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone
date.timezone = US/Eastern
date.timezone = US/Eastern
% ls -l /etc/localtime
lrwxrwxrwx 1 root root 30 Jan 30  2018 /etc/localtime -> /usr/share/zoneinfo/US/Eastern
% php -r 'echo date("D M j G:i:s T Y")."\n";'
Fri Dec 14 10:33:00 EST 2018
% date
Fri Dec 14 10:33:06 EST 2018
% echo "SELECT NOW();" | mysql -u nagios -p -h XXXX.us-east-1.rds.amazonaws.com
Enter password:
NOW()
2018-12-14 15:33:23
% echo "SELECT NOW();" | mysql -u nagiosql -p -h XXXX.us-east-1.rds.amazonaws.com
Enter password: 
NOW()
2018-12-14 15:34:01
% php -r "echo date('r').PHP_EOL;"
Fri, 14 Dec 2018 10:34:07 -0500
% strings /etc/localtime | tail -1
EST5EDT,M3.2.0,M11.1.0

[mysqld]
default-time-zone = '-05:00'

service mysqld restart

echo "SELECT @@global.time_zone;" | mysql -u root -pnagiosxi

echo "SELECT NOW();" | mysql -u root -pnagiosxi

npolovenko wrote:@stefanw, Glad that solution worked for you. Sure, we'll keep this open for a while.
As far as converting tables to InnoDB. The latest XI supports InnoDB engine for the nagiosxi and nagiosql databases. Nagios database needs to stay in My-ISAM. Perhaps instead of using AWS backup system, you can set up scheduled automatic backups in Nagios XI(DB snapshot is included in XI backups)?
https://assets.nagios.com/downloads/nag ... ios-XI.pdf