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@ox.org>:
Markus Krause <krause@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@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@biochem.mpg.de