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: 311
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....
Leap 15.2 | Version: 2.14-814a | BUILD: 210608-2108 | SVN Version: 3452 | DB Schema Version: 1635 | Asterisk 16.17.0-vici
www.CyburityLLC.com -:- 844-PC-SATA-2 -:- My Blog: the.cyburhacker.com -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1347
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, 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: 311
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: 311
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: 311
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 15 guests