Hello, I´m using Freeradius (May,24,2004) with Mysql and PEAP for Authentication of a Wireless-Lan Client. If I only check Username & Password, everything works fine.
Now, I want also to check the MAC-Address of this Wireless-Lan Client. Therefore I added the "Calling-Station-Id"-Attribute to the radcheck table. mysql> select * from radcheck; +----+----------+--------------------+----+--------------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+--------------+ | 1 | canram | User-Password | == | 123123 | | 2 | canram | Calling-Station-Id | == | 000d88522f1f | +----+----------+--------------------+----+--------------+ 2 rows in set (0.00 sec) Unfortunatelly, freeradius cannot validate this user anymore. Are there any config-files I have to change? Please see the freeradiusdebug output below. ------------------------------------------------------------------------ ---------------- rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=125 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x0200000b0163616e72616d Message-Authenticator = 0xfc56758dc0f3401bff35dc7ff7661def Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: EAP packet type response id 0 length 11 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 0 modcall[authorize]: module "files" returns notfound for request 0 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns updated for request 0 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 0 rlm_eap: EAP Identity rlm_eap: processing type md5 rlm_eap_md5: Issuing Challenge modcall[authenticate]: module "eap" returns handled for request 0 modcall: group authenticate returns handled for request 0 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x0101001604100f6fa9e8b28c56ac8f9621226c76b4ae Message-Authenticator = 0x00000000000000000000000000000000 State = 0xde6114c592a60d68537235ef5398a9b4 Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=138 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0xde6114c592a60d68537235ef5398a9b4 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020100060319 Message-Authenticator = 0xdeaffa0daedbb6a175f225a568170aa8 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 1 modcall[authorize]: module "preprocess" returns ok for request 1 modcall[authorize]: module "chap" returns noop for request 1 modcall[authorize]: module "mschap" returns noop for request 1 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 1 rlm_eap: EAP packet type response id 1 length 6 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 1 modcall[authorize]: module "files" returns notfound for request 1 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns ok for request 1 modcall: group authorize returns updated for request 1 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 1 rlm_eap: Request found, released from the list rlm_eap: EAP NAK rlm_eap: EAP-NAK asked for EAP-Type/peap rlm_eap: processing type tls rlm_eap_tls: Initiate rlm_eap_tls: Start returned 1 modcall[authenticate]: module "eap" returns handled for request 1 modcall: group authenticate returns handled for request 1 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x010200061920 Message-Authenticator = 0x00000000000000000000000000000000 State = 0xc4e92696c6aeeb274498b25d26396c08 Finished request 1 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=212 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0xc4e92696c6aeeb274498b25d26396c08 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x0202005019800000004616030100410100003d03014080713d0564ca6edc71302e4aae 719f109ec79e84b0fc7fffc07838a3aa42f000001600040005000a000900640062000300 060013001200630100 Message-Authenticator = 0x4e10e88d93fd4e8ba2838b85d22c7a17 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 2 modcall[authorize]: module "preprocess" returns ok for request 2 modcall[authorize]: module "chap" returns noop for request 2 modcall[authorize]: module "mschap" returns noop for request 2 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 2 rlm_eap: EAP packet type response id 2 length 80 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 2 modcall[authorize]: module "files" returns notfound for request 2 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns ok for request 2 modcall: group authorize returns updated for request 2 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 2 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS rlm_eap_tls: Length Included eaptls_verify returned 11 (other): before/accept initialization TLS_accept: before/accept initialization rlm_eap_tls: <<< TLS 1.0 Handshake [length 0041], ClientHello TLS_accept: SSLv3 read client hello A rlm_eap_tls: >>> TLS 1.0 Handshake [length 004a], ServerHello TLS_accept: SSLv3 write server hello A rlm_eap_tls: >>> TLS 1.0 Handshake [length 0694], Certificate TLS_accept: SSLv3 write certificate A rlm_eap_tls: >>> TLS 1.0 Handshake [length 0004], ServerHelloDone TLS_accept: SSLv3 write server done A TLS_accept: SSLv3 flush data TLS_accept:error in SSLv3 read client certificate A In SSL Handshake Phase In SSL Accept mode eaptls_process returned 13 rlm_eap_peap: EAPTLS_HANDLED modcall[authenticate]: module "eap" returns handled for request 2 modcall: group authenticate returns handled for request 2 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x0103040a19c0000006f1160301004a020000460301408060e25e0fc92a3564521abd4c 59d56e68cc5af590e0f6384737eb7867be092010970973b392195dc8161946fc4f64f0e4 06bec17ab0bb3390aa4016130dd12400040016030106940b00069000068d0002cd308202 c930820232a003020102020102300d06092a864886f70d010104050030819f310b300906 03550406130243413111300f0603550408130850726f76696e6365311230100603550407 1309536f6d65204369747931153013060355040a130c4f7267616e697a6174696f6e3112 3010060355040b13096c6f63616c686f7374311b301906035504031312436c69656e7420 6365 EAP-Message = 0x7274696669636174653121301f06092a864886f70d0109011612636c69656e74406578 616d706c652e636f6d301e170d3034303132353133323631305a170d3035303132343133 323631305a30819b310b30090603550406130243413111300f0603550408130850726f76 696e63653112301006035504071309536f6d65204369747931153013060355040a130c4f 7267616e697a6174696f6e31123010060355040b13096c6f63616c686f73743119301706 035504031310526f6f74206365727469666963617465311f301d06092a864886f70d0109 011610726f6f74406578616d706c652e636f6d30819f300d06092a864886f70d01010105 0003 EAP-Message = 0x818d0030818902818100dac525422bfedb082629a2cba44b3449c90d0ab462fb72c843 4a782098863d7eb7d7e70028c2b7ad555a51cc756cf4fa1d7091615ab450d5289553ae66 16aff014a55085d6b8fb4aee98638e426175cdd36c665c63cda177d34920eb30585edc87 73999c2980f81ad4638bbbea1c82d054023db7ef24a3ec1c3f6241a903d7f30203010001 a317301530130603551d25040c300a06082b06010505070301300d06092a864886f70d01 01040500038181007a2d921b1cf13bf2982a9178ec9ede6d88edc178a2e8bd40a0a06fb6 f0769957884cd7084537083496fd184165293f583c8e8240eb68e042c94b15752e4c07e8 0d09 EAP-Message = 0x779afa3dd55c24fa54ac292d77205d1c2477ed30d59f57caf9bd21ff2a8d16cc0911c5 0e4f295763fcb60efa3c3d2d0e43850f6e6fbe284902f6e83503650003ba308203b63082 031fa003020102020100300d06092a864886f70d010104050030819f310b300906035504 06130243413111300f0603550408130850726f76696e6365311230100603550407130953 6f6d65204369747931153013060355040a130c4f7267616e697a6174696f6e3112301006 0355040b13096c6f63616c686f7374311b301906035504031312436c69656e7420636572 74696669636174653121301f06092a864886f70d0109011612636c69656e74406578616d 706c EAP-Message = 0x652e636f6d301e170d3034303132353133323630375a Message-Authenticator = 0x00000000000000000000000000000000 State = 0xebaa8eb795cefc4c602f3dd8aec3e97b Finished request 2 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=138 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0xebaa8eb795cefc4c602f3dd8aec3e97b NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020300061900 Message-Authenticator = 0xefb2ab8e5c7c38823dc5d885a5f7b4aa Processing the authorize section of radiusd.conf modcall: entering group authorize for request 3 modcall[authorize]: module "preprocess" returns ok for request 3 modcall[authorize]: module "chap" returns noop for request 3 modcall[authorize]: module "mschap" returns noop for request 3 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 3 rlm_eap: EAP packet type response id 3 length 6 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 3 modcall[authorize]: module "files" returns notfound for request 3 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 1 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 1 modcall[authorize]: module "sql" returns ok for request 3 modcall: group authorize returns updated for request 3 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 3 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS rlm_eap_tls: Received EAP-TLS ACK message rlm_eap_tls: ack handshake fragment handler eaptls_verify returned 1 eaptls_process returned 13 rlm_eap_peap: EAPTLS_HANDLED modcall[authenticate]: module "eap" returns handled for request 3 modcall: group authenticate returns handled for request 3 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x010402f71900170d3036303132343133323630375a30819f310b300906035504061302 43413111300f0603550408130850726f76696e63653112301006035504071309536f6d65 204369747931153013060355040a130c4f7267616e697a6174696f6e3112301006035504 0b13096c6f63616c686f7374311b301906035504031312436c69656e7420636572746966 69636174653121301f06092a864886f70d0109011612636c69656e74406578616d706c65 2e636f6d30819f300d06092a864886f70d010101050003818d0030818902818100d4c5b1 9724f164acf1ffb189db1c8fbff4f14396ea7cb1e90f78d69451725377895dfe52ccb99b 41e8 EAP-Message = 0x0ddeb58b127a943f4f58cbc562878192fbdc6fece9f871e7c130d35cf5188817e9b133 249edd2a1c75d31043ae87553cec7a77ef26aa7d74281db9b77e17c6446c5dd9b188b432 50ca0229963722a123a726b00b4027fd0203010001a381ff3081fc301d0603551d0e0416 041468d36d3e1ee7bc9d5a057021c363da1365d1ade33081cc0603551d230481c43081c1 801468d36d3e1ee7bc9d5a057021c363da1365d1ade3a181a5a481a230819f310b300906 03550406130243413111300f0603550408130850726f76696e6365311230100603550407 1309536f6d65204369747931153013060355040a130c4f7267616e697a6174696f6e3112 3010 EAP-Message = 0x060355040b13096c6f63616c686f7374311b301906035504031312436c69656e742063 657274696669636174653121301f06092a864886f70d0109011612636c69656e74406578 616d706c652e636f6d820100300c0603551d13040530030101ff300d06092a864886f70d 01010405000381810033c00b66b1e579ef73a06798252dab8d5e5511fc00fd276d80d12f 834777c6743fdc2743fca1507704e4bc0979e4f60ac3ad9ee83e6f347369229d1f77229b a2e982359da563024a00163dba6d6c986c0bad28af85132ff8f0d76501bf1b7c2dff658c e1e62c01997b6e64e3e8d4373354ce9912847651539063b85bbc5485c516030100040e00 0000 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x6a152788b489851c529373300800ea88 Finished request 3 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=324 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0x6a152788b489851c529373300800ea88 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020400c01980000000b616030100861000008200801f42c9b951196547dc8c43ef65be 2148d01bcbd702e16c55078873d4098cb4fadd4ac91d260377e0280578b8fc1d74a9a472 41c5972ae1618a5f06efeff4f0dc239af9c1566186eea8c2f6fd55305293c50abb73ef6e 9421e077280477350d119026b363a7e668bfb4dda35abd1009e952a80378669b08e9ec19 f03389bc52761403010001011603010020e7907e3423de290d3b633c00f480f232aaf5a4 f964a32869da048a760e4a9aca Message-Authenticator = 0x4b7e2c057c569a6cbb2307fe2fab0100 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 4 modcall[authorize]: module "preprocess" returns ok for request 4 modcall[authorize]: module "chap" returns noop for request 4 modcall[authorize]: module "mschap" returns noop for request 4 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 4 rlm_eap: EAP packet type response id 4 length 192 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 4 modcall[authorize]: module "files" returns notfound for request 4 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 0 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' 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 4 modcall: group authorize returns updated for request 4 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 4 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS rlm_eap_tls: Length Included eaptls_verify returned 11 rlm_eap_tls: <<< TLS 1.0 Handshake [length 0086], ClientKeyExchange TLS_accept: SSLv3 read client key exchange A rlm_eap_tls: <<< TLS 1.0 ChangeCipherSpec [length 0001] rlm_eap_tls: <<< TLS 1.0 Handshake [length 0010], Finished TLS_accept: SSLv3 read finished A rlm_eap_tls: >>> TLS 1.0 ChangeCipherSpec [length 0001] TLS_accept: SSLv3 write change cipher spec A rlm_eap_tls: >>> TLS 1.0 Handshake [length 0010], Finished TLS_accept: SSLv3 write finished A TLS_accept: SSLv3 flush data (other): SSL negotiation finished successfully SSL Connection Established eaptls_process returned 13 rlm_eap_peap: EAPTLS_HANDLED modcall[authenticate]: module "eap" returns handled for request 4 modcall: group authenticate returns handled for request 4 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x0105003119001403010001011603010020431f3453d67a09c5a957714ac4f830a3d644 ce9e3fd240d727d820158f78e3b3 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x91506b3601ce44bf616c82aee1b8a1dd Finished request 4 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=138 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0x91506b3601ce44bf616c82aee1b8a1dd NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020500061900 Message-Authenticator = 0x1b77af8cebe2792f73db2e06b0c126e2 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 5 modcall[authorize]: module "preprocess" returns ok for request 5 modcall[authorize]: module "chap" returns noop for request 5 modcall[authorize]: module "mschap" returns noop for request 5 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 5 rlm_eap: EAP packet type response id 5 length 6 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 5 modcall[authorize]: module "files" returns notfound for request 5 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 5 modcall: group authorize returns updated for request 5 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 5 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS rlm_eap_tls: Received EAP-TLS ACK message rlm_eap_tls: ack handshake is finished eaptls_verify returned 3 eaptls_process returned 3 rlm_eap_peap: EAPTLS_SUCCESS modcall[authenticate]: module "eap" returns handled for request 5 modcall: group authenticate returns handled for request 5 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x010600201900170301001580226ede7d9c14ff5aa8565689635df95fced9e354 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x3c5b2e9d5500d67553a162ec846cdcf0 Finished request 5 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=166 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0x3c5b2e9d5500d67553a162ec846cdcf0 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020600221900170301001701de6926f3b38c60e24dd22eb94fe5fc5ca00dac4d41e7 Message-Authenticator = 0x9b6126ebe5c8c82b44f8d954390a302d Processing the authorize section of radiusd.conf modcall: entering group authorize for request 6 modcall[authorize]: module "preprocess" returns ok for request 6 modcall[authorize]: module "chap" returns noop for request 6 modcall[authorize]: module "mschap" returns noop for request 6 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 6 rlm_eap: EAP packet type response id 6 length 34 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 6 modcall[authorize]: module "files" returns notfound for request 6 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns ok for request 6 modcall: group authorize returns updated for request 6 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 6 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS eaptls_verify returned 7 rlm_eap_tls: Done initial handshake eaptls_process returned 7 rlm_eap_peap: EAPTLS_OK rlm_eap_peap: Session established. Decoding tunneled attributes. rlm_eap_peap: Identity - canram rlm_eap_peap: Tunneled data is valid. PEAP: Got tunneled EAP-Message EAP-Message = 0x0206000b0163616e72616d PEAP: Got tunneled identity of canram PEAP: Setting default EAP type for tunneled EAP session. PEAP: Setting User-Name to canram PEAP: Sending tunneled request EAP-Message = 0x0206000b0163616e72616d FreeRADIUS-Proxied-To = 127.0.0.1 User-Name = "canram" Processing the authorize section of radiusd.conf modcall: entering group authorize for request 6 modcall[authorize]: module "preprocess" returns ok for request 6 modcall[authorize]: module "chap" returns noop for request 6 modcall[authorize]: module "mschap" returns noop for request 6 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 6 rlm_eap: EAP packet type response id 6 length 11 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 6 modcall[authorize]: module "files" returns notfound for request 6 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): No matching entry in the database for request from user [canram] rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns notfound for request 6 modcall: group authorize returns updated for request 6 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 6 rlm_eap: EAP Identity rlm_eap: processing type mschapv2 rlm_eap_mschapv2: Issuing Challenge modcall[authenticate]: module "eap" returns handled for request 6 modcall: group authenticate returns handled for request 6 PEAP: Got tunneled reply RADIUS code 11 EAP-Message = 0x010700201a0107001b1095832a7a34a51cd90bf9b89cac4b205863616e72616d Message-Authenticator = 0x00000000000000000000000000000000 State = 0x3ae0a424865cfca18bca4fba00c6ec2e PEAP: Processing from tunneled session code 0x81711b8 11 EAP-Message = 0x010700201a0107001b1095832a7a34a51cd90bf9b89cac4b205863616e72616d Message-Authenticator = 0x00000000000000000000000000000000 State = 0x3ae0a424865cfca18bca4fba00c6ec2e PEAP: Got tunneled Access-Challenge modcall[authenticate]: module "eap" returns handled for request 6 modcall: group authenticate returns handled for request 6 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x010700371900170301002c49522bf26ac96bdefb22d05bb8f8202b7e27bf24143c3da5 066663e4a8aeaebf7ab60c54434d641463bdb214 Message-Authenticator = 0x00000000000000000000000000000000 State = 0xaf67191da11ad1c702effc5f41e430f5 Finished request 6 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=220 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0xaf67191da11ad1c702effc5f41e430f5 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020700581900170301004d4a86af14b6dfcf46e883a4a91f8617646e963c0b93dee04b 16c5be35302ff3bf7a1ef02f8e5bc6668bd9fbda7f1b262756ce7ccd79ee81d545237aeb dba862d3f740a13e176d03bb4432d7dab2 Message-Authenticator = 0xaaa50f9816037ca646f07b0d11c42dbc Processing the authorize section of radiusd.conf modcall: entering group authorize for request 7 modcall[authorize]: module "preprocess" returns ok for request 7 modcall[authorize]: module "chap" returns noop for request 7 modcall[authorize]: module "mschap" returns noop for request 7 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 7 rlm_eap: EAP packet type response id 7 length 88 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 7 modcall[authorize]: module "files" returns notfound for request 7 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 1 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 1 modcall[authorize]: module "sql" returns ok for request 7 modcall: group authorize returns updated for request 7 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 7 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS eaptls_verify returned 7 rlm_eap_tls: Done initial handshake eaptls_process returned 7 rlm_eap_peap: EAPTLS_OK rlm_eap_peap: Session established. Decoding tunneled attributes. rlm_eap_peap: EAP type mschapv2 rlm_eap_peap: Tunneled data is valid. PEAP: Got tunneled EAP-Message EAP-Message = 0x020700411a0207003c31c5b381bdaee23ea115d7e359f2a047ce000000000000000008 305d778c45ea50e1eb3639c06ee4f38d76377206eba1b40063616e72616d PEAP: Setting User-Name to canram PEAP: Adding old state with 3a e0 PEAP: Sending tunneled request EAP-Message = 0x020700411a0207003c31c5b381bdaee23ea115d7e359f2a047ce000000000000000008 305d778c45ea50e1eb3639c06ee4f38d76377206eba1b40063616e72616d FreeRADIUS-Proxied-To = 127.0.0.1 User-Name = "canram" State = 0x3ae0a424865cfca18bca4fba00c6ec2e Processing the authorize section of radiusd.conf modcall: entering group authorize for request 7 modcall[authorize]: module "preprocess" returns ok for request 7 modcall[authorize]: module "chap" returns noop for request 7 modcall[authorize]: module "mschap" returns noop for request 7 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 7 rlm_eap: EAP packet type response id 7 length 65 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 7 modcall[authorize]: module "files" returns notfound for request 7 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 0 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): No matching entry in the database for request from user [canram] rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns notfound for request 7 modcall: group authorize returns updated for request 7 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 7 rlm_eap: Request found, released from the list rlm_eap: EAP/mschapv2 rlm_eap: processing type mschapv2 Processing the authenticate section of radiusd.conf modcall: entering group Auth-Type for request 7 rlm_mschap: No User-Password configured. Cannot create LM-Password. rlm_mschap: No User-Password configured. Cannot create NT-Password. rlm_mschap: No LM-Password or NT-Password attribute found. Cannot perform MS-CHAP authentication. modcall[authenticate]: module "mschap" returns fail for request 7 modcall: group Auth-Type returns fail for request 7 rlm_eap: Freeing handler modcall[authenticate]: module "eap" returns reject for request 7 modcall: group authenticate returns reject for request 7 auth: Failed to validate the user. Login incorrect: [canram/<no User-Password attribute>] (from client localhost port 0) PEAP: Got tunneled reply RADIUS code 3 EAP-Message = 0x04070004 Message-Authenticator = 0x00000000000000000000000000000000 PEAP: Processing from tunneled session code 0x8172100 3 EAP-Message = 0x04070004 Message-Authenticator = 0x00000000000000000000000000000000 PEAP: Tunneled authentication was rejected. rlm_eap_peap: FAILURE modcall[authenticate]: module "eap" returns handled for request 7 modcall: group authenticate returns handled for request 7 Sending Access-Challenge of id 0 to 192.168.200.245:2048 EAP-Message = 0x010800261900170301001ba172a83404fc1aa21d836e1336e45a81c91c9bcc7376d049 0d25e4 Message-Authenticator = 0x00000000000000000000000000000000 State = 0xad921f7cc0204b10f94e5cff1720ff73 Finished request 7 Going to the next request rl_next: returning NULL Waking up in 6 seconds... rad_recv: Access-Request packet from host 192.168.200.245:2048, id=0, length=170 User-Name = "canram" NAS-IP-Address = 192.168.200.245 Called-Station-Id = "0006253bdc49" Calling-Station-Id = "000d88522f1f" NAS-Identifier = "0006253bdc49" NAS-Port = 34 Framed-MTU = 1400 State = 0xad921f7cc0204b10f94e5cff1720ff73 NAS-Port-Type = Wireless-802.11 EAP-Message = 0x020800261900170301001b302777624b1d771512e1dbccc509daf8fa19ff85bdf37b68 7303b6 Message-Authenticator = 0xba8a8051364f3d55ad4f214da5498d22 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 8 modcall[authorize]: module "preprocess" returns ok for request 8 modcall[authorize]: module "chap" returns noop for request 8 modcall[authorize]: module "mschap" returns noop for request 8 rlm_realm: No '@' in User-Name = "canram", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 8 rlm_eap: EAP packet type response id 8 length 38 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 8 modcall[authorize]: module "files" returns notfound for request 8 radius_xlat: 'canram' rlm_sql (sql): sql_set_user escaped user --> 'canram' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'canram' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'canram' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'canram' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 8 modcall: group authorize returns updated for request 8 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 8 rlm_eap: Request found, released from the list rlm_eap: EAP/peap rlm_eap: processing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS eaptls_verify returned 7 rlm_eap_tls: Done initial handshake eaptls_process returned 7 rlm_eap_peap: EAPTLS_OK rlm_eap_peap: Session established. Decoding tunneled attributes. rlm_eap_peap: Received EAP-TLV response. rlm_eap_peap: Tunneled data is valid. rlm_eap_peap: Had sent TLV failure, rejecting. rlm_eap: Handler failed in EAP/peap rlm_eap: Failed in EAP select modcall[authenticate]: module "eap" returns invalid for request 8 modcall: group authenticate returns invalid for request 8 auth: Failed to validate the user. Login incorrect: [canram/<no User-Password attribute>] (from client linksys port 34 cli 000d88522f1f) Delaying request 8 for 1 seconds Finished request 8 Going to the next request rl_next: returning NULL Waking up in 6 seconds... --- Walking the entire request list --- Sending Access-Reject of id 0 to 192.168.200.245:2048 EAP-Message = 0x04080004 Message-Authenticator = 0x00000000000000000000000000000000 Cleaning up request 8 ID 0 with timestamp 408060e2 Nothing to do. Sleeping until we see a request. ------------------------------------------------------------------------ -------- It looks like the PEAP-Module is not working correctly with the mysql-Module?! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html