Thank you very much Dan, because this is exactly the problem.
I used ldd to check shared library dependencies of the executable file sqlite3
and the result was:
linux-gate.so.1 => (0xb7fc3000)
libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0xb7f4e000)
libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7f4a000)
libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7f31000)
libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7de2000)
/lib/ld-linux.so.2 (0xb7fc4000)
However, the file libsqlite3.so.0 from the sqlite3 3.6.14 package is installed
to the /usr/local/lib/ folder. I then deleted libsqlite3.so.0 in /user/lib/ and
then copied the one from /usr/local/lib/ to /usr/lib/ and I got the correct
version of sqlite3.
Now I wonder is that enough? I mean whether simply copying libsqlite3.so.0 to
/usr/lib/ will let me use the new version completely? Or is there any further
modifications I must do for me to use sqlite3 3.6.14 'properly'?
Thank you so much for your help!
________________________________
From: Dan <danielk1...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Monday, May 18, 2009 4:43:53 PM
Subject: Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?
On May 18, 2009, at 3:33 PM, Robert Villanoa wrote:
> Thank you for your answer, Jean-Denis.
> When I type 'which sqlite3', I get the following location:
> /usr/local/bin/sqlite3
> And the value of my PATH variable is:
> /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/
> games
> So I think the executable file sqlite3 is seen by PATH.
> Could you please tell me any more suggestions?
$ ldd /usr/local/bin/sqlite3
Check it's linking to the correct libsqlite3.so.
Dan.
>
>
>
>
>
>
> ________________________________
> From: Jean-Denis Muys <jdm...@kleegroup.com>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Monday, May 18, 2009 2:50:38 PM
> Subject: Re: [sqlite] How to install the latest version of sqlite3
> on Ubuntu?
>
>
> On 5/18/09 9:19 AM, "Robert Villanoa" <robertvilla...@yahoo.com>
> wrote:
>
>> Hi everyone,
>>
>> I am new to sqlite3. My OS is Ubuntu 8.04 and it has sqlite3 3.4.2.
>> Now I want
>> to upgrade it to the latest version, 3.6.14, but I don't know how
>> to do that.
>>
>> Here are the steps I have done (after reading another thread about
>> this
>> issue):
>> 1. Remove the default version using 'sudo apt-get remove sqlite3'.
>> 2. Download sqlite-amalgamation-3.6.14.tar.gz, extract the package,
>> go to the
>> sqlite3 directory and run:
>> - ./configure
>> - make
>> - sudo make install
>> Although I did not encounter any error after executing these above
>> commands,
>> it seemed that I did not install sqlite3 3.6.14 successfully.
>> Whenever I type
>> 'sqlite3' into the GNOME terminal, it shows that the version is
>> 3.4.2.
>> What's wrong with me? Please help! Thanks in advanced!
>
> PATH problem? When you type "which sqlite3" in the terminal, what is
> the
> result? Does it match your install location?
>
> JD
>
> _______________________________________________
> 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
_______________________________________________
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
