[Help-gnu-radius] [MYSQL] Radius and MySql Stored Procedure

[Tan hanyin]

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!

_________________________________________________________________
Block pop-up ads with MSN Toolbar. http://toolbar.msn.com.my/