<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>Hello Anton,<br>
<br>
I bet MySQL isn't listening on localhost on your live machine,
but rather on eth0.<br>
If you really can't get it working, please post the output of:<br>
<br>
sudo netstat -tlnp | grep mysql<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 08/22/2014 09:57 AM, Лытаев Антон Викторович wrote:<br>
</div>
<blockquote cite="mid:53F6E9DE.7010805@ptcomm.ru" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hello,<br>
T<span id="result_box" class="" lang="en"><span class="hps"><span
id="result_box" class="short_text" lang="en"><span
class="hps">hat's</span> <span class="hps">part of the</span>
<span class="hps">config</span></span>:<br>
<br>
<small><i>loadmodule "nat_traversal.so"<br>
loadmodule "avpops.so" </i><i><br>
</i><i>modparam("auth_db", "load_credentials",
"$avp(loadedip)=domain;$avp(subscriber_username)=username;maxaor")<br>
modparam("avpops","db_url",</i><i><br>
</i><i> <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:mysql://opensips:opensipsrw@127.0.0.1/opensips">"mysql://opensips:opensipsrw@127.0.0.1/opensips"</a>)
</i><i><br>
</i><i>route[subscriberquota] {</i><i><br>
</i><i> avp_db_query("select quota from subscriber where
username='$var(subscriber)'","$avp(subscriberquota)");</i><i><br>
</i><i> if ($avp(subscriberquota) == 0) {</i><i><br>
</i><i> xlog("Subscriberquota route, NO LIMIT FOR
USER <$var(subscriber)>");</i><i><br>
</i><i> return;</i><i><br>
</i><i> }</i><i><br>
</i><i> $var(size) = 0;</i><i><br>
</i><i> get_profile_size("subscriberquota",
"$var(subscriber)", "$var(size)");</i><i><br>
</i><i> if( $var(size) >= $avp(subscriberquota) ){</i><i><br>
</i><i> sl_send_reply("503", "Simultaneous calls
limit reached");</i><i><br>
</i><i> xlog("Subscriberquota route, Limit of
$var(size) active calls has been reached for subscriber
$var(subscriber)");</i><i><br>
</i><i> exit;</i><i><br>
</i><i> }</i><i><br>
</i><i>
set_dlg_profile("subscriberquota","$var(subscriber)");</i><i><br>
</i><i> get_profile_size("subscriberquota",
"$var(subscriber)", "$var(size)");</i><i><br>
</i><i> xlog("Subscriberquota route, there are now
$var(size) active calls for subscriber $var(subscriber)");</i><i><br>
</i><i> return;</i><i><br>
</i><i>} </i><i><br>
</i></small><br>
on the test server</span> <span class="hps">(VM</span> <span
class="hps">VirtualBox</span> <span class="hps">-</span> C<span
class="hps">entos</span> <span class="hps">6.5</span> <span
class="hps">32bit)</span> <span class="hps">everything works
fine</span><span>, but</span> <span class="hps">on the live</span>
<span class="hps">server</span> <span class="hps">-</span> <span
class="hps">startup</span> <span class="hps">error:</span></span><br>
<br>
Aug 21 03:34:44 corp-32-45 opensips: WARNING:core:fix_socket_list:
could not rev. resolve 172.16.5.4<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
NOTICE:core:main: version: opensips 1.11.2-tls (x86_64/linux)<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
NOTICE:signaling:mod_init: initializing module ...<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
WARNING:usrloc:mod_init: Integer flags are now deprecated! Use
unique quoted strings!<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
WARNING:acc:mod_init: Integer flags are now deprecated! Use unique
quoted strings!<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
WARNING:acc:mod_init: Integer flags are now deprecated! Use unique
quoted strings!<br>
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]:
WARNING:acc:mod_init: Integer flags are now deprecated! Use unique
quoted strings!<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect
to MySQL server on '127.0.0.1' (110)<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect
to MySQL server on '127.0.0.1' (110)<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:core:db_do_init: could not add connection to the pool<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:core:db_do_init: could not add connection to the pool<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:avpops:avpops_db_init: cannot initialize database connection
for <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mysql://opensips:opensipsrw@127.0.0.1/opensips">mysql://opensips:opensipsrw@127.0.0.1/opensips</a><br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:avpops:avpops_db_init: cannot initialize database connection
for <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mysql://opensips:opensipsrw@127.0.0.1/opensips">mysql://opensips:opensipsrw@127.0.0.1/opensips</a><br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:core:init_mod_child: failed to initializing module avpops,
rank -2<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:core:init_mod_child: failed to initializing module avpops,
rank 1<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]:
ERROR:core:start_module_procs: error in init_child for PROC_MODULE<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]:
ERROR:core:main_loop: init_child failed for UDP listener<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect
to MySQL server on '127.0.0.1' (110)<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:core:db_do_init: could not add connection to the pool<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:avpops:avpops_db_init: cannot initialize database connection
for <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mysql://opensips:opensipsrw@127.0.0.1/opensips">mysql://opensips:opensipsrw@127.0.0.1/opensips</a><br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:core:init_mod_child: failed to initializing module avpops,
rank 3<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:core:main_loop: init_child failed for UDP listener<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]:
ERROR:core:main_loop: failed to send status code<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]:
CRITICAL:core:receive_fd: EOF on 8<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]:
CRITICAL:core:receive_fd: EOF on 9<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]:
CRITICAL:core:receive_fd: EOF on 11<br>
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7263]:
ERROR:nat_traversal:save_keepalive_state: failed to open keepalive
state file for writing: Permission denied<br>
<br>
<b><big><span id="result_box" class="short_text" lang="en"><span
class="hps">Please help</span> <span class="hps">solve
the problem</span></span></big></b><br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>