Perl postulant with Apache::DBI test failure

kili has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to install Apache::DBI and I get the following error during testing.

I knew enought to exit cpan and edit the test file to turn on more verbose debugging but I'm not clueful enough to figure out why the $thread1 and $thread2 differ when quering a MySQL instance.

I'm using a RH8.0 system with Perl installed to $HOME/bin/perl-5.8.0 and have $PATH setup accordingly. (RH's perl RPM give me big headaches and a virgin source build usually yields better results)

MySQL and Apache are from the RH RPM's

$ make test
PERL_DL_NONLAZY=1 /home/cgahlon/bin/perl-5.8.0/bin/perl "-MExtUtils::C
+ommand::MM"
 "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/10mysql....NOK 5#     Failed test (t/10mysql.t at line 29)          
+       
#          got: '132'
#     expected: '133'
t/10mysql....ok 7/7# Looks like you failed 1 tests of 7.              
+       
t/10mysql....dubious                                                  
+       
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 5
        Failed 1/7 tests, 85.71% okay
Failed Test Stat Wstat Total Fail  Failed  List of Failed
----------------------------------------------------------------------
+---------
t/10mysql.t    1   256     7    1  14.29%  5
Failed 1/1 test scripts, 0.00% okay. 1/7 subtests failed, 85.71% okay.
make: *** [test_dynamic] Error 2
[download]

Comment on Perl postulant with Apache::DBI test failure Download Code

Replies are listed 'Best First'.
Re: Perl postulant with Apache::DBI test failure by kili (Novice) on Apr 17, 2003 at 02:13 UTC
Doh! Good thing I always keep a file called perl-5.8.0-config-command around so I know what I did in ancient history (or two months ago). I'm re-compiling perl without -Dusethreads. I'm betting that will fix it. :-) I'll let ya know.	[reply]
Re: Perl postulant with Apache::DBI test failure by Anonymous Monk on Apr 17, 2003 at 14:56 UTC
This always fails for me, it has been a while since I delt with this, but I seem to remember that it fails that test because it is trying to access mysql as root with out a password. you probably have a password set for root. I just exit cpan and locate the build directory then: make make install myself. Mark	[reply]
Re: Perl postulant with Apache::DBI test failure by kili (Novice) on Apr 17, 2003 at 18:55 UTC
Re-compiling wihtout -Dusethreads fixed the problem. It also made a bunch of "Threads not safe in a production environment" warnings go away when building other modules.	[reply]