After many years we want to migrate from Steel-belted Radius to Freeradius. Current Freeradius setup (and working) Centos 7.5 MSSQL (due to application requirements) Default sql schema as provided with Freeradius. The only requirement we have is that we need to lookup the username in a table somewhere in our own mssql db (not the freeradius db) If the username is in the table: send accept. (not even using password)
From debug i can see this:
(0) sql: EXPAND %{User-Name} (0) sql: --> 32490013984 (0) sql: SQL-User-Name set to '32490013984' rlm_sql (sql): Reserved connection (0) (0) sql: EXPAND SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id (0) sql: --> SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '32490013984' ORDER BY id (0) sql: Executing select query: SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '32490013984' ORDER BY id (0) sql: User found in radcheck table how can i adjust the select query and change it to fit my own sql schema. I could not find it in main/mssql/queries.conf Is it possible? Thanks!