Has anyone sucessfully configured the perl DBI module to work with a MySQL
database?
After installing the MySql server, I have downloaded the following packages :-
1) DBI-1.18 - The DBI module for Perl.
This installs fine.
2) Msql-Mysql-modules-1.2216 - DBI drivers for MySql.
To install this, I do the following :-
perl Makefile.pl
make
make test
During "make test" it fails with the folowing error :-
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
-I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............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.
dubious
Test returned status 10 (wstat 2560, 0xa00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harness.pm line 288.
make[1]: *** [test_dynamic] Error 10
make[1]: Leaving directory
`/home/mhannah/downloads/Msql-Mysql-modules-1.2216/mysql'
make: *** [test] Error 2
Does anyone have any ideas what I'm doing wrong?
Thanks,
Mark.
Totalise - the Users ISP
----------------------
To become a member and a shareholder
visit http://www.totalise.net
-----------------------
The Totalise Email system, probably the most flexible email system in the
world. To register for an account goto http://www.totalise.net
--------------------------------------------------------------------
http://www.lug.org.uk http://www.linuxportal.co.uk
http://www.linuxjob.co.uk http://www.linuxshop.co.uk
--------------------------------------------------------------------