vicidial.org

It seems that time sync is not updating to the database correctly, seems like its only updating once a minute which is causing the client workstations to give a time-sync error. Nothing has changed, removed or added, the mysql/php time are fine. The IP has not changed... thanks in advance for your suggestions

ok in an effort to repair this problem, i went through the script that run or update server information, i ran the AST_update.pl from the CLI and got the following error in the output;

Code: Select all

DBD::mysql::db do failed: Table './asterisk/server_performance' is marked as crashed and last (automatic?) repair failed at AST_update.pl line 655.
Couldn't execute query: |INSERT INTO server_performance (start_time,server_ip,sysload,freeram,usedram,processes,channels_total,trunks_total,clients_total,clients_zap,clients_iax,clients_local,clients_sip,live_recordings,cpu_user_percent,cpu_system_percent,cpu_idle_percent) values('2014-06-29 16:01:08','192.168.40.26','002','15078','999','583','1','0','0','0','0','0','0','0','0','0','99')|


so i went to PhpMyAdmin and found that i got the same error when trying to select the 'server_performance' table; Table './asterisk/server_performance' is marked as crashed and last (automatic?)
its seems that the count of rows was wrong from what the data base thought it should be, thus causing it to crash.

so i ran

Code: Select all

CHECK TABLE server_performance

,

Code: Select all

REPAIR TABLE server_performance

and viola it was updating correclty and agents were able to log in and make calls

in closing the update script was failing at the update of the server_performance and not continuing on to the next point that updates the times in the 'server' table.