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 [email protected]: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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
