SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'[EMAIL PROTECTED]' ORDER BY id

1       4732    [EMAIL PROTECTED]       Cleartext-Password
EBLAImXtaUidLnSa        :=

 SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'[EMAIL PROTECTED]' ORDER BY id

1       4147    [EMAIL PROTECTED]       Callback-Id
0250092020001115        ==

SELECT GroupName FROM usergroup WHERE
UserName='[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2008 5:11 PM
To: [EMAIL PROTECTED]; 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

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

Reply via email to