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:x...@10.10.10.1/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:x...@10.10.10.1/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 Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
