This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: Can't use DBI and mod_perl together in Cygwin.


Apache isn't running as a service and other than this TCP error, works flawlessly.

Using the IP address gives the same error.

JP wrote:

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@cygwin.com [mailto:cygwin-owner@cygwin.com] On Behalf
Of kurt heston
Sent: Friday, December 17, 2004 10:29 AM
To: cygwin@cygwin.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/


-- 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/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]