[R] Install and Configure RSQLite in Ubuntu

[Phil Spector]

sudo apt-get install libsqlite3-dev

(Unfortunately, the method I described to find this package in my
previous post doesn't work for this one.)

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu



On Mon, 25 Apr 2011, Abraham Mathew wrote:

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