Why my schema is not working?

Dmitry A. Sysoev snaut at snaut.ru
Fri Apr 4 15:01:18 CEST 2008


Yes, a'm fix it. 



-----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:57 PM
To: freeradius-users at lists.freeradius.org
Subject: RE: Why my schema is not working?

And the warning about using User-Password is now gone from the debug?

Ivan Kalik
Kalik Informatika ISP


Dana 4/4/2008, "Dmitry A. Sysoev" <snaut at snaut.ru> piše:

>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,radgro
>upche 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
>
>-
>List info/subscribe/unsubscribe? See 
>http://www.freeradius.org/list/users.html
>
>

-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html





More information about the Freeradius-Users mailing list