Hi Folks,

I'm new to the linux world and am having some trouble installing the RSQLite
package.
SQLite is installed, but some dependencies(?) seem to be missing.
Can anyone help?


> sessionInfo()
R version 2.13.0 (2011-04-13)
Platform: i686-pc-linux-gnu (32-bit)



> install.packages()
Installing package(s) into ‘/home/abraham/R/i686-pc-linux-gnu-library/2.13’
(as ‘lib’ is unspecified)
trying URL 'http://ftp.osuosl.org/pub/cran/src/contrib/RSQLite_0.9-4.tar.gz'
Content type 'application/x-gzip' length 1298948 bytes (1.2 Mb)
opened URL
==================================================
downloaded 1.2 Mb

* installing *source* package ‘RSQLite’ ...
checking for gcc... gcc
checking for C compiler default output file name... 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 gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -E
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking for library containing fdatasync... none required
configure: creating ./config.status
config.status: creating src/Makevars
** libs
gcc -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DTHREADSAFE=0 -fpic -std=gnu99 -O3 -pipe -g -c RS-DBI.c -o
RS-DBI.o
gcc -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DTHREADSAFE=0 -fpic -std=gnu99 -O3 -pipe -g -c RS-SQLite.c
-o RS-SQLite.o
gcc -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DTHREADSAFE=0 -fpic -std=gnu99 -O3 -pipe -g -c
param_binding.c -o param_binding.o
gcc -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DTHREADSAFE=0 -fpic -std=gnu99 -O3 -pipe -g -c
sqlite-all.c -o sqlite-all.o
sqlite-all.c:1: warning: extra tokens at end of #ifdef directive


This is my output and the terminal freezes at this point.

The RSQLite files are installed but I can't get them work in R when I run
library(RSQLite)

> library(RSQLite)
Loading required package: DBI
Error in library.dynam(lib, package, package.lib) :
shared object 'RSQLite' not found
In addition: Warning message:
In loadNamespace(package, c(which.lib.loc, lib.loc), keep.source =
keep.source) :
package 'RSQLite' contains no R code
Error: package/namespace load failed for 'RSQLite'


Thanks for the help,
Abraham

	[[alternative HTML version deleted]]

