[R-sig-DB] problem loading RMySQL

[Jeffrey Horner]

Milstead.Bryan using epamail.epa.gov wrote on 04/30/2009 07:11 AM:
> 
> Hi Jeff:  I'd like to use the RMySQL package that you administer but am 
> having trouble loading it.  I can download and install the package but 
> can't load it.  Below is the output from my attempt.  I will appreciate 
> any help you can give me on this.   Thanks.
> 
> 
>  > utils:::menuInstallPkgs()
> trying URL 
> 'http://www.revolution-computing.com/cran/bin/windows/contrib/2.8/RMySQL_0.7-4.zip' 
> 
> Content type 'application/zip' length 386775 bytes (377 Kb)
> opened URL
> downloaded 377 Kb
> 
> package 'RMySQL' successfully unpacked and MD5 sums checked
> 
> The downloaded packages are in
>         C:\Documents and Settings\WMilstea\Local 
> Settings\Temp\RtmpxbLL7f\downloaded_packages
> updating HTML package descriptions
>  > local({pkg <- select.list(sort(.packages(all.available = TRUE)))
> + if(nchar(pkg)) library(pkg, character.only=TRUE)})
> Error in if (utils::file_test("-d", MySQLhome)) break :
>   argument is of length zero
> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
> Error: package/namespace load failed for 'RMySQL'

Weird. Run the code below and send me the output:

sessionInfo()
.libPaths()
Sys.getenv('MYSQL_HOME')
utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)

I'm also CC'ing this to r-sig-db to capture and archive your issue.

Jeff

-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner