Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Cannot install DBI

by NeilF (Sexton)
on Feb 01, 2006 at 14:13 UTC ( #527059=perlquestion: print w/replies, xml ) Need Help??

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

I'm trying to do some simple MYSQL stuff on my Windows XP machine. Basically I'm trying to read into the VBulletin MYSQL database with perl.

I downloaded phptriad2-2-1.exe which set everything I needed MYSQL and PHP wise, but also has installed me another copy of apache. Any how... the main thing is I now have VBulleting and a database on my machine.

HOWEVER, when I now try running a perl script, the moment it gets to a "USE DBI;" statement it causes an Internel System Error, and the error log reports:-

Can't locate in @INC (@INC contains: c:/usr/lib c:/usr/site/lib .) at c:/blahblah/ line 3.

This same error message occurs no matter which of the two version of apache I now have.

The interesting thing is I can see in "C:\usr\perl\site\lib" the following stuff:-
A "DBI" directory

I expect this other directory is from one of my numerous different perl/apache installs over the years?

Anyway, I tried installing DBI by using PPM but always get:- Error installing package 'DBD-Mysql': Could not local PPD file for package DBD-Mysql.

If I type "search" I get:-
Packages available from "" and nothing else...


Replies are listed 'Best First'.
Re: Cannot install DBI
by holli (Abbot) on Feb 01, 2006 at 14:57 UTC
    A package for DBD-mysql is available at these locations:

    See A guide to installing modules for Win32 for how to create a repository and general ppm advice.

    holli, /regexed monk/
      Looking at your link, some of the commands are invalid in my PPM...

      For example, if I type "rep", I get "unknown command 'rep'".

      Could it be my "PPM" is old/duff? It says (1.0.0) on starting up!?
        Yes. My ppm (Perl 5.8.0) is version 3.1. What's your version of Perl? It must at least be 5.6 or older.

        holli, /regexed monk/
Re: Cannot install DBI
by svenXY (Deacon) on Feb 01, 2006 at 14:51 UTC
    Can't locate in @INC (@INC contains: c:/usr/lib c:/usr/site/lib + .) ... I can see in "C:\usr\perl\site\lib" the following stuff
    Yep, and that's probably the problem. C:\usr\perl\site\lib is not in INC or - the other way round - your module is not in the directories searched by Perl. I'd try to copy the DBI stuff over to c:/usr/site/lib
    Update: I have to admit though that this one file only can hardly be the whole DBI let alone DBD::MySQL module...
      I've tried copying the three things (a directory and two files) mentioned to "c:\usr\site\lib" but the error message just changes to...

      Can't locate loadable object for module DBI in @INC (@INC contains: c:/usr/lib c:/usr/site/lib .) at c:/usr/site/lib/ line 250

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://527059]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2022-05-19 15:44 GMT
Find Nodes?
    Voting Booth?
    Do you prefer to work remotely?

    Results (71 votes). Check out past polls.