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
"/Users/etukaonono/Library/RAqua/library/RMySQL/libs/RMySQL.so":
dlcompat: dyld:
/Applications/StartR.app/RAqua.app/Contents/MacOS/RAqua Undefined
symbols:
_getopt_long
Error in library(pkgs[i], character.only = TRUE) :
.First.lib failed
If I uninstall the package and try running R CMD test RMySQL, I get the
following error messages. What should I be looking at to try and
reolve these issues?
[Etuka-Ononos-Computer:~/desktop] etukaonono% R CMD check RMySQL*
checking for working latex ... OK
* using log directory '/Users/etukaonono/Desktop/RMySQL.Rcheck'
* checking for file 'RMySQL/DESCRIPTION' ... OK
* checking if this is a source package ... OK
* Installing *source* package 'RMySQL' ...
loading cache ./config.cache
checking how to run the C preprocessor... (cached) cc -E
-traditional-cpp
checking for mysql_init in -lmysqlclient... (cached) yes
checking for mysql.h... (cached) no
checking for /usr/local/include/mysql/mysql.h... (cached) no
checking for /usr/include/mysql/mysql.h... (cached) yes
creating ./config.status
creating src/Makevars
** libs
make: `RMySQL.so' is up to date.
** R
** inst
** save image
[1] TRUE
[1] "dbObjectId"
[1] "format"
[1] "show"
[1] "print"
[1] "MySQLObject"
[1] "MySQLDriver"
[1] "dbUnloadDriver"
[1] "dbGetInfo"
[1] "dbListConnections"
[1] "summary"
[1] "MySQLConnection"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbDisconnect"
[1] "dbSendQuery"
[1] "dbGetQuery"
[1] "dbGetException"
[1] "dbGetInfo"
[1] "dbListResults"
[1] "summary"
[1] "dbListTables"
[1] "dbReadTable"
[1] "dbWriteTable"
[1] "dbExistsTable"
[1] "dbRemoveTable"
[1] "dbListFields"
[1] "dbCommit"
[1] "dbRollback"
[1] "dbCallProc"
[1] "MySQLResult"
[1] "dbClearResult"
[1] "fetch"
[1] "fetch"
[1] "dbGetInfo"
[1] "dbGetStatement"
[1] "dbListFields"
[1] "dbColumnInfo"
[1] "dbGetRowsAffected"
[1] "dbGetRowCount"
[1] "dbHasCompleted"
[1] "dbGetException"
[1] "summary"
[1] "dbDataType"
[1] "make.db.names"
[1] "SQLKeywords"
[1] "isSQLKeyword"
[1] "dbApply"
[1] "dbApply"
** help
>>> Building/Updating help pages for package 'RMySQL'
Formats: text html latex example
MySQL text html latex example
MySQLConnection-class text html latex example
MySQLDriver-class text html latex example
MySQLObject-class text html latex example
MySQLResult-class text html latex example
S4R text html latex
dbApply text html latex example
dbObjectId-class text html latex example
isIdCurrent text html latex example
mysqlDBApply text html latex example
mysqlSupport text html latex
safe.write text html latex example
* DONE (RMySQL)
* checking package directory ... OK
* checking for portable file names ... OK
* checking for sufficient/correct file permissions ... OK
* checking DESCRIPTION meta-information ... OK
* checking package dependencies ... OK
* checking index information ... OK
* checking package subdirectories ... OK
* checking R files for syntax errors ... OK
* checking R files for library.dynam ... OK
* checking S3 generic/method consistency ... WARNING
Error in .tryQuietly({ : Error in library(package, lib.loc = lib.loc,
character.only = TRUE, verbose = FALSE) :
.First.lib failed
Execution halted
* checking for replacement functions with final arg not named 'value'
... WARNING
Error in .tryQuietly({ : Error in library(package, lib.loc = lib.loc,
character.only = TRUE, verbose = FALSE) :
.First.lib failed
Execution halted
* checking Rd files ... OK
* checking for missing documentation entries ... ERROR
Error in .tryQuietly({ : Error in library(package, lib.loc = lib.loc,
character.only = TRUE, verbose = FALSE) :
Etuka Onono
Statistics and Modelling Science
Strathclyde University
-----------------------------------------------------------
Is The Clydesdale Bank ripping you off too?
