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