The database is offloaded, but my previous posting of that information took that into account. Here is the info you asked for: (note that PHP is not installed on the MySQL server)rkennedy wrote:Looks like your DB is offloaded, and I believe this issue could be related to timestamps. Could you run the following commands on both the XI machine, and the offloaded DB machine? Replace the SQL credentials as needed for the SQL machine. Some of these may fail, and that's fine. -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 -uroot-pn@gweb -e "SELECT NOW();"
Code: Select all
NAGIOS SERVER
root@fe1.nagios (Linux) $ ./check.sh
; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone
date.timezone = America/Los_Angeles
-rw-r--r--. 1 root root 2819 May 13 2014 /etc/localtime
Thu Sep 29 14:27:20 PDT 2016
Thu Sep 29 14:27:20 PDT 2016
+---------------------+
| NOW() |
+---------------------+
| 2016-09-29 14:27:20 |
+---------------------+
Code: Select all
MySQL SERVER
root@db1.nagios (Linux) $ ./check.sh
grep: /etc/php.ini: No such file or directory
-rw-r--r--. 1 root root 2819 Feb 14 2013 /etc/localtime
./check.sh: line 3: php: command not found
Thu Sep 29 14:27:20 PDT 2016
+---------------------+
| NOW() |
+---------------------+
| 2016-09-29 14:27:20 |
+---------------------+