similar to: RMySQL Install Problem

Hi, in the process of upgrading to R 1.6.0 I tried to install the latest RMySQL (0.5-0) package (Omegahat). The following error was reported [...] gcc -I/mnt/local/R/R-1.6.0/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -g -O2 -c RS-MySQL.c -o RS-MySQL.o RS-MySQL.c: In function `RS_MySQL_newConnection': RS-MySQL.c:203:

Dear R community, I tried to optimized my R code by using Rprof. In my R code I'm using MySQL database connections intensively. After a bunch of queries R fails with the following error message: Error in .Call("RS_MySQL_newConnection", drvId, con.params, groups, PACKAGE = .MySQLPkgName) : RS-DBI driver: (could not connect mylogin@mydatabase on dbname "myDB"

Hi! I am trying to install the RMySQL package. The installation stops with the following error message. path to mysql is set. setenv PKG_CPPFLAGS /home/arabidopsis/software/R1.9.1/linux/mysql/include setenv PKG_LIBS /home/arabidopsis/software/R1.9.1/linux/mysql/lib R CMD INSTALL RMySQL_0.5-5.tar.gz #....cut cut. creating src/Makevars ** libs gcc

Hello All, I tried to install RMySQL package, but the error messages says there is no such package, even though I did see RMySQL is there in the contributed package list in all mirror sites of CRAN I tried. Not sure what is the problem. > mysql.home <- '/usr/local/mysql' >

Hello, I'm tearing my hair out over this. Any help will be very much appreciated. It's been two long nights battling with RMySQL. > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/usr/local/lib/R/library/RMySQL/libs/RMySQL.so": dlcompat: dyld: /usr/local/lib/R/bin/R.bin Undefined symbols: _getopt_long

Hi, I have a problem loading RMySQL 0.5-5 on Mac OS 10.4.2 running R 2.1.1. I installed RMySQL using: export PKG_CPPFLAGS="-I/usr/local/mysql/include" export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient" R CMD INSTALL /Users/gwo/Desktop/RMySQL_0.5-5.tar.gz The installation seemed to work ok, but when I load RMySQL in R I get an error message: >library(RMySQL)

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

% sudo R CMD INSTALL RMySQL_0.5-7.tar.gz Password: * Installing *source* package 'RMySQL' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E checking for compress in -lz... no checking for getopt_long in -lc... no checking for mysql_init in -lmysqlclient... no checking for mysql.h... yes checking for mysql_init in -lmysqlclient... no checking for mysql_init

I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 bit on a dual dual core machine (that is, two dual core processors). Seems like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite right yet. There are a few mentions of this problem in google, but thus far none of the "fixes" and fixed my problem. I've tried defining the

Hi R users, I am unable to load RMySQL. The zip file is not available which I guess is needed to load this pakage. I also tried extracting the package from RMySQL_0.5-11.tar.gz and then pasted the package in the directory where R is loaded for which I am getting the following error message "Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed <

R-help list, I ported some R code from MS Windows PC to sun-solaris. Both do queries on the same MySQL database. PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 (on solaris) and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 mins. to run wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and RMySQL are resident on the same host

Dear list members -- I have problems in loading the pre-compiled library RMySQL_0.5-7 taken here (http://stat.bell-labs.com/RS-DBI/download/index.html) or RMySQL_0.6-0 taken here (http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/) on R 2.6.0 under Windows XP. I am using the MySQL features of EasyPHP1-8 (but the problem is not (for the moment) in connecting with a database but just

Hi, I have problems installing RMySQL under R1.8.1 and RHlinux (kernel2.4.7). During compilation I get: ** libs gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486 -fno-strength-reduce -g -c RS-DBI.c -o RS-DBI.o gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486

in download and automatic install the RMySQL, R show the error (look under session attach. MySQL is install and operational. Juan Santiago Ramseyer. > install.packages('RMySQL') --- Please select a CRAN mirror for use in this session --- Loading Tcl/Tk interface ... done tentando a URL 'http://cran.br.r-project.org/src/contrib/RMySQL_0.5-7.tar.gz' Content type

Hi, i try to install, but getting no success. What this mean cannot find -lz , any necessary lib left in my SuSE Installation? Many thanks, Christian linux:/usr/lib/R/bin # R CMD INSTALL RMySQL_0.5-2.tar.gz * Installing *source* package 'RMySQL' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E checking for mysql_init in -lmysqlclient... yes checking

Hi, I have struggled to re-implement the RMySQL package after upgrading from SuSe 6.3 to 7.2 and from R 1.2.1 to R 1.3.1, to no avail It compiles happily but when loading the package I get the following error > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/home/jniesch/R_HOME/lib/R/library/RMySQL/libs/RMySQL.so":

I have been installing and using the RMySQL package, version 0.5-3 with R versions 1.9.0 and 1.9.1 on Windows XP without any problem. I installed the package using the .zip binary package available at http://stat.bell-labs.com/RS-DBI/download/index.html. However, I ran into a problem using this package with the latest version 2.0.0 of R. The installation went ok, but loading the library using

Hi, I have some problem to install RMySQL package. Could you help me? I set up the path. [root at ep2 library]# export PKG_CPPFLAGS="-I/var/lib/mysql" [root at ep2 library]# export PKG_LIBS="-L/var/lib/mysql - lmysqlclient" [root at ep2 library]# R CMD INSTALL /home/younko/RMySQL_0.5- 5.tar.gz I got this bunch of error message. Please help me. * Installing *source*

I am having trouble getting RMySQL working with R. It did at one point, work with an older 1.x version of R, but now with R2.2.1, I am getting the following messages on my OS X 10.4.5 system: RS-DBI driver warning: (MySQL mismatch between compiled version 4.0.24 and runtime version 4.1.14) if I then try to run any further db commands such as dbConnect, R crashes with a bus error. When

Hi!! I want some help to install the RMySQL package. I've tried to configure some things but i'm still getting erros. Anybody could help me?? Thank's Talita Perciano Costa Leite Graduanda em Ci??ncia da Computa????o Universidade Federal de Alagoas - UFAL Departamento de Tecnologia da Informa????o - TCI Constru????o de Conhecimento por Agrupamento de Dados - CoCADa