Vicidial Slave Database adding Hours

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Vicidial Slave Database adding Hours

Postby Nefariousparity » Mon Mar 15, 2021 9:50 pm

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?
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm

Re: Vicidial Slave Database adding Hours

Postby carpenox » Tue Mar 16, 2021 2:19 am

what is the slave db server mysql timezone set to in comparison....
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2418
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Vicidial Slave Database adding Hours

Postby Nefariousparity » Tue Mar 16, 2021 6:55 pm

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
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm

Re: Vicidial Slave Database adding Hours

Postby Nefariousparity » Tue Mar 16, 2021 10:22 pm

I have built another slave, it would seem messing with the shift is changing the login time. However it is still more.
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm

Re: Vicidial Slave Database adding Hours

Postby Nefariousparity » Mon Apr 26, 2021 1:51 am

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.
|| DB Schema Version: 1609 || Asterisk 11.25.1-vici || BUILD: 190902-0839 ||VERSION: 2.14-718a||SVN: 3133||10xTelephony||1x Database||1x Slave||1x Web||1x Archive||ViciBox v.8.0.1
Nefariousparity
 
Posts: 327
Joined: Wed Sep 12, 2012 7:01 pm


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 26 guests