Fail: Time between this server and the mysql database is off Mysql time 2019-08-27 11:30:17 PHP time 2019-08-27 15:30:17

Hi All,

I recently installed LibreNMS with Apache on Lubuntu 18.04. After finishing up the installation, my validate config told me that

Fail: Time between this server and the mysql database is off Mysql time 2019-08-27 11:30:17 PHP time 2019-08-27 15:30:17

What should I concern to match time between mysql and PHP time setting? Any idea?

1 Like

mysql usually takes system TZ and in PHP you must configure it manually in php.ini (both, CLI and Apache) Check Configure PHP from here https://docs.librenms.org/Installation/Installation-Ubuntu-1804-Apache/

Hi, I checked TZ through

[email protected]:~$ date
Tue Aug 27 17:11:55 EDT 2019

and I checked php.ini files in

/etc/php/7.2/apache2
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone = America/New_York

/etc/php/7.2/cli
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone = America/New_York

Am I missing something? please let me know,

I just removed ‘;’ (meaning that the line is a comment) for both php.ini date.timezone and it is solved!

Thanks!

2 Likes