vicidial MySQL connect ERROR: Can't connect to local MySQL

vicidial mysql connect error

Topic:vicidial MySQL connect ERROR: Can't connect to local MySQL

Overview: Vicidial Mysql error

    while logging into the vicidial admin or agent portal you might see the below error

vicidial MySQL connect ERROR: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

What is vicidial

Vicidial is the most popular Open-Source Contact Center Solution in the world, that incorporates a predictive dialer to enable the blended handling of inbound / outbound calls alongside inbound emails and customer website chat.

Major Components of Vicidial
1. Asterisk - Telephony server
2.Mariadb - Database
3.Apache - Webserver

Root Cause:

Below are the list of Root causes for the above said error

Mysql crashed or mysql stopped 

Either the vicidial server shutdown all of sudden due to powercut or imporper shutdown (pressing the powerbutton directly) 

Overload of server leads to mysql crash 

Shortage of Harddisk space

***************************

Hardisk space issue

***************************

Type  the below command in linux shell to check whether the harddisk is full

df -h

if it displays below output , you need to delete some unwanted files

/dev/mapper/VolGroup00-LogVol00 446G 54G 0 100% /

****************************

Deleting the call Recordings

****************************

In Vicidial ,the Recordings and Logs will occupy the Harddisk fast.

Delete the files  under  /var/spool/asterisk/monitorDONE/ORIG    at weekly schedule

follow the below command to delete the file from ORIG folder

cd /var/spool/asterisk/monitorDONE/ORIG

rm -rf  *

If the above command throughs error like below

Cannot delete, file too long

then run the below command

find . -type f -name "*.wav" | xargs -l500 rm -f

You also need to delete the Voice files from var/spool/asterisk/monitor/MP3 or GSM

cd /var/spool/asterisk/monitor/MP3

rm -rf *

****************************

Deleting the Logs

****************************

cd /var/log/asterisk

rm -rf  messages.*

cd /var/log/httpd/

rm -rf error.*

rm -rf acces.*

****************************

Repairing the Mysql

****************************

Once the unwanted files deleted run the mysql repair command

mysqlcheck -u cron -p --auto-repair --check --optimize --all-databases

password;1234

****************************

Troubleshoot for the powercut , overload 

****************************

Just run the mysql repair command for the above issues.

mysqlcheck -u cron -p --auto-repair --check --optimize --all-databases

password: 1234

Once finished the troubleshooting , reboot the server once, and then login as agent .

****************************
Also see:
Solving Vicidial Time sync error clickHere
Solving vicidial no one in your session Clickhere
Solving zero leads in hopper issue ClickHere