"make test" fails on solaris - more info

Here is an update on my problems getting a successful response with 'make test' on my Solaris box. My environment is now:

Solaris 7 (64-bit Kernel)
MySQL 3.23.53 (yes it is installed correctly and up and running)
Perl 5.8.0 (I believe that DBI 1.30 comes with this version)

MySQL and Perl were built with GCC 3.2 (with libgcc 3.2 and GNU make, etc...)
- yes, I have zlib installed (version 1.1.4)
- yes, I used the GNU version of tar and not the Solaris version
- yes, I used the Solaris /usr/ccs/bin utils and not GNU's bin utils

I am trying to install the DBD-mysql-2.1020 module. The machine I am building it on does not have access to the Internet, so I'm not able to use CPAN to install it. I'm attempting to build it manually. Both perl and mysql built, and are currently running without any glitches or errors. I just don't understand why the 'make test' fails so absolutely. Is there a known problem with Solaris and the DBD-mysql-2.1020 module? Is there a problem with the Makefile.PL or with the libraries inside the DBD module? Or is the problem with version 5.8.0 of Perl? Or better yet, some combination?

I've tried these various Makefile.PL options:

perl Makefile.PL --libs='-L/usr/local/lib -R/usr/local/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lgen -lsocket -lnsl -lm'

perl Makefile.PL --libs='-L/usr/local/lib -R/usr/local/lib /usr/local/mysql/lib/mysql/libmysqlclient.a -lz -lcrypt -lgen -lsocket -lnsl -lm'

as well as many other derivations.



I am fresh out of ideas on what to try next. To pre-answer common response question:

- yes, I have read from the msql-mysql-modules@lists.mysql.com archives
- no, this is not a 'No library found for -lgz' problem
- yes, I HAVE read the README from both the Msql-Mysql-modules-1.2219 tarball
- yes, I HAVE read the README and the INSTALL.html from the DBD-mysql-2.1020 tarball
- yes, I have visited many Perl DBI sites and several other informational sites such as mysql.turbolift.com, and perl.com.


I find bits of information that are close, but I still haven't been able to get the 'make test' to work. I always seem to get the following message at the end of the 'make test' output:

....
### tons of junk ###
....
Failed 17/18 test scripts, 5.56% okay. 724/727 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2

(a bit more detail is provided at the end)

Any help, suggestions, criticisms, or instructions will be very much appreciated. I'm supposed to be moving our webservers away from Netscape Enterprise Webservers and towards an Apache/Perl/PHP/Mysql type solution. I can't believe that I'm stuck on this little piece.

Thanks,

Matthew Monroe
msmonroe@.stravin.com


# More 'make test' output:


# 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/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

....


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

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1965@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.