VICIDIAL is a software suite that is designed to interact with the Asterisk Open-Source PBX Phone system to act as a complete inbound/outbound contact center suite with inbound email support as well. If your vicidial server is not responding you can repair vicidial mysql to sort out some problems . Vicidial mysql can get crashed or corrupted due to heavy load, abnormal shutdown .
- Agent session disabled
- Autodial calls not landing to agents
- Realtime reports are not getting updated
- Lead uploading failed
- server stopped responding
you can easily fix or repair Mysql by using these commands .
Step 1: Delete Recording files
Login to server via SSH using PUTTY and check free available space on hard disk .
[[email protected] ~]# df -h
Filesystem Size Used Avail Use% Mounted on /dev/sda3 221G 5.4G 204G 3% / tmpfs 16G 0 16G 0% /dev/shm /dev/sda1 976M 106M 820M 12% /boot
If it shows 100% or close to more than 80% in use% section then hard disk is full and you need to delete the recordings and logs files of your server.
Now go to directory where you keep all your recording files. Usually it is located at
You need to delete all recorded files under ORIG directory, if you prefer to keep recording its advisable to copy all your recording files to local computer or any other places apart from this server.
[[email protected] ORIG]# rm -rf *
Above command will delete all the files under ORIG directory.
If above command displays cannot delete file too long , then download the WINSCP software and login to the server and go to /var/spool/asterisk/monitorDONE/ORIG select all files and delete it. Deleting files through WINSCP can take longer time .
you can use another alternative method to delete long file name.
Run this command
[[email protected] ORIG]# find . -type f -name "*.wav" | xargs -l500 rm -f
This will delete every 1500 files one by one and empty the folder.
Go to /var/spool/asterisk/monitorDONE/MP3
[[email protected] ORIG]# cd /var/spool/asterisk/monitorDONE/MP3 [[email protected] MP3]# rm -rf *
If u record in gsm then go to GSM, /var/spool/asterisk/monitorDONE/GSM directory and follow above steps to delete files .
Step 2: Delete LOG msg
you also need to delete log files which can also consume some hard disk space.
Login through Winscp and go to directory
/var/log/ and delete
message.1,2,4 secure.1,2,3... ,boot.1,2,3.....
Delete asterisk and httpd log msg as well using below commands or using winscp .
[[email protected] MP3]# cd /var/log/asterisk [[email protected] asterisk]# rm -rf messages.* [[email protected] asterisk]# cd /var/log/httpd/ [[email protected] httpd]# rm -rf error.* [[email protected] httpd]# rm -rf acces.*
Step 3: Repair Mysql
Start mysql and repair it using command
[[email protected] ~]# /etc/init.d/mysqld start [[email protected] ~]# mysqlcheck -u cron -p --auto-repair --check --optimize --all-databases
Default password for cron user is 1234 if you haven’t changed it.
Once finishes the repair of the MYSQL, reboot the server and check whether you are getting error or not.
It is advisable to optimize your mysql databases on regular basis to avoid any down time and too keep running your server at its optimal performance.
By following above command you should be able to repair vicidial Mysql . Let me know in comments if you still face any issue to repair vicidial mysql .