[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