Here is the radius log in debug mode after sending radius packet from radclient: rad_recv: Accounting-Request packet from host 10.77.202.78 port 1495, id=1, length=311 User-Name = " 01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC" Acct-Status-Type = Stop Acct-Authentic = RADIUS Framed-Protocol = PPP Acct-Input-Packets = 100 Acct-Output-Packets = 100 Tunnel-Server-Endpoint:0 = "10.77.202.97" Acct-Session-Id = "000D76B9" Acct-Tunnel-Connection = "2966486826" Acct-Session-Time = 10 Acct-Terminate-Cause = Session-Timeout Tunnel-Type:0 = L2TP Tunnel-Assignment-Id:0 = "10.77.202.97" Cisco-AVPair = "Disc-Cause-Ext=No Reason" Acct-Status-Type = Stop Acct-Input-Octets = 1000 Acct-Output-Octets = 2100 Acct-Status-Type = Stop Tunnel-Assignment-Id:0 = "ABC-BB-Test-1" Cisco-AVPair = "PPP-Disconnect-Cause=No reason" Tunnel-Client-Endpoint:0 = "10.77.202.98" NAS-IP-Address = xx.xx.xx.xx +- entering group preacct {...} ++[preprocess] returns ok [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent [acct_unique] Hashing ',Client-IP-Address = 10.77.202.78,NAS-IP-Address = xx.xx.xx.xx,Acct-Session-Id = "000D76B9",User-Name = " 01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC"' [acct_unique] Acct-Unique-Session-ID = "8d9821e205479a13". ++[acct_unique] returns ok [suffix] Looking up realm "ABC" for User-Name = " 01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC" [suffix] No such realm "ABC" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} ++? if (Acct-Status-Type == 'Stop') ? Evaluating (Acct-Status-Type == 'Stop') -> TRUE ++? if (Acct-Status-Type == 'Stop') -> TRUE ++- entering if (Acct-Status-Type == 'Stop') {...} [detail] expand: /usr/local/fnmt/freeradius2//var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /usr/local/fnmt/freeradius2//var/log/radius/radacct/ 10.77.202.78/detail-20090820 [detail] /usr/local/fnmt/freeradius2//var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/fnmt/freeradius2//var/log/radius/radacct/ 10.77.202.78/detail-20090820 [detail] expand: %t -> Thu Aug 20 01:04:39 2009 +++[detail] returns ok ++- if (Acct-Status-Type == 'Stop') returns ok ++[unix] returns noop [radutmp] expand: /usr/local/fnmt/freeradius2//var/log/radius/radutmp -> /usr/local/fnmt/freeradius2//var/log/radius/radutmp [radutmp] expand: %{User-Name} -> 01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC rlm_radutmp: No NAS-Port seen. Cannot do anything. rlm_radumtp: WARNING: checkrad will probably not work! ++[radutmp] returns noop [attr_filter.accounting_response] expand: %{User-Name} -> 01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 1 to 10.77.202.78 port 1495 Finished request 1. Cleaning up request 1 ID 1 with timestamp +141 Going to the next request Waking up in 8.9 seconds. Polling for detail file /usr/local/fnmt/freeradius2//var/log/radius/radacct/detail Packets are not logged to db. sqltrace_sql shows nothing. sql modules is not called? Where i'm doing the mistake.? please suggest. Thanks, Rams.

Message: 1 Date: Wed, 19 Aug 2009 13:37:13 +0100 From: Alan Buxey <A.L.M.Buxey@lboro.ac.uk> Subject: Re: accounting through detail module help To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <20090819123713.GA2117@lboro.ac.uk> Content-Type: text/plain; charset=us-ascii

hi,

the default server will call detail

the buffered-sql should call the actual SQL module to do the work.

this means default server spews packet data to detail file, the buffered-sql then reads that data and chucks into SQL

alan

------------------------------