Mysql procedure and freeradius

Jurgen van Vliet jurgen at wanbound.com
Thu Aug 10 09:38:47 CEST 2006


Hi,

That cant be the case, im using mysql 5 and a SP with freeradius 1.1.2
without any problems or recompiling.
It must be an other issue. Maybe the sql user you let freeradius connect
with has no rights to start the SP ? 

Regards, 

Jurgen
-----Oorspronkelijk bericht-----
Van: freeradius-users-bounces+jurgen=wanbound.com at lists.freeradius.org
[mailto:freeradius-users-bounces+jurgen=wanbound.com at lists.freeradius.org]
Namens Alesha
Verzonden: woensdag 9 augustus 2006 18:57
Aan: FreeRadius users mailing list
Onderwerp: Re: Mysql procedure and freeradius

> ensure the user has Process_priv.
>
> Also there is the security_type flag in the mysql.proc table which 
> defines who the proceedure runs as (invoker or definer)
>
> Its all quite well documented on the mysql website.

On mysql website i found that for executing stored procedures need a special
flag for connection(CLIENT_MULTI_STATEMENTS).So..i need to rewrite
freeradius source code to enabling mysql procedures.This is very bad news
for me..because i know C/C++ not very good.Maybe better to include special
option for rlm_sql_mysql to enable SP in freeradius?
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html




More information about the Freeradius-Users mailing list