Vicidial time sync error

[vishalsngh]

Hi

we had an outage and post rebooting the server, we are getting the below error

nrsvicidb:~ # tail -f /var/log/apache2/error_log
[Thu Apr 28 10:46:11.409894 2016] [php5:error] [pid 17806] [client 10.32.21.15:55310] PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 49, referer: http://192.168.6.234/agc/vicidial.php
[Thu Apr 28 10:46:11.409915 2016] [php5:error] [pid 17806] [client 10.32.21.15:55310] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 52, referer: http://192.168.6.234/agc/vicidial.php


Pls help!

[vishalsngh]

The exact error agents are getting is:
"There is a time synchronization problem with your system, pls tell your system administrator."


Any idea?

[lasthuman]

check your database.

[williamconley]

Get a UPS on that database server.

Here's an example of how to get the name of a crashed table and repair it ... plus an example of how to force check the entire DB and fix it if broken. That takes a lot longer, of course, but works better sometimes.

Code: Select all

mysql asterisk -e "show table status where comment like '%crashed%'" --user=cron -p1234

mysqlcheck --auto-repair  --user=cron -p1234 asterisk vicidial_log_extended

mysqlcheck --all-databases --auto-repair --user=cron -p1234