Flag --with-spatialite doesn't compile with mingw-builds

[d2tran]

mingw-builds (x32-4.8.1-release-posix-dwarf-rev5 and msys+7za+wget+svn+git+mercurial+cvs-rev13)

sqlite-autoconf-3080403 and libspatialite-4.1.1

v1.10.1 configure shows: Spatialite support: yes

ERROR Message

In file included from vfkreader.cpp:32:0:
vfkreader.h:44:21: fatal error: sqlite3.h: No such file or directory
 #include "sqlite3.h"
                     ^
compilation terminated.
../../../GDALmake.opt:542: recipe for target `../o/vfkreader.lo' failed
make[3]: *** [../o/vfkreader.lo] Error 1
make[3]: Leaving directory `/home/David/gdal-1.10.1/ogr/ogrsf_frmts/vfk'
../../GDALmake.opt:555: recipe for target `vfk-target' failed
make[2]: *** [vfk-target] Error 2
make[2]: Leaving directory `/home/David/gdal-1.10.1/ogr/ogrsf_frmts'
GNUmakefile:51: recipe for target `sublibs' failed
make[1]: *** [sublibs] Error 2
make[1]: Leaving directory `/home/David/gdal-1.10.1/ogr'
GNUmakefile:56: recipe for target `ogr-target' failed
make: *** [ogr-target] Error 2

​http://pastebin.com/tCYR95CU

it compiles fine with mingw32 (www.mingw.org) and gdal 1.9.2.

[Even Rouault]

Where is the prefix installation of your sqlite3 and spatialite libs : /usr/local ?

sqlite / spatialite detection in GDAL configure works moderately well with a prefix that is not /usr.

I however manage to get something to build by configuring like this : ./configure --with-spatialite=/usr/local --with-local

--with-local will add the /usr/local/include directory to all include paths.

[Jukka Rahkonen]

d2tran, does it compile for you as it did for Even?

[d2tran]

i did not test that. please reopen the ticket if it is false.