DBD::mysql fails tests

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kk747@columbia.edu - 29 Oct 2003 08:33 GMT

Hi all,

I've been having trouble installing DBD::mysql on a fresh install of
Panther, even after having patched Config.pm as Edward Moy suggested on
this list a couple weeks ago. Specifically, 'make test' spits back the
following:

t/mysql............FAILED tests 46-48
Failed 3/68 tests, 95.59% okay

All other tests pass with flying colors. This is with MySQL 4.0.16.

Anyway, so I googled around a bit, and it turns out this problem was
mentioned here exactly once before (see
http://www.mail-archive.com/macosx@perl.org/msg05466.html). My question
is, is anyone else having the same problem besides the two of us? It
seems a little suspicious that there'd be nothing else on the googlable
web about DBD::mysql failing these tests, if the problem were
universal. Perhaps there's something unique to Juan's configuration and
my own that is causing problems with this test?

I'm relatively new to Perl and MySQL, but I seem to recall reading
somewhere that DBD::mysql prefers a perl built without multi-threading.
Is it worth a try to recompile perl with multi-threading disabled?

To be honest, I don't know if DBD::mysql failing this one test is even
worth worrying about, but I'd still appreciate any advice anyone can
offer.

thanks,
ken

Reply to this Message

Conrad Schilbe - 29 Oct 2003 17:45 GMT

> Hi all,
>
[quoted text clipped - 27 lines]
> thanks,
> ken

Try installing with CPAN

As root do the following:

perl -MCPAN -eshell
cpan> install DBD::mysql

If this still fails the same test you should check that Mysql is running and
that root can connect without a password. You should change that after
installing.

c

Reply to this Message

kk747@columbia.edu - 29 Oct 2003 18:33 GMT

Hi Conrad, thanks for the tip. However, to clarify, I was already
trying to install via CPAN as root, and I've double checked that
there's no password on the MySQL root account. Since my earlier post,
I've done a little more digging and found some people on the perl list
at mysql.com who have had the same problem with the DBD::mysql tests.
So barring any other ideas, I'm just going to assume these errors are
meaningless and go ahead and force install.

Still, Conrad... I saw from an earlier thread here that you were able
to install DBD::mysql, using Apple's install of perl, without any
problems. I'm assuming it passed 'make test' for you? What version of
gcc were you using?

thanks,
ken

>> Hi all,
>>
[quoted text clipped - 46 lines]
>
> c

Reply to this Message

Conrad Schilbe - 29 Oct 2003 19:20 GMT

> Hi Conrad, thanks for the tip. However, to clarify, I was already
> trying to install via CPAN as root, and I've double checked that
[quoted text clipped - 8 lines]
> problems. I'm assuming it passed 'make test' for you? What version of
> gcc were you using?

I used 3.3.

But I'm using Mysql 3.x - Could be the difference.

> thanks,
> ken
[quoted text clipped - 49 lines]
>>
>> c

Reply to this Message

Mac Forum / Programming / Perl / October 2003

DBD::mysql fails tests