List:MySQL and Perl« Previous MessageNext Message »
From:Jim Cromie Date:November 11 2001 10:24pm
Subject:DBD::mysql install problems.
View as plain text  
Ive been having trouble installing latest DBD::mysql,
where trouble == make test failure.

Ive worked thru some of the problems, as reflected in the
attached `diff -ur`.   changes are setting-globals in t/mysql.mtest,
and changing my to our to allow do file to import settings.
I hope theyre of some use,


[root@groucho DBD-mysql-2.1003.mine]# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/i686-linux -I/usr/local/lib/perl5/5.6.1 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
t/60leaks..........skipped test on this platform
t/ak-dbd...........ok
t/akmisc...........trying: localhost test jimc secret
t/akmisc...........FAILED test 44
 Failed 1/351 tests, 99.72% okay
t/dbdadmin.........dubious
 Test returned status 0 (wstat 139, 0x8b)
 test program seems to have generated a core
DIED. FAILED tests 5-20
 Failed 16/20 tests, 20.00% okay
t/insertid.........ok
t/mysql2...........ok
t/mysql............FAILED test 23
 Failed 1/68 tests, 98.53% okay
Failed Test  Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/akmisc.t                351    1   0.28%  44
t/dbdadmin.t    0   139    20   16  80.00%  5-20
t/mysql.t                  68    1   1.47%  23
1 test skipped.
Failed 3/18 test scripts, 83.33% okay. 18/758 subtests failed, 97.63% okay.
make: *** [test_dynamic] Error 29




The biggest chunk of failures is in t/dbadmin.t, which
passes when run alone, but not as part of make test

[root@groucho DBD-mysql-2.1003.mine]# perl t/dbdadmin.t
1..20
ok 1
ok 2
List of mysql data sources:
List ends.
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19




diff -ur DBD-mysql-2.1003/blib/man3/Bundle::DBD::mysql.3
DBD-mysql-2.1003.mine/blib/man3/Bundle::DBD::mysql.3
--- DBD-mysql-2.1003/blib/man3/Bundle::DBD::mysql.3	Sun Nov 11 13:38:20 2001
+++ DBD-mysql-2.1003.mine/blib/man3/Bundle::DBD::mysql.3	Sun Nov 11 15:13:11 2001
@@ -1,5 +1,5 @@
 .\" Automatically generated by Pod::Man version 1.22
-.\" Sun Nov 11 13:38:20 2001
+.\" Sun Nov 11 15:13:11 2001
 .\"
 .\" Standard preamble:
 .\" ========================================================================
diff -ur DBD-mysql-2.1003/blib/man3/DBD::mysql.3
DBD-mysql-2.1003.mine/blib/man3/DBD::mysql.3
--- DBD-mysql-2.1003/blib/man3/DBD::mysql.3	Sun Nov 11 13:38:18 2001
+++ DBD-mysql-2.1003.mine/blib/man3/DBD::mysql.3	Sun Nov 11 15:13:09 2001
@@ -1,5 +1,5 @@
 .\" Automatically generated by Pod::Man version 1.22
-.\" Sun Nov 11 13:38:17 2001
+.\" Sun Nov 11 15:13:08 2001
 .\"
 .\" Standard preamble:
 .\" ========================================================================
diff -ur DBD-mysql-2.1003/blib/man3/DBD::mysql::INSTALL.3
DBD-mysql-2.1003.mine/blib/man3/DBD::mysql::INSTALL.3
--- DBD-mysql-2.1003/blib/man3/DBD::mysql::INSTALL.3	Sun Nov 11 13:38:19 2001
+++ DBD-mysql-2.1003.mine/blib/man3/DBD::mysql::INSTALL.3	Sun Nov 11 15:13:10 2001
@@ -1,5 +1,5 @@
 .\" Automatically generated by Pod::Man version 1.22
-.\" Sun Nov 11 13:38:19 2001
+.\" Sun Nov 11 15:13:10 2001
 .\"
 .\" Standard preamble:
 .\" ========================================================================
diff -ur DBD-mysql-2.1003/blib/man3/Mysql.3 DBD-mysql-2.1003.mine/blib/man3/Mysql.3
--- DBD-mysql-2.1003/blib/man3/Mysql.3	Sun Nov 11 13:38:21 2001
+++ DBD-mysql-2.1003.mine/blib/man3/Mysql.3	Sun Nov 11 15:13:12 2001
@@ -1,5 +1,5 @@
 .\" Automatically generated by Pod::Man version 1.22
-.\" Sun Nov 11 13:38:21 2001
+.\" Sun Nov 11 15:13:12 2001
 .\"
 .\" Standard preamble:
 .\" ========================================================================
Only in DBD-mysql-2.1003.mine: core
diff -ur DBD-mysql-2.1003/t/akmisc.t DBD-mysql-2.1003.mine/t/akmisc.t
--- DBD-mysql-2.1003/t/akmisc.t	Fri May  4 15:15:00 2001
+++ DBD-mysql-2.1003.mine/t/akmisc.t	Sun Nov 11 12:12:23 2001
@@ -23,6 +23,14 @@
    %hash,
   );
 
