[R] RMySQL loading error
Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. When I try to load rMySQL I get the following error: require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-25~1.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary failure: Invalid access to memory location. I did not get any errors while installing MySQL or RMySQL. It seems that there are other people with similar problems, although I could not find any hint on how to try to solve the problem. Any help, hint or advice would be greatly appreciated. Thanks, Clara Anton __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RMySQL loading error
On Thu, 9 Aug 2007, Clara Anton wrote: Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. More exact versions would be helpful. When I try to load rMySQL I get the following error: require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-25~1.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary failure: Invalid access to memory location. I did not get any errors while installing MySQL or RMySQL. It seems that there are other people with similar problems, although I could not find any hint on how to try to solve the problem. It is there, unfortunately along with a lot of uniformed speculation. Any help, hint or advice would be greatly appreciated. The most likely solution is to update (or downdate) your MySQL. You possibly got RMySQL from the CRAN Extras site, and if so this is covered in the ReadMe there: The build of RMySQL_0.6-0 is known to work with MySQL 5.0.21 and 5.0.45, and known not to work (it crashes on startup) with 5.0.41. Usually the message is the one you show, but I have seen R crash. The issue is the MySQL client DLL: that from 5.0.21 or 5.0.45 works in 5.0.41. All the reports of problems I have seen are for MySQL versions strictly between 5.0.21 and 5.0.45. -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RMySQL loading error
This was just discussed: https://www.stat.math.ethz.ch/pipermail/r-help/2007-August/138142.html On 8/9/07, Clara Anton [EMAIL PROTECTED] wrote: Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. When I try to load rMySQL I get the following error: require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-25~1.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary failure: Invalid access to memory location. I did not get any errors while installing MySQL or RMySQL. It seems that there are other people with similar problems, although I could not find any hint on how to try to solve the problem. Any help, hint or advice would be greatly appreciated. Thanks, Clara Anton __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] RMySQL loading error, mysql in path
I have successfully installed RMySQL_0.6-0 using under Windows XP MCE, I am using MySQL 5.0.41, I have added I have added C:\Program Files\R\R-2.4.1\library\RMySQL\libs and mysql to the windows PATH, but again, same error: and then when I load R and try to use RMySQL library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-24~1.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary failure: Invalid access to memory location. Error: package/namespace load failed for 'RMySQL' -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] RMySQL loading error
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 library '/usr/local/IT/R-2.1.0/library/RMySQL/libs/RMySQL.so': libmysqlclient.so.10: cannot open shared object file: No such file or directory Error in library(RMySQL) : .First.lib failed for 'RMySQL' q() # find / -name libmysqlclient.so.10 /usr/lib/mysql/libmysqlclient.so.10 -- Patrice Seyed Linux System Administrator - LinGA RHCE, SCSA Boston University Medical Campus __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] RMySQL loading error
On Wed, 17 May 2006, Patrice Seyed wrote: 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 You need /usr/lib/mysql in the your ld.so load path: normally this is done via ldconfig: for example my FC3 system has in /etc/ld.so.conf: include ld.so.conf.d/*.conf /usr/lib/mysql /usr/lib64/mysql /usr/i486-linux-libc5/lib In short, mysql has not been installed completely. Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library '/usr/local/IT/R-2.1.0/library/RMySQL/libs/RMySQL.so': libmysqlclient.so.10: cannot open shared object file: No such file or directory Error in library(RMySQL) : .First.lib failed for 'RMySQL' q() # find / -name libmysqlclient.so.10 /usr/lib/mysql/libmysqlclient.so.10 -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] RMySQL loading error
but of course; danke. -P Prof Brian Ripley wrote: On Wed, 17 May 2006, Patrice Seyed wrote: 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 You need /usr/lib/mysql in the your ld.so load path: normally this is done via ldconfig: for example my FC3 system has in /etc/ld.so.conf: include ld.so.conf.d/*.conf /usr/lib/mysql /usr/lib64/mysql /usr/i486-linux-libc5/lib In short, mysql has not been installed completely. Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library '/usr/local/IT/R-2.1.0/library/RMySQL/libs/RMySQL.so': libmysqlclient.so.10: cannot open shared object file: No such file or directory Error in library(RMySQL) : .First.lib failed for 'RMySQL' q() # find / -name libmysqlclient.so.10 /usr/lib/mysql/libmysqlclient.so.10 -- Patrice Seyed Linux System Administrator - LinGA RHCE, SCSA Boston University Medical Campus __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html