MSSQL Querys -> No matching entry

[Kristina Pfaff-Harris]

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