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:	<41C30969.4090109@delanobay.com>
Date:	Fri, 17 Dec 2004 08:29:29 -0800
From:	kurt heston <kheston AT delanobay DOT com>
Reply-To:	kheston AT delanobay DOT com
User-Agent:	Mozilla Thunderbird 0.7.2 (Windows/20040707)
MIME-Version:	1.0
To:	cygwin AT cygwin DOT com
Subject:	Re: Can't use DBI and mod_perl together in Cygwin.
References:	<41C304C5 DOT 2030901 AT delanobay DOT com>
In-Reply-To:	<41C304C5.2030901@delanobay.com>

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/

- Raw text -