Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/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: <200412171644.iBHGicdD021428@olympus.tcs.tulane.edu>
Reply-To: <jp AT tulane DOT edu>
From: "JP" <jp AT tulane DOT edu>
To: <cygwin AT cygwin DOT com>
Subject: RE: Can't use DBI and mod_perl together in Cygwin.
Date: Fri, 17 Dec 2004 10:44:38 -0600
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <41C30969.4090109@delanobay.com>
X-DCC-Tulane-Metrics: olympus 1000; IP=2 Body=1 Fuz1=1 Fuz2=1
X-IsSubscribed: yes

For the host field, are you using a hostname or the IP address?  If you're
using the hostname, try using the IP.

JP

> -----Original Message-----
> From: cygwin-owner AT cygwin DOT com [mailto:cygwin-owner AT cygwin DOT com] On Behalf
> Of kurt heston
> Sent: Friday, December 17, 2004 10:29 AM
> To: cygwin AT cygwin DOT com
> Subject: Re: Can't use DBI and mod_perl together in Cygwin.
> 
> Here is a more specific description of the DBI error I'm seeing that has
> me checking out the TCP/IP stack:
> 
> 
> DBI connect('','uid/pass@(DESCRIPTION=
>      (ADDRESS=(PROTOCOL=TCP)(HOST=$host)(PORT=1521))
>      (CONNECT_DATA=(SID=$sid)))',...) failed: ORA-12545: Connect failed
> because target host or object does not exist (DBD ERROR:
> OCIServerAttach) at /var/www/htdocs/bin/testperl.pl line 34
> 
> dbi status: ORA-12545: Connect failed because target host or object does
> not exist (DBD ERROR: OCIServerAttach)
> 
> 
> 
> kurt heston wrote:
> 
> > I've traced my problem to the TCP/IP stack.  The code below gives:
> >
> > "Can't get tcp protocol by name at
> > /var/www/htdocs/groups/Purch/bin/secure/test.cgi line 12"
> >
> > <pre>
> > #!/usr/bin/perl
> >
> > use CGI;
> > use Net::Ping;
> >
> > $query = new CGI;
> >
> > print $query->header;
> >
> > print "&lt;html&gt;&lt;head&gt;&lt;pre&gt;\n";
> >
> > $p = Net::Ping->new('tcp');
> > print "$host is alive.\n" if $p->ping("panther2");
> > print "$host is not alive.\n" if !$p->ping("panther2");
> > $p->close();
> >
> > print "&lt;/pre&gt;&lt;/head&gt;&lt;/html&gt;\n";
> > </pre>
> >
> > The DBD code that won't work from within Apache works fine from the
> > command line:
> >
> >   $DBH = DBI-
> >connect("Apache::DBI::Oracle:",q{uid/password@(DESCRIPTION=
> >     (ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1521))
> >     (CONNECT_DATA=(SID=databaseSID)))}, "");
> >
> > When this code is called from within the Apache process (within Cygwin),
> > I invariably get a 12545 error.  Again, the DBI apis work fine from the
> > Cygwin command-line.  I can connect and run queries without issue so
> > long as I don't try it within a CGI script.
> >
> > Pointers?
> >
> >
> > --
> > Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
> > Problem reports:       http://cygwin.com/problems.html
> > Documentation:         http://cygwin.com/docs.html
> > FAQ:                   http://cygwin.com/faq/
> >
> 
> --
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
> Problem reports:       http://cygwin.com/problems.html
> Documentation:         http://cygwin.com/docs.html
> FAQ:                   http://cygwin.com/faq/


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/