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