Time sync problem

[ClearCall]

I installed VICIbox Server from ISO downloaded from http://download.vicidial.com/iso/vicibo ... -7.0.4.iso
This is a test box I am setting up and is a single server unit.
VERSION: 2.14-620a
BUILD: 170623-2142
Asterisk 11.25.1-vici

When I log into the agent interface (agc/vicidial.php) I get "There is a time synchronization problem with your system, please tell your system administrator"
On the admin reports page (vicidial/admin.php?ADD=999999), the time in the upper right corner is correct and matches the PHP time and DB time in the server table at the bottom of the page. The first row of this table (which is retrieved from server_updater) does not update. The time displayed is the time the server was booted up.

Example from 16:29
SERVER - DESCRIPTION IP ACT LOAD CHAN AGNT DISK TIME VER
dialerxx Server dialerxx xx.xx.xx.xx Y / Y / Y 77 - 6% 0 0 3% 2017-07-01 16:20:04 2784
PHP Time 2017-07-01 16:29:54
DB Time 2017-07-01 16:29:54


Example from 16:36
SERVER - DESCRIPTION IP ACT LOAD CHAN AGNT DISK TIME VER
dialerxx Server dialerxx xx.xx.xx.xx Y / Y / Y 77 - 6% 0 0 3% 2017-07-01 16:20:04 2784
PHP Time 2017-07-01 16:36:07
DB Time 2017-07-01 16:36:07

If I delete the row in the server_updater table, the row gets re-created with the correct timestamp, but does not update again until I reboot the server. What process is supposed to update this table and keep it in sync?

[mflorell]

The AST_update.pl script. Try running it manually with the --debug flag.

[ClearCall]

The server_updater time does not update after running.

Output from command /usr/share/astguiclient/AST_update.pl --debugX ..

SHOW CHANNELS format: 4

|1|SELECT count(*) FROM server_updater where server_ip='xx.xx.xx.xx';|
LOOKING FOR Zap/DAHDI clients assigned to this server:
|SELECT extension FROM phones where protocol='Zap' and server_ip='xx.xx.xx.xx'|
LOOKING FOR IAX2 clients assigned to this server:
|SELECT extension FROM phones where protocol='IAX2' and server_ip='xx.xx.xx.xx'|
LOOKING FOR SIP clients assigned to this server:
|SELECT extension FROM phones where protocol='SIP' and server_ip='xx.xx.xx.xx'|
gs102
8001
8002
Zap Clients: |
IAX2 Clients: |
SIP Clients: |gs102|gs102@gs102|8001|8001@8001|8002|8002@8002|

----- SUPER-DUPER DEBUGGING -----
BUILD: 170406-1528
2017-07-03 12:12:38|PROGRAM STARTED|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2017-07-03 12:12:38|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
problem connecting to "localhost", port 5038: connect timed-out at /usr/share/astguiclient/AST_update.pl line 463

2017-07-03 12:12:38|STARTING NEW MANAGER TELNET CONNECTION||ATTEMPT|ONE DAY INTERVAL:12||


Netstat shows:
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:5038 0.0.0.0:* LISTEN 14990/asterisk
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1252/sshd
tcp 0 0 0.0.0.0:8888 0.0.0.0:* LISTEN 1423/perl
tcp 0 0 0.0.0.0:40569 0.0.0.0:* LISTEN 1573/ip_relay
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1470/master
tcp 0 0 0.0.0.0:4577 0.0.0.0:* LISTEN 1569/perl
tcp 0 0 0.0.0.0:41569 0.0.0.0:* LISTEN 1574/ip_relay
tcp 0 0 0.0.0.0:42569 0.0.0.0:* LISTEN 1575/ip_relay
tcp 0 820 xx.xx.xx.xx:22 xx.xx.xx.xx:18605 ESTABLISHED 25505/1
tcp 0 1 127.0.0.1:3452 127.0.0.1:5038 SYN_SENT 25570/perl
tcp 0 1 127.0.0.1:3456 127.0.0.1:5038 SYN_SENT 25587/perl
tcp 0 1 127.0.0.1:3454 127.0.0.1:5038 SYN_SENT 25574/perl
tcp 0 1 127.0.0.1:3458 127.0.0.1:5038 SYN_SENT 25593/perl
tcp 0 0 :::80 :::* LISTEN 1312/httpd-prefork
tcp 0 0 :::22 :::* LISTEN 1252/sshd
tcp 0 0 ::1:25 :::* LISTEN 1470/master
tcp 0 0 :::443 :::* LISTEN 1312/httpd-prefork
tcp 0 0 :::3306 :::* LISTEN 1274/mysqld
udp 0 0 0.0.0.0:42569 0.0.0.0:* 1575/ip_relay
udp 0 0 0.0.0.0:41569 0.0.0.0:* 1574/ip_relay
udp 0 0 0.0.0.0:40569 0.0.0.0:* 1573/ip_relay
udp 0 0 0.0.0.0:8888 0.0.0.0:* 1423/perl
udp 0 0 0.0.0.0:5060 0.0.0.0:* 14990/asterisk
udp 0 0 xx.xx.xx.xx:123 0.0.0.0:* 1309/ntpd
udp 0 0 127.0.0.1:123 0.0.0.0:* 1309/ntpd
udp 0 0 0.0.0.0:123 0.0.0.0:* 1309/ntpd
udp 0 0 0.0.0.0:4569 0.0.0.0:* 14990/asterisk
udp 0 0 ff70::a3b4:ccff:fee:123 :::* 1309/ntpd
udp 0 0 ::1:123 :::* 1309/ntpd
udp 0 0 :::123 :::* 1309/ntpd

[mflorell]

Either Asterisk isn't running, or the manager.conf/astguiclient.conf aren't configured properly.

[ClearCall]

Asterisk is running:
dialer:~ # asterisk -rvvv
[Jul 4 11:01:07] Asterisk 11.25.1-vici, Copyright (C) 1999 - 2013 Digium, Inc. and others.
[Jul 4 11:01:07] Created by Mark Spencer <markster@digium.com>
[Jul 4 11:01:07] Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
[Jul 4 11:01:07] This is free software, with components licensed under the GNU General Public
[Jul 4 11:01:07] License version 2 and other licenses; you are welcome to redistribute it under
[Jul 4 11:01:07] certain conditions. Type 'core show license' for details.
[Jul 4 11:01:07] =========================================================================
[Jul 4 11:01:07] Connected to Asterisk 11.25.1-vici currently running on dialer (pid = 14990)

I did not make any changes to manager.conf, astguiclient.conf (or really anything else as this is a new install).

The perl script seems to be getting stuck at creating a telnet connection. I created a rule in the linux firewall for port 5038 and the script now runs.

[mflorell]

What is the Asterisk version as shown in the Modify Server page for that dialer?

[ClearCall]

Asterisk Version: 11.25.1-vici

FYI: This system has only one NIC.

[mflorell]

Check that the manager.conf configuration for manager API users matches the settings in the Server entry in Vicidial.