[OpenSIPS-Users] Opensips blocked when using with Radius accounting and mysql stops

Iulian Macare iulian.macare at gmail.com
Thu Mar 22 11:14:57 CET 2012


Hello

I have the following scenario:

1 x Opensips with CDRTool installed on a machine ( Opensips,Mysql,
Freeradius & CDRTool )
1 x DB with MySQL that I have only the radius database

So on the Opensips machine I have the opensips & cdrtool databases ,
and on the DB server I have the radius database


Opensips aaa module sends the accounting information to Freeradius
that is configured to write sql queries on the DB server . If the DB
server get's overloaded ( I make a big select that locks the table )
or unavailable , opensips get's blocked and no other calls can be made

Of course, in radius log i get:

Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): Couldn't insert SQL
accounting START record - rlm_sql_mysql: no connection to db
Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): reconnect failed,
database down?
Thu Mar 22 11:05:17 2012 : Error: rlm_sql (sql): Failed to connect DB handle #13
Thu Mar 22 11:05:17 2012 : Error: rlm_sql_mysql: Mysql error 'Can't
connect to MySQL server on '192.168.4.63' (111)'
Thu Mar 22 11:05:17 2012 : Error: rlm_sql_mysql: Couldn't connect
socket to MySQL server radius at 192.168.4.63:radius


But when this is happening, all opensips childs use 100% of CPU and
nothing works. How can I prevent opensips in getting blocked if my
database server containing the radius database fails?



More information about the Users mailing list