Page 1 of 1

Asterisk not updating time in DB (timesync. error)

PostPosted: Sat Dec 01, 2018 3:46 pm
by c20xh2
VERSION: 2.14-692a
BUILD: 180927-0018
ISO : ViciBox_v8_1.x86_64-8.1.2


I just did a fresh install (cluster in VMWARE). I allready have a working cluster on the same host.

I get the "TimeSynchronisation error" once I log in a campaign as an agent. Before login I can see the time are correct in the report page. But as soon as I log in, it looks like asterisk stop sending his time to the database.

Ex:

Code: Select all
SERVER -   DESCRIPTION   IP   ACT   LOAD   CHAN   AGNT   DISK   TIME   VER
viciasteri   Test install of Asterisk server   192.168.2.202   Y / Y / Y   0 - 100%   0   1   1%   2018-12-01 15:37:03   3047
vicidbmast   DataBase Only - DO NOT DELETE   192.168.2.200   Y / N / N   0 - 100%   0   0   1%       3047
    PHP Time       2018-12-01 15:41:58   
    DB Time       2018-12-01 15:41:57   


If I check the system time on the machine directly, time is correct. I made sure everyone is pointing at the same ntp server.

What I find really odd is that everything works fine until I try to login as an agent. Nothing special in the logs and I'm able to do an outbound call if I connect my softphone directly to the asterisk.

Also , if I reboot the asterisk the time stay the same as before on the report page but if I do a reboot of the database everything get corrected. (Until I try to login in a campaing)

Any tip for me on this one ?

Thank you,

Re: Asterisk not updating time in DB (timesync. error)

PostPosted: Sun Dec 02, 2018 12:29 pm
by c20xh2
Quick update

I just reinstalled everything on a physical cluster (No VM) and still have the same issue.

Re: Asterisk not updating time in DB (timesync. error)

PostPosted: Sun Dec 02, 2018 2:36 pm
by c20xh2
From what I understand the script AST_upgrade.pl is the one updating the server time in the db.

If I try to run it manually I get :
Code: Select all
problem connecting to "localhost", port 5038: Connection refused at AST_update.pl line 469


Could this be the issue ?

When I look at the server_updater table I can see that the last_update is wrong

Re: Asterisk not updating time in DB (timesync. error)

PostPosted: Sun Dec 02, 2018 5:10 pm
by c20xh2
I installed the previous version (ViciBox_v8.x86_64-8.0.1.iso) and everything works as intended with the exact same steps. I will stick with this one for now.

Thank you :)

Re: Asterisk not updating time in DB (timesync. error)

PostPosted: Wed Oct 02, 2019 12:52 pm
by jholdsworth
williamconley wrote:check your asterisk version in admin->servers against the actual asterisk version installed (asterisk -V). Fix it if it is wrong.


This helped me resolve my asterisk time sync issue. :D