vicidial.org

Dear Sir
would you please help me time synchronization problem.
Astericks and Database server time is same ,also agent pc time also same (GMT-5) like as server .
also updated ADMIN_update_server_ip.p and Astericks server :etc/astguiclient.conf updated .But finding problem frequently . would you Please advise ......

ccdial1:~ # date
Sat Jun 1 04:36:34 EDT 2013
--
ccweb1:~ # date
Sat Jun 1 04:36:34 EDT 2013
ccdial1:~ # date -u (HW)
Sat Jun 1 08:37:28 UTC 2013

ccweb1:~ # date -u (HW)
Sat Jun 1 08:38:00 UTC 2013


Asterisk 1.4.44-vici

ISO ::ViciBox.x86_64-4.0.3.iso
ViciBox Server v.4.0!
SVN Version: 1953
DB Schema Version: 1341
Kernel:
Linux ccdial1 3.1.10-1.19-default #1 SMP Mon Feb 25 10:32:50 UTC 2013 (f0b13a3) x86_64 x86_64 x86_64 GNU/Linux
VERSION: 2.6-396a
BUILD: 130402-2322

Server :Cluster:: No senguma , No other SW install .
-----------------------------------------------------------------
Data base Server Log :
ccweb1:~ # tail -f /var/log/messages
Jun 1 04:43:01 ccweb1 /USR/SBIN/CRON[2197]: (root) CMD (/usr/share/astguiclient/AST_inbound_email_parser.pl)
Jun 1 04:44:01 ccweb1 /USR/SBIN/CRON[2212]: (root) CMD (/usr/share/astguiclient/AST_VDhopper.pl -q)
Jun 1 04:44:01 ccweb1 /USR/SBIN/CRON[2211]: (root) CMD (/usr/share/astguiclient/AST_inbound_email_parser.pl)
Jun 1 04:44:01 ccweb1 /USR/SBIN/CRON[2213]: (root) CMD (/usr/share/astguiclient/ADMIN_keepalive_ALL.pl)
Jun 1 04:45:01 ccweb1 /USR/SBIN/CRON[2228]: (root) CMD (/usr/share/astguiclient/ADMIN_keepalive_ALL.pl)
Jun 1 04:45:01 ccweb1 /USR/SBIN/CRON[2230]: (root) CMD (/usr/share/astguiclient/AST_VDhopper.pl -q)
Jun 1 04:45:01 ccweb1 /USR/SBIN/CRON[2231]: (root) CMD (/usr/share/astguiclient/AST_inbound_email_parser.pl)
Jun 1 04:45:31 ccweb1 sshd[2261]: reverse mapping checking getaddrinfo for 210-4-65-85-dsl.bdcom.com [210.4.65.85] failed - POSSIBLE BREAK-IN ATTEMPT!
Jun 1 04:45:40 ccweb1 sshd[2261]: Accepted keyboard-interactive/pam for root from 210.4.65.85 port 56866 ssh2
Jun 1 04:45:40 ccweb1 systemd-logind[923]: New session 40 of user root.
Jun 1 04:46:01 ccweb1 /USR/SBIN/CRON[2304]: (root) CMD (/usr/share/astguiclient/AST_VDhopper.pl -q)
Jun 1 04:46:01 ccweb1 /USR/SBIN/CRON[2305]: (root) CMD (/usr/share/astguiclient/AST_inbound_email_parser.pl)
Jun 1 04:46:01 ccweb1 /USR/SBIN/CRON[2306]: (root) CMD (/usr/share/astguiclient/ADMIN_keepalive_ALL.pl)

You should compare your system time, database time and web time.
I wrote a one-line command to check those times (just replace USER and PASSWORD and 'Europe/Stockholm':

Code: Select all

echo "SELECT server_ip, UNIX_TIMESTAMP(last_update),UNIX_TIMESTAMP(db_time) from server_updater" | mysql -uUSER -pPASSWORD -D asterisk && \
php -r "date_default_timezone_set('Europe/Stockholm'); echo 'php time: '.date('U');" && \
echo ""

When does the time issues occurs? at any special time of the day? or when you executes some script or when you reboot some server or similar?

also, posting your ip-address is bad karma

Thanks DomDon ... Server time issue solved .
Just Reply me please below issue Admin--> Audio Store

: "ERROR: server(192.168.1.70) does not match sounds web server ip(192.168.1.212)"

Previous IP was 212 , Now I am using 70 : I had followed your previous advise . Like run ADMIN_update_server_ip.pl and
edit /etc/astguiclient.conf in the asterisk server to point at the database:
VARDB_server => 192.168.1.70
how can I solve it ? Please advise

would you please check time related Query . I m not clear below time details . is it showing correct time ?

+---------------+-----------------------------+-------------------------+
| server_ip | UNIX_TIMESTAMP(last_update) | UNIX_TIMESTAMP(db_time) |
+---------------+-----------------------------+-------------------------+
| 1X.X.X.X | 1370706655 | 1370706655 |
+---------------+-----------------------------+-------------------------+

php time: 1370706671

There is 16 seconds difference from the database and php-time
if you run it again and the database time is the same then the update script (AST_update.pl) might be where the issue is,
run that script with debug flag and check what happens and how long it takes to execute

16 sec delay .. actually I run 2 command with in 16 sec . Anyway thanks for your help . Problem solved .

Just Reply me please below issue Admin--> Audio Store

: "ERROR: server(192.168.1.70) does not match sounds web server ip(192.168.1.212)"

Previous IP was 212 , Now I am using 70 : I had followed your previous advise . Like run ADMIN_update_server_ip.pl and
edit /etc/astguiclient.conf in the asterisk server to point at the database:
VARDB_server => 192.168.1.70
how can I solve it ? Please advise

check all system settings, and if that wont help then create a new thread for this problem, if you havnt done that already.