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

[Iulian Macare]

Tried like this.

Opensips with radius proxy on the same machine & radius doing the sql
on the different machine

If I stop radius doing the sql opensips still works but if I stop the
mysql on the 2nd machine opensips still blocks...

On Thu, Mar 22, 2012 at 12:27 PM, Tijmen de Mes <tijmen at ag-projects.com> wrote:
> 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
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users