Mysql procedure and freeradius

[Alan Lumb]

I think maybe it could be a problem if the version of mysql.h that was
during compilation used predates stored proceedures?

> 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
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>