How Getting accounting informations ?

[Vincent MARGUERIE]

Hi,

I've always got the same problem with accounting informations...sorry to 
query you one more time !!

But I've made a new test with radclient and I have this log (maybe it 
will be helpfull)

 > echo "User-Password = tata, User-Name = tata, Accounting-Status-Type 
= Start" | radclient -x -d /usr/local/etc/raddb/ radius:1813 acct whatever

rad_recv: Accounting-Request packet from host 192.168.0.1:32768, id=218, 
length=44
        User-Password = "\256\032\246\027\310$!\305\313UBc\306."
        User-Name = "tata"
  Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 7
  modcall[preacct]: module "preprocess" returns noop for request 7
    rlm_realm: No '@' in User-Name = "tata", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[preacct]: module "suffix" returns noop for request 7
modcall: leaving group preacct (returns noop) for request 7
  Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 7
radius_xlat:  
'/usr/local/var/log/radius/radacct/192.168.0.1/detail-20060328'
rlm_detail: 
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d 
expands to /usr/local/var/log/radius/radacct/192.168.0.1/detail-20060328
  modcall[accounting]: module "detail" returns ok for request 7
rlm_unix: no Accounting-Status-Type attribute in request.
  modcall[accounting]: module "unix" returns noop for request 7
rlm_radutmp: No Accounting-Status-Type record.
  modcall[accounting]: module "radutmp" returns noop for request 7
radius_xlat:  '*packet has no accounting status type*. [user 'tata', nas 
'192.168.0.1']'
rlm_sql (sql) in sql_accounting: packet has no accounting status type. 
[user 'tata', nas '192.168.0.1']
  modcall[accounting]: module "sql" returns invalid for request 7
modcall: leaving group accounting (returns invalid) for request 7
Finished request 7
Going to the next request
--- Walking the entire request list ---
Cleaning up request 7 ID 218 with timestamp 44289161
Nothing to do.  Sleeping until we see a request.

What  does "*packet has no accounting status type*" means ? Is it the 
reason for accounting doesn't work ?

I fell lost...please help :-)

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

For the auth section....there's no problem (see the following lines)

 > echo "User-Password = tata, User-Name = tata, Accounting-Status-Type 
= Start" | radclient -x -d /usr/local/etc/raddb/ radius:1812 auth whatever

rad_recv: Access-Request packet from host 192.168.0.1:32768, id=215, 
length=44
        User-Password = "tata"
        User-Name = "tata"
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 4
  modcall[authorize]: module "preprocess" returns ok for request 4
radius_xlat:  
'/usr/local/var/log/radius/radacct/192.168.0.1/auth-detail-20060328'
rlm_detail: 
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d 
expands to 
/usr/local/var/log/radius/radacct/192.168.0.1/auth-detail-20060328
  modcall[authorize]: module "auth_log" returns ok for request 4
  modcall[authorize]: module "chap" returns noop for request 4
  modcall[authorize]: module "mschap" returns noop for request 4
    rlm_realm: No '@' in User-Name = "tata", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 4
  rlm_eap: No EAP-Message, not doing EAP
  modcall[authorize]: module "eap" returns noop for request 4
    users: Matched entry DEFAULT at line 152
  modcall[authorize]: module "files" returns ok for request 4
radius_xlat:  'tata'
rlm_sql (sql): sql_set_user escaped user --> 'tata'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM 
radcheck           WHERE Username = 'tata'           ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, 
op           FROM radcheck           WHERE Username = 'tata'           
ORDER BY id
radius_xlat:  'SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'tata' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: query:  SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'tata' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM 
radreply           WHERE Username = 'tata'           ORDER BY id'
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, 
op           FROM radreply           WHERE Username = 'tata'           
ORDER BY id
radius_xlat:  'SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  
FROM radgroupreply,usergroup WHERE usergroup.Username = 'tata' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: query:  SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  
FROM radgroupreply,usergroup WHERE usergroup.Username = 'tata' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql (sql): Released sql socket id: 1
  modcall[authorize]: module "sql" returns ok for request 4
modcall: leaving group authorize (returns ok) for request 4
auth: type Local
auth: user supplied User-Password matches local User-Password
  Processing the post-auth section of radiusd.conf
modcall: entering group post-auth for request 4
radius_xlat:  
'/usr/local/var/log/radius/radacct/192.168.0.1/reply-detail-20060328'
rlm_detail: 
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d 
expands to 
/usr/local/var/log/radius/radacct/192.168.0.1/reply-detail-20060328
  modcall[post-auth]: module "reply_log" returns ok for request 4
rlm_sql (sql): Processing sql_postauth
radius_xlat:  'tata'
rlm_sql (sql): sql_set_user escaped user --> 'tata'
radius_xlat:  'INSERT into radpostauth (id, user, pass, reply, date) 
values ('', 'tata', 'tata', 'Access-Accept', NOW())'
radius_xlat:  '/usr/local/var/log/radius/sqltrace.sql'
rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id, 
user, pass, reply, date) values ('', 'tata', 'tata', 'Access-Accept', NOW())
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query:  INSERT into radpostauth (id, user, pass, reply, 
date) values ('', 'tata', 'tata', 'Access-Accept', NOW())
rlm_sql (sql): Released sql socket id: 0
  modcall[post-auth]: module "sql" returns ok for request 4
rlm_sql_log (sql_log): Processing sql_log_postauth
radius_xlat:  'INSERT INTO radpostauth                   ?? (user, pass, 
reply, date) VALUES                            ?? ('tata', 
'tata',         ?? 'Access-Accept', '2006-03-28 03:22:25');'
radius_xlat:  '/usr/local/var/log/radius/radacct/sql-relay'
  modcall[post-auth]: module "sql_log" returns ok for request 4
modcall: leaving group post-auth (returns ok) for request 4
Sending Access-Accept of id 215 to 192.168.0.1 port 32768
Finished request 4
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 4 ID 215 with timestamp 44288fd1
Nothing to do.  Sleeping until we see a request.

Regards,
Vincent