R devel - Nov 2009 - Error when adding package RMySQL (PR#14044)

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)
>

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