Asterisk not updating time in DB (timesync. error)

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Asterisk not updating time in DB (timesync. error)

Postby c20xh2 » Sat Dec 01, 2018 3:46 pm

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,
Last edited by c20xh2 on Sun Dec 02, 2018 1:06 pm, edited 1 time in total.
c20xh2
 
Posts: 95
Joined: Mon Feb 20, 2017 2:28 am

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

Postby c20xh2 » Sun Dec 02, 2018 12:29 pm

Quick update

I just reinstalled everything on a physical cluster (No VM) and still have the same issue.
c20xh2
 
Posts: 95
Joined: Mon Feb 20, 2017 2:28 am

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

Postby c20xh2 » Sun Dec 02, 2018 2:36 pm

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
c20xh2
 
Posts: 95
Joined: Mon Feb 20, 2017 2:28 am

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

Postby c20xh2 » Sun Dec 02, 2018 5:10 pm

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 :)
c20xh2
 
Posts: 95
Joined: Mon Feb 20, 2017 2:28 am

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

Postby jholdsworth » Wed Oct 02, 2019 12:52 pm

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
jholdsworth
 
Posts: 1
Joined: Thu Sep 12, 2019 4:27 am


Return to Support

Who is online

Users browsing this forum: No registered users and 89 guests