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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html