A little problem - FR with Mysql Stored Procedure

[Saeed Ahmed]

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 at lists.freeradius.org
[mailto:freeradius-users-bounces+saeed=n-g-c.com at 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