[OpenSIPS-Users] problem with avpops_db_init

Лытаев Антон Викторович lav at ptcomm.ru
Fri Aug 22 08:57:34 CEST 2014


Hello,
That's part of the config:

/loadmodule "nat_traversal.so"
loadmodule "avpops.so" //
//modparam("auth_db", "load_credentials", 
"$avp(loadedip)=domain;$avp(subscriber_username)=username;maxaor")
modparam("avpops","db_url",//
//    "mysql://opensips:opensipsrw@127.0.0.1/opensips") //
//route[subscriberquota] {//
//    avp_db_query("select quota from subscriber where 
username='$var(subscriber)'","$avp(subscriberquota)");//
//    if ($avp(subscriberquota) == 0) {//
//        xlog("Subscriberquota route, NO LIMIT FOR USER 
<$var(subscriber)>");//
//        return;//
//    }//
//    $var(size) = 0;//
//    get_profile_size("subscriberquota", "$var(subscriber)", 
"$var(size)");//
//    if( $var(size) >= $avp(subscriberquota) ){//
//        sl_send_reply("503", "Simultaneous calls limit reached");//
//        xlog("Subscriberquota route, Limit of $var(size) active calls 
has been reached for subscriber $var(subscriber)");//
//        exit;//
//    }//
//set_dlg_profile("subscriberquota","$var(subscriber)");//
//    get_profile_size("subscriberquota", "$var(subscriber)", 
"$var(size)");//
//    xlog("Subscriberquota route, there are now $var(size) active calls 
for subscriber $var(subscriber)");//
//    return;//
//} //
/
on the test server (VM VirtualBox - Centos 6.5 32bit) everything works 
fine, but on the live server - startup error:

Aug 21 03:34:44 corp-32-45 opensips: WARNING:core:fix_socket_list: could 
not rev. resolve 172.16.5.4
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]: NOTICE:core:main: 
version: opensips 1.11.2-tls (x86_64/linux)
Aug 21 03:34:44 corp-32-45 /usr/sbin/opensips[7263]: 
NOTICE:signaling:mod_init: initializing module ...
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!
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!
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!
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!
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)
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)
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]: 
ERROR:db_mysql:db_mysql_new_connection: initial connect failed
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]: 
ERROR:db_mysql:db_mysql_new_connection: initial connect failed
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]: 
ERROR:core:db_do_init: could not add connection to the pool
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]: 
ERROR:core:db_do_init: could not add connection to the pool
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]: 
ERROR:avpops:avpops_db_init: cannot initialize database connection for 
mysql://opensips:opensipsrw@127.0.0.1/opensips
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]: 
ERROR:avpops:avpops_db_init: cannot initialize database connection for 
mysql://opensips:opensipsrw@127.0.0.1/opensips
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]: 
ERROR:core:init_mod_child: failed to initializing module avpops, rank -2
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]: 
ERROR:core:init_mod_child: failed to initializing module avpops, rank 1
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7267]: 
ERROR:core:start_module_procs: error in init_child for PROC_MODULE
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7268]: 
ERROR:core:main_loop: init_child failed for UDP listener
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)
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:db_mysql:db_mysql_new_connection: initial connect failed
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:core:db_do_init: could not add connection to the pool
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:avpops:avpops_db_init: cannot initialize database connection for 
mysql://opensips:opensipsrw@127.0.0.1/opensips
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:core:init_mod_child: failed to initializing module avpops, rank 3
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:core:main_loop: init_child failed for UDP listener
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7270]: 
ERROR:core:main_loop: failed to send status code
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]: 
CRITICAL:core:receive_fd: EOF on 8
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]: 
CRITICAL:core:receive_fd: EOF on 9
Aug 21 03:35:47 corp-32-45 /usr/sbin/opensips[7287]: 
CRITICAL:core:receive_fd: EOF on 11
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

*Please help solve the problem*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140822/57f01668/attachment.htm>


More information about the Users mailing list