asterisk users - Mar 2011 - Asterisk 1.6 MySQL Realtime fails to connect with working username and password.

Okay, so here's the configuration I have for MySQL Realtime (Asterisk
version 1.6.2.17):

In /etc/asterisk/extconfig.conf:

sipusers => mysql,mya2billing,cc_sip_buddies

In /etc/asterisk/res_mysql.conf:

[mya2billing]
dbhost = localhost
dbname = mya2billing
dbuser = a2billinguser
dbpass = REDACTED
dbport = 3306

And here's the error messages I get:

voip2*CLI> realtime mysql status
localhost configured for mya2billing at localhost, port 3306 with username
a2billinguser.
mya2billing configured for mya2billing at localhost, port 3306 with username
a2billinguser.
[Mar  7 14:38:59] ERROR[15943]: res_config_mysql.c:1575 mysql_reconnect:
MySQL RealTime: Failed to connect database server mya2billing on localhost
(err 2002). Check debug for more info.
[Mar  7 14:38:59] ERROR[15943]: res_config_mysql.c:1575 mysql_reconnect:
MySQL RealTime: Failed to connect database server mya2billing on localhost
(err 2002). Check debug for more info.

This doesn't make any sense. res_mysql.conf contains working mysql
credentials that I can verify with running mysql from the command line.

On Mon, Mar 7, 2011 at 5:52 PM, Ernie Dunbar <maillist at lightspeed.ca>
wrote:
> Okay, so here's the configuration I have for MySQL Realtime (Asterisk
> version 1.6.2.17):
>
> In /etc/asterisk/extconfig.conf:
>
> sipusers => mysql,mya2billing,cc_sip_buddies
>
> In /etc/asterisk/res_mysql.conf:
>
> Don't know what res_mysql.conf is, I think it should be
res_config_mysql.conf? Sorry it's been a LONG time since I configured/used
realtime and that also was with ODBC and TDS but I know that the file
res_config_mysql.conf should definitely be there

HTH
\R
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110307/ba4be18c/attachment.htm>

On Mon, Mar 7, 2011 at 4:52 PM, Ernie Dunbar <maillist at lightspeed.ca>
wrote:
> [mya2billing]
> dbhost = localhost
> dbname = mya2billing
> dbuser = a2billinguser
> dbpass = REDACTED
> dbport = 3306
>
Try adding "dbsock = /var/lib/mysql/mysql.sock" to the end of this
config
stanza and see if that helps (or whatever is the actual location of your
mysql.sock file).

-- 
Thanks,
--Warren Selby, dCAP
http://www.selbytech.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110307/388d4b51/attachment.htm>