Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Unhappy Unanswered: Problem with DBI installation on WinNT

    I am new to Perl and have problems installing DBI on my local NT workstation.

    I've downloaded DBI.zip from activestate.
    Because of the firewall, I've problems connecting to activestate when trying to install from PPM. Therefore I've set the Active Repositories to local NT machine instead for installation.

    as attached are my commands:
    ppm> repo add local C:\foo
    ppm> search *
    Searching in Active Repositories
    1. DBI [1.32] Database independent interface for Perl
    ppm> install DBI
    Error: no suitable installation target found for package DBI.

    The DBI.ppd points to:
    <IMPLEMENTATION>
    <CODEBASE HREF="MSWin32-x86-multi-thread/DBI.tar.gz" />
    <ARCHITECTURE NAME="MSWin32-x86-multi-thread" />
    <OS NAME="MSWin32" />

    I do not understand as my directory MSWin32-x86-multi-thread/DBI.tar.gz is in place and search in PPM is able to find the PPD but why is that when I tried to install there will be "no suitable installation target found for package DBI"?
    My perl version is v5.8.0 built for MSWin32-x86-multi-thread
    and the PPM is version PPM - Programmer's Package Manager version3.0.1.

    I've tried to compile it from CPAN's DBI, it also failed.

    Please advise. Thanks in advance!

  2. #2
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9
    Replace the line

    <CODEBASE HREF="MSWin32-x86-multi-thread/DBI.tar.gz" />

    by
    <CODEBASE HREF="C:/DBI.tar.gz" />

    It will take the file from the C drive.

    Jef.

  3. #3
    Join Date
    Nov 2003
    Posts
    1
    Hi,

    I have the same problem and have tried with Jef72's solution, but it still doesn't work(?). Same error occurs. I have also tried to copy DBI.tar.gz file to root, but still nothing happens.

  4. #4
    Join Date
    Nov 2003
    Posts
    9
    hi Guys
    im also facing the same problem
    Im also using Win NT and did exactly the same thing but still not able to install
    I should find a solution
    regrads
    Ronan

  5. #5
    Join Date
    Dec 2003
    Location
    MA
    Posts
    2

    Can't Install DBI module due to firewall

    I've seen a few other posts on this - has anyone found the solution?

    Thanks,

    Kelly

  6. #6
    Join Date
    Dec 2003
    Location
    Haverhill, MA
    Posts
    4
    I'm having all the same problems...

    I downloaded DBI-1.39.tar.gz from CPAN and placed it in C:\Perl\repo...

    I run PPM, and did this:

    Code:
    ppm> repository add local C:\Perl\repo
    I then type this:

    Code:
    ppm> repository
    and I can see that the "local" repository has been added.

    If I then type

    Code:
    ppm> search *
    I eventually get told there are no results for '*';

    What else do I need to do to install the DBI packages necessary to interface with MySQL?! The machine in question does not have a direct connection to the Internet... in fact, it has none at all... I am tunnelling over to the machine and dropping the tarballs onto its hard drive from this machine I'm currently on..

    Any help would be appreciated...

    Thanks.

    Edit: The machine in question is running Windows XP Professional..
    Last edited by cparker15; 12-23-03 at 16:37.

  7. #7
    Join Date
    Dec 2003
    Location
    MA
    Posts
    2
    Hi Cparker,

    I'm running Win XP Professional as well. I went through HELL trying to figure out how to install without an internet connection and to be honest, I tried every suggestion I came across and NOTHING worked! Adding the local repository still only gives you the script which HAS to connect to the internet in order get the rest of the files to install DBI properly. What I ended up doing was taking my laptop off my corporate connection, hooking it up to my home cable modem and disabling my proxy so that I had FULL internet access (versus being at work with a firewall), and THEN the script ran fine because it could connect.

    If you can't connect to the internet or are behind a firewall, email me and I will send you the files you need and tell you where to put them - there's like 50 or 60 of them that need to be copied under a subdir under the Perl directory. Don't waste your time trying to install locally.

    Below is a listing of all the files... Not sure if strict copying will be enough, but it's worth a try. Let me know if you want me to send them along...

    Regards,

    Kelly


    ppm> install DBI
    ====================
    Install 'DBI' version 1.39 in ActivePerl 5.8.2.808.
    ====================
    Downloaded 445877 bytes.
    Extracting 62/62: blib/arch/auto/DBI/Driver_xst.h
    Installing C:\Perl\site\lib\auto\DBI\dbd_xsh.h
    Installing C:\Perl\site\lib\auto\DBI\DBI.bs
    Installing C:\Perl\site\lib\auto\DBI\DBI.dll
    Installing C:\Perl\site\lib\auto\DBI\DBI.exp
    Installing C:\Perl\site\lib\auto\DBI\DBI.lib
    Installing C:\Perl\site\lib\auto\DBI\dbipport.h
    Installing C:\Perl\site\lib\auto\DBI\DBIXS.h
    Installing C:\Perl\site\lib\auto\DBI\dbi_sql.h
    Installing C:\Perl\site\lib\auto\DBI\Driver.xst
    Installing C:\Perl\site\lib\auto\DBI\Driver_xst.h
    Installing C:\Perl\html\bin\dbiprof.html
    Installing C:\Perl\html\bin\dbiproxy.html
    Installing C:\Perl\html\site\lib\DBI.html
    Installing C:\Perl\html\site\lib\Bundle\DBI.html
    Installing C:\Perl\html\site\lib\DBD\Proxy.html
    Installing C:\Perl\html\site\lib\DBD\Sponge.html
    Installing C:\Perl\html\site\lib\DBI\Changes.html
    Installing C:\Perl\html\site\lib\DBI\DBD.html
    Installing C:\Perl\html\site\lib\DBI\FAQ.html
    Installing C:\Perl\html\site\lib\DBI\Profile.html
    Installing C:\Perl\html\site\lib\DBI\ProfileData.html
    Installing C:\Perl\html\site\lib\DBI\ProfileDumper.html
    Installing C:\Perl\html\site\lib\DBI\ProxyServer.html
    Installing C:\Perl\html\site\lib\DBI\PurePerl.html
    Installing C:\Perl\html\site\lib\DBI\W32ODBC.html
    Installing C:\Perl\html\site\lib\DBI\Const\GetInfoReturn.html
    Installing C:\Perl\html\site\lib\DBI\Const\GetInfoType.html
    Installing C:\Perl\html\site\lib\DBI\Const\GetInfo\ANSI.html
    Installing C:\Perl\html\site\lib\DBI\Const\GetInfo\ODBC.html
    Installing C:\Perl\html\site\lib\DBI\DBD\Metadata.html
    Installing C:\Perl\html\site\lib\DBI\ProfileDumper\Apache.htm l
    Installing C:\Perl\html\site\lib\Win32\DBIODBC.html
    Files found in blib\arch: installing files in blib\lib into architecture depende
    nt library tree
    Installing C:\Perl\site\lib\DBI.pm
    Installing C:\Perl\site\lib\Bundle\DBI.pm
    Installing C:\Perl\site\lib\DBD\ExampleP.pm
    Installing C:\Perl\site\lib\DBD\NullP.pm
    Installing C:\Perl\site\lib\DBD\Proxy.pm
    Installing C:\Perl\site\lib\DBD\Sponge.pm
    Installing C:\Perl\site\lib\DBI\Changes.pm
    Installing C:\Perl\site\lib\DBI\DBD.pm
    Installing C:\Perl\site\lib\DBI\FAQ.pm
    Installing C:\Perl\site\lib\DBI\Profile.pm
    Installing C:\Perl\site\lib\DBI\ProfileData.pm
    Installing C:\Perl\site\lib\DBI\ProfileDumper.pm
    Installing C:\Perl\site\lib\DBI\ProxyServer.pm
    Installing C:\Perl\site\lib\DBI\PurePerl.pm
    Installing C:\Perl\site\lib\DBI\W32ODBC.pm
    Installing C:\Perl\site\lib\DBI\Const\GetInfoReturn.pm
    Installing C:\Perl\site\lib\DBI\Const\GetInfoType.pm
    Installing C:\Perl\site\lib\DBI\Const\GetInfo\ANSI.pm
    Installing C:\Perl\site\lib\DBI\Const\GetInfo\ODBC.pm
    Installing C:\Perl\site\lib\DBI\DBD\Metadata.pm
    Installing C:\Perl\site\lib\DBI\ProfileDumper\Apache.pm
    Installing C:\Perl\site\lib\Win32\DBIODBC.pm
    Installing C:\Perl\bin\dbiprof
    Installing C:\Perl\bin\dbiprof.bat
    Installing C:\Perl\bin\dbiproxy
    Installing C:\Perl\bin\dbiproxy.bat
    Successfully installed DBI version 1.39 in ActivePerl 5.8.2.808.


    Originally posted by cparker15
    I'm having all the same problems...

    I downloaded DBI-1.39.tar.gz from CPAN and placed it in C:\Perl\repo...

    I run PPM, and did this:

    Code:
    ppm> repository add local C:\Perl\repo
    I then type this:

    Code:
    ppm> repository
    and I can see that the "local" repository has been added.

    If I then type

    Code:
    ppm> search *
    I eventually get told there are no results for '*';

    What else do I need to do to install the DBI packages necessary to interface with MySQL?! The machine in question does not have a direct connection to the Internet... in fact, it has none at all... I am tunnelling over to the machine and dropping the tarballs onto its hard drive from this machine I'm currently on..

    Any help would be appreciated...

    Thanks.

    Edit: The machine in question is running Windows XP Professional..

  8. #8
    Join Date
    Dec 2003
    Location
    Haverhill, MA
    Posts
    4

    SOLUTION

    I have successfully installed DBI and DBD-mysql onto my Windows XP machine (which does not have a 'net connection).

    Here are the steps I took to do it:

    1. Go to http://ppm.activestate.com/PPMPackages/zips/, choose your version of ActivePerl, and choose your platform
    2. Scroll down to find the package(s) you're looking for (in my case, I found DBI.zip and DBD-mysql.zip at http://ppm.activestate.com/PPMPackag...-only/Windows/).
    3. Download the package(s) into a directory you'll be able to find later on.
    4. Unzip the package(s) into your local repository directory (mine is C:\Perl\repo on the XP machine).
    5. If you haven't done so already, denote this directory as a repository directory within ppm. I labeled my repository "local" (minus double quotes). Here is the command I used to add my repository: ppm repository add local C:\Perl\repo
    6. Once the directory is added, search your repositories for all packages: ppm search * I got a list of the two packages in my "local" repository (DBI and DBD-mysql).

    Once I had the names, I installed each one. I did NOT edit the .ppd file that came bundled in the .zip file.
    1. First, I installed DBI: ppm install DBI
    2. Then I installed DBD-mysql: ppm install DBD-mysql


    All done! Start using the packages. It's that easy.

    Note: If you are already running from within ppm (you'll be able to tell because your command prompt will start with ppm>), then leave off the ppm in the command you type to carry out any actions. (Example: ppm> repository add local C:\Perl\repo instead of ppm> ppm repository add local C:\Perl\repo.)

    Please let me know if this has been a help to you. If you have any problems with these instructions, please reply to this post.

    You can also check my profile on here for further contact information, although I'd rather keep posts on this thread for anyone who may have difficulties in the future.

  9. #9
    Join Date
    Apr 2004
    Posts
    1

    Error trying to install DBI

    I did exactly what you asked and everything worked except when I tried to run the install. I am using Active State 5.8 on Windows XP Pro. Do I need to also unzip the tar.gz file that comes with the DBI.zip?


    C:\>ppm repository add local C:\Perl\repo
    Repositories:
    [1] ActiveState PPM2 Repository
    [2] ActiveState Package Repository
    [3] local

    C:\>ppm search *
    Searching in Active Repositories
    1. DBD-Oracle [1.03] Oracle database driver for the DBI module
    2. DBI [1.14] Database independent interface for Perl

    C:\>ppm install DBI
    Error: no suitable installation target found for package DBI.

  10. #10
    Join Date
    May 2004
    Posts
    5

    The same error

    I already did that, the same steps and anything appends

    Error: no suitable installation target found for package DBI

  11. #11
    Join Date
    May 2004
    Posts
    5

    In XP is a version problem

    bmckelley the problem is the version.
    First download DBI 1.42 and try again

  12. #12
    Join Date
    Nov 2005
    Posts
    1

    Problem with DBI installation on WinNT

    1)Download the correct dbi.zip (correct version) for the target perl installation
    2)extract the files in the local repository added
    3)type install DBI OR install dbi on the ppm prompt ( as is the case of dbi.ppd or DBI.ppd)

    installation will definately succeed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •