[asterisk-users] Re: Asterisk Real Time Engine - Fails to Connect to MySQL

[Christopher Aloi]

Scratch that email.....
problem was using 127.0.0.1 - I changed that to localhost and all is
well.....
Can I have the last three hours back now :)

On 8/25/06, Christopher Aloi <chris.aloi at gmail.com> wrote:
>
> Debian Stable
> Asterisk SVN-branch-1.2-r41069
>
> Hello List.....
>
> Okay, tonight I dove into Asterisk Real Time.
> I have the module compiled and installed and have the following setup:
>
> MySQL running with a DB created "asterisk" *how original right?
> Username 'astuser' password 'foo'
> I can locally login to MySQL (as user astuser with pw foo) and select the
> following:
>
> mysql> show tables;
> +--------------------+
> | Tables_in_asterisk |
> +--------------------+
> | sip_friends        |
> +--------------------+
> 1 row in set (0.00 sec)
>
> I have a sip_friend "800" setup in the table.
>
> My extconfig looks like this:
>
> [settings]
> sippeers => mysql,asterisk,sip_friends
>
> My res_config_mysql.conf looks like this:
>
> [general]
> dbhost = 127.0.0.1
> dbname = asterisk
> dbuser = astuser
> dbpass = foo
> dbport = 3306
> dbsock = /var/run/mysqld/mysqld.sock
>
> And here is what I see in the console; i wasn't able to get any more than
> this out of the debug file either.
> Anyone have any thoughts? What is error 2013???
>
> Thanks :) !
>
>
> Aug 26 01:13:02 ERROR[6256]: res_config_mysql.c:651 mysql_reconnect: MySQL
> RealTime: Failed to connect database server asterisk on 127.0.0.1 (err
> 2013). Check debug for more info.
> Aug 26 01:13:02 DEBUG[6256]: res_config_mysql.c:652 mysql_reconnect: MySQL
> RealTime: Cannot Connect (2013): Lost connection to MySQL server during
> query
>
>
>
> --
> ------
> Christopher T Aloi
> ------
>



-- 
------
Christopher T Aloi
------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060825/15b0fc26/attachment.htm