[R] RMySQL installed but not availalable

Adriano von Sydow pdasilva at xtra.co.nz
Thu Mar 10 10:12:59 CET 2005


Hi
I run Linux SuSE 9.1, with MSQL 4.0.18
I installed R 2.0.1 and it is working fine
I installed RM 0.5-5 package and verified all installed.packages (see 
below) but when I tried to use any RMySQL specific comand is gives me 
the same error messages

 > dbConnect
Error: Object "dbConnect" not found

It looks like the  packages is not installed

Any ideas or help would be welcome
Thanks,
Popolito

*** INSTALL *****
ginossauro:/home/avonsydow/Download/Stats # R CMD INSTALL 
RMySQL_0.5-5.tar.gz
* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... cc -E
checking for compress in -lz... yes
checking for getopt_long in -lc... yes
checking for mysql_init in -lmysqlclient... yes
checking for mysql.h... no
checking for /usr/local/include/mysql/mysql.h... no
checking for /usr/include/mysql/mysql.h... yes
updating cache ./config.cache
creating ./config.status
creating src/Makevars
** libs
gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include 
-I/opt/gnome/
include   -fPIC   -c RS-DBI.c -o RS-DBI.o
gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include 
-I/opt/gnome/
include   -fPIC   -c RS-MySQL.c -o RS-MySQL.o
gcc -shared -L/usr/local/lib -L/opt/gnome/lib -o RMySQL.so RS-DBI.o 
RS-MySQL.o -
lmysqlclient -lz  -L/usr/lib/R/lib -lR
** R
** inst
** save image
Loading required package: DBI
[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-methods                   text    html    latex   example
  dbApply                           text    html    latex   example
  dbCallProc-methods                text    html    latex
  dbCommit-methods                  text    html    latex   example
  dbConnect-methods                 text    html    latex   example
  dbDataType-methods                text    html    latex   example
  dbDriver-methods                  text    html    latex   example
  dbGetInfo-methods                 text    html    latex   example
  dbListTables-methods              text    html    latex   example
  dbObjectId-class                  text    html    latex   example
  dbReadTable-methods               text    html    latex   example
  dbSendQuery-methods               text    html    latex   example
  dbSetDataMappings-methods         text    html    latex   example
  fetch-methods                     text    html    latex   example
  isIdCurrent                       text    html    latex   example
  make.db.names-methods             text    html    latex   example
  mysqlDBApply                      text    html    latex   example
  mysqlSupport                      text    html    latex
  safe.write                        text    html    latex   example
  summary-methods                   text    html    latex
* DONE (RMySQL)



*****INSTALLED.PACKAGES *******

 > installed.packages()
           Package      LibPath              Version   Priority      Bundle
base       "base"       "/usr/lib/R/library" "2.0.1"   "base"        NA
boot       "boot"       "/usr/lib/R/library" "1.2-20"  "recommended" NA
class      "class"      "/usr/lib/R/library" "7.2-10"  "recommended" "VR"
cluster    "cluster"    "/usr/lib/R/library" "1.9.6"   "recommended" NA
datasets   "datasets"   "/usr/lib/R/library" "2.0.1"   "base"        NA
DBI        "DBI"        "/usr/lib/R/library" "0.1-8"   NA            NA
foreign    "foreign"    "/usr/lib/R/library" "0.8-0"   "recommended" NA
graphics   "graphics"   "/usr/lib/R/library" "2.0.1"   "base"        NA
grDevices  "grDevices"  "/usr/lib/R/library" "2.0.1"   "base"        NA
grid       "grid"       "/usr/lib/R/library" "2.0.1"   "base"        NA
KernSmooth "KernSmooth" "/usr/lib/R/library" "2.22-14" "recommended" NA
lattice    "lattice"    "/usr/lib/R/library" "0.10-14" "recommended" NA
MASS       "MASS"       "/usr/lib/R/library" "7.2-10"  "recommended" "VR"
methods    "methods"    "/usr/lib/R/library" "2.0.1"   "base"        NA
mgcv       "mgcv"       "/usr/lib/R/library" "1.1-8"   "recommended" NA
nlme       "nlme"       "/usr/lib/R/library" "3.1-53"  "recommended" NA
nnet       "nnet"       "/usr/lib/R/library" "7.2-10"  "recommended" "VR"
RMySQL     "RMySQL"     "/usr/lib/R/library" "0.5-5"   NA            NA
rpart      "rpart"      "/usr/lib/R/library" "3.1-20"  "recommended" NA
spatial    "spatial"    "/usr/lib/R/library" "7.2-10"  "recommended" "VR"
splines    "splines"    "/usr/lib/R/library" "2.0.1"   "base"        NA
stats      "stats"      "/usr/lib/R/library" "2.0.1"   "base"        NA
stats4     "stats4"     "/usr/lib/R/library" "2.0.1"   "base"        NA
survival   "survival"   "/usr/lib/R/library" "2.15"    "recommended" NA
tcltk      "tcltk"      "/usr/lib/R/library" "2.0.1"   "base"        NA
tools      "tools"      "/usr/lib/R/library" "2.0.1"   "base"        NA
utils      "utils"      "/usr/lib/R/library" "2.0.1"   "base"        NA
           Depends
base       NA
boot       "R (>= 2.0.0), graphics, stats"
class      "R (>= 2.0.0), graphics, stats"
cluster    "R (>= 1.9), stats, graphics, utils"
datasets   NA
DBI        "R (>= 1.7.1), methods"
foreign    "R (>= 2.0.0)"
graphics   "grDevices"
grDevices  NA
grid       "grDevices"
KernSmooth "R (>= 1.9.0)"
lattice    "R (>= 2.0.0)"
MASS       "R (>= 2.0.0), graphics, stats"
methods    NA
mgcv       "R (>= 1.9.0)"
nlme       "graphics, stats, R(>= 2.0.0)"
nnet       "R (>= 2.0.0), graphics, stats"
RMySQL     "R (>= 1.8.0), methods, DBI (>= 0.1-4)"
rpart      "R (>= 2.0.0)"
spatial    "R (>= 2.0.0), graphics, stats"
splines    NA
stats      NA
stats4     "graphics, stats, methods"
survival   "stats, utils, graphics, splines, R (>= 2.0.0)"
tcltk      NA
tools      NA
utils      NA
           Suggests
base       NA
boot       "survival"
class      "lattice, nlme, survival"
cluster    NA
datasets   NA
DBI        NA
foreign    NA
graphics   NA
grDevices  NA
grid       "lattice"
KernSmooth "MASS"
lattice    "grid"
MASS       "lattice, nlme, survival"
methods    NA
mgcv       "nlme (>= 3.1-52), MASS (>= 7.2-2)"
nlme       NA
nnet       "lattice, nlme, survival"
RMySQL     NA
rpart      "survival"
spatial    "lattice, nlme, survival"
splines    NA
stats      NA
stats4     NA
survival   NA
tcltk      NA
tools      NA
utils      NA
 >




More information about the R-help mailing list