[FGS] fgs build GDAL with mysql

[sbarnes]

Normand,

I was just running a fgs build and i had the same error.  I decided to  
try a newer mysql and i was able to build it without error.  Although  
changing the version of mysql required that i edit and pkg_def/_misc/ 
get_mysql_devel.sh.  I also had to edit pkg_def/php/fgs_build and  
pkg_def/gdal/fgs_build and hardcode the path to the new mysql binaries  
(not sure why but, i don't have time right now to figure out where the  
fgs_build script is getting the wrong $mysql_ARCHIVE_DIR).

here's my configure;

configured by ./configure, generated by GNU Autoconf 2.61,
   with options \"'--prefix=/home/sbarnes/fgs-dev/built/gdal' '--with- 
pymoddir=/home/sbarnes/fgs-dev/built/gdal/pymod' '--with-jpeg=/home/ 
sbarnes/fgs-dev/built/jpeg' '--with-libtiff=/home/sbarnes/fgs-dev/ 
built/tiff' '--with-geotiff=/home/sbarnes/fgs-dev/built/libgeotiff' '-- 
with-png=/home/sbarnes/fgs-dev/built/libpng' '--with-pg=/home/sbarnes/ 
fgs-dev/built/postgresql/bin/pg_config' '--with-odbc=/home/sbarnes/fgs- 
dev/built/unixODBC' '--with-xerces=/home/sbarnes/fgs-dev/built/ 
xerces_c' '--with-curl=/home/sbarnes/fgs-dev/built/curl/bin/curl- 
config' '--without-geos' '--without-python' '--without-libtool' '-- 
with-mysql=/home/sbarnes/fgs-dev/built/mysql-5.0.51a-linux-i686- 
glibc23/bin/mysql_config'\"


cheers,
shawn
On 8-Apr-08, at 1:01 PM, Normand Savard wrote:
> Hi,
>
> I'm trying to build the GDAL 1.5.0 package with mysql 4.1.22 enabled  
> on Debian etc 4, but I got the error below. What is particular is  
> that I succeeded to compile PHP 5.2.5 with the same mysql header. I  
> have also included my PHP and GDAL configuration settings below.
>
> Any clue?
>
> Norm
>
> -----------------------
> Error:
> make -C mysql
> make[3]: Entering directory `/home/fgs/fgs-dev/src/gdal-1.5.0/ogr/ 
> ogrsf_frmts/mysql'
> g++ -g -O2 -fPIC -Wall -I.. -I../.. -I/home/fgs/fgs-dev/src/ 
> gdal-1.5.0/port -I/home/fgs/fgs-dev/src/gdal-1.5.0/gcore -I/home/fgs/ 
> fgs-dev/src/gdal-1.5.0/alg -I/home/fgs/fgs-dev/src/gdal-1.5.0/ogr -I/ 
> home/fgs/fgs-dev/src/gdal-1.5.0/ogr/ogrsf_frmts -I/home/fgs/fgs-dev/ 
> built/mysql-standard-4.1.22-pc-linux-gnu-i686/include -DOGR_ENABLED - 
> I/home/fgs/fgs-dev/src/gdal-1.5.0/port -I/home/fgs/fgs-dev/built/ 
> unixODBC -I/home/fgs/fgs-dev/built/unixODBC/include -I/home/fgs/fgs- 
> dev/built/jpeg -I/home/fgs/fgs-dev/built/jpeg/include -I/home/fgs/ 
> fgs-dev/built/libgeotiff/include -I/home/fgs/fgs-dev/built/tiff/ 
> include -I/home/fgs/fgs-dev/built/libpng -I/home/fgs/fgs-dev/built/ 
> libpng/include -c -o ../o/ogrmysqldriver.o ogrmysqldriver.cpp
> /usr/include/asm-i486/bitops.h:244: error: expected initializer  
> before ‘int’
>
>
> -----------------
> GDAL config settings:
>
> configured by ./configure, generated by GNU Autoconf 2.61,
> with options \"'--prefix=/home/fgs/fgs-dev/built/gdal' '--with- 
> pymoddir=/home/
> fgs/fgs-dev/built/gdal/pymod' '--with-jpeg=/home/fgs/fgs-dev/built/ 
> jpeg' '--with
> -libtiff=/home/fgs/fgs-dev/built/tiff' '--with-geotiff=/home/fgs/fgs- 
> dev/built/l
> ibgeotiff' '--with-png=/home/fgs/fgs-dev/built/libpng' '--with-pg=/ 
> home/fgs/fgs-
> dev/built/postgresql/bin/pg_config' '--with-odbc=/home/fgs/fgs-dev/ 
> built/unixODB
> C' '--with-xerces=/home/fgs/fgs-dev/built/xerces_c' '--with-curl=/ 
> home/fgs/fgs-d
> ev/built/curl/bin/curl-config' '--without-geos' '--without-python'  
> '--without-li
> btool' '--with-mysql=/home/fgs/fgs-dev/built/mysql-standard-4.1.22- 
> pc-linux-gnu-
> i686/bin/mysql_config'\"
>
> ------------
> PHP config settings:
>
> ./configure --with-regex=system --with-freetype-dir=/home/fgs/fgs- 
> dev/built/f
> reetype --with-dbase --enable-dbase --prefix=/home/fgs/fgs-dev/built/ 
> php --with-
> mysql=shared,/home/fgs/fgs-dev/built/mysql-standard-4.1.22-pc-linux- 
> gnu-i686 --w
> ith-pgsql=shared,/home/fgs/fgs-dev/built/postgresql --with- 
> pdflib=shared,/home/f
> gs/fgs-dev/built/pdflib_lite --with-png-dir=/home/fgs/fgs-dev/built/ 
> libpng --wit
> h-jpeg-dir=/home/fgs/fgs-dev/built/jpeg --with-tiff-dir=/home/fgs/ 
> fgs-dev/built/
> tiff --with-gd=/home/fgs/fgs-dev/built/gd --with-zlib-dir=/home/fgs/ 
> fgs-dev/buil
> t/zlib --with-zlib -enable-track-vars --enable-sockets --enable- 
> wddx=shared --wi
> th-xmlrpc=shared --enable-calendar --with-libxml-dir=/home/fgs/fgs- 
> dev/built/lib
> xml2 --with-dom=shared,/home/fgs/fgs-dev/built/libxml2 --with-expat- 
> dir=/home/fg
> s/fgs-dev/built/expat --with-iconv-dir=/home/fgs/fgs-dev/built/ 
> libiconv --with-c
> url=shared,/home/fgs/fgs-dev/built/curl --with-iconv=/home/fgs/fgs- 
> dev/built/lib
> iconv --enable-cgi --enable-force-cgi-redirect --with-apxs2=/home/ 
> fgs/fgs-dev/bu
> ilt/apache/bin/apxs --enable-ftp --with-unixODBC=shared,/home/fgs/ 
> fgs-dev/built/
> unixODBC --with-mssql=shared,/home/fgs/fgs-dev/built/freetds
>
> _______________________________________________
> Foss-gis-suite mailing list
> Foss-gis-suite at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/foss-gis-suite