And any ideas? I'm sure, that this bug is very important.

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