Why my schema is not working?

Dmitry A. Sysoev snaut at snaut.ru
Fri Apr 4 15:14:09 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	=

I'm see happy result :) but I'm not see this result in radius.

-----Original Message-----
From: A.L.M.Buxey at lboro.ac.uk [mailto:A.L.M.Buxey at lboro.ac.uk] 
Sent: Friday, April 04, 2008 5:11 PM
To: snaut at snaut.ru; FreeRadius users mailing list
Subject: Re: Why my schema is not working?

Hi,
> Yes, I do it. But the my problem is still persent. 

have you tried running exactly the same query that FreeRADIUS runs - as seen
in your log - manually?  do you get to see the same happy result?

alan




More information about the Freeradius-Users mailing list