sql_set_user escaped user " HELP"
Hi Users I have been using FreeRadius-1.1.2 with Mysql database For accounting purpose only with combination of Sip-Express-Router 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 . For this reason "just for one call it is almost writing up to 10 Records and my database Engine is becoming very slow" So , how can I set the FreeRadius server so that it logs for one call only one record?. Below are some points i noticed "jack" calls "Billy" here radius server is setting records as sql_set_user escaped user---> jack when account starts and writing to database when acct stops sql_set_user escaped user-----> jack " here in this style i am getting only one record for one call" sql_set_user escaped user------>Billy " if its like this when act stops iam almost gettings 10 records for one call" 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 " Please Help me Guys. Thank You. Regards, Ravi.
"ravi reddy" <mravikreddy@gmail.com> wrote:
So , how can I set the FreeRadius server so that it logs for one call only one record?.
You fix the NAS to send only one record for one call. The server does not control how many records are sent for one call. The NAS does. Or, you write a custom processing script for accounting records. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
participants (2)
-
Alan DeKok -
ravi reddy