+our ($host, $user, $password, $dbname);
+
+$host = shift @ARGV || $ENV{'DBI_HOST'} || "";
+$user = shift @ARGV || $ENV{'DBI_USER'} || "";
+$password = shift @ARGV || $ENV{'DBI_PASS'} || "";
+$dbname = shift @ARGV || $ENV{'DBI_DB'} || "test";
+
+
 my($file);
 foreach $file ("lib.pl", "t/lib.pl", "Mysql/t/lib.pl") {
     if (-f $file) {
@@ -32,6 +40,8 @@
     }
 }
 
+print STDERR "trying: $host $dbname $user $password\n";
+
 use vars qw($mdriver);
 if ($mdriver ne 'mysql'  &&  $mdriver ne 'mSQL'  &&  $mdriver ne 'mSQL1')
{
     print "1..0\n";
@@ -48,11 +58,6 @@
 # problems you might have with resolving "localhost". Too many systems
 # are configured wrong in this respect. But you're welcome to test it
 # out.
-
-my $host = shift @ARGV || $ENV{'DBI_HOST'} || "";
-my $user = shift @ARGV || $ENV{'DBI_USER'} || "";
-my $password = shift @ARGV || $ENV{'DBI_PASS'} || "";
-my $dbname = shift @ARGV || $ENV{'DBI_DB'} || "test";
 
 use vars qw($mdriver $state $COL_NULLABLE $COL_KEY $testNum);
 if ($mdriver eq 'mysql') {
Only in DBD-mysql-2.1003.mine/t: akmisc.t~
diff -ur DBD-mysql-2.1003/t/mysql.mtest DBD-mysql-2.1003.mine/t/mysql.mtest
--- DBD-mysql-2.1003/t/mysql.mtest	Sun May  6 14:14:05 2001
+++ DBD-mysql-2.1003.mine/t/mysql.mtest	Sun Nov 11 12:52:03 2001
@@ -4,5 +4,16 @@
 #
 # module specific definitions for a 'mysql' database
 
+$test_user = 'jimc';
+$test_password = 'secret';
+
+# get t/akmisc.t to pass
+
+$host = 'localhost';
+$user = 'jimc';
+$password = 'secret';
+$dbname = 'test';
+
+$verbose = 1;
 
 1;
Only in DBD-mysql-2.1003.mine/t: mysql.mtest~
diff -ur DBD-mysql-2.1003/t/mysql.t DBD-mysql-2.1003.mine/t/mysql.t
--- DBD-mysql-2.1003/t/mysql.t	Fri May  4 15:15:00 2001
+++ DBD-mysql-2.1003.mine/t/mysql.t	Sun Nov 11 12:18:42 2001
@@ -9,10 +9,12 @@
 # are configured wrong in this respect. But you're welcome to test it
 # out.
 
-my $host = shift @ARGV || $ENV{'DBI_HOST'} || "";
-my $user = shift @ARGV || $ENV{'DBI_USER'} || "";
-my $password = shift @ARGV || $ENV{'DBI_PASS'} || "";
-my $dbname = shift @ARGV || $ENV{'DBI_DB'} || "test";
+our ($host,$user,$password,$dbname);
+
+#$host = shift @ARGV || $ENV{'DBI_HOST'} || "";
+#$user = shift @ARGV || $ENV{'DBI_USER'} || "";
+#$password = shift @ARGV || $ENV{'DBI_PASS'} || "";
+#$dbname = shift @ARGV || $ENV{'DBI_DB'} || "test";
 
 # That's the standard perl way tostart a testscript. It announces that
 # that many tests are to follow. And it does so before anything can go
Only in DBD-mysql-2.1003.mine/t: mysql.t~
diff -ur DBD-mysql-2.1003/t/mysql2.t DBD-mysql-2.1003.mine/t/mysql2.t
--- DBD-mysql-2.1003/t/mysql2.t	Fri May  4 15:15:00 2001
+++ DBD-mysql-2.1003.mine/t/mysql2.t	Sun Nov 11 12:11:02 2001
@@ -8,7 +8,7 @@
 # Change 1..1 below to 1..last_test_to_print .
 # (It may become useful if the test is moved to ./t subdirectory.)
 
-my($host, $user, $password, $dbname);
+our ($host, $user, $password, $dbname);
 
 $host = shift @ARGV || $ENV{'DBI_HOST'} || "";
 $user = shift @ARGV || $ENV{'DBI_USER'} || "";
Only in DBD-mysql-2.1003.mine/t: mysql2.t~

Thread
DBD::mysql install problems.Jim Cromie11 Nov
  • Re: DBD::mysql install problems.Jochen Wiedmann12 Nov
Re: DBD::mysql install problems.Jim Cromie12 Nov
  • Re: DBD::mysql install problems.Jochen Wiedmann13 Nov