raviprakash sunkara wrote:
radacctID | AcctSessionID | AcctuniqueID | UserName | AcctStartTime | ActStopTime | calledID | callingID | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 12h34yy 2334juuw45 Uac1 13:10:00 00:00:00 Uac2 uac1
2 12h34yy ko34ji899 Uac2 13:11:11 13:11:11 Uac1 Uac2 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
In accountting with openser + radius in should insert only one insert for every call made .
FreeRADIUS with SQL accounting will insert a row for each session when accounting starts, then update that row when accounting stops. I'd guess that the session with an AcctStopTime of all zeros that you posted hasn't actually stopped yet. Look at the schema, I'm pretty sure all zeros is the default value for that column. -- James Wakefield, Unix Administrator, Information Technology Services Division Deakin University, Geelong, Victoria 3217 Australia. Phone: 03 5227 8690 International: +61 3 5227 8690 Fax: 03 5227 8866 International: +61 3 5227 8866 E-mail: james.wakefield@deakin.edu.au Website: http://www.deakin.edu.au