[Asterisk-Users] Asterisk extensions from Mysql

[Chris Coulthurst]

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
 <mailto:chris at shuksan.com> chris at shuksan.com
 
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Bharat M.
Sarvan
Sent: Friday, May 13, 2005 6:27 AM
To: asterisk-users at lists.digium.com
Cc: asterisk-dev at lists.digium.com
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 <http://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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050513/de8e7f2c/attachment.htm