I am having problems with installing the DBD::MySQL Perl module. My system is: RedHat 8 (patched current) Perl 5.8.4 (installed from RPM but upgraded manually) Apache 2.0.40 Modperl 1.99
I am heading toward being able to install Best Practicals "request tracker". Currently this is a clean system. Any help is appreciated.
Here is the output from my install (as far as I went)
[EMAIL PROTECTED] DBD-mysql-2.9003]# perl Makefile.PL --cflags=-I/usr/include/mysql --libs='-L/usr/lib/mysql
-lz' --testdb=test --testuser=xxxx --testpassword='xxxx' --testhost=server.domain.com --ssl
I will use the following settings for compiling and testing:
cflags (Users choice) = -I/usr/include/mysql libs (Users choice) = -L/usr/lib/mysql -lz nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (Users choice) = 1 testdb (Users choice) = test testhost (Users choice) = server.domain.com testpassword (Users choice) = xxxx testuser (Users choice) = xxxx
To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'.
Checking if your kit is complete...
Looks good
Using DBI 1.42 (for perl 5.008004 on i686-linux) installed in /usr/local/lib/perl5/site_perl/5.8.4/i686-
linux/auto/DBI
Writing Makefile for DBD::mysql
[EMAIL PROTECTED] DBD-mysql-2.9003]# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/local/lib/perl5/site_perl/5.8.4/i686-linux/auto/DBI -I/usr/include/mysql -DDBD_MYSQL_WITH_
SSL -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=
\"2.9003\" -DXS_VERSION=\"2.9003\" -fpic "-I/usr/local/lib/perl5/5.8.4/i686-linux/CORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.4/i686-linux/auto/DBI/Driver
.xst > mysql.xsi
/usr/bin/perl /usr/local/lib/perl5/5.8.4/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.4/ExtUtils/t
ypemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 192
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
cc -c -I/usr/local/lib/perl5/site_perl/5.8.4/i686-linux/auto/DBI -I/usr/include/mysql -DDBD_MYSQL_WITH_
SSL -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=
\"2.9003\" -DXS_VERSION=\"2.9003\" -fpic "-I/usr/local/lib/perl5/5.8.4/i686-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/lib" /usr/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/au
to/DBD/mysql/mysql.so -L/usr/lib/mysql -lz
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
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
[EMAIL PROTECTED] DBD-mysql-2.9003]# 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/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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.4/i686-linux/DBI.pm line 1061.
Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.4/i686-linux/DBI.pm
line 1061.
Can't locate object method "connect" via package "Mysql" at /root/.cpan/build/DBD-mysql-2.9003/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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arc
h/auto/DBD/mysql/mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/
mysql/mysql.so: undefined symbol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.
pm line 230.
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 '/root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql.so' for
module DBD::mysql: /root/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql.so: undefined symb
ol: net_buffer_length at /usr/local/lib/perl5/5.8.4/i686-linux/DynaLoader.pm line 230.
at /root/.cpan/build/DBD-mysql-2.9003/blib/lib/Mysql.pm line 13
Compilation failed in require at /root/.cpan/build/DBD-mysql-2.9003/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.4/i686-linux/DBI.pm line 1061.
Use of uninitialized value in subroutine entry at /usr/local/lib/perl5/site_perl/5.8.4/i686-linux/DBI.pm
line 1061.
Can't locate object method "connect" via package "Mysql" at /root/.cpan/build/DBD-mysql-2.9003/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 3 6 200.00% 1-3
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. 721/724 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2
Most anything is easy after you've done it successfully a few times
Leon Sonntag
Innovative Web Applications
leon at iwa-solutions dot com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
