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

Christopher Aloi chris.aloi at gmail.com
Fri Aug 25 20:39:56 MST 2006


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
------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060825/ab692496/attachment.htm


More information about the asterisk-users mailing list