[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