Newbie question, DBD::mysql/AIX5

am 28.08.2003 11:24:10 von david

Hello, i'm triying to

perl -MCPAN -e 'install "DBD::mysql"'
in a machine wtih AIX5, mysql-3.23.37, Perl v5.8.0 built for
aix-thread-multi-64int.

What i'm doing wrong??? Thank you in advanced...

(...)
CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9002.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/opt/database/mysql/include'
libs (mysql_config) = -L/opt/database/mysql/lib
-lmysqlclient -lcrypt -lnsl_r -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (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.38 installed in
/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64int/ auto/DBI
Writing Makefile for DBD::mysql
/usr/local/bin/perl -e 'use ExtUtils::Mksymlists; \
Mksymlists("NAME" => "DBD::mysql", "DL_FUNCS" => { }, "FUNCLIST" =>
[], "DL_VARS" => []);'
cc_r -c
-I/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64in t/auto/DBI
-I'/opt/database/mysql/include' -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -I/usr/local/include -q32 -D_LARGE_FILES
-qlonglong -O -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\"
"-I/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE" dbdimp.c

(...)

Warning: duplicate function definition 'do' detected in mysql.xs,
line 193Warning: duplicate function definition 'rows' detected in
mysql.xs, line 291
cc_r -c
-I/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64in t/auto/DBI
-I'/opt/database/mysql/include' -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -I/usr/local/include -q32 -
D_LARGE_FILES -qlonglong -O -DVERSION=\"2.9002\"
-DXS_VERSION=\"2.9002\"
"-I/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE" mysql.c
1506-507 (W) No licenses available. Contact your program supplier to
add additional users. Compilation will proceed shortly.
1506-507 (W) No licenses available. Contact your program supplier to
add additional users. Compilation will proceed shortly.
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/opt/database/mysql/lib:/lib" /usr/local/bin/perl myld
ld -bhalt:4 -bM:SRE
-bI:/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE/p erl.exp
-bE:mysql.exp -bnoentry

(...)

Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/00base.t -1 132 ?? ?? % ??
t/10dsnlist.t -1 132 ?? ?? % ??
t/20createdrop.t -1 132 ?? ?? % ??
t/30insertfetch.t -1 132 ?? ?? % ??
t/40bindparam.t -1 132 ?? ?? % ??
t/40blobs.t -1 132 ?? ?? % ??
t/40listfields.t -1 132 ?? ?? % ??
t/40nulls.t -1 132 ?? ?? % ??
t/40numrows.t -1 132 ?? ?? % ??
t/50chopblanks.t -1 132 ?? ?? % ??
t/50commit.t -1 132 ?? ?? % ??
t/ak-dbd.t -1 132 90 90 100.00% 1-90
t/akmisc.t -1 132 351 351 100.00% 1-351
t/dbdadmin.t -1 132 21 21 100.00% 1-21
t/insertid.t -1 132 ?? ?? % ??
t/mysql.t -1 132 ?? ?? % ??
t/mysql2.t -1 132 ?? ??
1 test skipped.
Failed 17/18 test scripts, 5.56% okay. 462/462 subtests failed, 0.00% okay.
make: *** [test_dynamic] Error 2
/usr/local/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Newbie question, DBD::mysql/AIX5

am 28.08.2003 12:03:22 von david

--============_-1150057492==_ma============
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

I use all the time gcc:

gcc -v
Reading specs from /usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/3.0.1/specs
Configured with: ./configure --enable-threads=aix --disable-nls
Thread model: single
gcc version 3.0.1

Thank you in advanced...

There are too many details omitted in your mail, so it's hard to guess.
perl -MCPAN -e 'install "DBD::mysql"' >& my.log
so... more my.log

