Stenyj has asked for the wisdom of the Perl Monks concerning the following question:

I'm setting up PHPTriad on my computer. I've upgraded to a recent version of perl, and am installing the modules I'll need.
I installed CGI::Session and HTML::Template with ease. I've run into a problem when trying to install DBI-1.42, so that my scripts can interact with MySQL...

When I run perl makefile.pl, I get the following warning: "You are using a perl configured with threading enabled. You should be aware that using multiple threads is not recommended for production environments"

Then it does some stuff (Creating DBI::PurePerl.....) and gives me the following error:
"Warning: Prerequisite Test::More failed to load: Can't locate......."

When I try to run nmake once it finishes, it seems to do what it needs to, until it ends up giving me a fatal error stating:
"NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code '0x1'
Stop."

I'll admit, I haven't got a clue what's wrong. Does anyone know how I can get DBI installed so that my script will be able to communicate with MySQL?

Any help is MUCH appreciated.


Steny

Replies are listed 'Best First'.
Re: Trouble installing DBI
by NetWallah (Canon) on Mar 16, 2004 at 06:14 UTC
    Need more info on the first failure - it looks like you don't have Test::More. You can get that by doing
    PPM install Test::More

    Also, Have you tried

    ppm install DBI
    and if that fails, run:
    perl -MCPAN -e shell ##then install Bundle::CPAN ## Followed by install DBI

    Offense, like beauty, is in the eye of the beholder, and a fantasy.
    By guaranteeing freedom of expression, the First Amendment also guarntees offense.
Re: Trouble installing DBI
by MrSteeple (Initiate) on Mar 16, 2004 at 08:16 UTC
    If its a windows box, it'd much easier if you just install using the MSI package. Those of you who are dedicated source compilers of course wouldn't agree, but I'm awefully lazy. :-)
Re: Trouble installing DBI
by xorl (Deacon) on Mar 16, 2004 at 16:15 UTC
    There are two problems
    Then it does some stuff (Creating DBI::PurePerl.....) and gives me the following error: "Warning: Prerequisite Test::More failed to load: Can't locate......."
    This clearly means you need to find the Test::More module and install it (I'm sure it's at CPAN althought I haven't looked). That should allow everthing to work. However there is a Warning that I don't know how to advise you:
    When I run perl makefile.pl, I get the following warning: "You are using a perl configured with threading enabled. You should be aware that using multiple threads is not recommended for production environments"
    Obviously you could have performance issues if you use this install of perl. A quick google for "perl threading enabled DBI" turned up a lot of links. The only useful one was this quote from http://www.hk8.org/old_web/linux/dbi/appa_08.htm
    If the DBI is built using a Perl that has threads enabled, then it will use a per-driver mutex to ensure that only one thread is with a driver at any one time. Please note that support for threads in Perl is still experimental and is known to have some significant problems. Its use is not recommended.