Roundcube Community Forum

Release Support => Pending Issues => Topic started by: CarlosinFL on December 19, 2012, 03:37:16 PM

Title: DB Time Differs From PHP?
Post by: CarlosinFL on December 19, 2012, 03:37:16 PM
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.
Title: Re: DB Time Differs From PHP?
Post by: SKaero on December 20, 2012, 09:57:02 AM
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;