thr3ads.net - R help - [R] RMySQL installed but not availalable [Mar 2005]

If this information is useful, please help other people find it:
Share via:

Mulholland, Tom

2005-Mar-09 08:48 UTC

[R] RMySQL installed but not availalable

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 at xtra.co.nz]
> Sent: Thursday, 10 March 2005 5:13 PM
> To: r-help at 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 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
>

Adriano von Sydow

2005-Mar-10 09:12 UTC

head link

[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
 >

Possibly Parallel Threads

Search for more apparently analagous threads

R help - Mar 2005 - RMySQL installed but not availalable

[R] RMySQL installed but not availalable

[R] RMySQL installed but not availalable

Possibly Parallel Threads