From ligges at statistik.tu-dortmund.de  Thu Nov  5 21:10:30 2009
From: ligges at statistik.tu-dortmund.de (ligges at statistik.tu-dortmund.de)
Date: Thu,  5 Nov 2009 21:10:30 +0100 (CET)
Subject: [Rd] Error when adding package RMySQL (PR#14044)
Message-ID: <20091105201030.639C42831FF7@mail.pubhealth.ku.dk>



kare at modlab.se wrote:
> 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



So you probably forgot to install MySQL?

Why do you think this is a bug in the base R distribution?
Note that bugs of contributed packages (if they are really bugs) should 
be reported to the corresponding package maintainer rather than to the R 
bug tracking system.


Best,
Uwe Ligges



> 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)
> 
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel



[Rd] Error when adding package RMySQL (PR#14044)
ligges at statistik.tu-dortmund.de