>
wrt my probs, and attempted isolation of them into udiff,
Jochen Wiedmann wrote:
> Please send me the complete output of
>
> perl Makefile.PL
> make
> make test TEST_VERBOSE=1
ok, here comes the gory details...
[root@groucho build]# ls DBD-mysql-2.*
DBD-mysql-2.0902 DBD-mysql-2.1003 DBD-mysql-2.1003.mine
first the default run (w/o options)
[root@groucho build]# cd DBD-mysql-2.1003
[root@groucho DBD-mysql-2.1003]# perl Makefile.PL
I will use the following settings for compiling and testing:
testpassword (default ) =
testhost (default ) =
testuser (default ) =
nocatchstderr (default ) = 0
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
cflags (mysql_config) = -I'/usr/include/mysql'
testdb (default ) = test
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.20 installed in
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
[root@groucho DBD-mysql-2.1003]# make
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE dbdimp.c
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/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/mysql:/usr/lib:/lib" /usr/local/bin/perl myld cc
-shared -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
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/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3
You have new mail in /var/spool/mail/root
[root@groucho DBD-mysql-2.1003]# make test TEST_VERBOSE=1
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=1; runtests
@ARGV;'
t/*.t
t/00base...........1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/10dsnlist........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
Driver is mysql
1..3
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-3
Failed 3/3 tests, 0.00% okay
t/20createdrop.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/20createdrop.t line
45
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..5
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/30insertfetch.t line
48
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam......DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40bindparam.t line 64
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..28
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs..........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40blobs.t line 68
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40listfields.t line
57
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..16
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-16
Failed 16/16 tests, 0.00% okay
t/40nulls..........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40nulls.t line 50
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40numrows.t line 59
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..25
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/50chopblanks.t line
57
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..35
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit.........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/50commit.t line 64
Can't call method "tables" on an undefined value at t/lib.pl line 216.
1..30
Attempting to connect.
not ok 1
Cannot connect: Error 1045.
Make sure, your database server is up and running.
Check that 'DBI:mysql:database=test' references a valid database name.
DBI error message: Access denied for user: 'root@localhost' (Using
password: NO)
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks..........1..0
skipped test on this platform
t/ak-dbd...........1..90
DBI->connect(database=test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/ak-dbd.t line 59
not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO).
ok 2
ok 3
Can't call method "tables" on an undefined value at t/lib.pl line 216.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1, 4-90
Failed 88/90 tests, 2.22% okay
t/akmisc...........Verifying whether fetchrow returns TRUE for
results.
1..351
Mysql->connect(database=test;host=) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/akmisc.t line 133
First connect to server
not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin.........1..20
DBI->connect(database=test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/dbdadmin.t line 74not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
t/insertid.........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/insertid.t line 13
1..12
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql2...........Mysql->connect(database=test;host=) failed: Access
denied for user: 'root@localhost' (Using password: NO) at t/mysql2.t
line 23
Can't call method "getserverinfo" on an undefined value at t/mysql2.t
line 24.
not ok 1
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/mysql............Mysql->connect(database=test;host=) failed: Access
denied for user: 'root@localhost' (Using password: NO) at t/mysql.t
line
48
not ok 1: Access denied for user: 'root@localhost' (Using password:
NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
1..68
FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10dsnlist.t 10 2560 3 3 100.00% 1-3
t/20createdrop.t 10 2560 5 5 100.00% 1-5
t/30insertfetch.t 10 2560 11 11 100.00% 1-11
t/40bindparam.t 10 2560 28 28 100.00% 1-28
t/40blobs.t 10 2560 11 11 100.00% 1-11
t/40listfields.t 10 2560 16 16 100.00% 1-16
t/40nulls.t 10 2560 11 11 100.00% 1-11
t/40numrows.t 10 2560 25 25 100.00% 1-25
t/50chopblanks.t 10 2560 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 88 97.78% 1 4-90
t/akmisc.t 10 2560 351 351 100.00% 1-351
t/dbdadmin.t 10 2560 20 20 100.00% 1-20
t/insertid.t 255 65280 12 12 100.00% 1-12
t/mysql.t 68 68 100.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 16/18 test scripts, 11.11% okay. 714/721 subtests failed, 0.97%
okay.
make: *** [test_dynamic] Error 29
OK, BLIND TEST DIDNT WORK.
TRY SETTING OPTIONS ON CMDLINE
[root@groucho DBD-mysql-2.1003]# perl Makefile.PL --testuser=jimc
--testpassword=secret
I will use the following settings for compiling and testing:
testhost (default ) =
testpassword (Users choice) = secret
testuser (Users choice) = jimc
nocatchstderr (default ) = 0
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
cflags (mysql_config) = -I'/usr/include/mysql'
testdb (default ) = test
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.20 installed in
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
[root@groucho DBD-mysql-2.1003]# make
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE dbdimp.c
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/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/mysql:/usr/lib:/lib" /usr/local/bin/perl myld cc
-shared -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
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/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3
[root@groucho DBD-mysql-2.1003]# make test TEST_VERBOSE=1
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=1; runtests
@ARGV;'
t/*.t
t/00base...........1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/10dsnlist........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
Driver is mysql
1..3
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-3
Failed 3/3 tests, 0.00% okay
t/20createdrop.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/20createdrop.t line
45
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..5
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/30insertfetch.t line
48
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam......DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40bindparam.t line 64
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..28
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs..........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40blobs.t line 68
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40listfields.t line
57
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..16
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-16
Failed 16/16 tests, 0.00% okay
t/40nulls..........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40nulls.t line 50
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..11
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/40numrows.t line 59
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..25
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks.....DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/50chopblanks.t line
57
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
1..35
not ok 1
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit.........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/50commit.t line 64
Can't call method "tables" on an undefined value at t/lib.pl line 216.
1..30
Attempting to connect.
not ok 1
Cannot connect: Error 1045.
Make sure, your database server is up and running.
Check that 'DBI:mysql:database=test' references a valid database name.
DBI error message: Access denied for user: 'root@localhost' (Using
password: NO)
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks..........1..0
skipped test on this platform
t/ak-dbd...........1..90
DBI->connect(database=test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/ak-dbd.t line 59
not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO).
ok 2
ok 3
Can't call method "tables" on an undefined value at t/lib.pl line 216.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1, 4-90
Failed 88/90 tests, 2.22% okay
t/akmisc...........Verifying whether fetchrow returns TRUE for
results.
1..351
Mysql->connect(database=test;host=) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/akmisc.t line 133
First connect to server
not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-351
Failed 351/351 tests, 0.00% okay
t/dbdadmin.........1..20
DBI->connect(database=test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/dbdadmin.t line 74not ok 1
Cannot connect: Access denied for user: 'root@localhost' (Using
password: NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
t/insertid.........DBI->connect(database=test) failed: Access denied
for
user: 'root@localhost' (Using password: NO) at t/insertid.t line 13
1..12
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql2...........Mysql->connect(database=test;host=) failed: Access
denied for user: 'root@localhost' (Using password: NO) at t/mysql2.t
line 23
Can't call method "getserverinfo" on an undefined value at t/mysql2.t
line 24.
not ok 1
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/mysql............Mysql->connect(database=test;host=) failed: Access
denied for user: 'root@localhost' (Using password: NO) at t/mysql.t
line
48
not ok 1: Access denied for user: 'root@localhost' (Using password:
NO)
It looks as if your server is not up and running.
This test requires a running server.
Please make sure your server is running and retry.
1..68
FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10dsnlist.t 10 2560 3 3 100.00% 1-3
t/20createdrop.t 10 2560 5 5 100.00% 1-5
t/30insertfetch.t 10 2560 11 11 100.00% 1-11
t/40bindparam.t 10 2560 28 28 100.00% 1-28
t/40blobs.t 10 2560 11 11 100.00% 1-11
t/40listfields.t 10 2560 16 16 100.00% 1-16
t/40nulls.t 10 2560 11 11 100.00% 1-11
t/40numrows.t 10 2560 25 25 100.00% 1-25
t/50chopblanks.t 10 2560 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 88 97.78% 1 4-90
t/akmisc.t 10 2560 351 351 100.00% 1-351
t/dbdadmin.t 10 2560 20 20 100.00% 1-20
t/insertid.t 255 65280 12 12 100.00% 1-12
t/mysql.t 68 68 100.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 16/18 test scripts, 11.11% okay. 714/721 subtests failed, 0.97%
okay.
make: *** [test_dynamic] Error 29
NOT MUCH LUCK HERE EITHER
TRY MY DIFF'D VERSION
my diff has 2 kinds of changes.
t/mysql.mtest to set values picked up via do file mechanics used in
t/[0-5]0*.t
changes to dist-files that corrected some install probs.
[root@groucho DBD-mysql-2.1003.mine]# perl Makefile.PL
I will use the following settings for compiling and testing:
testpassword (default ) =
testhost (default ) =
testuser (default ) =
nocatchstderr (default ) = 0
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
cflags (mysql_config) = -I'/usr/include/mysql'
testdb (default ) = test
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.20 installed in
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
[root@groucho DBD-mysql-2.1003.mine]# make
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE dbdimp.c
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I'/usr/include/mysql' -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.1003\"
-DXS_VERSION=\"2.1003\" -fpic
-I/usr/local/lib/perl5/5.6.1/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/mysql:/usr/lib:/lib" /usr/local/bin/perl myld cc
-shared -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
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/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3
[root@groucho DBD-mysql-2.1003.mine]#
[root@groucho DBD-mysql-2.1003.mine]# make test
OK, DROPPING VERBOSITY TO GET PAST MAILER LIMIT 30000 bytes
[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
You have new mail in /var/spool/mail/root
[root@groucho DBD-mysql-2.1003.mine]#
[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
ok 20
