From kare at modlab.se  Thu Nov  5 15:00:14 2009
From: kare at modlab.se (kare at modlab.se)
Date: Thu,  5 Nov 2009 15:00:14 +0100 (CET)
Subject: [Rd] Error when adding package RMySQL (PR#14044)
Message-ID: <20091105140014.74806282C76F@mail.pubhealth.ku.dk>

Full_Name: K?re Jonsson
Version: 2.10
OS: WinXP
Submission from: (NULL) (85.225.178.169)


I made a brand new installation of R 2.10 in two machines and got the same
problem.

Machine 1 is Win XP on metal installation
machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any
Microsoft windows XP siftware always successfully is installed.

Operation 1. Add package RMySQL from Swedish CRAN.
Operation 2. library(RMySQL)

You can see the textual dump below. I need help to understand what is wrong.

Kind regards,
K?re Jonsson


> utils:::menuInstallPkgs()
--- Please select a CRAN mirror for use in this session ---
also installing the dependency ?DBI?

trying URL 'http://ftp.sunet.se/pub/lang/CRAN/bin/windows/contrib/2.10/DBI_0.2-4.zip'
Content type 'application/zip' length 375508 bytes (366 Kb)
opened URL
downloaded 366 Kb

trying URL 'http://ftp.sunet.se/pub/lang/CRAN/bin/windows/contrib/2.10/RMySQL_0.7-4.zip'
Content type 'application/zip' length 284408 bytes (277 Kb)
opened URL
downloaded 277 Kb

package 'DBI' successfully unpacked and MD5 sums checked
package 'RMySQL' successfully unpacked and MD5 sums checked

The downloaded packages are in
        C:\Documents and Settings\Administrator\Local
Settings\Temp\Rtmpjqc0Bc\downloaded_packages
> library(RMySQL)
Loading required package: DBI
Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 2) :

  Registry key 'SOFTWARE\MySQL AB' not found
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'
> MySQL()
Error: could not find function "MySQL"
> con <- dbConnect(dbDriver("MySQL"), dbname = "mysql")
Error in do.call(as.character(drvName), list(...)) : 
  could not find function "MySQL"
Error in is(object, Cl) : 
  error in evaluating the argument 'drv' in selecting a method for function
'dbConnect'
> version
               _                            
platform       i386-pc-mingw32              
arch           i386                         
os             mingw32                      
system         i386, mingw32                
status                                      
major          2                            
minor          10.0                         
year           2009                         
month          10                           
day            26                           
svn rev        50208                        
language       R                            
version.string R version 2.10.0 (2009-10-26)
>



[Rd] Error when adding package RMySQL (PR#14044)
kare at modlab.se