[gdal-dev] (no subject) [sqlite configuration]

[Even Rouault]

Le jeudi 23 janvier 2014 17:09:41, Jonathan Greenberg a écrit :
> GDALers:
> 
> I've not had this error before when compiling GDAL for Linux boxes, but I'm
> getting some sqlite error.  This is from:
> ./configure --prefix=/pathto/wherever --with=python
> make
> 
> ***
> ...
> chmod a+x gdal-config
> /bin/sh /projects/oa/shared/jgrn/code/src/gdal-1.10.1/libtool --mode=link
>     g++  gdalinfo.lo commonutils.lo
>  /projects/oa/shared/jgrn/code/src/gdal-1.10.1/libgdal.la -o gdalinfo
> libtool: link: g++ .libs/gdalinfo.o .libs/commonutils.o -o .libs/gdalinfo
>  /projects/oa/shared/jgrn/code/src/gdal-1.10.1/.libs/libgdal.so
> -L/usr/apps/oa/lib -L/usr/lib64/hdf -L/usr/apps/oa/lib/lib
> -L/usr/local/openmpi-1.4-gcc/lib /usr/apps/oa/lib/libgeos_c.so
> /usr/apps/oa/lib/libgeos.so /usr/apps/oa/lib/libsqlite3.so -lexpat -ljasper
> -lnetcdf -lhdf5 /usr/apps/oa/lib/libmfhdf.so /usr/apps/oa/lib/libdf.so
> /usr/apps/oa//lib/libjpeg.so /usr/apps/oa/lib/libpng15.so -lpthread -lrt
> -lpcre -lcurl /usr/apps/oa/lib/libxml2.so -lm -ldl -lz  -Wl,-rpath
> -Wl,/usr/apps/oa/lib -Wl,-rpath -Wl,/usr/apps/oa//lib
> /projects/oa/shared/jgrn/code/src/gdal-1.10.1/.libs/libgdal.so: undefined
> reference to `sqlite3_column_table_name'
> collect2: ld returned 1 exit status
> make[1]: *** [gdalinfo] Error 1
> make[1]: Leaving directory
> `/projects/oa/shared/jgrn/code/src/gdal-1.10.1/apps'
> make: *** [apps-target] Error 2
> 
> 
> ***
> 
> I do have SQLite properly installed via the sqlite-autoconf-3080200
> release, configured via:
> ./configure --prefix=/pathto/wherever
> make
> make install
> 
> Any ideas?

Jonathan,

The GDAL source code tries to use sqlite3_column_table_name only if it is 
available i the sqlite library. Indeed, not all builds of sqlite3 have 
sqlite3_column_table_name defined. So you should not get this error 
theroretically.

My hypothesis is that the test in ./configure that detects if 
sqlite3_column_table_name is available or not must link against another 
library than the one that GDAL is finally linking against. This is a bit weird 
however that this happens, but I'd encourage you checking that there are not 
several libsqlite3.so hanging around.

Even

-- 
Geospatial professional services
http://even.rouault.free.fr/services.html