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.