MSSQL Querys -> No matching entry
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
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
participants (2)
-
Fernando Brito -
Kristina Pfaff-Harris