Overview: Vicidial mysql repair command
In this blog post i have give the commands to repair the corrupted database in vicidial based servers like vicibox goautodial scratch vicidial installation
VICIdial is
an enterprise class, open source, contact center suite in use by many
large call centers around the world. VICIdial has a full featured
predictive dialer. It is capable of inbound, outbound, and blended
phone call handling.
Vicidial software uses below software's for its operation.
mysql/mariadb - database
Apache - webserver
Asterisk - Telephony
Root cause for Vicidial Database Corrupt
Often Vicidial Database will be crashed due to many reasons which i have listed below.
1. Server Over Load
2. Server Improper Shutdown
3. Server Low Disk Space
Impact of Database corrupt in vicidial
Impact in Vicidial while db/mysql corrupted
1. your session has been disabled2. Autodial calls not landing to Agents.
3. realtime report not updating properly
4. agent error
5. Time sync error
Vicidial database repair command
For Latest Vicibox run the below commandsmysqlcheck -p --check asterisk
mysqlcheck -p --auto-repair asterisk
mysqlcheck -p --optimize asterisk
If the above command failed to Repair a particular table, identify the corrupted table and run the below command.
mysql -pmysql>use asterisk
mysql>REPAIR table table_name USE_FRM;
eg: REPAIR table vicidial_live_agents USE_FRM;
Note: by default mysql root password is not set in vicibox, that is just press enter after mysql -p, if not working use mysql -ucront -p with password 1234
For Goautodial/ Vicidial scratch installs run below command
mysqlcheck -u root -p --auto-repair --check --optimize --all-databasesnote: if you
using goautodial then the password will be goautodial, if not working
then use below command, which uses default vicidial mysql credentials
password will be : 1234
note: the default password of vicidial mysql logins.
you might receive below error while running above command
Error:: mysqlcheck doesnt't support multiple contradicting commands.
Run the below commands
mysqlcheck -u root -p --optimize --all-databases
Sample mysql check command output
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt
asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt
Conclusion:
Comments
Post a Comment