Hi Mark
I don't know if you've managed to get this to work yet, but I successfully use PPM behind a firewall. Basically (and if you read the docs it does kind of explain this) you need to set some environment variables before you run PPM. If you have a pssive proxy (ie you don't use a username / password to get to the web) you just need to set HTTP_Proxy : set HTTP_Proxy="http://my.proxy.name:nnnnn"; where the nnnn is the port number you use to get out. It's important to have the "http://"; on the front, otherwise it doesn't work. If you have an active proxy which requires a username and password, you'll need to set two other variables also : set HTTP_Proxy_User="my_username" set HTTP_Proxy_Pass="password" I have a batchfile called setnet which I use. It basically sets the proxy and user and then sets password to the first parameter passed to the script. That way I don't have my password hard coded into a script. Sorry if all this is teaching you to suck eggs but I know it took me a couple of tries to get it going. If you're still having problems, drop me a line and I'll email you a PPD for DBI-1.20. Hope this helps ! Paul Mark Buckle <[EMAIL PROTECTED]> on 05/02/2002 15:41:04 To: "'Sterin, Ilya'" <[EMAIL PROTECTED]> "''''[EMAIL PROTECTED]' ' ' '" <[EMAIL PROTECTED]> cc: (bcc: Paul BARKER/IT/HTLUK) bcc: Paul BARKER/IT/HTLUK Subject: RE: ActivePerl & DBI - can't build DBI1.20 - and wheres DBD-Ingre s ? And if you're behind a company firewall and you get this error ? C:\DBI-1.20>ppm install http://www.xmlproj.com/PPM/DBI-1_20.ppd Installing package 'http://www.xmlproj.com/PPM/DBI-1_20.ppd'... Error installing package 'http://www.xmlproj.com/PPM/DBI-1_20.ppd': Could not lo cate a PPD file for package http://www.xmlproj.com/PPM/DBI-1_20.ppd C:\DBI-1.20> -----Original Message----- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 15:14 To: 'Mark Buckle '; ''''[EMAIL PROTECTED]' ' ' ' Subject: RE: ActivePerl & DBI - can't build DBI1.20 - and wheres DBD-Ingre s ? I repeat again and again and again. You are using ActiveState Perl, which comes with the PPM utility. Use it to install the binaries, and you won't have to compile anything. In command prompt... ppm install http://www.xmlproj.com/PPM/DBI-1_20.ppd This will install DBI 1.20 Ilya -----Original Message----- From: Mark Buckle To: '''[EMAIL PROTECTED]' ' ' Sent: 2/5/02 5:27 AM Subject: RE: ActivePerl & DBI - can't build DBI1.20 - and wheres DBD-Ingre s ? OK, I've got rid of the elementary beginners style errors in the make process that were bothering me yesterday, and am now getting an error when trying to link DBI.dll C:\DBI-1.20>nmake Microsoft (R) Program Maintenance Utility Version 1.62.7022 Copyright (C) Microsoft Corp 1988-1997. All rights reserved. link -out:blib\arch\auto\DBI\DBI.dll -dll -nologo -nodefaultlib -release -libpath:"C:\perl\lib\CORE" -machine:x86 DBI.obj C:\Perl\lib\CORE\perl56.li b oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib adva pi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib wsock32.lib m pr.lib winmm.lib version.lib odbc32.lib odbccp32.lib msvcrt.lib -def:DBI.def C:\Perl\lib\CORE\perl56.lib : fatal error LNK1106: invalid file or disk full: ca nnot seek to 0x3c36e642 NMAKE : fatal error U1077: 'link' : return code '0xc' if I take out C:\Perl\lib\CORE\perl56.lib from the link statment, I just get all the unresolved symbol errors you would expect. Is there anything one should know about this library ? I've checked the ActivState docs and there is nothing specific about required compiler/linker versions. I'm using VC++ Can any-one help at all ? Thanks in advance. Mark. -----Original Message----- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: 04 February 2002 15:42 To: 'Mark Buckle '; '''[EMAIL PROTECTED]' ' ' Subject: RE: ActivePerl & DBI - can't build DBI1.20 - and wheres DBD-Ingre s ? Definitely, we need more PPMs, since the ActiveState folks are not updating their stuff:-( Ilya -----Original Message----- From: Mark Buckle To: Sterin, Ilya; ''[EMAIL PROTECTED]' ' Sent: 2/4/02 8:36 AM Subject: RE: ActivePerl & DBI - can't build DBI1.20 - and wheres DBD-Ingre s ? Perhaps, not, but then I definitely am going to have to try and build DBD-Ingres, for which there is no PPM module, not even and out of date one . :-) . Mark. -----Original Message----- From: Sterin, Ilya [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: 04 February 2002 15:37 To: 'Mark Buckle '; ''[EMAIL PROTECTED]' ' Subject: RE: ActivePerl & DBI - can't build DBI1.20 You shouldn't try to build it, just use PPM to install. In command line... ppm install http://www17.addr.com/~xmlproj/PPM/DBI-1.20.ppd <http://www17.addr.com/~xmlproj/PPM/DBI-1.20.ppd> This would install. It used to be on www.xmlproj.com, but I'm undergoing a host change, so the DSN is all screwed up. It should be up in a few days. Ilya -----Original Message----- From: Mark Buckle To: '[EMAIL PROTECTED]' Sent: 2/4/02 6:55 AM Subject: RE: ActivePerl & DBI - can't build DBI1.20 -----Original Message----- From: Mark Buckle Sent: 04 February 2002 13:41 To: 'Berger, Daniel'; 'tzonekev'; [EMAIL PROTECTED] Subject: RE: ActivePerl & DBI - can't build DBI1.20 I've tried building DBI-1.20 on NT with VC++ 5, and come up with the following error (I've mapped copy to cp BTW) :- $ perl Makefile.PL *** You are using a perl with experimental threading enabled! *** You should be aware that using multiple threads is unstable *** are should NOT be done in production environments. DBI thread mutex protection is enabled *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage. Optional modules are available from any CPAN mirror, in particular http://www.perl.com/CPAN/modules/by-module <http://www.perl.com/CPAN/modules/by-module> http://www.perl.org/CPAN/modules/by-module <http://www.perl.org/CPAN/modules/by-module> ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module <ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module> Checking if your kit is complete... Looks good Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers. Windows users need to use the correct make command. That may be nmake or dmake depending on which Perl you are using. If using the Win32 ActiveState build then it is recommended that you use the ppm utility to fetch and install a prebuilt DBI instead. Writing Makefile for DBI $ nmake Microsoft (R) Program Maintenance Utility Version 1.62.7022 Copyright (C) Microsoft Corp 1988-1997. All rights reserved. cp DBIXS.h blib\arch\auto\DBI/DBIXS.h cp lib/DBD/NullP.pm blib\lib\DBD\NullP.pm cp dbipport.h blib\arch\auto\DBI/dbipport.h cp lib/DBI/Format.pm blib\lib\DBI\Format.pm cp dbd_xsh.h blib\arch\auto\DBI/dbd_xsh.h cp lib/DBI/Shell.pm blib\lib\DBI\Shell.pm cp lib/DBI/FAQ.pm blib\lib\DBI\FAQ.pm cp DBI.pm blib\lib\DBI.pm cp lib/DBD/ExampleP.pm blib\lib\DBD\ExampleP.pm cp lib/Bundle/DBI.pm blib\lib\Bundle\DBI.pm cp lib/Win32/DBIODBC.pm blib\lib\Win32\DBIODBC.pm cp lib/DBI/W32ODBC.pm blib\lib\DBI\W32ODBC.pm cp lib/DBI/DBD.pm blib\lib\DBI\DBD.pm cp lib/DBD/Proxy.pm blib\lib\DBD\Proxy.pm cp lib/DBI/ProxyServer.pm blib\lib\DBI\ProxyServer.pm cp dbi_sql.h blib\arch\auto\DBI/dbi_sql.h cp Driver.xst blib\arch\auto\DBI/Driver.xst cp lib/DBD/Sponge.pm blib\lib\DBD\Sponge.pm C:\perl\bin\perl.exe -p -e "s/~DRIVER~/Perl/g" < blib\arch\auto\DBI/Driver.xst > Perl.xsi C:\perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib C:\Perl\lib\ExtUtils/xsubpp -typemap C:\Perl\lib\ExtUtils\typemap Perl.xs > Perl.xsc && C:\perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e mv Perl.xsc Perl.c cl -c -nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPERL_MSVCRT_READFIX -O1 -MD -DNDEBUG -DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -IC:\Perl\lib\CORE Perl.c NMAKE : fatal error U1077: 'cl' : return code '0x80' Stop. $ -----Original Message----- From: Berger, Daniel [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: 05 October 2001 15:25 To: 'tzonekev'; [EMAIL PROTECTED] Subject: RE: ActivePerl & DBI Mr. Bunce (or someone) will have generate a new .ppd file for version 1.20 in order for you to use PPM. In the meantime, you can either do: 1) perl -MCPAN -e shell; install DBI or 2) perl Makefile.PL; make; make test; make install (replace make with nmake if MS Windoze) Regards, Mr. Sunblade -----Original Message----- From: tzonekev [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, October 04, 2001 4:32 PM To: [EMAIL PROTECTED] Subject: ActivePerl & DBI Can anyone please help in upgrading active state perl DBI module from ver1.14, readily available on the ActiveState repository, to version 1.20, the current one, found on many CPAN sites Kevin Pickering Planet Telecom ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ******************************************************************************* Important. Confidentiality: This communication is intended for the above-named person and may be confidential and/or legally privileged. Any opinions expressed in this communication are not necessarily those of the company. If it has come to you in error you must take no action based on it, nor must you copy or show it to anyone; please delete/destroy and inform the sender immediately. Monitoring/Viruses Orange may monitor all incoming and outgoing emails in line with current legislation. Although we have taken steps to ensure that this email and attachments are free from any virus, we advise that in keeping with good computing practice the receipient should ensure they are actually virus free. Orange PCS Limited is a subsidiary of Orange SA and is registered in England No 2178917, with its address at St James Court, Great Park Road, Almondsbury Park, Bradley Stoke, Bristol BS32 4QJ. *******************************************************************************
