Problems installing DBD for MySQL

am 02.08.2004 16:09:34 von Fritz Buetikofer

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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/my sql.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/mys ql.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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Problems installing DBD for MySQL

am 03.08.2004 15:07:41 von Rudy Lippan

On Mon, 2 Aug 2004, Fritz Buetikofer wrote:

> Perhaps a required shared library or dll isn't installed where expected

Looks like it can't find your mysql libraries.

> 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/my sql.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/mys ql.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

mysql_real_escape_string is a function provided by libmysql.so.

Rudy

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

Re: Problems installing DBD for MySQL

am 03.08.2004 15:07:41 von Rudy Lippan

Re: Problems installing DBD for MySQL

am 03.08.2004 16:30:16 von Fritz Buetikofer

Hi all,

On Aug 3, 2004, at 3:07 PM, Rudy Lippan wrote:

> On Mon, 2 Aug 2004, Fritz Buetikofer wrote:
>
>> Perhaps a required shared library or dll isn't installed where
>> expected
>
>
> Looks like it can't find your mysql libraries.
>
>> 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/my sql.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/mys ql.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
>
>
> mysql_real_escape_string is a function provided by libmysql.so.

With this feedback from Rudy I looked in the binary_dist 4.0.20 for
the libmysqlclient.so
file but could not find it. So I also downloaded the mysql sources,
built it and then
copied over the libmysqlclient.so file to the /usr/local/lib directory.
Now everything
ran fine.

Best regards,

--Fritz.

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

Re: Problems installing DBD for MySQL

am 03.08.2004 16:30:16 von Fritz Buetikofer