similar to: RMySQL and stored procedures

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

Hi, I'm trying to install asterisk-addons-1.6.0-beta1 on my machine. But getting following 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:

Hi All. I have a question about calling MySQL stored procedures that is a little different from the usual. I know stored procedures are not really the ''Rails way'' but in this case there is no other way to accomplish the same task and I have used them successfully. Background: I am using a query to produce a real-time status of items flowing through a factory. The query

Hello Simon, Hello everyone, I have a problem with retrieving database-queries chunkwise. In my query (Postgresql-Database, Postgres-Version 9.1) dbHasCompleted seems to always return TRUE. dbGetQuery works for smaller tables, but not for the whole query, since then a Heap-Overflow-Error will occur (and a Error: "java.lang.OutOfMemoryError: GC overhead limit exceeded" when trying to

Hello, Q/ Is it possible to create a DBMS connection automatically on startup of R? (Making sure of course that the db server has been started...) I am running MySQL on Mac OS X 10.4.2 with R2.4.1. I have tried to write a function using the RMySQL commands (below) and place them in .First of .RProfile: drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, {other parameters present in

Hi all, I know stored procedures are considered evil around, but there are times when you just have to use them. In the project I''m working on, I needed to call a mysql5 stored procedure, but I only got an error message saying "ActiveRecord::StatementInvalid: Mysql::Error: PROCEDURE vc.testsp can''t return a result set in the given context: call testsp()" I found out

user, password from user_sensitive_data_table into dovecot-sql.conf, but I'll live with that. You most probably had your reasons, and ultimately I agree - security first ;-) -- Chaos greets U ------=_Part_57551_1009602.1160777305352 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <br><br><div><span

All, In the following, when I just enter R from UNIX and make a connection to Oracle database, dbHasCompleted(rs) is TRUE. This shouldn't have happened since I haven't fetched any thing. Help will be appreciated. -MY --------------------------------------------------------------------- MyUnixMachine% R R : Copyright 2003, The R Development Core Team Version 1.7.0 (2003-04-16) R is

Hi, I've been able to configure --with-mysql in Solaris 10 which has MySQL version 4.0.31 bundled in. Since beta4 build fails due to change in src/lib-sql/driver-mysql.c. I've never used this feature but so I don't need it. This is just a FYI if someone reads mailing list. "driver-mysql.c", line 139: undefined symbol: CLIENT_MULTI_RESULTS "driver-mysql.c",

Last time I came up with a problem with concernin MySQL authorization with stored procedures. Timo helped me get going by with modified client_flags (MULTISTATEMENT keyword). Now all it happened again but from another way. My stored proce for MySQL is causing fillowing error: "Oct 21 12:39:22 haos dovecot: auth-worker(default): sql(user,192.168.X.X): Password query fai led: Commands out of

Dear all, I tried the following in R: >library(ROracle) >ora <- dbDriver("Oracle") >channel <- dbConnect(ora, user = "scott", password="tiger",dbname="abcdef") >rs <- dbSendQuery(channel, "select * from USArrests") >while(!dbHasCompleted(rs)) { xxx <- fetch(rs, n = 5000) } + + + > xxx Error: Object

This code below produces empty XXX.png files - if I use plot(), it works and if I enter the commands png(filename=fn) bubble(positions, do.sqrt=FALSE, main=q) dev.off() manually, it works as well. I am lost - any help appreciated. The weird thing is that it worked before I made some changes... (I don't have a copy of the working version...). R version: platform i686-pc-linux-gnu arch

I'm trying to use RSQLite statement to cycle through a large database in "chunks" via the fetch(...,n=20000). As far as I can tell, however, it keeps re-fetching the same beginning set of rows -- any ideas what might be wrong with the following code? The select statement is pulling from multiple tables. I apologize in advance -- the DB is about 4gb so I can't make it easily

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

I was trying to email directly the developer, David A. James, but all the emails bounce... Does anyone know if RMySQL may be re-compiled under Windows and what are the limitations? Cheers, Michal -------------------------------------------------------- This email is confidential and intended solely for the use o...{{dropped}}

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

Hi there, I tried to setup a passwddb with mysql, but it wont connect to my database, even if I patch the driver-mysql.c Here a test program I wrote to check the connection: int main() { MYSQL mysql; mysql_init(&mysql); if (mysql_real_connect(&mysql, NULL, "root", "asd2sdf3", "ccc", 0, "/var/lib/mysql/mysql.sock", 0) == NULL)

Hi, I have built R (current development version) and BioConductor 1.7 with portland group compiler on a AMD Opteron. When I ran qc assessment on Affymetrix latin square data set, I got the following output, Loading required package: affy Loading required package: Biobase Loading required package: tools Welcome to Bioconductor Vignettes contain introductory material. To view,

Hi, We're looking for a number of people to join our group (Applied Computational Biology and Bioinformatics -- ACBB) and applying state of the art techniques (see for example, xmap.picr.man.ac.uk) to integrate, analyse and interpret datasets arising from the latest generation of microarrays (including exon, SNP and tiling arrays), quantitative mass-spectrometry and next generation