asterisk users - May 2005 - 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/88cab5e2/attachment.htm

I guess you don't know how to read.
> Failed to connect database server asterisk on. Check debug for
> more info.
Holy cow! You failed to connect to your database! Imagine that. I wonder why
it isn't working. Hmm. Could it be that? Did you check the debug for more
info? Probably not seeing as you are emailing the list.

-Matthew

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@shuksan.com> chris@shuksan.com
 
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Bharat M.
Sarvan
Sent: Friday, May 13, 2005 6:27 AM
To: asterisk-users@lists.digium.com
Cc: asterisk-dev@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