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 = -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Kalik Sent: Friday, April 04, 2008 4:32 PM To: freeradius-users@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