[R-sig-DB] problem loading RMySQL

[Miiste@d@Bry@@ m@iii@g oii ep@m@ii@ep@@gov]

Hi Jeff:  thanks for getting back to me so quickly. 

Here is the output::

> sessionInfo()
R version 2.8.1 (2008-12-22) 
i386-pc-mingw32 

locale:
LC_COLLATE=English_United States.1252;LC_CTYPE=English_United 
States.1252;LC_MONETARY=English_United 
States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252

attached base packages:
[1] stats     graphics  grDevices datasets  tcltk     utils     methods 
base 

other attached packages:
[1] ineq_0.2-8      foreign_0.8-34  DBI_0.2-4       svSocket_0.9-43 
svMisc_0.9-46   TinnR_1.0.3 
[7] R2HTML_1.59-1   Hmisc_3.5-2 

loaded via a namespace (and not attached):
[1] cluster_1.11.13 grid_2.8.1      lattice_0.17-22 tools_2.8.1 
> .libPaths()
[1] 
"//AA.AD.EPA.GOV/ORD/NAR/USERS/EC2/wmilstea/NETMYD~1/PORTAB~2/R/R-28~1.1/library"
> Sys.getenv('MYSQL_HOME')
MYSQL_HOME 
        "" 
> utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
$`MySQL Connector/ODBC 5.1`
$`MySQL Connector/ODBC 5.1`$Version
[1] "5.1.5"


Cheers,  Bryan

milstead.bryan using epa.gov
(401) 782-3015




From:
Jeffrey Horner <jeff.horner using vanderbilt.edu>
To:
Bryan Milstead/NAR/USEPA/US using EPA, "r-sig-db using stat.math.ethz.ch" 
<r-sig-db using stat.math.ethz.ch>
Date:
04/30/2009 11:12 AM
Subject:
Re: problem loading RMySQL



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



	[[alternative HTML version deleted]]