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