make test fails on my solaris box
am 06.11.2002 02:01:01 von msmonroeHello,
I am having all sorts of trouble installing the MySQL DBD on my Sun Solaris machine. When I run 'make test', after what appears to be a successful 'perl Makefile.PL' and 'make' I get back a the following error message;
....
Failed 17/18 test scripts, 5.56% okay. 724/727 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2
I have tried building MySQL and Perl from source, as well as using pre-built binaries. In attempting to build MySQL, Perl and the MySQL DBD, I have used several version of GCC including 2.95.3, 3.0.1, 3.1 and 3.2. In addition, I have attempted to install the following versions of the MySQL DBD; Msql-Mysql-modules-1.2216, Msql-Mysql-modules-1.2219 and most recently DBD-mysql-2.1020. I get the same error no matter what I do.
While I am new to the MySQL community I have been a UNIX sys-admin for many years. My environment is as follows:
Solaris 7 - all patches are up to date. (I have attempted to install the MySQL DBD running both the 32 and 64 bit versions of the kernel)
MySQL version 3.23.45
ncurses 5.2
libgcc 3.1
zlib 1.1.4
Perl 5.8.0
GCC 3.1
DBD-mysql-2.1020
GNU versions of make and tar
Solaris versions of ar, ld etc...
Following are the responses I get back from running 'perl Makefile.PL', 'make' and 'make test':
# perl Makefile.PL
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I'/usr/local/mysql/include/mysql'
libs (mysql_config) = -L/usr/local/lib -R/usr/local/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lgen -lsocket -lnsl -lm
nocatchstderr (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.30 installed in /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI
Writing Makefile for DBD::mysql
# make
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/DBD/mysql.pod blib/lib/DBD/mysql.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -I'/usr/local/mysql/include/mysql' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.1020\" -DXS_VERSION=\"2.1020\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" < /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI/Driver.xst > mysql.xsi
/usr/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 'rows' detected in mysql.xs, line 289
gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -I'/usr/local/mysql/include/mysql' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.1020\" -DXS_VERSION=\"2.1020\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/mysql/lib/mysql:/usr/local/lib:/usr/ lib" /usr/bin/perl myld gcc -B/usr/ccs/bin/ -G -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib -R/usr/local/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lgen -lsocket -lnsl -lm
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/Mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/00base.t line 38
t/00base...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlist........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/10dsnlist.t line 45
t/10dsnlist........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.....install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/20createdrop.t line 45
t/20createdrop.....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch....install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/30insertfetch.t line 48
t/30insertfetch....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam......install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40bindparam.t line 64
t/40bindparam......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs..........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40blobs.t line 68
t/40blobs..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.....install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40listfields.t line 57
t/40listfields.....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-16
Failed 16/16 tests, 0.00% okay
t/40nulls..........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40nulls.t line 50
t/40nulls..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40numrows.t line 59
t/40numrows........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks.....install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50chopblanks.t line 57
t/50chopblanks.....dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit.........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50commit.t line 64
t/50commit.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks..........skipped
all skipped: no reason given
t/ak-dbd...........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/ak-dbd.t line 59
t/ak-dbd...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-90
Failed 90/90 tests, 0.00% okay
t/akmisc...........Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 926.
Can't locate object method "connect" via package "Mysql" at /tmp/DBD-mysql-2.1020/blib/lib/Mysql.pm line 71.
Driver has not implemented the disconnect_all method. at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 565
END failed--call queue aborted.
t/akmisc...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin.........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/dbdadmin.t line 74
t/dbdadmin.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
t/insertid.........install_driver(mysql) failed: Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/insertid.t line 13
t/insertid.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql............Can't load '/tmp/DBD-mysql-2.1020/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open failed: No such file or directory at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.
at /tmp/DBD-mysql-2.1020/blib/lib/Mysql.pm line 13
Compilation failed in require at /tmp/DBD-mysql-2.1020/blib/lib/Mysql.pm line 13.
Compilation failed in require at t/mysql.t line 34.
BEGIN failed--compilation aborted at t/mysql.t line 34.
t/mysql............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 926.
Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 926.
Can't locate object method "connect" via package "Mysql" at /tmp/DBD-mysql-2.1020/blib/lib/Mysql.pm line 71.
Driver has not implemented the disconnect_all method. at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 565
END failed--call queue aborted.
t/mysql2...........dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/00base.t 255 65280 5 2 40.00% 4-5
t/10dsnlist.t 255 65280 9 9 100.00% 1-9
t/20createdrop.t 255 65280 5 5 100.00% 1-5
t/30insertfetch.t 255 65280 11 11 100.00% 1-11
t/40bindparam.t 255 65280 28 28 100.00% 1-28
t/40blobs.t 255 65280 11 11 100.00% 1-11
t/40listfields.t 255 65280 16 16 100.00% 1-16
t/40nulls.t 255 65280 11 11 100.00% 1-11
t/40numrows.t 255 65280 25 25 100.00% 1-25
t/50chopblanks.t 255 65280 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 90 100.00% 1-90
t/akmisc.t 255 65280 351 351 100.00% 1-351
t/dbdadmin.t 255 65280 20 20 100.00% 1-20
t/insertid.t 255 65280 12 12 100.00% 1-12
t/mysql.t 255 65280 68 68 100.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 17/18 test scripts, 5.56% okay. 724/727 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2
### end of 'make test' output ###
Any Ideas? Is there any information I didn't include that I should have? I would much appreciate any information anyone might have.
Thanks in advance,
Matt
msmonroe@stravin.com
------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1964@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.