Hi everyone,

I have a question here, :)

Do Radius support MySql stored procedure? I modified the part "check_attr_query" and "reply_attr_query" in the /raddb/sqlserver file to suit the scenario I wanted, as follow (that is, calling the stored procedure):
--------------------------------------------------------------------------------------------------
# This query returns a list of a/v pairs to be added to user's check pairs.
check_attr_query        call checkAttrQuery('%u')

# The query is used only if the user is authorized successfully.
reply_attr_query        call replyAttrQuery('%u')
--------------------------------------------------------------------------------------------------

The problem is, upon client login, I get this error in the radius log file. Whereas, when I execute the same MySql stored procedures in Mysql Query Browser, it works just fine.

"Auth.error: [MYSQL] PROCEDURE RADIUS.checkAttrQuery can't return a result set in the given context"

==>How do I solve this problem? I'm using MySql 5.018 and GNU-Radius 1.3
Any assitance is greatly appreciated! Thanks!

Cheers!

_________________________________________________________________
Find love online with MSN Personals. http://match.msn.com.my/match/mt.cfm?pg=channel



_______________________________________________
Help-gnu-radius mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/help-gnu-radius

Reply via email to