Problems installing DBD::mysql W/ MySQL 4.2 on Debian Linux

Problems installing DBD::mysql W/ MySQL 4.2 on Debian Linux

am 29.08.2004 11:11:21 von Hal Vaughan

I tried to post this, and it looks like my mail server wasn't working. =20
Apologies if I've double posted.


I have a Libranet (Debian based) Linux system.  I=A0tried=A0installing=
=A0MySQL=A0and
DBD::mysql through apt-get, but it didn't work (I also used apt-get to get
all the packages, then install DBD::mysql separately, still no luck).  I
finally decided to download the latest version of MySQL from mysql.com and
install it.  I=A0had=A0to=A0create=A0the=A0directory=A0/usr/incl ude/mys=
ql=A0and=A0copy=A0all
the header files to it.

I've been trying to install DBD::mysql for several hours.  I=A0have=A0b=
een
reading the directions, but I still can't find (including through Google --
but I tend to always search on the wrong terms, so Google search links are
helpful -- especially if you can let me know the terms that brought up the
right answer) anything that helps me get this module installed.

I do "perl Makefile.PL" and "make" and everything is fine.  I've=A0post=
ed=A0the
output from "make test" at the end of the post, due to it's length.  I=
=A0read
in the instructions that this might be a problem with the linker and added
the line:

=2DL/usr/lib/gcc-lib/i386-linux/3.2.3/libgcc.a -lgcc

at the end of the line in Makefile that starts with "CFLAGS =3D ", but it m=
ade
absolutely no difference.

So what can I do to install this?  I'd=A0prefer=A0to=A0get=A0it=A0worki=
ng=A0with=A0the
later version of MySQL, but if I have to wipe that and go with apt-get
packages, I can do that.  At=A0this=A0point,=A0I=A0ma=A0very=A0frustrat=
ed=A0because=A0it's
not working with the "official" package and it doesn't work with the
Debian .deb files (they don't include mysql_config, and it always complains
about not finding that).

Any help is appreciated.

Hal
=2D--------------------------------
Output from "make test":

PERL_DL_NONLAZY=3D1 /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
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/00base.t=A0line=A038
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 4-5
        Failed=A02/5=A0tests,=A060.00%=A0oka y
t/10dsnlist........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/10dsnlist.t=A0line=A045
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-9
        Failed=A09/9=A0tests,=A00.00%=A0okay
t/20createdrop.....install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/20createdrop.t=A0line=A045
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-5
        Failed=A05/5=A0tests,=A00.00%=A0okay
t/30insertfetch....install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/30insertfetch.t=A0line=A048
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-11
        Failed=A011/11=A0tests,=A00.00%=A0ok ay
t/40bindparam......install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A03)=A0line=A03
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/40bindparam.t=A0line=A064
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-28
        Failed=A028/28=A0tests,=A00.00%=A0ok ay
t/40blobs..........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/40blobs.t=A0line=A068
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-11
        Failed=A011/11=A0tests,=A00.00%=A0ok ay
t/40listfields.....install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/40listfields.t=A0line=A057
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-18
        Failed=A018/18=A0tests,=A00.00%=A0ok ay
t/40nulls..........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/40nulls.t=A0line=A050
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-11
        Failed=A011/11=A0tests,=A00.00%=A0ok ay
t/40numrows........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/40numrows.t=A0line=A059
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-25
        Failed=A025/25=A0tests,=A00.00%=A0ok ay
t/50chopblanks.....install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/50chopblanks.t=A0line=A057
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-35
        Failed=A035/35=A0tests,=A00.00%=A0ok ay
t/50commit.........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/50commit.t=A0line=A064
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-30
        Failed=A030/30=A0tests,=A00.00%=A0ok ay
t/60leaks..........skipped
        all=A0skipped:=A0$ENV{SLOW_TESTS}=A0 is=A0not=A0set=
=A0or=A0Proc::ProcessTable=A0not
installed
t/ak-dbd...........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/ak-dbd.t=A0line=A059
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-90
        Failed=A090/90=A0tests,=A00.00%=A0ok ay
t/akmisc...........Had to create DBD::mysql::dr::imp_data_size unexpectedly
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Use of uninitialized value in subroutine entry
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Can't locate object method "connect" via package "Mysql"
at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-351
        Failed=A0351/351=A0tests,=A00.00%=A0 okay
t/dbdadmin.........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/dbdadmin.t=A0line=A074
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-21
        Failed=A021/21=A0tests,=A00.00%=A0ok ay
t/insertid.........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0(eval=A01)=A0line=A03
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
=A0at=A0t/insertid.t=A0line=A013
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-12
        Failed=A012/12=A0tests,=A00.00%=A0ok ay
t/mysql............Can't load
'/root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /root/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: net_buffer_length at /usr/lib/perl/5.8.2/DynaLoader.pm
line 225.
=A0at=A0/root/DBD-mysql-2.9004/blib/lib/Mysql.pm=A0line=A013
Compilation failed in require at /root/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.
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
DIED. FAILED tests 1-68
        Failed=A068/68=A0tests,=A00.00%=A0ok ay
t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Use of uninitialized value in subroutine entry
at /usr/local/lib/perl/5.8.2/DBI.pm line 1011.
Can't locate object method "connect" via package "Mysql"
at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 71.
dubious
        Test=A0returned=A0status=A0255=A0(ws tat=A065280,=A0=
0xff00)
=46ailed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% oka=
y.
=46ailed Test      =A0Stat=A0Wstat=A0Total=A0Fail  Fa iled=
  List=A0of=A0Failed
=2D--------------------------------------------------------- ---------------=
=2D-----
t/00base.t        =A0255=A065280     =A05  =A0=
=A04  80.00%  4-5
t/10dsnlist.t      255=A065280    =A09=A 0  18=A0200=
00%  1-9
t/20createdrop.t  =A0255=A065280    =A05  =A 010=A0200.00%=
  1-5
t/30insertfetch.t  255=A065280    11  =A022= A0200.00%  =
1-11
t/40bindparam.t    255=A065280    28  =A 056=A0200.00%=
  1-28
t/40blobs.t        255=A065280    11   =A022=A02=
00.00%  1-11
t/40listfields.t  =A0255=A065280    18  =A03 6=A0200.00%=A0=
=A01-18
t/40nulls.t        255=A065280    11   =A022=A02=
00.00%  1-11
t/40numrows.t      255=A065280    25=A0= A0=A050=A0200.0=
0%  1-25
t/50chopblanks.t  =A0255=A065280    35  =A07 0=A0200.00%=A0=
=A01-35
t/50commit.t      =A0255=A065280    30=A 0  60=A0200=
00%  1-30
t/ak-dbd.t        =A0255=A065280     90  180=A02=
00.00%  1-90
t/akmisc.t        =A0255=A065280  =A0351   702=A0200=
00%  1-351
t/dbdadmin.t      =A0255=A065280    21=A 0  42=A0200=
00%  1-21
t/insertid.t      =A0255=A065280    12=A 0  24=A0200=
00%  1-12
t/mysql.t          255=A065280  =A0= A068  136=
=A0200.00%  1-68
t/mysql2.t        =A0255=A065280     ??  =A0??=
      =A0%  ??
1 test skipped.
make: *** [test_dynamic] Error 255

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org