RMySQL installed but not availalable

Did you _load_ the package?
R> library( RMySQL )

On Thursday 10 March 2005 10:12, Adriano von Sydow wrote:
 

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