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:[EMAIL PROTECTED] > Sent: Thursday, 10 March 2005 5:13 PM > To: [email protected] > 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 > > > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
