Install and Configure RSQLite in Ubuntu

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Install and Configure RSQLite in Ubuntu

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


______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: 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
  [hidden email]



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

______________________________________________
[hidden email] 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.