[R] RMySQL installed but not availalable
Adriano von Sydow
pdasilva at xtra.co.nz
Fri Mar 11 08:00:15 CET 2005
Thanks Arne,
that was spot on.
Cheers,
Popolito
Arne Henningsen wrote:
>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
>>
>>
>
>
>
More information about the R-help
mailing list