Have you tried to connect to the db using the mysql command line client?ie: mysql -u username -p -h 1.2.3.4 opensips
The most likely solution is that you don't have networking enabled in mysql. Does a "netstat -nlp" show mysqld running and on a IP port? It's also possible that your user/password isn't valid for users from your IP. I'm not sure what IP the server will think you are at if you connect to the server on it's own address -Brett On Thu, Jan 29, 2009 at 4:09 PM, TCB <[email protected]> wrote: > I have noticed a very strange behaviour when trying to run opensips with a > db via TCP . This error does > not occur when OSIPS connects via unix socket to the DB, i have googled > this error an found not > solution. As you can see from the log the first few connections succeed but > then DB conn fails at some point. > You can see the full debug here http://rafb.net/p/Hv7O2b67.html > --Error-- > > Jan 29 23:57:37 [5569] DBG:core:db_bind_mod: using db bind api for > db_mysql > Jan 29 23:57:37 [5569] DBG:core:db_do_init: connection 0x81cbb80 not found > in pool > Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: opening > connection: mysql://xxxx:[email protected]/opensips > Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: connection > type is 10.10.10.1 via > TCP/IP > > Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: protocol > version is 10 > Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: server version > is 5.0.72-log > Jan 29 23:57:37 [5569] DBG:core:db_new_result: allocate 28 bytes for result > set at 0x81cbc60 > > --error -- > > Jan 29 23:47:37 [5340] DBG:core:db_bind_mod: using db bind api for db_mysql > Jan 29 23:47:37 [5340] DBG:core:db_do_init: connection 0x81cbb78 not found > in pool > Jan 29 23:47:37 [5340] DBG:db_mysql:db_mysql_new_connection: opening > connection: mysql://xxxx:[email protected]/opensips > Jan 29 23:47:39 [5340] ERROR:db_mysql:db_mysql_new_connection: driver > error: Can't connect to MySQL server on '10.01.10.1' (4) > Jan 29 23:47:39 [5340] ERROR:core:db_do_init: could not add connection to > the poolJan 29 23:47:39 [5340] ERROR:lcr:mod_init: Unable to open database > connection > > Over 127.0.0.1 TCP it works fine ! > > Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: connection > type is 127.0.0.1 via TCP/IP > Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: protocol > version is 10 > Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: server version > is 5.0.67-0ubuntu6 > > Could this be a bug ? > -- > TC > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
