Hi Users<br>
&nbsp; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have been using
FreeRadius-1.1.2 with Mysql database&nbsp; For accounting purpose
only&nbsp; with combination of Sip-Express-Router<br>
<br>
So, here what's my problem is some accounting details are very fair but
some are getting very rough data :- that means when call starts it logs
like 4 to 5 records with starting time and when call stops it again
logs in 5 to 6 records with acct stop time .<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
For this reason &quot;just for one call it is almost writing up to 10
Records and my database Engine is becoming very slow&quot;<br>
<br>
So , how can I set the FreeRadius server so that it logs for one call only one record?.<br>
<br>
&nbsp;Below are some points i noticed <br>
<br>
&nbsp;&quot;jack&quot; calls &quot;Billy&quot;<br>
<br>
here radius server is setting records as <br>
sql_set_user escaped user---&gt; jack<br>
<br>
when account starts and writing to database <br>
<br>
when acct stops<br>
<br>
sql_set_user escaped user-----&gt; jack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;
here in this style i am getting only one record for one call&quot;<br>
<br>
sql_set_user escaped user------&gt;Billy&nbsp;&nbsp; &quot; if its like this
when act stops iam almost gettings 10 records for one call&quot;<br>
<br>
SO, HOW I CAN SET THE SQL.CONF SO THAT , THE FREERADIUS SERVER BY
DEFAULT IT HAS TO TAKE ONLY CALLED PERSON AS &quot;sql_set_user escaped user
&quot; <br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Please Help me Guys.<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Thank You.<br>
<br>
Regards,<br>
Ravi.<br>
<br>