ubuntu安装sqlite及出错处理

ubuntu安装sqlite及出错处理

出错处理参考：

     http://stackoverflow.com/questions/6696861/how-do-i-upgrade-my-sqlite3-package-on-debian-lenny

To compile you probably need build-essentials:

alfred@alfred-laptop:~$ apt-cache search ^build-essential$
build-essential - Informational list of build-essential packages
alfred@alfred-laptop:~$ sudo apt-get install build-essential

Compile SQLite:

alfred@alfred-laptop:~/tmp$ wget http://www.sqlite.org/sqlite-autoconf-3070701.tar.gz
alfred@alfred-laptop:~/tmp/sqlite-autoconf-3070701$ ./configure
alfred@alfred-laptop:~/tmp/sqlite-autoconf-3070701$ make
alfred@alfred-laptop:~/tmp/sqlite-autoconf-3070701$ sudo make install
alfred@alfred-laptop:~/tmp/sqlite-autoconf-3070701$ sudo ldconfig

especially sudo ldconfig is important. When I did not do that I got

alfred@alfred-laptop:~/tmp/sqlite-autoconf-3070701$ sqlite3
SQLite header and source version mismatch
2010-08-23 18:52:01 42537b60566f288167f1b5864a5435986838e3a3
2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f

I am running Ubuntu which is based on Debian:

alfred@alfred-laptop:~/linux$ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=10.10 DISTRIB_CODENAME=maverick DISTRIB_DESCRIPTION="Ubuntu 10.10"

Finally I ran sqlite3

alfred@alfred-laptop:~$ sqlite3 --version
3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f

share | improve this answer