Spatialite 4.3.0a on Ubuntu 14.94.2 LTS : when compiling --> configure: error: cannot find sqlite3.h, bailing out

[cesare gerbino]

Hi all,

I'm trying to install Spatialite 4.3.0a (rif. http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0a.tar.gz), on a Ubuntu 14.94.2 LTS.

I've installed:

• apache2
• apache2-mod-php5
• php5
• php5-cli
• php5-sqlite
• proj 4.9.2
• geos 3.5.0
• freexl 1.0.2

When I try to download and compiling using the following

wget http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0a.tar.gz

tar -xzf libspatialite-4.3.0a.tar.gz

cd libspatialite-4.3.0a

./configure 




obtain  

configure: error: cannot find sqlite3.h, bailing out

Suggestions? Thank you very much in advance!!!

Cesare







[a.fu...@lqt.it]

On Mon, 14 Dec 2015 03:10:51 -0800 (PST), cesare gerbino wrote:
> Hi all,
>
> I'm trying to install Spatialite 4.3.0a
>
> (rif. http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0a.tar.gz),
> on a Ubuntu 14.94.2 LTS.
>
> I've installed:
>

> * APACHE2
> * APACHE2-MOD-PHP5
> * PHP5
> * PHP5-CLI
> * PHP5-SQLITE
> * PROJ 4.9.2
> * GEOS 3.5.0
> * FREEXL 1.0.2

>
> When I try to download and compiling using the following
>
> wget
>
> http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0a.tar.gz
> tar -xzf libspatialite-4.3.0a.tar.gz
> cd libspatialite-4.3.0a
> ./configure 
>
> obtain  
>
> configure: error: cannot find sqlite3.h, bailing out
>

Ciao Cesare,

on Linux platforms any library is usually distributed as two
(or even more) different packages:
1. runtime: the shared library (.so)
2. development: the header files
3. other: e.g. debug, static library (.a) etc

you've just installed several runtime packages, but accordingly
to your report you've missed to install their companion "-dev"
packages, so the header files are still missing.
now you simply have to install:

- sqlite3-dev
- libproj-dev
- libgeos-dev
- libfreexl-dev

bye Sandro

[cesare gerbino]

Hi Sandro,

I've installed all the "dev-*" packages and retry the ./configure .... 

Now the message is:

Configure: error: could not find geos_c.h - you may need to specify the directory of a geos-config file using --with-geosconfig

Seaching on the web there is not so much about this stuff, the more interesting thing is the follow https://groups.google.com/forum/#!topic/spatialite-users/J4LcmNJeFVY

I've tried 

./configure --with-geosconfig=/usr/local/bin/geos-config

but the error is stiil the same

NOTE: my geos-config file is empty (??!!)

P.S I did not think it was so difficult! ... :-)

[cesare gerbino]

Hi Sandro,

I've solved now trying to install the new RC 4.4.0 .....

 Thanks