MySQL RealTime: Failed to connect database server asterisk on /var/lib/mysql/mysql.sock (err 1045)

Question

I am using asterisk realtime but while configuring i am getting the below error

MySQL RealTime: Failed to connect database server asterisk on /var/lib/mysql/mysql.sock (err 1045)

Answer 1

have you modified logger.conf so that debug info is written to/var/log/asterisk/full ? 

in  /etc/asterisk.res_config_mysql.conf

Put

 

[general]

dbhost = localhost

dbname = asteriskrealtime

dbuser = root

dbpass = password

dbport = 3306

dbsock = /var/lib/mysql/mysql.sock

dbcharset = latin1

;requirements=warn ; or createclose or createchar

 

To Verify us the following command

localhost*CLI> realtime mysql status

general connected to asteriskrealtime@localhost, port 3306 with username root for 7 minutes.

 

Answer 2

Run this command

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak

then

service mysql restart

enjoy...