Support for Nagios products and services
https://support.nagios.com/forum/
Code: Select all
grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
mysql -unagiosxi -pn@gweb -e "SELECT NOW();"
Code: Select all
[root@nagiosxi ~]# grep "date.timezone" /etc/php.ini
; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone
date.timezone = Europe/Paris
[root@nagiosxi ~]# ls -l /etc/localtime
lrwxrwxrwx 1 root root 32 Jan 9 09:55 /etc/localtime -> /usr/share/zoneinfo/Europe/Paris
[root@nagiosxi ~]# php -r 'echo date("D M j G:i:s T Y")."\n";'
Fri Jan 20 9:50:46 CET 2017
[root@nagiosxi ~]# date
Fri Jan 20 09:50:51 CET 2017
[root@nagiosxi ~]# mysql -unagiosxi -pn@gweb -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2017-01-20 09:50:57 |
+---------------------+
[root@nagiosxi ~]#
You may need to restart nagios / ndo2db / mysql / httpd after adjusting the time all around, as they may be holding pre-cached timezones. Are you still experiencing the issue after doing so?Is your database hosted local, or offloaded?
Code: Select all
[root@nagiosxi ~]# service ndo2db restart
Stopping ndo2db: done.
Starting ndo2db: done.
[root@nagiosxi ~]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@nagiosxi ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using nagiosxi.cg.ahp for ServerName
[ OK ]
[root@nagiosxi ~]# date
Mon Jan 23 12:13:53 CET 2017
[root@nagiosxi ~]#