How do you execute a stored proc against a sql sever to authenticate a user. What do you do with the response to either accept or reject the user? We are trying to authenticate the user by returning a 1 for yes or 0 for no. The stored proc is executed by the update control but the User Password is not being added, its only adding the User-name and leaving the Userpassword field blank. Tmp-String-0 := "%{sql:EXEC [IsUserAuthenticated] ('%{User-Name}','%{User-Password}'" } if (Tmp-String-0 =~ /1/) update control { &Auth-Type := Accept }
On Feb 3, 2015, at 12:47 PM, Robert Graham <robert_graham@uhaul.com> wrote:
How do you execute a stored proc against a sql sever to authenticate a user. What do you do with the response to either accept or reject the user?
Via an SQL query. :)
The stored proc is executed by the update control but the User Password is not being added, its only adding the User-name and leaving the Userpassword field blank.
Probably because there is no User-Password in the request. As always, run the server in debugging mode to see what’s going on. And it’s generally a bad idea to have SQL do authentication. SQL is for a database. FreeRADIUS is for authentication. Alan DeKok.
participants (2)
-
Alan DeKok -
Robert Graham