Tak wygląda podłączenie mikrotik do radiusa

Ready to process requests. rad_recv: Accounting-Request packet from host 10.0.0.2 port 48102, id=3, length=48 Acct-Status-Type = Accounting-On NAS-Identifier = "MikroTik" NAS-IP-Address = 10.0.0.2 Acct-Delay-Time = 0 +- entering group preacct ++[preprocess] returns ok rlm_acct_unique: WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent rlm_acct_unique: WARNING: Attribute Acct-Session-Id was not found in request, unique ID MAY be inconsistent rlm_acct_unique: WARNING: Attribute User-Name was not found in request, unique ID MAY be inconsistent rlm_acct_unique: Hashing ',Client-IP-Address = 10.0.0.2,NAS-IP-Address = 10.0.0.2,,' rlm_acct_unique: Acct-Unique-Session-ID = "f86ac4289cbec3af". ++[acct_unique] returns ok ++[files] returns noop +- entering group accounting expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/freeradius/radacct/10.0.0.2/detail-20111106 rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/10.0.0.2/detail-20111106 expand: %t -> Sun Nov 6 19:10:01 2011 ++[detail] returns ok ++[unix] returns noop expand: /var/log/freeradius/radutmp -> /var/log/freeradius/radutmp rlm_radutmp: NAS MikroTik restarted (Accounting-On packet seen) ++[radutmp] returns ok Sending Accounting-Response of id 3 to 10.0.0.2 port 48102 Finished request 1. Cleaning up request 1 ID 3 with timestamp +228 Going to the next request Ready to process requests. --------------------------------------------------------------------------------------

A tak wygląda podłączenie klienta pod wifi

Ready to process requests. rad_recv: Access-Request packet from host 10.0.0.2 port 51605, id=4, length=133 Service-Type = Framed-User NAS-Port-Id = "wlan1" User-Name = "00:12:F0:E9:74:B7" Calling-Station-Id = "00-12-F0-E9-74-B7" Called-Station-Id = "00-02-6F-46-F9-DD:MikroTik" User-Password = "" NAS-Identifier = "MikroTik" NAS-IP-Address = 10.0.0.2 +- entering group authorize ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop expand: %{User-Name} -> 00:12:F0:E9:74:B7 rlm_sql (sql): sql_set_user escaped user --> '00:12:F0:E9:74:B7' rlm_sql (sql): Reserving sql socket id: 13 expand: SELECT id, upper(mac) as UserName , 'User-Password' as Attribute, '' as Value, '==' as op FROM nodes WHERE upper(mac) = '%{SQL-User-Name}' and access=1 ORDER by id -> SELECT id, upper(mac) as UserName , 'User-Password' as Attribute, '' as Value, '==' as op FROM nodes WHERE upper(mac) = '00:12:F0:E9:74:B7' and access=1 ORDER by id rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql_getvpdata: database query error rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 13 ++[sql] returns fail Invalid user: [00:12:F0:E9:74:B7/] (from client MikroTik port 0 cli 00-12-F0-E9-74-B7) Delaying reject of request 2 for 1 seconds Going to the next request