make test errors for cpan install DBD::mysql

We managed to truly FUBAR our Perl installation a couple of weekends ago.
(don't ask).
I got it back (and upgraded to 5.8.5) but lost the MySQL access (probably
among other things).

So, I reinstalled DBD::mysql from CPAN. The build had no problems but I'm a
cautious sort and I like to run "make test". Tis did not go well:

Running make test
PERL_DL_NONLAZY=1 /ad4/ENV/freebsd-ELF/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........DBI connect('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:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
t/10dsnlist........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
[...more of the same till I kill it ...]

This confuses me greatly because I _do_ have MySQL installed and running and
my notes from when I installed it don't say anything about root@localhost.

I've got MySQL 3.23.55 running under FreeBSD 4.7. A friend suggested I just
make force install and move on so I did and things appear to work (although
not running the tests makes me a bit nervous).

ps aux | grep mysql
mysql 289 0.0 0.4 27484 4152 con- S Tue07PM 0:12.97
/usr/local/libexe
vlb@cfcl [~] 147: mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show DATABASES
-> ;
+---------------+
| Database |
+---------------+
| genomatik |
| mambo_cfcl |
| midgard |
| mt_heatercats |
| mysql |
| tasks |
| test |
+---------------+
7 rows in set (0.10 sec)



Now I am planning to upgrade MySQL to 4.1.7 and the upgrade notes advise me to
Ensure that I don't have any MySQL clients that use shared libraries
(like the Perl DBD::mysql module).
Well, I do...
If you do, you should recompile them,...
Ok. But then I will likely run into the test confusion again.

What magic incantations should I run through MySQL to get access for user:
'root@localhost' (Using password: NO). Or whatever it is I need to do. Burn
incense. Pour a little wine on the ground... my gods don't require nasty
things done to small furry mammals...


(If you can help I'd dearly appreciate a cc: as I get the digest form of this
list).
--
Vicki Brown ZZZ Journeyman Sourceror:
SF Bay Area, CA zz |\ _,,,---,,_ Scripts & Philtres
http://www.cfcl.com zz /,`.-'`' -. ;-;;,_Code, Doc, Process, QA
http://cfcl.com/vlb |,4- ) )-,_. ,\ ( `'-'Perl, Unix, Mac OS X, WWW
____________________ '---''(_/--' `-'\_) ___________________________

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: make test errors for cpan install DBD::mysql

Vicki Brown wrote:

> t/10dsnlist........DBI connect('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)

As the message says: The test suite attempts to login as user "root"
(currently logged in user) to database "test" on host "localhost"
without password, which is refused by your database. Most probably,
because you have disabled such access.

Either specify a user name and password (see the module docs for how to
do this) or ignore the errors and proceed by forcing "make install".


Jochen

--
http://lilypie.com/baby1/050423/1/5/1/+1

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org