DBD:mysql make test problem 
Author Message
 DBD:mysql make test problem

Hi,

i installed my mysql under /usr/local/mysql/current

libs are in /usr/local/mysql/current/lib/mysql
headers in /usr/local/mysql/current/lib/include

i compiled DBD:mysql with:

perl Makefile.PL \
--libs=-L/usr/local/mysql/current/lib/mysql/ \
-lmysqlclient -lz \
--cflags=-I/usr/local/mysql/current/include/mysql/ \
--testdb=test \
--testuser=test \
--testpassword=test \
--testhost=localhost

which prints out:
I will use the following settings for compiling and testing:

  cflags        (Users choice)
= -I/usr/local/mysql/current/include/mysql/
  libs          (Users choice) = -L/usr/local/mysql/current/lib/mysql/
  nocatchstderr (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (Users choice) = test
  testhost      (Users choice) = localhost
  testpassword  (Users choice) = test
  testuser      (Users choice) = test

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.37 installed in
/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
Writing Makefile for DBD::mysql

a make test gives these errors:


/bin/sh -c true
/bin/sh -c true
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI -I/usr/loc
al/mysql/current/include/mysql/ -fno-strict-aliasing -I/usr/local/incl
ude -O2 -march=i386 -mcpu=i686   -DVERSION=\"2.1027\" -DXS_VERSION=\"2
.1027\" -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/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/bin/perl myld gcc  -shared -L/usr/local/lib
dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so
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
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/i386-linux
 -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose);

t/00base............install_driver(mysql) failed: Can't load
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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-3
        Failed 3/3 tests, 0.00% okay
t/20createdrop......install_driver(mysql) failed: Can't load
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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 test on this platform
t/ak-dbd............install_driver(mysql) failed: Can't load
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line
1020.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 1020.
Can't locate object method "connect" via package "Mysql" (perhaps you
forgot to load "Mysql"?) at 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 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/mysql2............Had to create DBD::mysql::dr::imp_data_size
unexpectedly at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line
1020.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 1020.
Can't locate object method "connect" via package "Mysql" (perhaps you
forgot to load "Mysql"?) at blib/lib/Mysql.pm line 71.
t/mysql2............dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/mysql.............Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql: blib/arch/auto/DBD/mysql/mysql.so: undefined
symbol: mysql_real_escape_string at
/usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 at blib/lib/Mysql.pm line 13
Compilation failed in require at 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       Status Wstat Total Fail  Failed  List of Failed
----------------------------------------------------------------------
----------
t/00base.t               255 65280     5    2  40.00%  4-5
t/10dsnlist.t            255 65280     3    3 100.00%  1-3
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    21   21 100.00%  1-21
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. 719/722 subtests failed, 0.42%
okay.
make: *** [test_dynamic] Fehler 2

whats wrong?
make works fine

--
Freundliche Grsse

Alexander Bruns



Tue, 22 Nov 2005 16:22:13 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problems testing DBD::mysql

2. MySql DBD test failure - compiles fine

3. Help: Problem making DBD::Oracle v0.44

4. problems making DBD:mSQL ...

5. Help: Problem making DBD::Oracle v0.44

6. Does DBD:mysql support transactions (mysql 3.23 does)

7. Inserting binary files into mysql database with DBD::mysql

8. Please help: installing mySQL and DBD::mySQL on separate boxes

9. DBD::mysql not loading mysql.dll

10. DBI (DBD:mysql) and Mysql ENUM Datatype question

11. DBD::mysql::st execute failed: Lost connection to MySQL server

12. install dbd::mysql without installing mysql ??

 

 
Powered by phpBB® Forum Software