I was having problems getting clsql working with sqlite3 on ubuntu.

no matter how I adjusted the paths, it would not load the library with uffi.

After messing around with it for most of the morning, I finally discovered that there was something funky with the symbolic links in the /usr/lib/ area.

lrwxrwxrwx 1 root root     15 2009-12-30 08:09 libsqlite3.so -> libqslite3.so.0
lrwxrwxrwx 1 root root     19 2009-11-02 23:03 libsqlite3.so.0 -> libsqlite3.so.0.8.6
-rw-r–r– 1 root root 556648 2009-09-19 16:35 libsqlite3.so.0.8.6

when I tried to ldd /usr/lib/libsqlite3.so it said that there was no file /usr/lib/libsqlite3.so

Redoing the link like so:

sudo ln -sf libsqlite3.so.0.8.6 libsqlite3.so

fixed the problem and allowed me to (require ‘clsql-sqlite3) with no problems

HTH

Advertisement