Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <00d501c3004e$ee6a5160$141ea8c0@dm>
From: "Dmitry Melekhov" <dm AT belkam DOT com>
To: "Pierre A. Humblet" <Pierre DOT Humblet AT ieee DOT org>, <cygwin AT cygwin DOT com>
References: <321323244855 DOT 20030410222844 AT familiehaase DOT de> <3E9538B8 DOT 5010107 AT belkam DOT com> <321323244855 DOT 20030410222844 AT familiehaase DOT de> <3 DOT 0 DOT 5 DOT 32 DOT 20030410233114 DOT 007fcc30 AT incoming DOT verizon DOT net> <3E963AF7 DOT 6060101 AT belkam DOT com> <3E96CA54 DOT 35118EA3 AT ieee DOT org> <009201c30048$8cf1ad80$141ea8c0 AT dm> <3E96E558 DOT 9D8E5729 AT ieee DOT org>
Subject: Re: Exim, .forward and DBD::Oracle
Date: Fri, 11 Apr 2003 21:22:28 +0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000


----- Original Message -----
From: "Pierre A. Humblet" <Pierre DOT Humblet AT ieee DOT org>
To: "Dmitry Melekhov" <dm AT belkam DOT com>; <cygwin AT cygwin DOT com>
Sent: Friday, April 11, 2003 7:55 PM
Subject: Re: Exim, .forward and DBD::Oracle


> Dmitry Melekhov wrote:
> >
> > Hello!
> >
> > You are right.
> > Problem is in PATH.
> > If I set PATH _inside_ perl script this doesn't help...
> > I simulated this doing unset PATH in command line
> > and I have the same problem.
> > When I export PATH=/cygdrive/c/oracle/ora81
> > this is enough to load Oracle.dll.
> >
> > Then I tried to setup exim as following, i.e. with PATH
> > $ /bin/cygrunsrv -I exim -p /usr/bin/exim -a "-bd -q15m" -e
> > "PATH=/cygdrive/c/oracle/ora81/bin"
> >
> > Unfortunately, in perl script I still have PATH=/usr/bin
> > and Oracle.dll can't be loaded.
> > Any ideas? Thank you!
>
> Sure Dmitry, as I wrote
> >> see "path" in sections 28.3 and 28.4 of the exim user
> >> guide http://www.exim.org/exim-html-4.10/doc/html/spec.html
>

Oops, sorry!

> What's happening is that for security reasons exim will
> always reset PATH to /usr/bin (default, you can configure it
> to something else) when launching the pipe process.
>
> I don't understand why setting PATH inside the script
> doesn't work, but that's a perl issue and I know nothing
> about perl.

Thank you!

Now I have correct PATH.
But I have another problem :-(
Certanly, this is question for perl experts.
Perl never ends....
I see perl.exe from user tabel runs forever when it is started from
.forward.

If I kill this process last output from it is:
DynaLoader::bootstrap for DBD::Oracle (auto/DBD/Oracle/Oracle.dll)

This is script:

#!/usr/bin/perl
$ENV{ORACLE_HOME}='c:\oracle\ora81';
system ("/usr/bin/env");
use DBI;
$user = "tabel";
$passwd = "";
$host = "oracle.belkam.com";
$sid = "TABEL";
$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);
print "OK";


Certanly, I can successefely run this from .forward on Linux (well, we run
postfix on this machine).

But I need to run it on windows :-(








--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/