On Tue, 15 Nov 2005, Fernando Brito wrote: > query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = > '00:11:7C:00:01:57' ORDER BY id > radius_xlat: 'SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op > FROM radgroupcheck,usergroup WHERE usergroup.Username = '00:11:7C:00:01:57' > AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' > query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = > '00:11:7C:00:01:57' ORDER BY id
Have you tried those SQL queries manually? Looks like maybe your "usergroup" and "radreply" table don't exist or cannot be accessed... What I do is try to run those queries manually on the database to see if they work and then double-check the configs to make sure that you're using the right database name, etc. Kristina - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html