Problems installing DBD for MySQL

Fritz Buetikofer <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]> 
Dear all

I am running a SUN with Solaris 9, Perl 5.8.3 and mysql 4.0.20-standard.
Now I tried to install DBD-mysql-2.9004 ...

First I got the error with the net_buffer_length variable, which I  
replaced
with a '0'. Now I was able to build the perl module. But when starting  
the
'make test' I get the following error messages:

loislane# make test
PERL_DL_NONLAZY=1 /bin/perl "-MExtUtils::Command::MM" "-e"  
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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-18
         Failed 18/18 tests, 0.00% okay
t/40nulls..........install_driver(mysql) failed: Can't load  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable  
not installed
t/ak-dbd...........install_driver(mysql) failed: Can't load  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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.3/sun4-solaris/DBI.pm line 1078.
Use of uninitialized value in subroutine entry at  
/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.pm line 1078.
Can't locate object method "connect" via package "Mysql" at  
/usr/local/src/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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-21
         Failed 21/21 tests, 0.00% okay
t/insertid.........install_driver(mysql) failed: Can't load  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/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  
'/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for  
module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file  
/usr/local/src/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:  
symbol mysql_real_escape_string: referenced symbol not found at  
/usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 229.
  at /usr/local/src/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13
Compilation failed in require at  
/usr/local/src/DBD-mysql-2.9004/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.3/sun4-solaris/DBI.pm line 1078.
Use of uninitialized value in subroutine entry at  
/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/DBI.pm line 1078.
Can't locate object method "connect" via package "Mysql" at  
/usr/local/src/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
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    4  80.00%  4-5
t/10dsnlist.t      255 65280     9   18 200.00%  1-9
t/20createdrop.t   255 65280     5   10 200.00%  1-5
t/30insertfetch.t  255 65280    11   22 200.00%  1-11
t/40bindparam.t    255 65280    28   56 200.00%  1-28
t/40blobs.t        255 65280    11   22 200.00%  1-11
t/40listfields.t   255 65280    18   36 200.00%  1-18
t/40nulls.t        255 65280    11   22 200.00%  1-11
t/40numrows.t      255 65280    25   50 200.00%  1-25
t/50chopblanks.t   255 65280    35   70 200.00%  1-35
t/50commit.t       255 65280    30   60 200.00%  1-30
t/ak-dbd.t         255 65280    90  180 200.00%  1-90
t/akmisc.t         255 65280   351  702 200.00%  1-351
t/dbdadmin.t       255 65280    21   42 200.00%  1-21
t/insertid.t       255 65280    12   24 200.00%  1-12
t/mysql.t          255 65280    68  136 200.00%  1-68
t/mysql2.t         255 65280    ??   ??       %  ??
1 test skipped.
Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41%  
okay.
gmake: *** [test_dynamic] Error 2

Any idea what is wrong with the perl module and/or mysql-4 ??

--Fritz.


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.