Have you tried to connect to the db using the mysql command line client?<div>ie:</div><div>mysql -u username -p -h 1.2.3.4 opensips</div><div><br></div><div>The most likely solution is that you don't have networking enabled in mysql.</div>
<div>Does a "netstat -nlp" show mysqld running and on a IP port?</div><div><br></div><div>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</div>
<div>-Brett</div><div><br><br><div class="gmail_quote">On Thu, Jan 29, 2009 at 4:09 PM, TCB <span dir="ltr"><<a href="mailto:tawandac@gmail.com">tawandac@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I have noticed a very strange behaviour when trying to run opensips with a db via TCP . This error does<br>not occur when OSIPS connects via unix socket to the DB, i have googled this error an found not <br>solution. As you can see from the log the first few connections succeed but then DB conn fails at some point.<br>
You can see the full debug here <a href="http://rafb.net/p/Hv7O2b67.html" target="_blank">http://rafb.net/p/Hv7O2b67.html</a><br>--Error-- <br><br>Jan 29 23:57:37 [5569] DBG:core:db_bind_mod: using db bind api for db_mysql <br>
Jan 29 23:57:37 [5569] DBG:core:db_do_init: connection 0x81cbb80 not found in pool <br>Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: opening connection: mysql://<a href="http://xxxx:xxxx@10.10.10.1/opensips" target="_blank">xxxx:xxxx@10.10.10.1/opensips</a><br>
Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: connection type is 10.10.10.1 via TCP/IP <br>Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: protocol version is 10 <br>
Jan 29 23:57:37 [5569] DBG:db_mysql:db_mysql_new_connection: server version is 5.0.72-log <br>Jan 29 23:57:37 [5569] DBG:core:db_new_result: allocate 28 bytes for result set at 0x81cbc60 <br><br>--error --<br>
<br>Jan 29 23:47:37 [5340] DBG:core:db_bind_mod: using db bind api for db_mysql<br>Jan 29 23:47:37 [5340] DBG:core:db_do_init: connection 0x81cbb78 not found in pool<br>Jan 29 23:47:37 [5340] DBG:db_mysql:db_mysql_new_connection: opening connection: mysql://<a href="http://xxxx:xxxx@10.10.10.1/opensips" target="_blank">xxxx:xxxx@10.10.10.1/opensips</a><br>
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)<br>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<br>
<br>Over 127.0.0.1 TCP it works fine ! <br><br>Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: connection type is 127.0.0.1 via TCP/IP <br>Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: protocol version is 10 <br>
Jan 29 23:52:02 [5443] DBG:db_mysql:db_mysql_new_connection: server version is 5.0.67-0ubuntu6 <br clear="all"><br>Could this be a bug ? <br><font color="#888888">-- <br>TC<br>
</font><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>