When installing RoundCube today, the installer informed me:
Check DB config
DSN (write): OK
DB Schema: OK
DB Write: OK
DB Time: NOT OK(Database time differs s from PHP time)
My web, db, and mail are all three unique machines. Who do I need to check the PHP time on? The db server running PostgreSQL 9.2? The web server running Apache / PHP / RoundCube? Or the mail server running Postfix? I'm guessing it's the time on the web server which has PHP installed. But how do I resolve this? My database server is using NTP and looks perfect.
That error is odd, what do you get if you run the following query on the PostgreSQL server?
SELECT EXTRACT(EPOCH FROM DATE_TRUNC('seconds', CAST ((CURRENT_TIMESTAMP) AS TIMESTAMP))) AS tz_db;