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
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
