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

[Iulian Macare]

The Opensips error are:

Mar 22 10:58:52 opensipsnew /usr/sbin/opensips[15230]:
ERROR:acc:acc_aaa_request: Radius accounting request failed for
status: 'Failed' Call-I.....
Mar 22 10:58:52 opensipsnew /usr/sbin/opensips[15230]: rc_send_server:
no reply from RADIUS server localhost:1813
Mar 22 10:58:23 opensipsnew /usr/sbin/opensips[15231]:
ERROR:acc:acc_aaa_request: Radius accounting request failed for
status: 'Stop' Call-Id....
Mar 22 10:58:23 opensipsnew /usr/sbin/opensips[15231]: rc_send_server:
no reply from RADIUS server localhost:1813
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15229]:
ERROR:acc:acc_aaa_request: Radius accounting request failed for
status: 'Stop' Call-I...
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15229]: rc_send_server:
no reply from RADIUS server localhost:1813
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15232]:
ERROR:acc:acc_aaa_request: Radius accounting request failed for
status: 'Failed' Call-: ...
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15232]: rc_send_server:
no reply from RADIUS server localhost:1813
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15230]:
ERROR:acc:acc_aaa_request: Radius accounting request failed for
status: 'Stop' Call-I...
Mar 22 10:58:22 opensipsnew /usr/sbin/opensips[15230]: rc_send_server:
no reply from RADIUS server localhost:1813

I will try something to use sql failover in radius ... primary to use
my DB server and if fails to write data in  a different DB server to
check if this will work ...

Or perhaps there is somekind of parameter in opensips that will not
block opensips if acc module fails to do accounting

On Thu, Mar 22, 2012 at 12:14 PM, Iulian Macare <iulian.macare at gmail.com> 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?