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: [email protected]
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
