SQLite header and source version mismatch after install Sqlite3 and Spatialite on Ubuntu 14.04

64 views
Skip to first unread message

cesare gerbino

unread,
Jan 26, 2016, 2:27:55 PM1/26/16
to SpatiaLite Users
I'm trying to install Spatialite on Ubuntu ....

My Ubuntu version is the follow ...

$ lsb_release -dc
Description:    Ubuntu 14.04.3 LTS
Codename:       trusty

Here you are what I've installed

1) Sqlite3
=======
tar -xzf sqlite-autoconf-3100200.tar.gz
cd sqlite-autoconf-3100200/
./configure
make
sudo make install
sudo ldconfig
cd ..


2) Proj
=====
   tar -xzf proj-4.9.2.tar.gz
   cd proj-4.9.2
   ./configure
   make
   sudo make install
   cd ..  

3) Geos
======
   tar -xjf geos-3.5.0.tar.bz2
   cd geos-3.5.0
   ./configure
   make
   sudo make install
   sudo ldconfig
   cd ..  

4) Freexl
=======
   tar -xzf freexl-1.0.2.tar.gz
   cd freexl-1.0.2
   ./configure
   make
   sudo make install
   sudo ldconfig
   cd .. 

5) Spatialite
=========
   tar -xzf libspatialite-4.4.0-RC0.tar.gz
   cd libspatialite-4.4.0-RC0
   ./configure --enable-geocallbacks
   make
   sudo make install
   sudo ldconfig
   cd ..


7) export "LD_LIBRARY_PATH=/usr/local/lib" 

9) sudo chmod 777 /var/www/sqlite3_ext 

10) sudo chmod 777 /var/www/sqlite3_ext/*.so

Trying to execute the PHP code found at the bottom of the page http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/php.html all works fine ....

Trying to launch sqlite3 also works

$ sqlite3
SQLite version 3.10.2 2016-01-20 15:27:19
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

but .... when I try to launch spatialite .....

$ spatialite
SQLite header and source version mismatch
2016-01-20 15:27:19 17efb4209f97fb4971656086b138599a91a75ff9
2013-12-06 14:53:30 27392118af4c38c5203a04b8013e1afdb1cebd0d

Any suggestions? 

Thank you very much in advance!!!!

 Cesare




a.fu...@lqt.it

unread,
Jan 26, 2016, 3:33:44 PM1/26/16
to spatiali...@googlegroups.com
On Tue, 26 Jan 2016 11:27:55 -0800 (PST), cesare gerbino wrote:
> but .... when I try to launch spatialite .....
>
> $ spatialite
> SQLite header and source version mismatch
> 2016-01-20 15:27:19 17efb4209f97fb4971656086b138599a91a75ff9
> 2013-12-06 14:53:30 27392118af4c38c5203a04b8013e1afdb1cebd0d
>
> Any suggestions? 
>

Hi Cesare,

the spatialite (CLI tool) simply is a strict derivative of
the sqlite3 front-end, and both them include an internal
check intended to verify if the run-time version of libsqlite3
exactly is the same used when configuring and building
the tool.

now you've installed newer versions of libsqlite3 and
libspatialite without rebuilding the CLI tool, and as a
direct consequence this later warns you about mismatching
versions.

you simply have to rebuild and reinstall the spatialite
CLI tool against the more recent libraries and this
issue will magically disappear ;-)

bye Sandro

cesare gerbino

unread,
Jan 27, 2016, 3:31:44 PM1/27/16
to SpatiaLite Users
Hi Sandro,

after spatialite CLI tool installation now all works fine ... Thank you!

 Cesare
Reply all
Reply to author
Forward
0 new messages