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

I have a Libranet (Debian based) Linux system.  I tried installing MySQL and 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 had to create the directory /usr/include/mysql and copy all the header files to it.

I've been trying to install DBD::mysql for several hours.  I have been 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 posted the output from "make test" at the end of the post, due to it's length.  I read in the instructions that this might be a problem with the linker and added the line:

-L/usr/lib/gcc-lib/i386-linux/3.2.3/libgcc.a -lgcc

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

So what can I do to install this?  I'd prefer to get it working with the later version of MySQL, but if I have to wipe that and go with apt-get packages, I can do that.  At this point, I ma very frustrated because it'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

--------------------------------- Output from "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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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 '/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.  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 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/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 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 '/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.  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 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 '/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.  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 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 '/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.  at /root/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13 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 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/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 returned status 255 (wstat 65280, 0xff00) Failed 17/18 test scripts, 5.56% okay. 727/730 subtests failed, 0.41% okay. 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. make: *** [test_dynamic] Error 255