sqlite3_open_v2 error sqlite3_open_v2 error linux linux

sqlite3_open_v2 error


I got this error this week, and resolved it by adding the path to the sqlite library to LD_LIBRARY_PATH:

This was the path

[/usr/local/lib]$ ls... libsqlite3.a  libsqlite3.la  libsqlite3.so  libsqlite3.so.0  libsqlite3.so.0.8.6

And I added it in the profile:

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/libexport LD_LIBRARY_PATH

This resolved the issue for me.


I had this problem too.

I resolved it this way :

mv /usr/lib/libsqlite3.so.0  /usr/lib/libsqlite3.so.0.backgem install sqlite3 -- --with-sqlite3-include=/usr/local/include --with-sqlite3-lib=/usr/local/lib


FWIW, I had to first install sqlite3 because my existing version was too old, and then build sqlite3 gem while pointing to the correct libraries:

wget http://www.sqlite.org/sqlite-autoconf-3070701.tar.gztar -zxvf sqlite-autoconf-3070701.tar.gzcd sqlite-autoconf-3070701./configuremake && make installgem install sqlite3  -- --with-sqlite3-include=/usr/local/include --with-sqlite3-lib=/usr/local/lib