Thanks for reply, ##sql.conf## I wrote authorize_check_query= "call proc_name...."; This is ok, but to get it in action, I mean without errors, I need to edit mysql_real_connect() I thought I could change it in freeradius-1.0.5/src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c There I found mysql_real_connect() in static int sql_init_socket() function I edited mysql_real_connect(), by putting CLIENT_MULTI_STATEMENTS in it. then Cd freeradius-1.0.5 ./configure Make Make install But there was no effect. Even I made some syntax errors in sql_mysql.c but stil there was no effect, It seems that I didn't compiled well or freeradius don't use sql_mysql.c file. need more help plzz Thanks -----Original Message----- From: freeradius-users-bounces+saeed=n-g-c.com@lists.freeradius.org [mailto:freeradius-users-bounces+saeed=n-g-c.com@lists.freeradius.org] On Behalf Of Lewis Bergman Sent: Thursday, February 09, 2006 2:10 PM To: FreeRadius users mailing list Subject: Re: A little problem - FR with Mysql Stored Procedure Saeed Ahmed wrote:
Means I need to use CLIENT_MULTI_STATEMENTS in mysql_real_connect(), so, for now, I just need this little guidance that which file should I edit to get SP working with Freeradius. I would think that sql.conf would be the place to start. After that I would guess you would have to prod around rlm_sql if you are returning an array or result set if rlm is expecting someting else.
-- Lewis Bergman Texas Communications 4309 Maple St. Abilene, TX 79602-8044 Off. 325-691-1301 Cell 325-439-0533 fax 325-695-6841 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html