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

[Tijmen de Mes]

Hi,

A work around is use a radius as a proxy on the Opensips machine. So the 
proxy will always be available even if the radius server is not.

The setup would look like the following:
Opensips --> radius proxy --> radius server doing the sql

-- 
Tijmen de Mes
AG Projects



On 03/22/2012 11:14 AM, Iulian Macare wrote:
> 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?
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users