Installing weft-qda / sqlite-ruby on linpus

Hello everyone,

This is my first post here, and I’m not even sure it’s in the right
place, but here goes…

I have an Acer Aspire One laptop, running Linpus, and I want to install
weft-qda on it (Weft QDA - a free, open-source tool for qualitative data analysis).
It has sqlite-ruby as a dependency.
GEM offers to install either sqlite-ruby version 2.2.3 or 2.2.2, but
both fail, with this error:

checking for main() in -lsqlite… no
checking for sqlite.h… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers. Check the mkmf.log for more details. You may
need configuration options.

The mkmf.log file:

have_library: checking for main() in -lsqlite… -------------------- no

“gcc -o conftest -I. -I/usr/lib/ruby/1.8/i386-linux -I. -I/usr/local
-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
-fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386
-mtune=generic -fasynchronous-unwind-tables -Wall -fPIC conftest.c
-L”." -L"/usr/lib" -L"/usr/local" -L. -rdynamic -Wl,-export-dynamic
-lruby-static -lsqlite -lpthread -ldl -lcrypt -lm -lc"
/usr/bin/ld: cannot find -lsqlite
collect2: ld returned 1 exit status
checked program was:
/* begin /
1: /top/
2: int main() { return 0; }
3: int t() { void ((volatile p)()); p = (void (()()))main; return 0; }
/
end */

“gcc -o conftest -I. -I/usr/lib/ruby/1.8/i386-linux -I. -I/usr/local
-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
-fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386
-mtune=generic -fasynchronous-unwind-tables -Wall -fPIC conftest.c
-L”." -L"/usr/lib" -L"/usr/local" -L. -rdynamic -Wl,-export-dynamic
-lruby-static -lsqlite -lpthread -ldl -lcrypt -lm -lc"
/usr/bin/ld: cannot find -lsqlite
collect2: ld returned 1 exit status
checked program was:
/* begin /
1: /top/
2: int main() { return 0; }
3: int t() { main(); return 0; }
/
end */


have_header: checking for sqlite.h… -------------------- no

“gcc -E -I. -I/usr/lib/ruby/1.8/i386-linux -I. -I/usr/local -O2 -g
-pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
–param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic
-fasynchronous-unwind-tables -Wall -fPIC conftest.c -o conftest.i”
conftest.c:1:20: error: sqlite.h: No such file or directory
checked program was:
/* begin /
1: #include <sqlite.h>
/
end */


So I probably need to install some libraries/headers as the error says.

So far I’ve installed:
ruby-sqlite3
sqlite-devel
pcsqlite-devel
libgda-sqlite-devel

But it’s still not working, I keep getting the same error message, and I
have no idea what to do next.
If someone could point me in the right direction I would be grateful.

Kind regards,
Sebastian

Hi Sebastiaan

Sebastiaan Kamp wrote:

This is my first post here, and I’m not even sure it’s in the right
place, but here goes…

It would be better on the Weft QDA users’ mailing list:

http://rubyforge.org/mailman/listinfo/weft-qda-users

I have an Acer Aspire One laptop, running Linpus, and I want to install
weft-qda on it (Weft QDA - a free, open-source tool for qualitative data analysis).

Christophe Lejeune has provided some helpful instructions on setting
Weft QDA on Linux, discussing different options:

http://analyses.ishs.ulg.ac.be/logiciels/weft-qda.installation.debian.en.html

A big problem is that the version you are trying to install (1.0.1) has
dependencies on old versions of GTK and wxWidgets on Linux, and most
distros make these hard to support. You will be able to install sqlite,
but from user reports it will be very difficult to get wxruby 0.6.0 (now
four years old) working on modern Linux distros.

The development version of Weft QDA works with latest versions, but
isn’t ready for production use yet; 1.9.0 is only alpha quality, and
whilst the latest unreleased code is much better, it has a whole new set
of dependencies because it uses Ruby 1.9.

I don’t like to say it, but using 1.0.1 on Windows (possibly via Wine)
might be the best option if you have an analysis you want to proceed
with now. Unlike Linux, Weft QDA should run on fairly ancient versions
of Windows (eg NT/2000 - and probably 98).

It has sqlite-ruby as a dependency.
GEM offers to install either sqlite-ruby version 2.2.3 or 2.2.2, but
both fail, with this error:

Have a think about the options, then see how you want to proceed.

alex

Thank you very much Alex,

I got the impression it was going to be hard.
Going to try it with Wine first beceause I’d like to keep this fast
Linpus Linux.

Greetings,
Sebastian