accounting through detail module help

[ramesh p]

 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 at 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 at 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 at 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 at 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 at 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 at lboro.ac.uk>
> Subject: Re: accounting through detail module help
> To: FreeRadius users mailing list
>        <freeradius-users at lists.freeradius.org>
> Message-ID: <20090819123713.GA2117 at 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
>
>
> ------------------------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090820/e322a6a7/attachment.html>