Time synchronization problem on VICIBOX 12.0.1

All installation and configuration problems and questions

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

Time synchronization problem on VICIBOX 12.0.1

Postby Thiago » Tue Jan 21, 2025 12:12 pm

Hello everyone and happy new year, a little late! :lol:
excuse my english, i'm french
I was very pleased and enthusiastic to see the vicibox 12.0.1 ISO, which I quickly installed because my vicibox 9 was already having strange problems and I couldn't find the solutions.
I successfully installed vicibox 12 (GREAT JOB, THANKS) and installed the wephone, and all went well... EXCEPT THAT There is a time synchronization problem with your system, please tell your system administrator
I've already done everything, checked all the forums, asked CHATGPT but obviously the problem isn't with the date as everything is synchronised.
Code: Select all
SERVER -   DESCRIPTION   IP   ACT   LOAD   CHAN   AGNT   DISK   TIME   VER
apisnixCRM   SERVEUR APISNIX CRM 1   151.X.X.X   Y / Y / Y   9 - 3%   0   1   11%   2025-01-21 17:32:52   3896
    PHP Time       2025-01-21 17:32:55   
    DB Time       2025-01-21 17:32:55   

it's chrony that synchronises the server, there's sometimes a delay of max 3 seconds which is always caught up, I'll send you the results of the verification commands read in the other posts.
I followed the instructions in this link https://itgala.xyz/vicidial-there-is-a- ... nistrator/, which corresponded to the williamconley answer for solving a previous similar problem, the only error I had was on screen -r ASTupdate
Code: Select all
 screen -ls
There are screens on:
        1305.asterisk   (Detached)
        1277.astshell20250121104705     (Detached)
        31520.ASTVDremote       (Detached)
        31517.ASTVDauto (Detached)
        31514.ASTlisten (Detached)
        31511.ASTsend   (Detached)
        31508.ASTupdate (Detached)
        13308.ASTemail  (Detached)
        13305.ASTVDadFILL       (Detached)
        13302.ASTVDadapt        (Detached)
        2807.ASTfastlog (Detached)
11 Sockets in /run/screens/S-root.
 #chronyc tracking
Reference ID    : 55C7D662 (ntp1.leontp.com)
Stratum         : 2
Ref time (UTC)  : Tue Jan 21 16:37:57 2025
System time     : 0.000104765 seconds fast of NTP time
Last offset     : +0.000026742 seconds
RMS offset      : 0.000087597 seconds
Frequency       : 47.377 ppm slow
Residual freq   : -0.000 ppm
Skew            : 0.009 ppm
Root delay      : 0.004926677 seconds
Root dispersion : 0.000332277 seconds
Update interval : 1031.2 seconds
Leap status     : Normal
 #timedatectl
               Local time: Tue 2025-01-21 17:45:39 WAT
           Universal time: Tue 2025-01-21 16:45:39 UTC
                 RTC time: Tue 2025-01-21 16:45:39
                Time zone: Africa/Lagos (WAT, +0100)
System clock synchronized: yes
              NTP service: active
          RTC in local TZ: no
 #screen -r ASTupdate
ERROR: 2025-01-21 17:45:29|8096|command timed-out|
ERROR: 2025-01-21 17:45:32|8097|command timed-out|
ERROR: 2025-01-21 17:45:35|8098|command timed-out|
ERROR: 2025-01-21 17:45:38|8099|command timed-out|
ERROR: 2025-01-21 17:45:42|8100|command timed-out|
#dahdi_cfg -v
DAHDI Tools Version - 3.1.0

DAHDI Version: /home/abuild/rpmbuild/BUILD/obj/default
Echo Canceller(s):
Configuration
======================

0 channels to configure.
 # dahdi_test
Opened pseudo dahdi interface, measuring accuracy...
99.998% 99.994% 99.999% 99.997% 99.995% 99.999% 99.998% 99.998%
99.996% 99.999% 99.997% 100.000% 99.998% 99.996% 99.999% 99.995% ^C
--- Results after 16 passes ---
Best: 100.000% -- Worst: 99.994% -- Average: 99.997320%
Cumulative Accuracy (not per pass): 99.997
 # service dahdi status
dahdi is neither service nor target!?


I modified these 3 files to ensure that the timezones corresponded
# nano /etc/php8/cli/php.ini
# nano /etc/my.cnf
# nano /etc/php8/cli/php.ini
Now, agents currently call via a softphone but it's not comfortable, it goes through without a problem

