search for: client_multi_stat

Displaying 6 results from an estimated 6 matches for "client_multi_stat".

2006 Oct 07
0
No subject
...p;&nbsp;&nbsp; I don't think I've changed anything related to that between<br>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rc7 and rc8.<br><br>I guess the difference is that I removed this code: <br><br>#ifdef CLIENT_MULTI_STATEMENTS<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Updates require this because everything is committed in one large<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQL statement. */<br>&nbsp;&nbs...
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 funct...
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, s...
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 M...