RE: [R] RMySQL installed but not availalable

From: Mulholland, Tom <Tom.Mulholland_at_dpi.wa.gov.au>
Date: Wed 09 Mar 2005 - 19:48:28 EST


I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere!

Tom

> -----Original Message-----
> From: Adriano von Sydow [mailto:pdasilva@xtra.co.nz]
> Sent: Thursday, 10 March 2005 5:13 PM
> To: r-help@stat.math.ethz.ch
> Subject: [R] RMySQL installed but not availalable
>
>
> 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
>



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 Wed Mar 09 20:07:36 2005

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