Re: Mysql procedure and freeradius

I used mysql 5 headers.Maybe SP were fixed onlu in freeradius 1.1.2?I'll try to update freeradius..and then write a letter. I think maybe it could be a problem if the version of mysql.h that was during compilation used predates stored proceedures? - List info/subscribe/unsubscribe? See

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

Mysql procedure and freeradius

Hi All. I have the trouble with mysql freeradius.I begin to write own authorization using mysql procedures.In sql.conf i have this --- authorize_check_query = CALL DB.auth_check('%{SQL-User-Name}'); -- And in DB have procedure auth_check with this code: --- CREATE TEMPORARY TABLE DB.make_auth