Can't use DBI and mod_perl together in Cygwin.

kurt heston kheston@delanobay.com
Fri Dec 17 17:00:00 GMT 2004


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 "<html><head><pre>\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 "</pre></head></html>\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/



More information about the Cygwin mailing list