Topic:Troubleshooting vicidial MySQL connect ERROR
In this article you are going to learn how to troubleshoot the vicidial mysql connect error which displays while logging to admin or agent portal.
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.
Root Causes of vicidial mysql connect error
vicidial Mysql crash repair
Often you will face MySQL crash in vicidial due to various reasons like server over load, improper shutdown of servers, Insufficient disk space , bulk upload or download of data from vicidial, Too many connections like dos attack .
Here is the article for MySQL repair and tutorial on avoiding the MySQL crash in vicidial
Vicidial Disk Space full
If the Disk space is full that is 100% occupied ,then the MySQL leads to crash due to insufficient space with too many MySQL connections. In vicidial the huge disk space will be consumed by
RecordingsMySQL databaseLog files.
For Deleting the Old Recordings ,follow my article deleting vicidial recordings older than X no of days
If you are using and running vicidial with huge data like multiple list with huge leads, Call logs more than a year or more , then this will leads to slowdown of MySQL performance and leads to crash.
Its always best practice to delete old call logs, lead data's in vicidial ,here is my article to delete old call log data's in vicidial database
cd /var/log/asteriskrm -rf messages.*
cd /var/log/httpd/rm -rf error.*rm -rf acces.*
Vicidial MySQL New IP update
If you have changed your vicidial server IP or changed the MySQL server IP in cluster setup, make sure to update the new IP in the vicidial database and the astguiclient.conf file in each vicidial server.
Run the below command to update the New IP in the vicidial servers
vi /etc/astguiclient.conf# Database connection informationVARDB_server => 192.168.1.123VARDB_database => asteriskVARDB_user => cronVARDB_pass => 1234VARDB_custom_user => customVARDB_custom_pass => custom1234VARDB_port => 3306
For professional support reach me on skype or telegram id: striker24x7