[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-gnu-radius] [MYSQL] Radius and MySql Stored Procedure
From: |
Tan hanyin |
Subject: |
[Help-gnu-radius] [MYSQL] Radius and MySql Stored Procedure |
Date: |
Thu, 12 Jan 2006 09:20:59 +0000 |
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