Hello,

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,