Page 1 of 1
Vicidial Slave Database adding Hours
Posted:
Mon Mar 15, 2021 9:50 pmby Nefariousparity
Hello, I have created a few Ubuntu LXC slave database boxes, and it is adding +2 hours on agent performance report their time column? I thought maybe because the slave was in a different time, I guess not? Or maybe it is from the hardware clock?
Re: Vicidial Slave Database adding Hours
Posted:
Tue Mar 16, 2021 2:19 amby carpenox
what is the slave db server mysql timezone set to in comparison....
Re: Vicidial Slave Database adding Hours
Posted:
Tue Mar 16, 2021 6:55 pmby Nefariousparity
The host is PST, timezone on the container is EST,
Master DB is EST
Slave DB MYSQL
current_timestamp |
+---------------------+
| 2021-03-16 19:46:26
Re: Vicidial Slave Database adding Hours
Posted:
Tue Mar 16, 2021 10:22 pmby Nefariousparity
I have built another slave, it would seem messing with the shift is changing the login time. However it is still more.
Re: Vicidial Slave Database adding Hours
Posted:
Mon Apr 26, 2021 1:51 amby Nefariousparity
I would like to add also, in the end. Once we moved from virtualized slave, to hardware everything ran as normal. Tried in container, tried as a VM.