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

[Sébastien Kalt <skalt@throka.org>]

Hi Bas,

2015-08-31 22:00 GMT+02:00 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.
Ok, I didn't know, when I searched some years ago I only found
examples with libspatialite.

It works without error with mod_spatialite, thank you !

Regards,

Sébastien