Christopher Aloi
2006-Aug-25 20:39 UTC
[asterisk-users] Asterisk Real Time Engine - Fails to Connect to MySQL
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
Christopher Aloi
2006-Aug-25 20:45 UTC
[asterisk-users] Re: Asterisk Real Time Engine - Fails to Connect to MySQL
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@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