[sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Robert Villanoa
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

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Jean-Denis Muys
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

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Robert Villanoa
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

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Jean-Denis Muys
On 5/18/09 10:33 AM, Robert Villanoa robertvilla...@yahoo.com 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:

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Dan
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

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Robert Villanoa
Dear Jean Denis, to answer your question, I did the following: After installing sqlite3 3.6.14, I executed the search command sudo find / -name sqlite3 to find all possible locations containing the executable file sqlite3. And the result I get is:

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Robert Villanoa
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 =

Re: [sqlite] How to install the latest version of sqlite3 on Ubuntu?

2009-05-18 Thread Alex Mandel
Robert, 1. When you build you want to make sure to override the default directory settings. ./configure --builddir=/usr/ Check the directions and configure script for options (make sure to run make clean before you attempt to run make again.) 2. Use Checkinstall, it will build a deb file