CPAN: Storable loaded ok
Going to read /data/.cpan/Metadata
Database was generated on Wed, 27 Aug 2003 05:45:07 GMT
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9002.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for
/data/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9002.ta r.gz ok
Scanning cache /data/.cpan/build for sizes
DBD-mysql-2.9002/
DBD-mysql-2.9002/t/
DBD-mysql-2.9002/t/mysql2.t
DBD-mysql-2.9002/t/akmisc.t
DBD-mysql-2.9002/t/60leaks.t
DBD-mysql-2.9002/t/10dsnlist.t
DBD-mysql-2.9002/t/ak-dbd.t
DBD-mysql-2.9002/t/50chopblanks.t
DBD-mysql-2.9002/t/mysql.t
DBD-mysql-2.9002/t/lib.pl
DBD-mysql-2.9002/t/40blobs.t
DBD-mysql-2.9002/t/40nulls.t
DBD-mysql-2.9002/t/insertid.t
DBD-mysql-2.9002/t/40listfields.t
DBD-mysql-2.9002/t/40bindparam.t
DBD-mysql-2.9002/t/mysql.dbtest
DBD-mysql-2.9002/t/dbdadmin.t
DBD-mysql-2.9002/t/20createdrop.t
DBD-mysql-2.9002/t/00base.t
DBD-mysql-2.9002/t/30insertfetch.t
DBD-mysql-2.9002/t/40numrows.t
DBD-mysql-2.9002/t/50commit.t
DBD-mysql-2.9002/t/mysql.mtest
DBD-mysql-2.9002/MANIFEST
DBD-mysql-2.9002/myld
DBD-mysql-2.9002/dbdimp.c
DBD-mysql-2.9002/lib/
DBD-mysql-2.9002/lib/DBD/
DBD-mysql-2.9002/lib/DBD/mysql/
DBD-mysql-2.9002/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9002/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9002/lib/DBD/mysql.pm
DBD-mysql-2.9002/lib/Mysql/
DBD-mysql-2.9002/lib/Mysql/Statement.pm
DBD-mysql-2.9002/lib/Bundle/
DBD-mysql-2.9002/lib/Bundle/DBD/
DBD-mysql-2.9002/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9002/lib/Mysql.pm
DBD-mysql-2.9002/dbdimp.h
DBD-mysql-2.9002/mysql.xs
DBD-mysql-2.9002/MANIFEST.SKIP
DBD-mysql-2.9002/README
DBD-mysql-2.9002/INSTALL.html
DBD-mysql-2.9002/Makefile.PL
DBD-mysql-2.9002/ChangeLog
DBD-mysql-2.9002/constants.h
DBD-mysql-2.9002/TODO

CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9002.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/opt/database/mysql/include'
libs (mysql_config) = -L/opt/database/mysql/lib
-lmysqlclient -lcrypt -lnsl_r -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (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.38 installed in
/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64int/ auto/DBI
Writing Makefile for DBD::mysql
/usr/local/bin/perl -e 'use ExtUtils::Mksymlists; \
Mksymlists("NAME" => "DBD::mysql", "DL_FUNCS" => { }, "FUNCLIST" =>
[], "DL_VARS" => []);'
cc_r -c
-I/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64in t/auto/DBI
-I'/opt/database/mysql/include' -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -I/usr/local/include -q32 -D_LARGE_FILES
-qlonglong -O -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\"
"-I/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE" dbdimp.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g"
/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64int/ auto/DBI/Driver.xst >
mysql.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp
-typemap /usr/local/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs >
mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 193
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
cc_r -c
-I/opt/perl5/lib/perl5/site_perl/5.8.0/aix-thread-multi-64in t/auto/DBI
-I'/opt/database/mysql/include' -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -I/usr/local/include -q32 -D_LARGE_FILES
-qlonglong -O -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\"
"-I/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE" mysql.c
1506-507 (W) No licenses available. Contact your program supplier to
add additional users. Compilation will proceed shortly.
1506-507 (W) No licenses available. Contact your program supplier to
add additional users. Compilation will proceed shortly.
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/opt/database/mysql/lib:/lib" /usr/local/bin/perl myld
ld -bhalt:4 -bM:SRE
-bI:/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE/p erl.exp
-bE:mysql.exp -bnoentry -lpthreads -lc_r -L/usr/local/lib dbdimp.o
mysql.o -o blib/arch/auto/DBD/mysql/mysql.so
-L/opt/database/mysql/lib -lmysqlclient -lcrypt -lnsl_r -lm
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Bundle::DBD::mysql.3
/usr/local/bin/make -j3 -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........dubious
Test returned status -1 (wstat 132, 0x84)
t/10dsnlist........dubious
Test returned status -1 (wstat 132, 0x84)
t/20createdrop.....dubious
Test returned status -1 (wstat 132, 0x84)
t/30insertfetch....dubious
Test returned status -1 (wstat 132, 0x84)
t/40bindparam......dubious
Test returned status -1 (wstat 132, 0x84)
t/40blobs..........dubious
Test returned status -1 (wstat 132, 0x84)
t/40listfields.....dubious
Test returned status -1 (wstat 132, 0x84)
t/40nulls..........dubious
Test returned status -1 (wstat 132, 0x84)
t/40numrows........dubious
Test returned status -1 (wstat 132, 0x84)
t/50chopblanks.....dubious
Test returned status -1 (wstat 132, 0x84)
t/50commit.........dubious
Test returned status -1 (wstat 132, 0x84)
t/60leaks..........skipped
all skipped: no reason given
t/ak-dbd...........dubious
Test returned status -1 (wstat 132, 0x84)
DIED. FAILED tests 1-90
Failed 90/90 tests, 0.00% okay
t/akmisc...........dubious
Test returned status -1 (wstat 132, 0x84)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin.........dubious
Test returned status -1 (wstat 132, 0x84)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid.........dubious
Test returned status -1 (wstat 132, 0x84)
t/mysql............dubious
Test returned status -1 (wstat 132, 0x84)
t/mysql2...........dubious
Test returned status -1 (wstat 132, 0x84)
Failed 17/18 test scripts, 5.56% okay. 462/462 subtests failed, 0.00% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/00base.t -1 132 ?? ?? % ??
t/10dsnlist.t -1 132 ?? ?? % ??
t/20createdrop.t -1 132 ?? ?? % ??
t/30insertfetch.t -1 132 ?? ?? % ??
t/40bindparam.t -1 132 ?? ?? % ??
t/40blobs.t -1 132 ?? ?? % ??
t/40listfields.t -1 132 ?? ?? % ??
t/40nulls.t -1 132 ?? ?? % ??
t/40numrows.t -1 132 ?? ?? % ??
t/50chopblanks.t -1 132 ?? ?? % ??
t/50commit.t -1 132 ?? ?? % ??
t/ak-dbd.t -1 132 90 90 100.00% 1-90
t/akmisc.t -1 132 351 351 100.00% 1-351
t/dbdadmin.t -1 132 21 21 100.00% 1-21
t/insertid.t -1 132 ?? ?? % ??
t/mysql.t -1 132 ?? ?? % ??
t/mysql2.t -1 132 ?? ?? % ??
1 test skipped.
make: *** [test_dynamic] Error 2
/usr/local/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force

--============_-1150057492==_ma============--

Re: Newbie question, DBD::mysql/AIX5

am 28.08.2003 12:03:22 von David Garcia Aristegui

Re: Newbie question, DBD::mysql/AIX5

am 28.08.2003 12:25:51 von david

Excuse me, for me it's hard to explain things in english. Perl etc
was already compiled with gcc 3.0.1
I'm gonna try from source (DBD-mysql-2.9002.tar.gz) with the
Makefile.PL, make, make test, make install dance...

Thankx

>Quoting David Garc=EDa Aristegui :
>
>> I use all the time gcc:
>
>Excellent, so your first step is done. Unfortunately your Perl (most
>probably a binary version of Perl which you have obtained from somewhere
>else) doesn't. :-)
>
>The bad news is, that it is *very* difficult to exchange compilers after
>Perl is compiled. In other words, I definitely recommend to recompile
>Perl from sources using gcc. (Btw, has definitely not been a version
>which is known to be bug free. I'd recommend 2.95 or at least 3.2.)
>
>
>> LD_RUN_PATH=3D"/opt/database/mysql/lib:/lib" /usr/local/bin/perl myld
>> ld -bhalt:4 -bM:SRE
>> -bI:/usr/local/lib/perl5/5.8.0/aix-thread-multi-64int/CORE/p erl.exp
>> -bE:mysql.exp -bnoentry -lpthreads -lc_r -L/usr/local/lib dbdimp.o
>> mysql.o -o blib/arch/auto/DBD/mysql/mysql.so
>> -L/opt/database/mysql/lib -lmysqlclient -lcrypt -lnsl_r -lm
>
>If I am right to blame the missing license, I'd expect an error message
>here. We don't see an error message here, but that might be related
>to a bug in the myld script. Use the option --nocatchstderr when running
>"perl Makefile.PL".
>
>
>Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Newbie question, DBD::mysql/AIX5

am 28.08.2003 12:25:51 von David Garcia Aristegui