More

Spatialite not loaded in PHP5 on Ubuntu


I'm trying to install Spatialite (4.3.0a) on Ubuntu (14.94.2 LTS)… I'd like to use it with PHP (5.5.9-1)…

Following this post

https://faimsproject.atlassian.net/wiki/display/FAIMS/Installing+Spatialite+4+on+Ubuntu

(obviously using the updated versions of the packages involved… ), I've now installed:

  • PHP 5.5.9-1
  • SQLite 3.9.2
  • Proj4 4.9.2
  • Geos 3.5.0
  • Freexl 1.0.2
  • Spatialite 4.3.0a

I've also exported /usr/local/lib

export "LD_LIBRARY_PATH=/usr/local/lib"

It seems that SQLITE 3 and Spatialite are working fine…

sqlite3 myDB SQLite version 3.9.2 2015-11-02 18:31:45 Enter ".help" for usage hints. sqlite> SELECT load_extension('mod_spatialite'); sqlite> SELECT sqlite_version(); 3.9.2 sqlite> SELECT spatialite_version(); 4.3.0a sqlite> SELECT proj4_version(); Rel. 4.9.2, 08 September 2015 sqlite> SELECT geos_version(); 3.5.0-CAPI-1.9.0 r4084 sqlite> .quit

But if I try to execute this simple PHP file

  Testing SpatiaLite on PHP  

Testing SpatiaLite on PHP

… the result is

testing SpatiaLite on PHP SQLite version: 3.9.2

so it seems that somthing is going wrong with loading Spatialite.

My php.ini configuration is the follow

[sqlite] http://php.net/sqlite.assoc-case sqlite.assoc_case = 0 [sqlite3] sqlite3.extension_dir = /var/www/html/test/sqlite3_ext

In /var/www/html/test/sqlite3_ext there are

-rwxr-xr-x 1 cesare cesare 15527574 Dec 1 22:17 libspatialite.so -rwxr-xr-x 1 cesare cesare 15944537 Dec 2 22:28 mod_spatialite.so

I've solved putting

$db->loadExtension('mod_spatialite.so');

in my PHP code and configuring the LD_LIBRARY_PATH env variable in this way

export "LD_LIBRARY_PATH=/usr/local/lib"

for execution from command line


Watch the video: Join data from point to layer with QGIS and Spatialite geopackage (October 2021).