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
______________________________________________ R-help at 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
Arne Henningsen Department of Agricultural Economics University of Kiel Olshausenstr. 40 D-24098 Kiel (Germany) Tel: +49-431-880 4445 Fax: +49-431-880 1397 ahenningsen at agric-econ.uni-kiel.de http://www.uni-kiel.de/agrarpol/ahenningsen/