<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>I am using
freeradius 1.1.0. The backend is mysql 5.0.22 which is located on a different
server on the same network.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>My configuration is
as follows:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>I am doing some
stress testing to benchmark my infrastructure.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>I use SIPp for the
same. The SIPp sends the calls to cisco gateway, the cisco gateway sends the
authentication request to freeradius server. The radius server queries the mysql
database and once the authentication is successful and the call is
completed; the accounting request is also passed to the radius server by
cisco which in turn is sent to the mysql database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Now I kept the SIPp
at rate of 45 calls per second, but after say 10 to 15 minutes the radius server
dies. This is the message I could see in the log:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=375123614-07072006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>rlm_sql (sql): There
are no DB handles to use! skipped 0, tried to connect 0</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=375123614-07072006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Error:
rlm_sql_mysql: MYSQL Error: Cannot get result<BR>Fri Jul 7 14:18:46 2006 :
Error: rlm_sql_mysql: MYSQL Error:<BR>Fri Jul 7 14:18:46 2006 : Error:
rlm_sql_mysql: MYSQL Error: No Fields<BR>Fri Jul 7 14:18:46 2006 : Error:
rlm_sql_mysql: MYSQL error:<BR>Fri Jul 7 14:18:46 2006 : Info:
rlm_sql_mysql: Starting connect to MySQL server for #4<BR>Fri Jul 7
14:18:46 2006 : Error: rlm_sql (sql): failed after
re-connect.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=375123614-07072006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>I tried googling the
archive but could not get a proper solution. One more thing; I had configured
rlm_mysql using the following command:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>./configure
--without-thread.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Could this be a
cause of some problem, I did this as the radius was not finding mysql
libraries.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=375123614-07072006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Can someone please
help on this.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=375123614-07072006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=375123614-07072006>Thanks in
advance.</DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>
<DIV><SPAN class=495483006-22062006><FONT face=Arial
size=2>w/regards,</FONT></SPAN></DIV>
<DIV><SPAN class=495483006-22062006><FONT face=Arial size=2>Jayesh
Nambiar</FONT></SPAN></DIV></FONT></DIV>
<DIV> </DIV></BODY></HTML>