Why my schema is not working?
Dmitry A. Sysoev
snaut at snaut.ru
Fri Apr 4 14:45:01 CEST 2008
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'250092020001115 at evdo.uln.skylink.ru' ORDER BY id
1 4732 250092020001115 at evdo.uln.skylink.ru Cleartext-Password
EBLAImXtaUidLnSa :=
SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'250092020001115 at evdo.uln.skylink.ru' ORDER BY id
1 4147 250092020001115 at evdo.uln.skylink.ru Callback-Id
0250092020001115 ==
SELECT GroupName FROM usergroup WHERE
UserName='250092020001115 at evdo.uln.skylink.ru' OR CLID='' order by priority
1 blackholed
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
(usergroup.Username = '250092020001115 at evdo.uln.skylink.ru' or
usergroup.CLID = '') AND usergroup.GroupName = radgroupcheck.GroupName ORDER
BY usergroup.PRIORITY,radgroupcheck.id
1 181 blackholed Auth-Type Reject :=
2 182 blackholed Fall-Through No =
-----Original Message-----
From: freeradius-users-bounces+snaut=snaut.ru at lists.freeradius.org
[mailto:freeradius-users-bounces+snaut=snaut.ru at lists.freeradius.org] On
Behalf Of Ivan Kalik
Sent: Friday, April 04, 2008 4:32 PM
To: freeradius-users at lists.freeradius.org
Subject: RE: Why my schema is not working?
What happens when you copy and paste the query from the debug? Can you post
the result?
I would doubt that the code is "alergic" to that particular group and works
for others. "blackholed" doesn't look like a reserved word.
Queries are executed by mysql not radius server.
Ivan Kalik
Kalik Informatika ISP
More information about the Freeradius-Users
mailing list