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
spec...@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]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
