Claim your Biolink Click Here
1 like 0 dislike
1.3k views
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)
in Computers & Internet by (460 points) | 1.3k views

2 Answers

0 like 0 dislike

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.
 
by
0 like 0 dislike
Run this command

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

then

service mysql restart

enjoy...
by

Related questions

0 like 0 dislike
2 answers
asked May 27, 2014 in Education & Reference by Yogi (460 points) | 292 views
1 like 0 dislike
3 answers
0 like 0 dislike
0 answers
0 like 0 dislike
1 answer
2 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,308 questions
1,469 answers
568 comments
4,809 users