Hello all,<br><br>I&#39;ve done some tests to build gdal 1.9.0 in Ubuntu 10.04 (Lucid)<br>I&#39;ve build proj 3.3.2, Sqlite 3.3.10, Free XL 1.0.0b, libspatialite amalgation 3.0.0, spatialite-tools 3.0.0<br>No problem with sqlite alone.<br>

<br>#####################################################<br>My main problem is when I compile gdal for spatialite support.<br>#####################################################<br><br>I do <br><br>./configure --with-geos=yes --with-python --with-spatialite=yes --with-sqlite3=yes --with-curl=/usr/bin/ --with-pg=/usr/lib/postgresql/9.0/bin/pg_config<br>

make<br><br>and I get<br><br>...<br>libtool: link: g++ .libs/gdalinfo.o -o .libs/gdalinfo  /home/thomas/compile/gdal-1.9.0/.libs/libgdal.so -L/usr/local/lib -L/usr/lib /usr/lib/libodbc.so /usr/lib/libodbcinst.so /usr/lib/libexpat.so -lxerces-c /usr/lib/libNCSEcw.so /usr/lib/libNCSEcwC.so /usr/lib/libNCSCnet.so /usr/lib/libNCSUtil.so /usr/lib/libjasper.so -lnetcdf /usr/lib/libhdf5.so /usr/lib/libmfhdfalt.so /usr/lib/libdfalt.so -logdi /usr/lib/libgif.so /usr/lib/libjpeg.so -lpng -lpq -lz -lrt /usr/local/lib/libspatialite.so -lpthread -ldl /usr/local/lib/libfreexl.so /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so /usr/lib/libproj.so -lm /usr/lib/libcurl-gnutls.so<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_bind_int&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_double&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_exec&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_text&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_bind_double&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_bind_blob&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_step&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_get_table&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_open&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_free_table&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_reset&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_vfs_find&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_bytes&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_clear_bindings&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_blob&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_vfs_unregister&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_last_insert_rowid&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_libversion_number&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_name&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_prepare&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_vfs_register&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_int&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_prepare_v2&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_finalize&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_bind_text&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_count&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_close&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_decltype&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_column_type&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_errmsg&#39;<br>


gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_bind_null&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_free&#39;<br>gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_open_v2&#39;<br>


<br>With the ./configure, the return was<br>SQLite support:            yes<br>SpatiaLite support:        yes<br><br>Doing<br>
<br>
ldd /home/thomas/compile/gdal-1.9.0/.libs/libgdal.so|grep lite<br>return<br>libspatialite.so.2 =&gt; /usr/local/lib/libspatialite.so.2 (0x012ec000)<br><br><br>#############################################################<br>

The same case without --with-spatialite=yes<br>no problem in the make, but no spatialite support<br>#############################################################<br><br>./configure --with-geos=yes --with-python --with-sqlite3=yes --with-curl=/usr/bin/ 
--with-pg=/usr/lib/postgresql/9.0/bin/pg_config<br>make<br><br>Doing<br><br>ldd /home/thomas/compile/gdal-1.9.0/.libs/libgdal.so|grep lite<br>return<br>libsqlite3.so.0 =&gt; /usr/local/lib/libsqlite3.so.0 (0x0040f000)<br>

<br>########<br>Question<br>########<br><br>I suppose the 
list of<br>&quot;gdal-1.9.0/.libs/libgdal.so: undefined reference to `sqlite3_*&quot; is sent because of the missing<br>libsqlite3.so.0 =&gt; /usr/local/lib/libsqlite3.so.0 (0x0040f000) <br>but why the libgdal.so doesn&#39;t reference libsqlite3.so too when building using --with-spatialite=yes<br>

For information, I&#39;ve used ldconfig after each build of each lib.<br>Any clue is welcome, maybe I miss something obvious.<br><br>Thanks<br><br>ThomasG