Hi Users<br>
<br>
I have been using
FreeRadius-1.1.2 with Mysql database For accounting purpose
only 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>
For this reason "just for one call it is almost writing up to 10
Records and my database Engine is becoming very slow"<br>
<br>
So , how can I set the FreeRadius server so that it logs for one call only one record?.<br>
<br>
Below are some points i noticed <br>
<br>
"jack" calls "Billy"<br>
<br>
here radius server is setting records as <br>
sql_set_user escaped user---> jack<br>
<br>
when account starts and writing to database <br>
<br>
when acct stops<br>
<br>
sql_set_user escaped user-----> jack "
here in this style i am getting only one record for one call"<br>
<br>
sql_set_user escaped user------>Billy " if its like this
when act stops iam almost gettings 10 records for one call"<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 "sql_set_user escaped user
" <br>
<br>
Please Help me Guys.<br>
<br>
Thank You.<br>
<br>
Regards,<br>
Ravi.<br>
<br>