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