Hello,
I have a horizontal cluster based installation where in 1 machine has the Omnilead APP and the Postgres database in another machine working well.
I have noted the calls logs are being written with timestamp GMT and not in GMT-5 where We are located. This despite the fact that the time zone was specifically set in the inventory file in the installation process.
If I run in postgres:
select time,numero_marcado,duracion_llamada from reportes_app_llamadalog ORDER BY time DESC LIMIT 10;
the output is:
time | numero_marcado | duracion_llamada
-------------------------------+----------------+------------------
2020-08-28 15:24:27.583375-05 | 1921681115 | 81
2020-08-28 15:23:13.466234-05 | 1921681115 | -1
2020-08-28 15:23:06.870378-05 | 1921681115 | -1
2020-08-28 15:23:00.251202-05 | 1921681115 | -1
2020-08-28 15:22:59.737645-05 | 1921681115 | -1
2020-08-28 15:18:55.554318-05 | 1921681115 | -1
2020-08-28 15:18:47.496078-05 | 1921681115 | -1
2020-08-28 15:17:30.663336-05 | 1921681115 | -1
2020-08-28 15:17:17.662794-05 | 1921681115 | -1
2020-08-28 15:16:47.11327-05 | 1921681115 | 319
(10 rows)
As you can see, the timestamp includes the local timezone (-05), but the time written is GMT, for example in the record:
time | numero_marcado | duracion_llamada
-------------------------------+----------------+------------------
2020-08-28 15:24:27.583375-05 | 1921681115 | 81
that call was received 2020-08-28 10:24:27.
Both servers (APP and DB) are synced with a NTP Server.
Any idea of what is going on?
Thanks!
