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

I am not able to install Oracle DBD on Windows 2000 / Perl 5.8.X behind a proxy server

by Crian (Curate)
on Mar 04, 2004 at 09:41 UTC ( [id://333814]=perlquestion: print w/replies, xml ) Need Help??

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

Dear monks,

I have tried to find a solution for my problem via SuperSearch, but without success. If I missed a thread, please show me the way, but if there is really no thread to this problem, I would be glad to get your help.

The Problem is: I am not able to install the Oracle DBD package on Windows 2000 / Perl 5.8.X behind a proxy server. (With Active Perl 5.6.X it was no problem and it isn't also from home with Perl 5.8.X without a proxy server.)

I can't reach the Active Perl server from within ppm (because of our proxy server), so I tried to download the package and install it from my local computer.

But ppm always tries to establish a connection to ActiveState before doing anything else, so I can't install this package (and probably any other not pure perl package too :-( ) because it always hang.

I tried a lot things, changing DBD-Oracle8.ppd and so on, but without success. Perhaps I could change the file ppm.pm, but I may not have the right to do so and also don't know, how I could do so, so this way seems to be not a good one.

Has anyone a solution to this problem?
  • Comment on I am not able to install Oracle DBD on Windows 2000 / Perl 5.8.X behind a proxy server

Replies are listed 'Best First'.
Re: I am not able to install Oracle DBD on Windows 2000 / Perl 5.8.X behind a proxy server
by crabbdean (Pilgrim) on Mar 04, 2004 at 09:53 UTC
    I hear ya! I had the same problem. You have to set your environment variables for HTTP_proxy and possibly HTTP_proxy_user and HTTP_proxy_pass on your computer. (then possible reboot). Read the ActiveState doco http://aspn.activestate.com/ASPN/PPM/FAQ at the bottom of this page on how to setup PPM3.

    Just be wary if your network is monitored for rogue perlscripts. When running ppm3 your firewall may pick up the attempt for a perl script to send network traffic. If your security manager is as diligent as ours he'll be tapping you on the shoulder within a matter of minutes. If he trusts you then your fine, but you may want to tell him what you are about to do.

    Cheers,
    Dean

    Programming these days takes more than a lone avenger with a compiler. - sam
      ++crabbdean

      Many thanks for that link :-))

      I will report any success here.

      And thanks for your warning too, I will ask our security manager before I will try this.

      Update: I have the permission to try to set these environment variables temporally. So I will try to install the package, but I still have to wait for other processes before I can reboot my computer and try it out.

      I will report later...

      Update2: I tried the shown way this morning out, but it did not work :( ppm still tells me:

      c:\temp>ppm PPM - Programmer's Package Manager version 3.0.1. Copyright (c) 2001 ActiveState SRL. All Rights Reserved. Entering interactive shell. Using Term::ReadLine::Stub as readline lib +rary. Profile tracking is not enabled. If you save and restore profiles manu +ally, your profile may be out of sync with your computer. See 'help profile' + for more information. Type 'help' to get started. ppm> search Oracle Searching in Active Repositories Error: No valid repositories: Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error) at C:/Perl/site/lib/PPM/Repository.pm line 84 Error: 500 Can't connect to ppm-ia.ActiveState.com:80 (connect: Unknown error) at C:/Perl/site/lib/PPM/Repository.pm line 84
      Any further idea what could help?

      Update3: Now it worked so far, that I can search for Modules, but when I try to install I get the message
      ppm> search File-Slurp Searching in Active Repositories 1. File-Slurp [9999.04] Efficient Reading/Writing of Complete + Files 2. File-Slurp [2004.0904] Read and write files with a single co +mmand 3. File-Slurp [9999.01] Efficient Reading/Writing of Complete + Files 4. File-Slurp [9999.02] Efficient Reading/Writing of Complete + Files 5. File-Slurp [9999.04] Efficient Reading/Writing of Complete + Files 6. File-Slurp-Tree [1.22] slurp and emit file trees as nested h +ashes 7. File-Slurp-Tree [1.22] slurp and emit file trees as nested h +ashes ppm> install 1 Package 1: ==================== Install 'File-Slurp' version 9999.04 in ActivePerl 5.8.0.805. ==================== Can't unlink file C:\TEMP/File-Slurp-9999-1456/File-Slurp-9999.04.tar. +gz: Permission denied at C:/Perl/site/lib/PPM/Repository.pm line 239 Can't remove directory C:\TEMP/File-Slurp-9999-1456: Permission denied + at C:/Perl/site/lib/PPM/Repository.pm line 239 Error: error downloading 'http://ppm.ActiveState.com/PPMPackages/5.8-w +i- ndows/MSWin32-x86-multi-thread-5.8/File-Slurp-9999.04.tar.gz': 407 Pro +xy Authentication Required


      So I guess anything is still wrog with my Proxy Authentication (but the variables are set right as far as 'set' tells me).
        Either set the environment variables on the command line (as noted in another reply) before starting PPM, or add them in the "My Computer" properties. When you open a new DOS window, the new environment variables will be in effect.
        My only initial thought here was maybe you have access through the proxy but not to download. Or not permission to where its trying to create the temporary files and directories for install. Smells to me like a permissions problem somewhere along the line.

        I know that's not overly helpful but just my first thoughts from your error messages. Let us know how you go.

        Dean

        Programming these days takes more than a lone avenger with a compiler. - sam
        A Standard for the Transmission of IP Datagrams on Avian Carriers
        You have to set the proxy by http_proxy=http://username:paswd@proxyIP:port install is working fine for me. Sudhir sinha lssudhir@gmail.com
Re: I am not able to install Oracle DBD on Windows 2000 / Perl 5.8.X behind a proxy server
by neniro (Priest) on Mar 04, 2004 at 17:43 UTC
    Hi crian,

    you can try the following (on the w2k command prompt):

    SET HTTP_Proxy=http://192.168.0.x:8080/
    best regards,
    neniro
      Hey, that worked :)

      I suppose I had a typo in my settings by the other way.


      Many thanks at all...

      Update: But I still can not install packages.. (see my other posting above)
Re: I am not able to install Oracle DBD on Windows 2000 / Perl 5.8.X behind a proxy server
by rdfield (Priest) on Mar 04, 2004 at 10:29 UTC
    Activestate don't distribute DBD::Oracle for 5.8, only 5.6. You'll have to google to find someone who can (perhaps make a request to crazyinsomniac/PodMaster).

    rdfield

      Doing a ppm3 search for "oracle" for 5.8 this is what I found. Not sure if any of these modules are useful having not used them:

      1. Class-DBI-Oracle 0.51 Extensions to Class::DBI for Oracle
      2. Class-DBI-Oracle 0.51 Extensions to Class::DBI for Oracle
      3. DBIx-OracleLogin 0.02 takes a string and splits out individual login
      4. DBIx-OracleLogin 0.02 takes a string and splits out individual login
      5. DDL-Oracle 1.11 a DDL generator for Oracle databases
      6. Oracle-Trace 1.06 Perl Module for parsing Oracle Trace files
      7. Oracle-Trace 1.06 Perl Module for parsing Oracle Trace files

      While searching I also came across these, of interest might be Oraperl (???) Oracle Module search

      Dean

      Programming these days takes more than a lone avenger with a compiler. - sam
        Not particularly useful if DBD::Oracle isn't installed and you're trying to use an Oracle database.

        rdfield

      And this is unfortunately why we have to stick with 5.6 on all of our Wintel servers. According to ths post you can get the dbi-oracle ppd here

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2024-04-26 08:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found