[R] RSQLite install R x86_64 fail

[David Ruau]

Hi,

On a fresh install of R on mac os x 10.6.4 (snow leopard) RSQLite did not install while running biocLite()
$ R
R version 2.11.1 (2010-05-31)
Copyright (C) 2010 The R Foundation for Statistical Computing
ISBN 3-900051-07-0

[...]
Loading required package: utils
BioC_mirror = http://www.bioconductor.org
Change using chooseBioCmirror().
[Previously saved workspace restored]

> biocLite("RSQLite")
Using R version 2.11.1, biocinstall version 2.6.7.
Installing Bioconductor version 2.6 packages:
[1] "RSQLite"
Please wait...

Warning in install.packages(pkgs = pkgs, repos = repos, ...) :
  argument 'lib' is missing: using '/Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11'
trying URL 'http://cran.fhcrc.org/src/contrib/RSQLite_0.9-1.tar.gz'
Content type 'application/x-gzip' length 1402602 bytes (1.3 Mb)
opened URL
==================================================
downloaded 1.3 Mb

* installing *source* package ‘RSQLite’ ...
checking for gcc... /opt/local/bin/gcc-mp-4.4 -std=gnu99
checking for C compiler default output file name... rm: a.out.dSYM: is a directory
a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables... 
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether /opt/local/bin/gcc-mp-4.4 -std=gnu99 accepts -g... yes
checking for /opt/local/bin/gcc-mp-4.4 -std=gnu99 option to accept ISO C89... none needed
checking how to run the C preprocessor... /opt/local/bin/gcc-mp-4.4 -std=gnu99 -E
checking for gcc... (cached) /opt/local/bin/gcc-mp-4.4 -std=gnu99
checking whether we are using the GNU C compiler... (cached) yes
checking whether /opt/local/bin/gcc-mp-4.4 -std=gnu99 accepts -g... (cached) yes
checking for /opt/local/bin/gcc-mp-4.4 -std=gnu99 option to accept ISO C89... (cached) none needed
configure: creating ./config.status
config.status: creating src/Makevars
** libs
/opt/local/bin/gcc-mp-4.4 -std=gnu99 -I/opt/local/lib/R/include -I/usr/local/mysql/include -DTHREADSAFE=0 -I/opt/local/include    -fPIC  -pipe -O2 -m64 -c RS-DBI.c -o RS-DBI.o
/opt/local/bin/gcc-mp-4.4 -std=gnu99 -I/opt/local/lib/R/include -I/usr/local/mysql/include -DTHREADSAFE=0 -I/opt/local/include    -fPIC  -pipe -O2 -m64 -c RS-SQLite.c -o RS-SQLite.o
/opt/local/bin/gcc-mp-4.4 -std=gnu99 -I/opt/local/lib/R/include -I/usr/local/mysql/include -DTHREADSAFE=0 -I/opt/local/include    -fPIC  -pipe -O2 -m64 -c param_binding.c -o param_binding.o
/opt/local/bin/gcc-mp-4.4 -std=gnu99 -I/opt/local/lib/R/include -I/usr/local/mysql/include -DTHREADSAFE=0 -I/opt/local/include    -fPIC  -pipe -O2 -m64 -c sqlite-all.c -o sqlite-all.o
sqlite-all.c:1:35: warning: extra tokens at end of #ifdef directive
mkdir -p ../inst/include
cp sqlite/sqlite3.h ../inst/include
cp sqlite/sqlite3ext.h ../inst/include
/opt/local/bin/gcc-mp-4.4 -std=gnu99 -dynamiclib -Wl,-headerpad_max_install_names -undefined dynamic_lookup -single_module -multiply_defined suppress -L/opt/local/lib -o RSQLite.so RS-DBI.o RS-SQLite.o param_binding.o sqlite-all.o -L/usr/local/mysql/lib -lmysqlclient -L/opt/local/lib/R/lib -lR
installing to /Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite/libs
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices ...
** testing if installed package can be loaded
Error in dyn.load(file, DLLpath = DLLpath, ...) : 
  unable to load shared library '/Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite/libs/RSQLite.so':
  dlopen(/Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite/libs/RSQLite.so, 6): Symbol not found: _sqlite3_backup_finish
  Referenced from: /Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite/libs/RSQLite.so
  Expected in: flat namespace
 in /Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite/libs/RSQLite.so
ERROR: loading failed
* removing ‘/Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite’
* restoring previous ‘/Users/druau/R/x86_64-apple-darwin10.4.0-library/2.11/RSQLite’

The downloaded packages are in
	‘/private/var/folders/e9/e9-5zLVqFgGBR2S8qU74+U+++TM/-Tmp-/RtmpBgST91/downloaded_packages’
Warning message:
In install.packages(pkgs = pkgs, repos = repos, ...) :
  installation of package 'RSQLite' had non-zero exit status

#############
#############

The binary install work with install.packages("RSQLite", type='mac.binary') or 'mac.binary.leopard' but the package does not load properly.
> library('RSQLite')
Error: package 'RSQLite' was built for universal-apple-darwin9.8.0


The RSQLite.so file is not in libs/RSQLite.so but in libs/x86_64/RSQLite.so

> sessionInfo()
R version 2.11.1 (2010-05-31) 
x86_64-apple-darwin10.4.0 

locale:
[1] en_US.UTF-8/en_US.UTF-8/C/C/en_US.UTF-8/C

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

loaded via a namespace (and not attached):
[1] tools_2.11.1

Thanks,
David