Hmm... And why: select * from usergroup where username='[EMAIL PROTECTED]'; 1 17652 [EMAIL PROTECTED] blackholed 10
rad_recv: Access-Request packet from host 127.0.0.1 port 23905, id=127, length=81 User-Name = "[EMAIL PROTECTED]" User-Password = "EBLAImXtaUidLnSa" NAS-IP-Address = 10.173.65.200 +- entering group authorize expand: simbirsk -> simbirsk SIMBIRSK-ULN: Does not match: User-Name = [EMAIL PROTECTED] ++[SIMBIRSK-ULN] returns ok expand: uuuuuuuuuu -> uuuuuuuuuu UUU: Does not match: User-Name = [EMAIL PROTECTED] ++[UUU] returns ok ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop rlm_realm: Looking up realm "evdo.uln.skylink.ru" for User-Name = "[EMAIL PROTECTED]" rlm_realm: Found realm "evdo.uln.skylink.ru" rlm_realm: Proxying request from user 250092020001115 to realm evdo.uln.skylink.ru rlm_realm: Adding Realm = "evdo.uln.skylink.ru" rlm_realm: Authentication realm is LOCAL. ++[suffix] returns noop users: Matched entry DEFAULT at line 3 ++[files] returns ok expand: %{User-Name} -> [EMAIL PROTECTED] rlm_sql (sqlauth): sql_set_user escaped user --> '[EMAIL PROTECTED]' rlm_sql (sqlauth): Reserving sql socket id: 1 expand: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '[EMAIL PROTECTED]' ORDER BY id WARNING: Found User-Password == "...". WARNING: Are you sure you don't mean Cleartext-Password? WARNING: See "man rlm_pap" for more information. rlm_sql (sqlauth): User found in radcheck table expand: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '[EMAIL PROTECTED]' ORDER BY id expand: SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}' OR CLID='%{Calling-Station-Id}' order by priority -> SELECT GroupName FROM usergroup WHERE UserName='[EMAIL PROTECTED]' OR CLID='' order by priority expand: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE (usergroup.Username = '%{SQL-User-Name}' or usergroup.CLID = '%{Calling-Station-Id}') AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY usergroup.PRIORITY,radgroupcheck.id -> SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE (usergroup.Username = '[EMAIL PROTECTED]' or usergroup.CLID = '') AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY usergroup.PRIORITY,radgroupcheck.id rlm_sql (sqlauth): Released sql socket id: 1 ++[sqlauth] returns ok rad_check_password: Found Auth-Type Local !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! !!! Replacing User-Password in config items with Cleartext-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! !!! Please update your configuration so that the "known good" !!! !!! clear text password is in Cleartext-Password, and not in User-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! auth: type Local auth: user supplied User-Password matches local User-Password Login OK: [EMAIL PROTECTED]/EBLAImXtaUidLnSa] (from client localhost port 0) Sending Access-Accept of id 127 to 127.0.0.1 port 23905 Callback-Id == "0250092020001115" Finished request 3. Going to the next request Waking up in 4.9 seconds. Cleaning up request 3 ID 127 with timestamp +156 Ready to process requests. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Kalik Sent: Friday, April 04, 2008 1:43 PM To: freeradius-users@lists.freeradius.org Subject: Re: Why my schema is not working? >rlm_sql (sqlauth): User found in group mppc He is a member of another group that has higher priority. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html