<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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 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 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 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 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>
</body>
</html>