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
