fgs build GDAL with mysql

[Normand Savard-2]

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@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[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@...
> http://lists.maptools.org/mailman/listinfo/foss-gis-suite

_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[Normand Savard-2]

sbarnes wrote:

> 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'\"
>
>

Shawn,

Thank you.  I'll wait a little bit to see if Frank has an idea and if
not I'll do what you do.  I'll have to recompile PHP and others though.

By the way the mysql variable is set when the
$FGS_PKGS_DEF_HOME/_misc/get_mysql_devel.sh is execute but the fgs_build
script of GDAL the script is called after the OPTIONS is set.  It is why
the $mysql_ARCHIVE_DIR variable is not set.

Norm


_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[Frank Warmerdam-2]

Normand Savard wrote:

> sbarnes wrote:
>> 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'\"
>>
>>
> Shawn,
>
> Thank you.  I'll wait a little bit to see if Frank has an idea and if
> not I'll do what you do.  I'll have to recompile PHP and others though.
>
> By the way the mysql variable is set when the
> $FGS_PKGS_DEF_HOME/_misc/get_mysql_devel.sh is execute but the fgs_build
> script of GDAL the script is called after the OPTIONS is set.  It is why
> the $mysql_ARCHIVE_DIR variable is not set.

Norm,

The type of problem you see is *normally* due to some include file #defining
some common name, and screwing up prototypes of other system files.  I don't
have any advice how to fix it, other than Shawn's.  I do vaguely recall
running into this myself once in the past, but I don't recall any specific
solution.  So just upgrade mysql as suggested.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam@...
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org

_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite

[Normand Savard-2]

Frank Warmerdam wrote:
> The type of problem you see is *normally* due to some include file
> #defining
> some common name, and screwing up prototypes of other system files.  I
> don't
> have any advice how to fix it, other than Shawn's.  I do vaguely recall
> running into this myself once in the past, but I don't recall any
> specific
> solution.  So just upgrade mysql as suggested.
>

Thank you Frank.  I'll do so.

Norm
_______________________________________________
Foss-gis-suite mailing list
Foss-gis-suite@...
http://lists.maptools.org/mailman/listinfo/foss-gis-suite