and 2 other little problems: when you connect to the web agent, the voice says ‘The number you are dialling is not in service’, and when you click on CALL AGENT AGAIN, the softphone says INCALL, I don't know if this is linked to TIME SYNCHRONISATION.
and last minor problem, there are more colors for WARNING, ERROR, dialplan... all is black and white in the asterisk CLI, not colours red, yellow, purple which is very important to read and detect the problems easily. this problem occurred after the restart of the vicidial service, before it is enough to restart the vicidial service 1 or 2 times after you restart the asterisk service and the colour returned, I tried that today without success, i add color = yes in nano /etc/asterisk/asterisk.conf, nothing

Thanks in advance
My installation: ViciBox v.12.0.2 || openSUSE Leap 15.6 || Asterisk 18.26.1-vici ||
VERSION: 2.14-934a || BUILD: 250103-0843 || SVN Version: 3899 || DB Schema Version: 1723
Thiago
 
Posts: 18
Joined: Fri Jun 28, 2024 5:18 am

Re: Time synchronization problem on VICIBOX 12.0.1

Postby mflorell » Tue Jan 21, 2025 5:33 pm

There's been a default change in the more recent MySQL/MariaDB codebase for TIMESTAMP database fields that causes this. It has been fixed in the VICIdial codebase, and we will be releasing a VICIbox 12.0.2 version very soon that also has a fix included.
mflorell
Site Admin
 
Posts: 18398
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Time synchronization problem on VICIBOX 12.0.1

Postby carpenox » Tue Jan 21, 2025 6:41 pm

this may help some people on 11.0.1 and 11.0.2 and 12


https://dialer.one/index.php/how-to-fix ... 12-errors/
Alma Linux 9.5 | SVN Version: 3906 | DB Schema Version: 1724 | Asterisk 18.26.0 | PHP8
https://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: 2519
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Time synchronization problem on VICIBOX 12.0.1

Postby Thiago » Wed Jan 22, 2025 3:44 am

carpenox wrote:this may help some people on 11.0.1 and 11.0.2 and 12

https://dialer.one/index.php/how-to-fix ... 12-errors/

Thanks for your feedback, I applied the MariaDB patch and restarted, but it didn't work.
Then I read on https://docs.vicibox.com/en/latest/bugf ... 201-2.html that it must be because I setup a new ViciBox v.12.0 database using vicibox-installer and zypper up
so I applied the 2nd patch which is Optional export and import to fix fields
But bad luck, always the same error There is a time synchronization problem with your system, please tell your system administrator I think I'm cursed
This evening, I'm going to drop the database altogether and re-run the installer vicibox-installer, in the hope that it will fix the problem.
please how do i good drop the database? is there a way to install vicibox 12.0.2 without reinstalling the OS?
My installation: ViciBox v.12.0.2 || openSUSE Leap 15.6 || Asterisk 18.26.1-vici ||
VERSION: 2.14-934a || BUILD: 250103-0843 || SVN Version: 3899 || DB Schema Version: 1723
Thiago
 
Posts: 18
Joined: Fri Jun 28, 2024 5:18 am

Re: Time synchronization problem on VICIBOX 12.0.1

Postby carpenox » Wed Jan 22, 2025 5:49 am

did you also upgrade your SVN to 3898?
Alma Linux 9.5 | SVN Version: 3906 | DB Schema Version: 1724 | Asterisk 18.26.0 | PHP8
https://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: 2519
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Time synchronization problem on VICIBOX 12.0.1

Postby williamconley » Wed Jan 22, 2025 1:51 pm

Thiago wrote:But bad luck, always the same error There is a time synchronization problem with your system, please tell your system administrator I think I'm cursed
This evening, I'm going to drop the database altogether and re-run the installer vicibox-installer, in the hope that it will fix the problem.
please how do i good drop the database? is there a way to install vicibox 12.0.2 without reinstalling the OS?


Note that this error is not technically related to time. It only means that the dialer is not updating a specific field in your database record, or (as likely in this case) that field is not set to update the date when the record is changed. Start by verifying that the table is configured to auto-update the timestamp field if any changes are made to the record. This may be necessary on other timestamp records as well. There are patches published that likely have this change in them, did you apply those and were there any errors?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20331
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Time synchronization problem on VICIBOX 12.0.1

Postby Thiago » Wed Jan 22, 2025 6:28 pm

carpenox wrote:did you also upgrade your SVN to 3898?

great !!! after updating svn, the problem has been solved

I have partially solved the softphone problem, now the voice speaks to say that I am in the conference (conf-onlyperson.gsm), but the webphone is not incall, it just screen the Campaign CallerID like this 15142634569 - ACagcW17375872571998199819981998 after the page of No one is in your session: 8600051, when I click on CALL AGENT AGAIN.

ASTERISK CLI GIVES
Code: Select all
[Jan 22 23:15:36] -- SIP/1998-0000000b is ringing
[Jan 22 23:15:36] -- Got SIP response 486 ‘Busy Here’ back from 154.X.X.X:21176
[Jan 22 23:15:36] -- SIP/1998-0000000b is busy


