Unable to locate package libsqlite3-mod-spatialite

[arvindshmicrosoft]

hi Jim, Am getting an error when trying to setup on Ubuntu 14.04, setup.sh fails:

Unable to locate package libsqlite3-mod-spatialite

Any suggestions?

[jlmcgraw]

I don't know the details as to why but something changed with how spatialite extension is loaded into sqlite in more recent versions

A couple of options:

a) You can try with a more recent version of Ubuntu (which includes newer sqlite)

b) Try installing "libspatialite3" instead of "libsqlite3-mod-spatialite" in setup.sh, and adjust sqliteToSpatialite.sql as follows:

-- The old way of loading spatialite SELECT load_extension('libspatialite.so'); -- The new way -- See https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite -- SELECT load_extension('mod_spatialite');

[arvindshmicrosoft]

Thanks Jesse. I downloaded the DEB file for libspatialite3 and then used dpkg to install it. That seems to have fixed this.

[jlmcgraw]

I don't know the details as to why but something changed with how spatialite extension is loaded into sqlite in more recent versions

A couple of options:

 a) You can try with a more recent version of Ubuntu

 b) Try installing "libspatialite3" instead, and adjust 

sqliteToSpatialite.sql as follows:

-- The old way of loading spatialite SELECT load_extension('libspatialite.so'); -- The new way -- See https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite -- SELECT load_extension('mod_spatialite');

Let me know how it goes

-Jesse

On 10/23/2016 03:39 AM, arvindshmicrosoft wrote:

hi Jim, Am getting an error when trying to setup on Ubuntu 14.04, setup.sh fails:

Unable to locate package libsqlite3-mod-spatialite

Any suggestions?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jlmcgraw/processFaaData/issues/1, or mute the thread https://github.com/notifications/unsubscribe-auth/ADSE3owqDIbVHkpXUIzcYU_WeUcx6IUvks5q2w9DgaJpZM4KeEj5.