Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin AT sources DOT redhat DOT com
Date: Tue, 25 Sep 2001 03:27:19 -0500 (Central Daylight Time)
From: Michael Hoffman <grouse AT mail DOT utexas DOT edu>
Subject: Re: perl/dbi Can't create TCP/IP socket
In-reply-to: <200109250754.AAA13255@gull.mail.pas.earthlink.net>
X-X-Sender: grouse AT mail DOT utexas DOT edu
To: Dale Henderson <dalehend AT yahoo DOT com>
Cc: cygwin AT cygwin DOT com
Message-id: <Pine.WNT.4.40.0109250314140.1092-100000@barbecueworld>
MIME-version: 1.0
Content-type: TEXT/PLAIN; charset=US-ASCII

On Tue, 25 Sep 2001, dk henderson wrote:

> I narrowed it down and found that perl/dbi works from the shell
> prompt, but not from cgi. Not really sure how they interface and would
> appreciate any pointers.

Not really sure what that last sentence means. Who are "they"?

I have used perl with DBI, MySQL and Apache before without incident. Can
you open any kind of socket from your CGI script? More information, like
perl -V and cygcheck -s -v -r might be helpful. See
<http://cygwin.com/bugs.html>.

> >I can connect to a remote mysql server via the mysql client at a
> >cygwin shell prompt, but when I try from the localhost browser running
> >apache 1.3.20, I get the above error msg.
> >
> > $dbh = DBI->connect("$data_source", "$username", "$password",
> >{ RaiseError => 1, PrintError => 1, AutoCommit => 1 });
> >where $data_source = DBI:mysql:<database name>:www.freesql.org:3306
> >
> >and <database name> is  a plain text name
> >
> >Is there any explanation for this?
> >
> >the apache httpd.conf has the same User as $username in $dbh value.
-- 
Michael Hoffman <grouse AT mail DOT utexas DOT edu>
The University of Texas at Austin


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/