Re: [R] RMySQL installed but not availalable

From: Don MacQueen <macq_at_llnl.gov>
Date: Thu 10 Mar 2005 - 11:41:59 EST

>require(RMySQL)
>help('MySQL')

then see the examples shown by the help page

At 9:12 PM -1200 3/9/05, 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@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

-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA

______________________________________________
R-help@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
Received on Thu Mar 10 19:17:42 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:42 EST