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.


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/


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