Stored Procedure

Robert Graham robert_graham at
Tue Feb 3 18:47:17 CET 2015

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

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]
	if (Tmp-String-0 =~ /1/)
	update control {
		&Auth-Type := Accept

More information about the Freeradius-Users mailing list