SQLite3 load_extension() fails to load spatialite (Was: transition: geos (spatialite->postgis->gdal->spatialite circular dependency))

[Sebastiaan Couwenberg <sebastic@xs4all.nl>]

On 31-08-15 21:49, Sébastien Kalt wrote:
> I'm having an error when I try to load spatialite extension in sqlite
> under Sid :
> 
> $ sqlite3
> SQLite version 3.8.11.1 2015-07-29 20:00:57
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> sqlite> select load_extension("/usr/lib/x86_64-linux-gnu/libspatialite.so.7");
> Error: /usr/lib/x86_64-linux-gnu/libspatialite.so.7: undefined symbol:
> sqlite3_spatialite_init
> sqlite>
> 
> Before filing a bug, might that be a temporary side effect of this transition ?
> 
> I'm using sqlite3 3.8.11.1-1 and libspatialite7 4.3.0-3.

This doesn't seem related to the geos transition.

When using load_extension() you use mod_spatialite from the
libsqlite3-mod-spatialite package:

 SELECT load_extension('mod_spatialite');

You should use libspatialite when linking your application to SpatiaLite.

Kind Regards,

Bas

-- 
 GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146  50D1 6750 F10A E88D 4AF1