Did you change your path (in $HOME/.bash_profile) to point to /usr/local/bin, then log out and log back in again? I think the path setting may be the real issue.
After changing /etc/ld.so.conf did you run `ldconfig` as root? Thanks Bob Cochran Greenbelt, Maryland, USA P Kishor wrote: > 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 > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users