MSSQL Querys -> No matching entry

[Fernando Brito]

Hi, I'm trying to make a simple authorization using the mssql module but
when Radius execute all the querys "No matching entry..." is the answer.
I'm completely sure that all the data store in my database is correct,
but I always had the same responce:


radiusd -X -------------------------

radius_xlat:  '00:11:7C:00:01:57'
rlm_sql (mssql): sql_set_user escaped user --> '00:11:7C:00:01:57'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = '00:11:7C:00:01:57' ORDER BY id'
rlm_sql (mssql): Reserving sql socket id: 4
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
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
rlm_sql_unixodbc: 'HY000 [unixODBC] Msg 208, Level 16, State 1, Server
RELLIKII, Line 1 Invalid object name 'usergroup'. '
rlm_sql_getvpdata: database query error
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '00:11:7C:00:01:57' ORDER BY id'
query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '00:11:7C:00:01:57' ORDER BY id
rlm_sql_unixodbc: 'HY000 [unixODBC] Msg 208, Level 16, State 1, Server
RELLIKII, Line 1 Invalid object name 'radreply'. '
rlm_sql_getvpdata: database query error
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00:11:7C:00:01:57' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
query:  SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00:11:7C:00:01:57' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql_unixodbc: 'HY000 [unixODBC] Msg 208, Level 16, State 1, Server
RELLIKII, Line 1 Invalid object name 'usergroup'. '
rlm_sql_getvpdata: database query error
rlm_sql (mssql): No matching entry in the database for request from user
[00:11:7C:00:01:57]
rlm_sql (mssql): Released sql socket id: 4
  modcall[authorize]: module "mssql" returns notfound for request 0

------------------------------------


Is there something that I'm missing?!?! Thanks!!


NanO