similar to: installing RMySQL:summary

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 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 - I'm trying to set up a parallelized batch job that is run under rmpi and managed by sge, using qsub, but it reports that it can't load RMySQL because it can't find the libmysqlclient.so.15 file. Note, when I run R interactively, and manually load the RMySQL library, it works without a hitch, however, when I have qsub launch R, it reports the following error: Error in

i was able to install DBI and RMySQL cleanly. I get the error below on "library('RMySQL')". The file it is complaining about is located in /usr/lib/mysql/, where is R trying to load it from? Tried a symlink into /usr/local/lib/mysql to no avail. thx. -P Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared

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

Hello everybody, i had a big issue with RMySQL, working on an installation of R on multiple nodes via net file-system. The point is that we installed Xampp as suite for mysql, perl, apache and php on every node, and we need to use R scripts with mysql. Xampp doesn't compile anything, it gives you pre-compiled binaries all linked together, you just extract from a tarball. At my first try,

Dear R users I have a problem installing RMySQL_0.5-5 in that ld skips incompatible libmysqlclient as shown below. Can someone help? Thanks Einar Arnason I am on a Red Hat Enterprise Linux ES (v. 3 for AMD64/Intel EM64T) 2.4.21-15.EL #1 SMP Thu Apr 22 running mysql Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686) using EditLine wrapper distributed under xampp (www.apachefriends.org)

Good Afternoon: Have an R script that uses RMySQL package. Everything works great within 32 bit ubuntu linux environment (/usr/sbin/mysqld: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.15, stripped). > mysqlClientLibraryVersions() 5.1.41 5.1.37 50141 50137 Now testing on 64 bit ubuntu linux environment

It appears that fetch() gets only the first 500 rows by default. I don't see this in the documentation, but timeinfo <- fetch(rs) gets only 500 rows where timeinfo <- fetch(rs,n=-1) gets (correctly) 736 for the same query. Is this an undocumented feature? I played with this data for an alarming amount of time before I realized that I was missing a third of the data. I

Full_Name: Ankhee Dutta Version: 2.3 OS: LINUX Submission from: (NULL) (202.141.12.97) I have a linux system of Mandriva-2007 with R version 2.3.0 and MySQL with 5.0.0. I have also got DBI-R database interface version-0.1-11 installed on my Linux system.While installing RMySQL package version 0.5-11 i am facing problem . while installation the error report which is coming is as follows:

Hi, I got error messeges when I try to install RMySQL. The version of MySQL installed on my Debian is 4.0.12. Error messages were about the location of /include and /lib of MySQL distribution. Final error messages were; usr/bin/ld: cannot find -lz Any tips or advices? Thanks -- Sung-youn Kim -------------- Dept. of Political Science Stony Brook University (SUNY at Stony Brook) Office:

Is it true that append=T does not work in assignTable() in RMySQL ? More specifically: I cannot append a data.frame to an existing table in a MySQL database, although I can use the same data.frame to create a new table. Even more specifically: > assignTable(con,"employee",dita,append=T) Error in execStatement.MySQLConnection(con, statement, ...) : RS-DBI driver: (could not

Hi, I am having trouble getting RMySQL running on a solaris machine. [43] bedrock:/home/jayoung/source_codes/R/other_packages> uname -a SunOS bedrock 5.10 Generic_118833-36 sun4v sparc SUNW,Sun-Fire-T200 I thought I had finally managed to get it installed, albeit with some warnings that I didn't understand (it took me a while to find where our mysql libraries were), but when I tried

I could really use some advice about installing the RMySQL package under R 2.1.0 on Mac OS 10.4. I get the following message from R when I try: --------------------------------------------------------------------------- Configuration error: Could not locate the library "libz" required by MySQL. INSTRUCTIONS: The "libz" library is required by the MySQL client

Hi, I've got a Dual G5 running 10.3.7 and I'm trying to install RMySQL. I've already got R up and running. When I try the command > install.packages("RMySQL") It downloads a few things and then produces the following error: --------------------------- Configuration error: Could not locate the library "libz" required by MySQL. INSTRUCTIONS: The

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

% 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

Hello All, I have a technical difficulty installing RMySQL. I am running openSUSE11.1 and R 2.12 I have installed MySQL from the website. and following installation , as root This is the part where trouble begin, ...... checking mysql.h usability... no checking mysql.h presence... no checking for mysql.h... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in

Dear anybody I am running Fedora Core 6 with the latest version of R. When I try to install the package RMySQL I get this message: * Installing *source* package 'RMySQL' ... creating cache ./config.cache checking how to run the C preprocessor... /lib/cpp checking for compress in -lz... no checking for getopt_long in -lc... no checking for