Displaying 6 results from an estimated 6 matches for "client_multi_statements".
2006 Oct 07
0
No subject
...p; I don't think I've changed anything related to that between<br>> rc7 and rc8.<br><br>I guess the difference is that I removed this code:
<br><br>#ifdef CLIENT_MULTI_STATEMENTS<br> /* Updates require this because everything is committed in one large<br> SQL statement. */<br> &...
2008 Jan 21
1
asterisk-addons-1.6.0-beta1---Error
...error during make:
[root at Cancer asterisk-addons-1.6.0-beta1]# make
make[1]: Entering directory `/usr/src/asterisk/asterisk-addons-1.6.0-beta1'
[CC] app_addon_sql_mysql.c -> app_addon_sql_mysql.o
app_addon_sql_mysql.c: In function `aMYSQL_connect':
app_addon_sql_mysql.c:266: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use in this function)
app_addon_sql_mysql.c:266: error: (Each undeclared identifier is reported only once
app_addon_sql_mysql.c:266: error: for each function it appears in.)
app_addon_sql_mysql.c:266: error: `CLIENT_MULTI_RESULTS' undeclared (first use in this function)
m...
2006 Oct 21
1
mysql-5.0.26 stored procedure authorization, take 2
...nc.html
On the other hand with my previous mysql installation (mysql-5.0.24-r1) this
error is gone (I checked by downgrading).
My dovecot-sql.conf:
driver = mysql
connect = host=/var/run/mysqld/mysqld.sock dbname=mailbase user=mailuser
password=******** client_flags=65536
#655536 is equivalent of CLIENT_MULTI_STATEMENTS flag
#yes, I still insist
on using stored proc for authorization. This gives me few usefull
features I like.
password_query = call Authenticat('%u', '%n', '%d')
With this config on mysq-5.0.26 I get
"...Commands out of sync; you can't run this command now..."...
2010 Mar 05
2
Bug in driver-mysql.c + fix
I tried to use MySQL stored procedures from dovecot:
password_query = CALL user_pass_check('%n', '%d', '%w')
user_query = CALL user_info('%n', '%d')
This failed with the message:
User query failed: PROCEDURE imap.user_info can't return a result set in the given context
The root of this problem is that mysql_real_connect() needs to be called with
2006 Oct 27
0
RMySQL and stored procedures
...plemented", but I was trying to
get around the problem connecting like that:
drv <- dbDriver("MySQL")
con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName,
host=MyHost, client.flag="196608" )
where 196608 is a combination of CLIENT_MULTI_RESULTS and
CLIENT_MULTI_STATEMENTS as mentioned in the
mysql_real_connect() documentation. Without these flags stored
procedures calls do not run at all.
I also do fetching the results in a loop - as suggested in the doc, so:
doStoredProcedureFetch <- function( connection, sql ) {
res <- dbSendQuery( connection, sql )...
2006 May 05
2
Rails MySQL Stored Procedure Fun
...I have designed the results page
in Rails (using model calls to find_by_sql to get results) and tested
successfully on Webrick on a windows box. I previously had a problem
with returning data from a MySQL stored procedure (due to Activerecord''s
MySQL connection adapter not passing the CLIENT_MULTI_STATEMENTS and
CLIENT_MULTI_RESULTS flags in the connection options) but overcame this
by hacking the ActiveRecord MySQL connection adapter and adding the
required options to be passed to the mysql_real_connect call.
I ported the application to a production Apache / Ubuntu server which
runs Rails MySQL s...