Accounting is not working. Please help.

[alex]

I think everything is ok.

rad_recv: Access-Request packet from host 192.168.1.1:6001, id=91, length=124
        User-Name = "00:13:02:a7:57:9f"
        User-Password = "testing123"
        NAS-IP-Address = 192.168.1.1
        Called-Station-Id = "00-20-a6-6b-72-aa:PIM DOCK A"
        Calling-Station-Id = "00-13-02-a7-57-9f"
        NAS-Port = 9
        NAS-Port-Type = Wireless-802.11
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 14
  modcall[authorize]: module "preprocess" returns ok for request 14
  modcall[authorize]: module "chap" returns noop for request 14
  modcall[authorize]: module "mschap" returns noop for request 14
    rlm_realm: No '@' in User-Name = "00:13:02:a7:57:9f", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 14
radius_xlat:  '00:13:02:a7:57:9f'
rlm_sql (sql): sql_set_user escaped user --> '00:13:02:a7:57:9f'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM radcheck           WHERE Username = '00:13:02:a7:57:9f'           ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, op           FROM radcheck           WHERE Username = '00:13:02:a7:57:9f'           ORDER BY id
radius_xlat:  'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = '00:13:02:a7:57:9f' 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 = '00:13:02:a7:57:9f' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM radreply           WHERE Username = '00:13:02:a7:57:9f'           ORDER BY id'
rlm_sql_mysql: query:  SELECT id, UserName, Attribute, Value, op           FROM radreply           WHERE Username = '00:13:02:a7:57:9f'           ORDER BY id
radius_xlat:  'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00:13:02:a7:57:9f' 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 = '00:13:02:a7:57:9f' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql (sql): Released sql socket id: 0
  modcall[authorize]: module "sql" returns ok for request 14
modcall: leaving group authorize (returns ok) for request 14
auth: type Local
auth: user supplied User-Password matches local User-Password
Login OK: [00:13:02:a7:57:9f/testing123] (from client other port 9 cli 00-13-02-a7-57-9f)
Sending Access-Accept of id 91 to 192.168.1.1 port 6001
Finished request 14
Going to the next request



>  -------Original Message-------
>  From: Kevin Bonner <keb at pa.net>
>  Subject: Re: Accounting is not working. Please help.
>  Sent: 27 Mar '07 02:08
>  
>  On Monday 26 March 2007 16:30:35 alex wrote:
>  > Hey guys, i just follow this guide.
>  > http://www.frontios.com/freeradius.html
>  > and everything looks ok, the users are already working and login without
>  > problem. But the accounting is not working, the mysql tables are empty, i
>  > checked when i user access and everything looks ok, and the radacct still
>  > empty.
>  >
>  > In my radiusd.conf i have
>  > accounting {
>  >         detail
>  >         radutmp
>  >         sql
>  > }
>  > Other guy is checking in the AP, but i wanna be sure i have the correct
>  > values in the server.
>  >
>  > Any  comment is appreciated.
>  > Alex
>  
>  Did you run in debug mode (-X)?  If so, did the output show anything strange
>  when processing an accounting packet?  Is the NAS configured to send
>  accounting records to the radius server?
>  
>  -Kevin
>  -
>  List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html