Hi,

I'm trying to install RSQLite on R 2.14 Ubuntu 12.04 i686. The installation
always gets stalled and ends up not working. I installed libsqlite3-dev but
still no luck. Anyone know how to solve this?

$ R CMD INSTALL RSQLite_0.11.1.tar.gz
* installing to library ‘/home/ubuntu/R/i686-pc-linux-gnu-library/2.14’
* installing *source* package ‘RSQLite’ ...
** package ‘RSQLite’ successfully unpacked and MD5 sums checked
checking for gcc... gcc -std=gnu99
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 -std=gnu99 accepts -g... yes
checking for gcc -std=gnu99 option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -std=gnu99 -E
checking for gcc... (cached) gcc -std=gnu99
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc -std=gnu99 accepts -g... (cached) yes
checking for gcc -std=gnu99 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 -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
RS-DBI.c -o RS-DBI.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
RS-SQLite.c -o RS-SQLite.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
param_binding.c -o param_binding.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
sqlite-all.c -o sqlite-all.o
sqlite-all.c:1:35: warning: extra tokens at end of #ifdef directive
[enabled by default]
^Cmake: *** wait: No child processes.  Stop.
make: *** Waiting for unfinished jobs....
make: *** wait: No child processes.  Stop.
** R
^C
* removing ‘/home/ubuntu/R/i686-pc-linux-gnu-library/2.14/RSQLite’

ubuntu@ip-10-99-65-94:~/R/kaggle/diabetes$
ubuntu@ip-10-99-65-94:~/R/kaggle/diabetes$
ubuntu@ip-10-99-65-94:~/R/kaggle/diabetes$
ubuntu@ip-10-99-65-94:~/R/kaggle/diabetes$ R CMD INSTALL
RSQLite_0.11.1.tar.gz
* installing to library ‘/home/ubuntu/R/i686-pc-linux-gnu-library/2.14’
* installing *source* package ‘RSQLite’ ...
** package ‘RSQLite’ successfully unpacked and MD5 sums checked
checking for gcc... gcc -std=gnu99
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 -std=gnu99 accepts -g... yes
checking for gcc -std=gnu99 option to accept ISO C89... none needed
checking how to run the C preprocessor... gcc -std=gnu99 -E
checking for gcc... (cached) gcc -std=gnu99
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc -std=gnu99 accepts -g... (cached) yes
checking for gcc -std=gnu99 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 -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
RS-DBI.c -o RS-DBI.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
RS-SQLite.c -o RS-SQLite.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
param_binding.c -o param_binding.o
gcc -std=gnu99 -I/usr/share/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_SOUNDEX -DSQLITE_MAX_VARIABLE_NUMBER=40000
-DSQLITE_MAX_COLUMN=30000 -DTHREADSAFE=0     -fpic  -O3 -pipe  -g -c
sqlite-all.c -o sqlite-all.o
sqlite-all.c:1:35: warning: extra tokens at end of #ifdef directive
[enabled by default]

	[[alternative HTML version deleted]]

