<div class="gmail_quote">
<div>Here is the radius log in debug mode after sending radius packet from radclient:</div>
<div>rad_recv: Accounting-Request packet from host 10.77.202.78 port 1495, id=1, length=311<br> User-Name = "<a href="mailto:01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC">01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC</a>"<br>
Acct-Status-Type = Stop<br> Acct-Authentic = RADIUS<br> Framed-Protocol = PPP<br> Acct-Input-Packets = 100<br> Acct-Output-Packets = 100<br> Tunnel-Server-Endpoint:0 = "10.77.202.97"<br>
Acct-Session-Id = "000D76B9"<br> Acct-Tunnel-Connection = "2966486826"<br> Acct-Session-Time = 10<br> Acct-Terminate-Cause = Session-Timeout<br> Tunnel-Type:0 = L2TP<br>
Tunnel-Assignment-Id:0 = "10.77.202.97"<br> Cisco-AVPair = "Disc-Cause-Ext=No Reason"<br> Acct-Status-Type = Stop<br> Acct-Input-Octets = 1000<br> Acct-Output-Octets = 2100<br>
Acct-Status-Type = Stop<br> Tunnel-Assignment-Id:0 = "ABC-BB-Test-1"<br> Cisco-AVPair = "PPP-Disconnect-Cause=No reason"<br> Tunnel-Client-Endpoint:0 = "10.77.202.98"<br>
NAS-IP-Address = xx.xx.xx.xx<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent<br>[acct_unique] Hashing ',Client-IP-Address = 10.77.202.78,NAS-IP-Address = xx.xx.xx.xx,Acct-Session-Id = "000D76B9",User-Name = "<a href="mailto:01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC"'">01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC"'</a><br>
[acct_unique] Acct-Unique-Session-ID = "8d9821e205479a13".<br>++[acct_unique] returns ok<br>[suffix] Looking up realm "ABC" for User-Name = "<a href="mailto:01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC">01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC</a>"<br>
[suffix] No such realm "ABC"<br>++[suffix] returns noop<br>++[files] returns noop<br>+- entering group accounting {...}<br>++? if (Acct-Status-Type == 'Stop')<br>? Evaluating (Acct-Status-Type == 'Stop') -> TRUE<br>
++? if (Acct-Status-Type == 'Stop') -> TRUE<br>++- entering if (Acct-Status-Type == 'Stop') {...}<br>[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/<a href="http://10.77.202.78/detail-20090820">10.77.202.78/detail-20090820</a><br>
[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/<a href="http://10.77.202.78/detail-20090820">10.77.202.78/detail-20090820</a><br>
[detail] expand: %t -> Thu Aug 20 01:04:39 2009<br>+++[detail] returns ok<br>++- if (Acct-Status-Type == 'Stop') returns ok<br>++[unix] returns noop<br>[radutmp] expand: /usr/local/fnmt/freeradius2//var/log/radius/radutmp -> /usr/local/fnmt/freeradius2//var/log/radius/radutmp<br>
[radutmp] expand: %{User-Name} -> <a href="mailto:01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC">01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC</a><br> rlm_radutmp: No NAS-Port seen. Cannot do anything.<br>
rlm_radumtp: WARNING: checkrad will probably not work!<br>++[radutmp] returns noop<br>[attr_filter.accounting_response] expand: %{User-Name} -> <a href="mailto:01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC">01-0AE87C20-01-00000001-0004-78C8DB79-FFFFFFFFFFFFFFFF@ABC</a><br>
attr_filter: Matched entry DEFAULT at line 12<br>++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of id 1 to 10.77.202.78 port 1495<br>Finished request 1.<br>Cleaning up request 1 ID 1 with timestamp +141<br>
Going to the next request<br>Waking up in 8.9 seconds.<br>Polling for detail file /usr/local/fnmt/freeradius2//var/log/radius/radacct/detail</div>
<div> </div>
<div>Packets are not logged to db. sqltrace_sql shows nothing.<br></div>
<div>sql modules is not called? Where i'm doing the mistake.?</div>
<div>please suggest.</div>
<div> </div>
<div>Thanks,</div>
<div>Rams.</div>
<div> </div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span><br><br>Message: 1<br>Date: Wed, 19 Aug 2009 13:37:13 +0100<br>From: Alan Buxey <<a href="mailto:A.L.M.Buxey@lboro.ac.uk">A.L.M.Buxey@lboro.ac.uk</a>><br>
Subject: Re: accounting through detail module help<br>To: FreeRadius users mailing list<br> <<a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a href="mailto:20090819123713.GA2117@lboro.ac.uk">20090819123713.GA2117@lboro.ac.uk</a>><br>
Content-Type: text/plain; charset=us-ascii<br><br>hi,<br><br>the default server will call detail<br><br>the buffered-sql should call the actual SQL module to do the work.<br><br>this means default server spews packet data to detail file,<br>
the buffered-sql then reads that data and chucks into SQL<br><br>alan<br><br><br>------------------------------<br></blockquote></div><br>