[R] RMySQL installed but not availalable
Arne Henningsen
ahenningsen at email.uni-kiel.de
Wed Mar 9 13:30:13 CET 2005
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/
More information about the R-help
mailing list