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 <[EMAIL PROTECTED]>:
> Markus Krause <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