asterisk cli of log agent
Code: Select all
== WebSocket connection from '154.X.X.X:20965' for protocol 'sip' accepted using version '13'
[Jan 23 00:23:01]     -- Registered SIP '1998' at 154.X.X.X:20965
[Jan 23 00:23:01]   == Manager 'updatecron' logged off from 127.0.0.1
[Jan 23 00:23:01]   == Manager 'updatecron' logged on from 127.0.0.1
[Jan 23 00:23:01]   == Manager 'sendcron' logged on from 127.0.0.1
[Jan 23 00:23:01]   == Manager 'sendcron' logged on from 127.0.0.1
[Jan 23 00:23:01]   == Manager 'sendcron' logged off from 127.0.0.1
[Jan 23 00:23:03]   == Manager 'sendcron' logged on from 127.0.0.1
[Jan 23 00:23:03]   == Using SIP RTP CoS mark 5
[Jan 23 00:23:03]     -- Called 1998
[Jan 23 00:23:04]     -- SIP/1998-00000007 is ringing
[Jan 23 00:23:04]        > 0x7feb84007360 -- Strict RTP learning after remote address set to: 154.X.X.X:21003
[Jan 23 00:23:04]        > 0x7feb84007360 -- Strict RTP learning after remote address set to: 154.X.X.X:21003
[Jan 23 00:23:04]        > 0x7feb84007360 -- Strict RTP learning after remote address set to: 154.X.X.X:21003
[Jan 23 00:23:04] WARNING[8263]: res_rtp_asterisk.c:3295 __rtp_recvfrom: 1737588183.22: DTLS packet from 154.X.X.X:21003 dropped. ICE not completed yet.
[Jan 23 00:23:04]     -- SIP/1998-00000007 answered
[Jan 23 00:23:04]     -- Executing [8600051@default:1] MeetMe("SIP/1998-00000007", "8600051,F") in new stack
[Jan 23 00:23:04]     -- Created MeetMe conference 1023 for conference '8600051'
[Jan 23 00:23:04]     -- <SIP/1998-00000007> Playing 'conf-onlyperson.gsm' (language 'en')
[Jan 23 00:23:04]        > 0x7feb84007360 -- Strict RTP learning after ICE completion

and please nothing for color asterisk CLI ? :oops:
My installation: ViciBox v.12.0.2 || openSUSE Leap 15.6 || Asterisk 18.26.1-vici ||
VERSION: 2.14-934a || BUILD: 250103-0843 || SVN Version: 3899 || DB Schema Version: 1723
Thiago
 
Posts: 18
Joined: Fri Jun 28, 2024 5:18 am

Re: Time synchronization problem on VICIBOX 12.0.1

Postby carpenox » Thu Jan 23, 2025 9:15 pm

you can set webphone to connect with 1 second thru options.php file, instructions can be found here:

https://dialer.one/index.php/how-to-mod ... ur-dialer/

Hope this helps
Alma Linux 9.5 | SVN Version: 3906 | DB Schema Version: 1724 | Asterisk 18.26.0 | PHP8
https://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: 2519
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Time synchronization problem on VICIBOX 12.0.1

Postby williamconley » Thu Jan 23, 2025 10:22 pm

do you have SSL set up for the web phone? It is required to have valid SSL. If you had to click past any warnings in the web interface to get to the page via ssl, note that WebRTC will not do that. It will simply not work until SSL is valid.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20331
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Time synchronization problem on VICIBOX 12.0.1

Postby carpenox » Fri Jan 24, 2025 8:58 am

asterisk would not play the "only-person" sound if that were the case Bill
Alma Linux 9.5 | SVN Version: 3906 | DB Schema Version: 1724 | Asterisk 18.26.0 | PHP8
https://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: 2519
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Time synchronization problem on VICIBOX 12.0.1

Postby williamconley » Fri Jan 24, 2025 3:28 pm

carpenox wrote:asterisk would not play the "only-person" sound if that were the case Bill

in theory it also wouldn't say "you're the only person in the conference", but here we are. A verification seems in order.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20331
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Time synchronization problem on VICIBOX 12.0.1

Postby Thiago » Sun Jan 26, 2025 8:17 pm

I rebuilt the server because I didn't have a large database, so I took the opportunity to put in the latest update

But I've got an even stranger problem, I'm creating a topic on this one

Thank you for guiding me and for continuing to do so
My installation: ViciBox v.12.0.2 || openSUSE Leap 15.6 || Asterisk 18.26.1-vici ||
VERSION: 2.14-934a || BUILD: 250103-0843 || SVN Version: 3899 || DB Schema Version: 1723
Thiago
 
Posts: 18
Joined: Fri Jun 28, 2024 5:18 am


Return to Support

Who is online

Users browsing this forum: No registered users and 27 guests