DBD::mysql make fails on AIX 5.2

Hello,

I'm having some problems installing DBD::mysql on an AIX box. Here
are the system specs:
OS : AIX 5.2.0.0
Perl : 5.8.8 compiled with gcc
gcc : 4.1.1
DBI : 1.52
DBD::mysql : 3.0008
mysql : 5.0.18 (from mysql_config --version)

Makefile generation seems clean:
pcboutro@ccb690[502] >> perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) =
-I/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/i nclude -ma
-qstrict -qoptimize=2 -qmaxmem=8192
embedded (mysql_config) =
libs (mysql_config) =
-L/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/l ib
-lmysqlclient -lz -lcrypt -lnsl_r -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.52 (for perl 5.008008 on aix-thread-multi) installed in
/db2blast/perl/lib/site_perl/5.8.8/aix-thread-multi/auto/DBI /
Writing Makefile for DBD::mysql

But make fails:
pcboutro@ccb690[503] >> make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
/db2blast/perl/bin/perl -e 'use ExtUtils::Mksymlists; \
Mksymlists("NAME" => "DBD::mysql", "DL_FUNCS" => { }, "FUNCLIST" =>
[], "DL_VARS" => []);'
gcc -c -I/db2blast/perl/lib/site_perl/5.8.8/aix-thread-multi/auto/D BI
-I/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/i nclude -ma
-qstrict -qoptimize=2 -qmaxmem=8192 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-D_THREAD_SAFE -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGE_FILES -O
-DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\"
"-I/db2blast/perl/lib/5.8.8/aix-thread-multi/CORE" dbdimp.c
gcc: unrecognized option '-qstrict'
gcc: unrecognized option '-qoptimize=2'
gcc: unrecognized option '-qmaxmem=8192'
cc1: error: unrecognized command line option "-ma"
make: *** [dbdimp.o] Error 1

I'm not sure if I'm missing something obvious or not: any suggestions
much appreciated!

Paul

RE: DBD::mysql make fails on AIX 5.2

On 19-Oct-2006 Paul Boutros wrote:
> Hello,
>
> I'm having some problems installing DBD::mysql on an AIX box. Here
> are the system specs:
> OS : AIX 5.2.0.0
> Perl : 5.8.8 compiled with gcc
> gcc : 4.1.1
> DBI : 1.52
> DBD::mysql : 3.0008
> mysql : 5.0.18 (from mysql_config --version)
>
> Makefile generation seems clean:
> pcboutro@ccb690[502] >> perl Makefile.PL
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) =
> -I/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/i nclude -ma
> -qstrict -qoptimize=2 -qmaxmem=8192
> embedded (mysql_config) =
> libs (mysql_config) =
> -L/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/l ib
> -lmysqlclient -lz -lcrypt -lnsl_r -lm
> mysql_config (guessed ) = mysql_config
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> testdb (default ) = test
> testhost (default ) =
> testpassword (default ) =
> testsocket (default ) =
> testuser (default ) =
>
> To change these settings, see 'perl Makefile.PL --help' and
> 'perldoc INSTALL'.
>
> Checking if your kit is complete...
> Looks good
> Using DBI 1.52 (for perl 5.008008 on aix-thread-multi) installed in
> /db2blast/perl/lib/site_perl/5.8.8/aix-thread-multi/auto/DBI /
> Writing Makefile for DBD::mysql
>
> But make fails:
> pcboutro@ccb690[503] >> make
> cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
> cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
> cp lib/Mysql.pm blib/lib/Mysql.pm
> cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
> cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
> cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
> /db2blast/perl/bin/perl -e 'use ExtUtils::Mksymlists; \
> Mksymlists("NAME" => "DBD::mysql", "DL_FUNCS" => { }, "FUNCLIST" =>
> [], "DL_VARS" => []);'
> gcc -c -I/db2blast/perl/lib/site_perl/5.8.8/aix-thread-multi/auto/D BI
> -I/pubmed/mysql/mysql_inst/mysql-max-5.0.18-aix5.2-powerpc/i nclude -ma
> -qstrict -qoptimize=2 -qmaxmem=8192 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
> -D_THREAD_SAFE -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -fno-strict-aliasing -pipe
> -Wdeclaration-after-statement -I/usr/local/include -D_LARGE_FILES -O
> -DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\"
> "-I/db2blast/perl/lib/5.8.8/aix-thread-multi/CORE" dbdimp.c
> gcc: unrecognized option '-qstrict'
> gcc: unrecognized option '-qoptimize=2'
> gcc: unrecognized option '-qmaxmem=8192'
> cc1: error: unrecognized command line option "-ma"
> make: *** [dbdimp.o] Error 1
>
> I'm not sure if I'm missing something obvious or not: any suggestions
> much appreciated!
>
> Paul

Well the obvious reason it is failing is that the gcc you have doesn't
understand -qstrict, -qoptimize=2, -qmaxmem=8192 and -ma. Did you compile with
a different gcc to the one you are using now?

You can obviously remove those from the make file but I'd look at your perl -V
output to see how perl itself was compiled first.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com