Hi, I've installed freeradius and it was working fine with users file authentication but when I add sql module ( freeradius's wiki->SQL_HOWTO ) when I try radtest with a username that is in db, authentication failed, and it's the out put of debug mode:
rad_recv: Access-Request packet from host 127.0.0.1:1026, id=168, length=147 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "n2test" MS-CHAP-Challenge = 0x409da00bcdf49bf9ac057995c300f40b MS-CHAP2-Response = 0x24003e5162483aabe749b5dd4550f8e68be60000000000000000980209d9d70a472836d24769c794daa603e726bc8f27c73e Calling-Station-Id = "192.168.1.4" NAS-IP-Address = 127.0.0.1 NAS-Port = 0 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 12 modcall[authorize]: module "preprocess" returns ok for request 12 modcall[authorize]: module "chap" returns noop for request 12 rlm_mschap: Found MS-CHAP attributes. Setting 'Auth-Type = mschap' modcall[authorize]: module "mschap" returns ok for request 12 rlm_realm: No '@' in User-Name = "n2test", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 12 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 12 users: Matched entry DEFAULT at line 153 users: Matched entry DEFAULT at line 172 users: Matched entry DEFAULT at line 184 modcall[authorize]: module "files" returns ok for request 12 radius_xlat: 'n2test' rlm_sql (sql): sql_set_user escaped user --> 'n2test' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'n2test' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns fail for request 12 modcall: leaving group authorize (returns fail) for request 12 Finished request 12 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 12 ID 168 with timestamp 471cb73a Nothing to do. Sleeping until we see a request. Why this happens? can this was for some missing information in my db?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html