Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , 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: <41C31073.1010003@delanobay.com> Date: Fri, 17 Dec 2004 08:59:31 -0800 From: kurt heston 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: <200412171644 DOT iBHGicdD021428 AT olympus DOT tcs DOT tulane DOT edu> In-Reply-To: <200412171644.iBHGicdD021428@olympus.tcs.tulane.edu> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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 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" >>> >>>
>>>#!/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";
>>>
>>> >>>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/