PDA

View Full Version : Problem with DBI installation on WinNT


WorkDB
02-13-03, 23:47
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! :)

jef72
09-24-03, 08:32
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.

Davor
11-28-03, 11:29
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.

ronan_40060
12-02-03, 09:22
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

kel508
12-18-03, 15:50
I've seen a few other posts on this - has anyone found the solution?

Thanks,

Kelly

cparker15
12-23-03, 16:34
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:

ppm> repository add local C:\Perl\repo

I then type this:

ppm> repository

and I can see that the "local" repository has been added.

If I then type

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..

kel508
12-23-03, 23:43
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:

ppm> repository add local C:\Perl\repo

I then type this:

ppm> repository

and I can see that the "local" repository has been added.

If I then type

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..

cparker15
12-29-03, 15:52
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:


Go to http://ppm.activestate.com/PPMPackages/zips/, choose your version of ActivePerl, and choose your platform
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/PPMPackages/zips/8xx-builds-only/Windows/).
Download the package(s) into a directory you'll be able to find later on.
Unzip the package(s) into your local repository directory (mine is C:\Perl\repo on the XP machine).
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
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.

First, I installed DBI: ppm install DBI
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 (http://www.dbforums.com/member.php?action=getinfo&userid=52746) on here for further contact information, although I'd rather keep posts on this thread for anyone who may have difficulties in the future.

bmckelley
04-30-04, 10:13
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.

ulloita
05-31-04, 11:26
I already did that, the same steps and anything appends

Error: no suitable installation target found for package DBI

ulloita
05-31-04, 12:25
bmckelley the problem is the version.
First download DBI 1.42 and try again

atulperl
11-21-05, 07:59
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