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
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
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');
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,
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
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
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
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
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
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
10 matches
Mail list logo