the following solved it [01:00 PM] ~$ export LD_LIBRARY_PATH=/usr/local/lib [01:00 PM] ~$ echo $LD_LIBRARY_PATH /usr/local/lib [01:00 PM] ~$ sqlite3 SQLite version 3.5.6 Enter ".help" for instructions sqlite> .q [01:00 PM] ~$
why is it the I had to do the above? Why is LD_LIBRARY_PATH not set automatically? And, since it wasn't set, how come other programs were working fine (assuming that other programs in the /usr/local/bin space were looking for libs in /usr/local/lib as well And, what can I do to make LD_LIBRARY_PATH permanent? On Thu, Mar 13, 2008 at 12:12 PM, P Kishor <[EMAIL PROTECTED]> wrote: > fwiw, my /etc/ld.so.conf is like so > > /usr/kerberos/lib > /usr/X11R6/lib > /usr/lib/pgsql > /usr/lib > /usr/local/lib > /usr/local/arcsde/sdeexe83/lib > /usr/lib/qt-3.1/lib > ld.so.conf (END) > > > in other words, /usr/local/lib is in it. > > > > On Thu, Mar 13, 2008 at 12:09 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > I am not at all conversant with RH Linux (RHEL-es3). I have just > > compiled sqlite3.5.6 from amalgamation, and I get the error that > > libsqlite3.so.0 can't be found. I did the following > > > > ./configure > > make && make install > > > > sqlite3 is place in /usr/local/bin > > and libsqlite3.so.0 is placed in /usr/local/lib > > > > [12:07 PM] /usr/local/lib$ ls -l libsql* > > -rw-r--r-- 1 root 765640 Mar 13 11:51 libsqlite3.a > > -rwxr-xr-x 1 root 828 Mar 13 11:51 libsqlite3.la* > > lrwxrwxrwx 1 root 19 Mar 13 11:51 libsqlite3.so -> > > libsqlite3.so.0.8.6* > > lrwxrwxrwx 1 root 19 Mar 13 11:51 libsqlite3.so.0 -> > > libsqlite3.so.0.8.6* > > -rwxr-xr-x 1 root 679734 Mar 13 11:51 libsqlite3.so.0.8.6* > > > > > > of course ldd -v does say > > > > [12:03 PM] ~$ ldd -v /usr/local/bin/sqlite3 > > libsqlite3.so.0 => not found > > > > What extra step do I have to take on this computer to make sqlite3 > > work properly? > > > > -- > > Puneet Kishor > > > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users