pb w/ accounting: wrong username (anonymous) used

[Markus Krause]

i found another weired thing:
the account log file "/var/log/radius/radacct/192.168.10.2./detail-20051114"
does contain the correct username entries, in the mysql table raddact the
account start logging is missing:

+++++++ /var/log/radius/radacct/192.168.10.2./detail-20051114:
Mon Nov 14 18:10:08 2005
        Acct-Delay-Time = 0
        NAS-Identifier = "AP-T-01"
        User-Name = "test1"
        Acct-Status-Type = Start
        Acct-Session-Id = "00:0E:35:C4:70:A8"
        Acct-Authentic = RADIUS
        Calling-Station-Id = "000e35c470a8"
        Called-Station-Id = "000cdb8be098"
        NAS-IP-Address = 192.168.10.2
        Service-Type = Framed-User
        NAS-Port-Type = Wireless-802.11
        Client-IP-Address = 192.168.10.2
        Acct-Unique-Session-Id = "8d85887a1ead2772"
        Timestamp = 1131988208

Mon Nov 14 18:10:26 2005
        Acct-Delay-Time = 0
        NAS-Identifier = "AP-T-01"
        Acct-Input-Octets = 10209
        Acct-Output-Octets = 9614
        Acct-Input-Packets = 80
        Acct-Output-Packets = 40
        User-Name = "test1"
        Acct-Status-Type = Stop
        Acct-Session-Id = "00:0E:35:C4:70:A8"
        Acct-Session-Time = 19
        Acct-Authentic = RADIUS
        Acct-Terminate-Cause = Lost-Service
        Calling-Station-Id = "000e35c470a8"
        Called-Station-Id = "000cdb8be098"
        NAS-IP-Address = 192.168.10.2
        Service-Type = Framed-User
        NAS-Port-Type = Wireless-802.11
        Client-IP-Address = 192.168.10.2
        Acct-Unique-Session-Id = "8d85887a1ead2772"
        Timestamp = 1131988226
------- (/var/log/radius/radacct/192.168.10.2./detail-20051114)

+++++++ mysql output:
mysql> select * from radacct where AcctUniqueID="8d85887a1ead2772";
+-----------+-------------------+------------------+----------+-------+--------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+
| RadAcctId | AcctSessionId     | AcctUniqueId     | UserName | Realm |
NASIPAddress | NASPortId | NASPortType     | AcctStartTime       | AcctStopTime
       | AcctSessionTime | AcctAuthentic | ConnectInfo_start | ConnectInfo_stop
| AcctInputOctets | AcctOutputOctets | CalledStationId | CallingStationId |
AcctTerminateCause | ServiceType | FramedProtocol | FramedIPAddress |
AcctStartDelay | AcctStopDelay |
+-----------+-------------------+------------------+----------+-------+--------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+
|        43 | 00:0E:35:C4:70:A8 | 8d85887a1ead2772 | test1    |       |
192.168.10.2 |         0 | Wireless-802.11 | 2005-11-14 18:10:08 | 2005-11-14
18:10:26 |              19 | RADIUS        |                   |               
  |           10209 |             9614 | 000cdb8be098    | 000e35c470a8     |
Lost-Service       | Framed-User |                |                 |          
   0 |             0 |
+-----------+-------------------+------------------+----------+-------+--------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+
1 row in set (0.00 sec)

mysql>
-------

it seems that the sql accounting (always! tried several times) never gets an 
"accounting start".
can this be due to misconfiguration or is there something broken in the sql
module?

thanks in advance for any hints!

regards,
   markus



Zitat von Alan DeKok <aland at ox.org>:
> Markus Krause <krause at biochem.mpg.de> wrote:
> > Sending Access-Accept of id 238 to 192.168.10.2:2430
> >         Session-Timeout = 600
> >         User-Name := "test1"
> ...
> > rad_recv: Accounting-Request packet from host 192.168.10.2:9000, id=15,
> > length=123
> >         Acct-Delay-Time = 0
> >         NAS-Identifier = "AP-T-01"
> >         User-Name = "anonymous"
>
>   Your NAS is broken.  Call the manufacturer, and ask them for a
> firmware upgrade that allows it to support RADIUS properly.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>


--
Markus Krause                           email: krause at biochem.mpg.de
Computing Center                        Tel.: 089 - 89 40 85 99
Group Lottspeich / Proteomics           Fax.: 089 - 89 40 85 98

---------------------------------------------------------------------
     This message was sent using https://webmail.biochem.mpg.de
If you encounter any problems please report to rz-linux at biochem.mpg.de