If you are using a newer version of mysql, you might have run in to the same problem that I did with passwords.  Apparently newer MySQL versions changed the way that passwords are hashed, and I had to tell it to use the old has instead.  Using the MySQL console I made a change not unlike this:

 

\u mysql;

update user set Password=OLDPASSWORD(passwordgoeshere’) where User=’asterisk’;

flush privileges;

 

This assumes the User you created was ‘asterisk’

 

Also, make sure that the mysql.sock file is where it thinks it is.  It could be in /tmp, or it could be somewhere else.   If it isn’t where its supposed to be, set its location in /etc/my.cnf, and comment out the location in /etc/asterisk/

 

 

 

Chris Coulthurst

[EMAIL PROTECTED]

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bharat M. Sarvan
Sent: Friday, May 13, 2005 6:27 AM
To: [email protected]
Cc: [email protected]
Subject: [Asterisk-Users] Asterisk extensions from Mysql

 

Hello

         I was just stuck around as to how I configure my Asterisk to access extensions from Mysql. I have made all the necessary changes in the extconfig.conf, the extensions.conf, res_mysql.conf, res_config_odbc.conf,res_odbc.conf as they have mentioned on the site www.voip-info.org.

    

       But still I am getting the error as

 

May 13 07:52:49 ERROR [6420]: res_config_mysql.c:588 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on. Check debug for more info.

 

       Does anybody know how to go about configuring Asterisk to access extensions from the mysql database? Please kindly do reply

 

 

 

 

 

 

 

Regards,

Bharat M. Sarvan

 

_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to