hello,
i have a problem in this sql-statement (in mssql.conf):
authorize_check_query = "SELECT id,UserName,Attribute,Value,op,right FROM ${authcheck_table} WHERE ((Username = '%{SQL-User-Name}') AND (right = 1) AND (CallingID = '%{Calling-Station-Id}')) OR ('%{Called-Station-Id}' IN (SELECT TelNr FROM Emergencynbrs)) ORDER BY id"
if i´m using the OR-statement in my authorize_check_query,i can not authentificate the User! i have tryed too with OR (1=1) but no way.
without the OR part off the sql Statement it work´s correctly.
any help is apprecied.
Live.com Jouez et gagnez des Xbox 360!
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html