[MYSQL] Radius and MySql Stored Procedure

"Tan hanyin" <[email protected]> Thu, 12 Jan 2006 09:18:10 +0000
Newsgroups gmane.comp.gnu.radius.general
Message-ID <[email protected]>
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