Tests fail when installing DBD::mysql

Hi,

I am having trouble installing the DBD:mysql module on Mac OS 10.4.11.
It's failing during some of the tests:

t/50chopblanks................1/29
# Failed test '$name should not have blanks chopped'
# at t/50chopblanks.t line 60.
# got: ''
# expected: ' '

# Failed test '$name should not have blanks chopped'
# at t/50chopblanks.t line 60.
# got: ' a b c'
# expected: ' a b c '
# Looks like you failed 2 tests of 29.
t/50chopblanks................ Dubious, test returned 2 (wstat 512, 0x200)
Failed 2/29 subtests
t/50commit....................ok
t/55utf8......................skipped: SKIP TEST: You must have MySQL
version 5.0 and greater for this test to run
t/60leaks.....................skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types.....................ok
t/70takeimp...................ok
t/71impdata...................ok
t/75supported_sql.............ok
t/76multi_statement...........1/24
# Failed test 'Second update had 2 warnings'
# at t/76multi_statement.t line 50.
# got: '0'
# expected: '2'

NOTE: at this point, it just hangs.

I am using perl version 5.8.6


I have seen some other posts with similar problems, but no real resolution.
The full output is attached below.

Thanks,
Brett.





# /usr/bin/perl -MCPAN -e 'install "DBD::mysql"'
CPAN: Storable loaded ok (v2.13)
Going to read /private/var/root/Library/Application Support/.cpan/Metadata
Database was generated on Sat, 29 Nov 2008 20:28:11 GMT
Running install for module 'DBD::mysql'
CPAN: YAML loaded ok (v0.66)
Running make for C/CA/CAPTTOFU/DBD-mysql-4.010.tar.gz
CPAN: Digest::SHA loaded ok (v5.46)
CPAN: Compress::Zlib loaded ok (v1.41)
Checksum for /private/var/root/Library/Application
Support/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.0 10.tar.gz ok
DBD-mysql-4.010/
DBD-mysql-4.010/ChangeLog
DBD-mysql-4.010/constants.h
DBD-mysql-4.010/dbdimp.c
DBD-mysql-4.010/dbdimp.h
DBD-mysql-4.010/eg/
DBD-mysql-4.010/eg/._bug14979.pl
DBD-mysql-4.010/eg/bug14979.pl
DBD-mysql-4.010/eg/._bug21028.pl
DBD-mysql-4.010/eg/bug21028.pl
DBD-mysql-4.010/eg/bug30033.pl
DBD-mysql-4.010/eg/bug30033pg.pl
DBD-mysql-4.010/eg/decimal_test.pl
DBD-mysql-4.010/eg/issue21946.pl
DBD-mysql-4.010/eg/prepare_memory_usage.pl
DBD-mysql-4.010/eg/proc_example1.pl
DBD-mysql-4.010/eg/proc_example2.pl
DBD-mysql-4.010/eg/proc_example2a.pl
DBD-mysql-4.010/eg/proc_example2b.pl
DBD-mysql-4.010/eg/proc_example3.pl
DBD-mysql-4.010/eg/proc_example4.pl
DBD-mysql-4.010/INSTALL.html
DBD-mysql-4.010/lib/
DBD-mysql-4.010/lib/Bundle/
DBD-mysql-4.010/lib/Bundle/DBD/
DBD-mysql-4.010/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.010/lib/DBD/
DBD-mysql-4.010/lib/DBD/mysql/
DBD-mysql-4.010/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.010/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.010/lib/DBD/mysql.pm
DBD-mysql-4.010/Makefile.PL
DBD-mysql-4.010/Makefile.PL.embedded
DBD-mysql-4.010/MANIFEST
DBD-mysql-4.010/MANIFEST.SKIP
DBD-mysql-4.010/META.yml
DBD-mysql-4.010/myld
DBD-mysql-4.010/mysql.xs
DBD-mysql-4.010/README
DBD-mysql-4.010/t/
DBD-mysql-4.010/t/00base.t
DBD-mysql-4.010/t/10connect.t
DBD-mysql-4.010/t/20createdrop.t
DBD-mysql-4.010/t/25lockunlock.t
DBD-mysql-4.010/t/29warnings.t
DBD-mysql-4.010/t/30insertfetch.t
DBD-mysql-4.010/t/31insertid.t
DBD-mysql-4.010/t/32insert_error.t
DBD-mysql-4.010/t/35limit.t
DBD-mysql-4.010/t/35prepare.t
DBD-mysql-4.010/t/40bindparam.t
DBD-mysql-4.010/t/40bindparam2.t
DBD-mysql-4.010/t/40blobs.t
DBD-mysql-4.010/t/40catalog.t
DBD-mysql-4.010/t/40keyinfo.t
DBD-mysql-4.010/t/40listfields.t
DBD-mysql-4.010/t/40nulls.t
DBD-mysql-4.010/t/40numrows.t
DBD-mysql-4.010/t/40server_prepare.t
DBD-mysql-4.010/t/40server_prepare_error.t
DBD-mysql-4.010/t/40types.t
DBD-mysql-4.010/t/41bindparam.t
DBD-mysql-4.010/t/41blobs_prepare.t
DBD-mysql-4.010/t/42bindparam.t
DBD-mysql-4.010/t/50chopblanks.t
DBD-mysql-4.010/t/50commit.t
DBD-mysql-4.010/t/55utf8.t
DBD-mysql-4.010/t/60leaks.t
DBD-mysql-4.010/t/65types.t
DBD-mysql-4.010/t/70takeimp.t
DBD-mysql-4.010/t/71impdata.t
DBD-mysql-4.010/t/75supported_sql.t
DBD-mysql-4.010/t/76multi_statement.t
DBD-mysql-4.010/t/80procs.t
DBD-mysql-4.010/t/lib.pl
DBD-mysql-4.010/t/mysql.dbtest
DBD-mysql-4.010/t/mysql.mtest
DBD-mysql-4.010/TODO
CPAN: File::Temp loaded ok (v0.20)

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.010.tar.gz



PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> grant all privileges on test.* to 'root'@'localhost' identified
by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.pl --testuser=username

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/local/mysql/include -fno-common
embedded (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient
-lz -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
Use of uninitialized value in printf at Makefile.PL line 175,
line 93.
testuser ( ) = root

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

Checking if your kit is complete...
Looks good
*** Warning: whitespace characters in the current directory path
(/private/var/root/Library/Application
Support/.cpan/build/DBD-mysql-4.010-MvVlQa) may cause problems

Multiple copies of Driver.xst found in:
/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/
/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI/ at Makefile.PL
line 747
Using DBI 1.607 (for perl 5.008006 on darwin-thread-multi-2level)
installed in /Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::mysql
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI
-I/usr/local/mysql/include -fno-common -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-g -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing
-I/usr/local/include -Os -DVERSION=\"4.010\" -DXS_VERSION=\"4.010\"
"-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/COR E" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI/Driv er.xst >
mysql.xsi
/usr/bin/perl /System/Library/Perl/5.8.6/ExtUtils/xsubpp -typemap
/System/Library/Perl/5.8.6/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 225
Warning: duplicate function definition 'rows' detected in mysql.xs, line 650
cc -c -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI
-I/usr/local/mysql/include -fno-common -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-g -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing
-I/usr/local/include -Os -DVERSION=\"4.010\" -DXS_VERSION=\"4.010\"
"-I/System/Library/Perl/5.8.6/darwin-thread-multi-2level/COR E" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.bundle
LD_RUN_PATH="/usr/lib" /usr/bin/perl myld env
MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup
-L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.bundle \
-L/usr/local/mysql/lib -lmysqlclient -lz -lm \

chmod 755 blib/arch/auto/DBD/mysql/mysql.bundle
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
CAPTTOFU/DBD-mysql-4.010.tar.gz
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base......................ok
t/10connect...................ok
t/20createdrop................ok
t/25lockunlock................ok
t/29warnings..................ok
t/30insertfetch...............ok
t/31insertid..................ok
t/32insert_error..............ok
t/35limit.....................ok
t/35prepare...................ok
t/40bindparam.................ok
t/40bindparam2................ok
t/40blobs.....................ok
t/40catalog...................ok
t/40keyinfo...................ok
t/40listfields................ok
t/40nulls.....................ok
t/40numrows...................ok
t/40server_prepare............ok
t/40server_prepare_error......ok
t/40types.....................ok
t/41bindparam.................ok
t/41blobs_prepare.............ok
t/42bindparam.................ok
t/50chopblanks................1/29
# Failed test '$name should not have blanks chopped'
# at t/50chopblanks.t line 60.
# got: ''
# expected: ' '

# Failed test '$name should not have blanks chopped'
# at t/50chopblanks.t line 60.
# got: ' a b c'
# expected: ' a b c '
# Looks like you failed 2 tests of 29.
t/50chopblanks................ Dubious, test returned 2 (wstat 512, 0x200)
Failed 2/29 subtests
t/50commit....................ok
t/55utf8......................skipped: SKIP TEST: You must have MySQL
version 5.0 and greater for this test to run
t/60leaks.....................skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types.....................ok
t/70takeimp...................ok
t/71impdata...................ok
t/75supported_sql.............ok
t/76multi_statement...........1/24
# Failed test 'Second update had 2 warnings'
# at t/76multi_statement.t line 50.
# got: '0'
# expected: '2'
^Cmake: *** [test_dynamic] Interrupt
CAPTTOFU/DBD-mysql-4.010.tar.gz
/usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
reports CAPTTOFU/DBD-mysql-4.010.tar.gz
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