Re: FR with MySQL - Stored Procedures

2007-05-14 Thread Alan DeKok
Thomas Martens wrote: I added your hack to my version too. I also don't get any errors till now. It seems to work with SP, and also normal SQL-querys. Sounds good to me. Here is the diff...so please, a FR developer take a look at it;) Nicolas is looking into it. It should be in 1.1.7

RE: FR with MySQL - Stored Procedures

2007-05-14 Thread Gunther
That is great news! Alan DeKok wrote: Thomas Martens wrote: I added your hack to my version too. I also don't get any errors till now. It seems to work with SP, and also normal SQL-querys. Sounds good to me. Here is the diff...so please, a FR developer take a look at it;) Nicolas is

RE: FR with MySQL - Stored Procedures

2007-05-10 Thread Gunther
Did some further research on the MySQL - FR Stored Procedure (SP) problem. When calling the SP, MySQL always returns two results. One is the actual result and the other is the number of affected rows, which is different to a normal e.g. SELECT query. SP: mysql call CheckIt('myString');

RE: FR with MySQL - Stored Procedures

2007-05-10 Thread Thomas Martens
I added your hack to my version too. I also don't get any errors till now. It seems to work with SP, and also normal SQL-querys. I've modified your patch with some comments and also added a mysql_version check, so that the patch will only apply to MySQL version 5. Here is the diff...so please,

Re: FR with MySQL - Stored Procedures

2007-05-08 Thread cky
Hello Gunther, I've the same problems here. I use also a simple SP (just for testing) and I run into the same problems, like you. I've also patched the sql_mysql.c file and added the CLIENT_MULTI_STATEMENTS flag. After that, I get also the error 2014. After that, I added to every function, a

Re: FR with MySQL - Stored Procedures

2007-05-08 Thread cky
so...after a while I found a workaround for the SP problem..well, is quick and dirty and probably not the best solution. I've added to the function sql_fetch_row in sql_mysql.c a simple sql_free_result(sqlsocket, config);...see the diff below. Now my Stored Procedure works correct and as expected

RE: FR with MySQL - Stored Procedures

2007-05-08 Thread Gunther
a second time, and there are still some results not freed. Gunther -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] g] On Behalf Of cky Sent: Tuesday, 08 May 2007 10:18 AM To: freeradius-users@lists.freeradius.org Subject: Re: FR with MySQL - Stored Procedures so...after

Re: FR with MySQL - Stored Procedures

2007-05-07 Thread Gunther
I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my operating system (CentOS 4.4)). So

Re: FR with MySQL - Stored Procedures

2007-05-07 Thread Alan DeKok
Gunther wrote: I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my operating

RE: FR with MySQL - Stored Procedures

2007-05-07 Thread Gunther
Alan DeKok wrote I forgot to mention that the problem I reported previously is actually not 'Stored Procedure' related, but related to the MySQL client_flag 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored Procedures and is causing the problem (at least with my