Re: perl/dbi Can't create TCP/IP socket

public inbox for cygwin@cygwin.com
 help / color / mirror / Atom feed

* Re: perl/dbi Can't create TCP/IP socket
@ 2001-09-25  2:25 dk henderson
  2001-09-25 10:47 ` Michael Hoffman
  0 siblings, 1 reply; 14+ messages in thread
From: dk henderson @ 2001-09-25  2:25 UTC (permalink / raw)
  To: Michael Hoffman; +Cc: cygwin

I tried a cgi ftp client and it failed to connect to any hosts as well. Of course,
http works!


9/25/01 4:27:19 AM, Michael Hoffman <grouse@mail.utexas.edu> wrote:

>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"?

referring to dbi and apache

>
>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 >.
>
see at bottom for version outputs


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


perl -V 
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
    osname=cygwin, osvers=1.3.2(0.3932), archname=cygwin-multi
    uname='cygwin_nt-4.0 loreley 1.3.2(0.3932) 2001-05-20 23:28 i686 unknown '
    config_args='-de -Dusemultiplicity'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=define
    useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
    cc='gcc', ccflags ='-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include',
    optimize='-O2',
    cppflags='-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include'
    ccversion='', gccversion='2.95.3-5 (cygwin special)', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4
    alignbytes=8, usemymalloc=y, prototype=define
  Linker and Libraries:
    ld='ld2', ldflags =' -s -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib /lib
    libs=-lgdbm -lcrypt
    perllibs=-lcrypt
    libc=/usr/lib/libc.a, so=dll, useshrplib=true, libperl=libperl5_6_1.a
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' -s'
    cccdlflags=' ', lddlflags=' -s -L/usr/local/lib'


Characteristics of this binary (from libperl): 
  Compile-time options: MULTIPLICITY USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
  Built under cygwin
  Compiled at Aug 22 2001 01:05:05
  @INC:
    /usr/lib/perl5/5.6.1/cygwin-multi
    /usr/lib/perl5/5.6.1
    /usr/lib/perl5/site_perl/5.6.1/cygwin-multi
    /usr/lib/perl5/site_perl/5.6.1
    /usr/lib/perl5/site_perl
    .


Cygnus Win95/NT Configuration Diagnostics
Current System Time: Tue Sep 25 06:19:32 2001

Win95 Ver 4.0 build 67109975  B

Path:	/usr/local/bin
	/usr/bin
	/bin
	/cygdrive/c/WINDOWS
	/cygdrive/c/WINDOWS/COMMAND
	/cygdrive/c/PERL/BIN
	/cygdrive/c/PROGRAM FILES/MTS

SysDir: C:\WINDOWS\SYSTEM
WinDir: C:\WINDOWS

PWD = `/usr/edrive/src'
LD_LIBRARY_PATH = `/usr/local/lib:/lib:/usr/lib'
MAKE_MODE = `unix'
HOME = `/home/projectobjects'

PROMPT = `$p$g'
DBI_PASS = `newman'
DBI_DSN = `dbi:Pg'
POSTGRES_INCLUDE = `/usr/include/postgresql'
COMSPEC = `C:\WINDOWS\COMMAND.COM'
!C: = `C:\WINDOWS'
CMDLINE = `bash --login -i'
HOSTNAME = `PROJECTOBJECTS'
!D: = `D:\cygwin\bin'
WINDIR = `C:\WINDOWS'
WINBOOTDIR = `C:\WINDOWS'
PS1 = `\[\033]0;\w\007
\033[32m\]\u@\h \[\033[33m\w\033[0m\]
$ '
ODBCHOME = `/usr/local'
DBI_USER = `projectobjects'
MACHTYPE = `i686-pc-cygwin'
POSTGRES_LIB = `/usr/lib'
TEMP = `/cygdrive/c/WINDOWS/TEMP'
SHLVL = `1'
SHELL = `/bin/bash'
HOSTTYPE = `i686'
OSTYPE = `cygwin'
TERM = `cygwin'
PGDATA = `/usr/share/postgresql/data'
_ = `/usr/bin/cygcheck'
OLDPWD = `/usr/edrive/local/apache/cgi-bin/ftp'
TZ = `EST5EDT4,M4.1.2/0,M10.5.0/0'

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\&Programs\Cygnus Solutions
  (default) = (unsupported type)
HKEY_CURRENT_USER\Software\Cygnus Solutions
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2
  (default) = `/cygdrive'
  cygdrive flags = 0x00000022
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2\/usr/edrive
  (default) = `e:\cygwin'
  flags = 0x00000000
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/
  (default) = `D:/cygwin'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin
  (default) = `D:/cygwin/bin'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib
  (default) = `D:/cygwin/lib'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\00
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\01
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\02
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\03
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\04
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\05
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\06
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\07
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\08
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\09
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0A
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0B
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0C
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0D
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0E
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\0F
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\10
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\11
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\12
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\13
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\14
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\15
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\16
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\17
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\18
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\19
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\1A
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\1B
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\1C
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts\1D

a:  fd           N/A    N/A                    
c:  hd  FAT     1372Mb  99% CP    UN           DRIVE0VOL00
d:  hd  FAT      999Mb  99% CP    UN           APPS
e:  hd  FAT      547Mb  87% CP    UN           

D:\cygwin\bin  /usr/bin  system  binmode
D:\cygwin\lib  /usr/lib  system  binmode
D:\cygwin  /        system  binmode
e:\cygwin  /usr/edrive  user    textmode
c:    /cygdrive/c  user    binmode,noumount
d:    /cygdrive/d  user    binmode,noumount
e:    /cygdrive/e  user    binmode,noumount

Found: D:\cygwin\bin\bash.exe
Found: D:\cygwin\bin\cat.exe
Found: D:\cygwin\bin\cpp.exe
Found: D:\cygwin\bin\find.exe
Found: c:\WINDOWS\COMMAND\find.exe
Warning: D:\cygwin\bin\find.exe hides c:\WINDOWS\COMMAND\find.exe
Found: D:\cygwin\bin\gcc.exe
Found: D:\cygwin\bin\gdb.exe
Found: D:\cygwin\bin\ld.exe
Found: D:\cygwin\bin\ls.exe
Found: D:\cygwin\bin\make.exe
Found: D:\cygwin\bin\sh.exe

   56k 2000/12/02 D:\cygwin\bin\cygbz21.0.dll - os=4.0 img=1.0 sys=4.0
                  "cygbz21.0.dll" v0.0 ts=2000/11/20 18:53
   81k 2001/04/28 D:\cygwin\bin\cygitcl30.dll - os=4.0 img=1.0 sys=4.0
                  "cygitcl30.dll" v0.0 ts=2001/4/28 18:57
   35k 2001/04/28 D:\cygwin\bin\cygitk30.dll - os=4.0 img=1.0 sys=4.0
                  "cygitk30.dll" v0.0 ts=2001/4/28 18:57
  390k 2001/04/28 D:\cygwin\bin\cygtcl80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtcl80.dll" v0.0 ts=2001/4/28 18:56
    5k 2001/04/28 D:\cygwin\bin\cygtclpip80.dll - os=4.0 img=1.0 sys=4.0
   10k 2001/04/28 D:\cygwin\bin\cygtclreg80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtclreg80.dll" v0.0 ts=2001/4/28 18:56
  623k 2001/04/28 D:\cygwin\bin\cygtk80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtk80.dll" v0.0 ts=2001/4/28 18:57
   18k 2000/10/22 D:\cygwin\bin\cyggdbm.dll - os=4.0 img=1.0 sys=4.0
                  "cyggdbm.dll" v0.0 ts=2000/10/22 22:26
   21k 2001/06/20 D:\cygwin\bin\cygintl.dll - os=4.0 img=1.0 sys=4.0
                  "cygintl.dll" v0.0 ts=2001/6/20 13:09
   45k 2001/07/04 D:\cygwin\bin\cygjbig1.dll - os=4.0 img=1.0 sys=4.0
                  "cygjbig1.dll" v0.0 ts=2001/7/3 23:25
  119k 2001/06/06 D:\cygwin\bin\cygjpeg6b.dll - os=4.0 img=1.0 sys=4.0
                  "cygjpeg6b.dll" v0.0 ts=2001/6/6 0:27
   45k 2001/04/25 D:\cygwin\bin\cygform5.dll - os=4.0 img=1.0 sys=4.0
                  "cygform5.dll" v0.0 ts=2001/4/25 1:28
   26k 2001/04/25 D:\cygwin\bin\cygmenu5.dll - os=4.0 img=1.0 sys=4.0
                  "cygmenu5.dll" v0.0 ts=2001/4/25 1:27
  156k 2001/04/25 D:\cygwin\bin\cygncurses++5.dll - os=4.0 img=1.0 sys=4.0
                  "cygncurses++5.dll" v0.0 ts=2001/4/25 1:29
  226k 2001/04/25 D:\cygwin\bin\cygncurses5.dll - os=4.0 img=1.0 sys=4.0
                  "cygncurses5.dll" v0.0 ts=2001/4/25 1:17
   15k 2001/04/25 D:\cygwin\bin\cygpanel5.dll - os=4.0 img=1.0 sys=4.0
                  "cygpanel5.dll" v0.0 ts=2001/4/25 1:27
   17k 2001/06/28 D:\cygwin\bin\cyghistory4.dll - os=4.0 img=1.0 sys=4.0
                  "cyghistory4.dll" v0.0 ts=2001/1/6 23:34
   21k 2001/06/28 D:\cygwin\bin\cyghistory5.dll - os=4.0 img=1.0 sys=4.0
                  "cyghistory5.dll" v0.0 ts=2001/6/27 22:27
  108k 2001/06/28 D:\cygwin\bin\cygreadline4.dll - os=4.0 img=1.0 sys=4.0
                  "cygreadline4.dll" v0.0 ts=2001/1/6 23:34
  135k 2001/06/28 D:\cygwin\bin\cygreadline5.dll - os=4.0 img=1.0 sys=4.0
                  "cygreadline5.dll" v0.0 ts=2001/6/27 22:27
  245k 2001/06/12 D:\cygwin\bin\cygtiff3.dll - os=4.0 img=1.0 sys=4.0
                  "cygtiff3.dll" v0.0 ts=2001/6/12 13:25
   41k 2001/07/04 D:\cygwin\bin\cygXpm-noX4.dll - os=4.0 img=1.0 sys=4.0
                  "cygXpm-noX4.dll" v0.0 ts=2001/7/3 21:21
   45k 2001/07/04 D:\cygwin\bin\cygXpm-X4.dll - os=4.0 img=1.0 sys=4.0
                  "cygXpm-X4.dll" v0.0 ts=2000/11/19 21:45
   49k 2001/02/03 D:\cygwin\bin\cygz.dll - os=4.0 img=1.0 sys=4.0
                  "cygz.dll" v0.0 ts=2001/2/3 15:35
  365k 2000/10/24 D:\cygwin\bin\cygdb3.dll - os=4.0 img=1.0 sys=4.0
                  "cygdb3.dll" v0.0 ts=2000/10/24 0:21
  463k 2000/10/24 D:\cygwin\bin\cygdb_cxx3.dll - os=4.0 img=1.0 sys=4.0
                  "cygdb_cxx3.dll" v0.0 ts=2000/10/24 0:22
  611k 2001/01/27 D:\cygwin\bin\cygwinb19.dll - os=4.0 img=1.0 sys=4.0
                  "cygwin1.dll" v0.0 ts=2000/12/25 12:39
  163k 2001/05/06 D:\cygwin\bin\cygpng2.dll - os=4.0 img=1.0 sys=4.0
                  "cygpng2.dll" v0.0 ts=2001/5/6 0:05
  615k 2001/01/31 D:\cygwin\bin\cygwin1_old.dll - os=4.0 img=1.0 sys=4.0
                  "cygwin1.dll" v0.0 ts=2001/1/31 10:08
  701k 2001/09/13 D:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
                  "cygwin1.dll" v0.0 ts=2001/9/12 23:54
    Cygwin DLL version info:
        dll major: 1003
        dll minor: 3
        dll epoch: 19
        dll bad signal mask: 19005
        dll old termios: 5
        dll malloc env: 28
        api major: 0
        api minor: 46
        shared data: 3
        dll identifier: cygwin1
        mount registry: 2
        cygnus registry name: Cygnus Solutions
        cygwin registry name: Cygwin
        program options name: Program Options
        cygwin mount registry name: mounts v2
        cygdrive flags: cygdrive flags
        cygdrive prefix: cygdrive prefix
        cygdrive default prefix: 
        build date: Wed Sep 12 23:54:31 EDT 2001
        shared id: cygwin1S3

Use -h to see help about each section




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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-25  2:25 perl/dbi Can't create TCP/IP socket dk henderson
@ 2001-09-25 10:47 ` Michael Hoffman
  2001-09-26  2:30   ` yahoo
  0 siblings, 1 reply; 14+ messages in thread
From: Michael Hoffman @ 2001-09-25 10:47 UTC (permalink / raw)
  To: Dale Henderson; +Cc: cygwin

On Tue, 25 Sep 2001, dk henderson wrote:

> I tried a cgi ftp client and it failed to connect to any hosts as
> well. Of course, http works!

Please try to be more precise. I am having difficulty understanding
what you mean and this makes it hard to help you.

When you say you tried a CGI FTP client, are you talking about using
Net::FTP from a perl script? What is the error message?

When you say HTTP works, do you mean that you can activate a script
through CGI that will then get information from somewhere else via
HTTP (I assume with LWP)?

If you can use LWP, but not Net::FTP or DBI, that is very strange.

> >> Not really sure how they interface and would appreciate any
> >> pointers.
> 
> referring to dbi and apache

DBI and Apache shouldn't have any interface. Apache calls on perl
which deals with DBI.

> perl -V 

Looks good.

> Cygnus Win95/NT Configuration Diagnostics
> Current System Time: Tue Sep 25 06:19:32 2001
> 
> Win95 Ver 4.0 build 67109975  B
> 
> Path:	/usr/local/bin
> 	/usr/bin
> 	/bin
> 	/cygdrive/c/WINDOWS
> 	/cygdrive/c/WINDOWS/COMMAND
> 	/cygdrive/c/PERL/BIN
> 	/cygdrive/c/PROGRAM FILES/MTS

What is in C:\Perl\Bin? Is this ActiveState?

> D:\cygwin\bin  /usr/bin  system  binmode
> D:\cygwin\lib  /usr/lib  system  binmode
> D:\cygwin  /        system  binmode
> e:\cygwin  /usr/edrive  user    textmode
> c:    /cygdrive/c  user    binmode,noumount
> d:    /cygdrive/d  user    binmode,noumount
> e:    /cygdrive/e  user    binmode,noumount

What is this "E:\Cygwin"?

>   611k 2001/01/27 D:\cygwin\bin\cygwinb19.dll - os=4.0 img=1.0 sys=4.0
>                   "cygwin1.dll" v0.0 ts=2000/12/25 12:39
> ...
>   615k 2001/01/31 D:\cygwin\bin\cygwin1_old.dll - os=4.0 img=1.0 sys=4.0
>                   "cygwin1.dll" v0.0 ts=2001/1/31 10:08
>   701k 2001/09/13 D:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
>                   "cygwin1.dll" v0.0 ts=2001/9/12 23:54

Why do you have a cygwinb19.dll and a cygwin1_old.dll hanging around?

Having ActiveState and old versions of the Cygwin DLL lying around are
going to confuse things. Your E:\Cygwin indicates that you might even
have an old version of the rest of Cygwin. 

My advice:

1) Delete and reinstall Cygwin, and don't mount old copies.

2) Take ActiveState out of your path in Cygwin if you want to use
   Cygwin perl.

3) Try to use some kind of Net functionality on your new Cygwin/perl
   installation calling both from Apache and the shell. If it still
   fails, provide the simplest possible testcase.

Good luck.
--
Michael Hoffman <grouse@mail.utexas.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/

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-25 10:47 ` Michael Hoffman
@ 2001-09-26  2:30   ` yahoo
  2001-09-26 14:44     ` Michael Hoffman
  0 siblings, 1 reply; 14+ messages in thread
From: yahoo @ 2001-09-26  2:30 UTC (permalink / raw)
  To: Michael Hoffman; +Cc: cygwin

I removed ASPerl and the older cygwin DLL's.
I ran a small test case for shell and apache.
Here are the two files with the results just below them
cygcheck and perl -V are below


sqltest3.pl
use DBI; # fill in the following variables
$database = "projectobjects";
$host = "www.freesql.org";
$username = "projectobjects";
$password = "newman"; # mysql is the driver that I am using in this case.
You can switch it to say'odbc' or whatever
$dbh = DBI->connect("DBI:mysql:$database:$host:3306", $username, $password);
if (not $dbh) {
  print "you cannot connect to the database";
}
else { print "successful connect"; }
exit;

############################################################################
#############
projectobjects@PROJECTOBJECTS /usr/edrive/src
$ perl sqltest3.pl
successful connect
projectobjects@PROJECTOBJECTS /usr/edrive/src

############################################################################
############
sqltest.cgi
#!/usr/bin/perl

use DBI; # fill in the following variables
$db = "projectobjects";
$db_host = "www.freesql.org";
$username = "projectobjects";
$password = "newman";
$db_port  = "3306";
$data_source = "DBI:mysql:$db:$db_host:$db_port";

print "Content-type: text/html\n\n";
print "<html>\n";
print "<head><title>SQL Test</title></head>\n";
print "<body>\n";

# connects to mysql.
  $dbh = DBI->connect("$data_source", "$username", "$password", { RaiseError
=> 1, PrintError => 1, AutoCommit => 1 });
  if (not $dbh){
      $orig_error = $DBI::errstr;
      if ($DBI::errstr =~ m/(.nknown database)/) { # database specified not
existed
            print "$orig_error";
        }
        elsif (($DBI::errstr =~ m/an't connect to/) || ($DBI::errstr =~
m/Unknown MySQL Server Host/) ) {
            print "$orig_error";
        }
        else { print "connection failed: $DBI::errstr"; }
        print "<\body><\html>";
        exit;
    }
 print "successful connect";
 print "<\body><\html>";

exit;
############################################################################
########
Content-type: text/html

Software error:
DBI->connect(projectobjects:www.freesql.org:3306) failed: Can't create
TCP/IP socket (1) at /usr/edrive/local/apache/cgi-bin/sqltest.cgi line 18

############################################################################
#######

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
  Platform:
    osname=cygwin, osvers=1.3.2(0.3932), archname=cygwin-multi
    uname='cygwin_nt-4.0 loreley 1.3.2(0.3932) 2001-05-20 23:28 i686 unknown
'
    config_args='-de -Dusemultiplicity'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=define
    useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
    cc='gcc', ccflags
='-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include',
    optimize='-O2',



 cppflags='-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include'
    ccversion='', gccversion='2.95.3-5 (cygwin special)', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
    alignbytes=8, usemymalloc=y, prototype=define
  Linker and Libraries:
    ld='ld2', ldflags =' -s -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib /lib
    libs=-lgdbm -lcrypt
    perllibs=-lcrypt
    libc=/usr/lib/libc.a, so=dll, useshrplib=true, libperl=libperl5_6_1.a
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' -s'
    cccdlflags=' ', lddlflags=' -s -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
  Built under cygwin
  Compiled at Aug 22 2001 01:05:05
  @INC:
    /usr/lib/perl5/5.6.1/cygwin-multi
    /usr/lib/perl5/5.6.1
    /usr/lib/perl5/site_perl/5.6.1/cygwin-multi
    /usr/lib/perl5/site_perl/5.6.1
    /usr/lib/perl5/site_perl
    .
############################################################################
########

Cygnus Win95/NT Configuration Diagnostics
Current System Time: Wed Sep 26 06:27:52 2001

Win95 Ver 4.0 build 67109975  B

Path: /usr/local/bin
 /usr/bin
 /bin
 /cygdrive/c/WINDOWS
 /cygdrive/c/WINDOWS/COMMAND
 /cygdrive/c/PROGRAM FILES/MTS

SysDir: C:\WINDOWS\SYSTEM
WinDir: C:\WINDOWS

PWD = `/usr/edrive/src'
LD_LIBRARY_PATH = `/usr/local/lib:/lib:/usr/lib'
MAKE_MODE = `unix'
HOME = `/home/projectobjects'

PROMPT = `$p$g'
DBI_PASS = `newman'
DBI_DSN = `dbi:Pg'
POSTGRES_INCLUDE = `/usr/include/postgresql'
COMSPEC = `C:\WINDOWS\COMMAND.COM'
!C: = `C:\WINDOWS'
CMDLINE = `bash --login -i'
HOSTNAME = `PROJECTOBJECTS'
!D: = `D:\cygwin\bin'
!E: = `E:\cygwin\src\soupermail'
WINDIR = `C:\WINDOWS'
WINBOOTDIR = `C:\WINDOWS'
PS1 = `\[\033]0;\w\007
\033[32m\]\u@\h \[\033[33m\w\033[0m\]
$ '
ODBCHOME = `/usr/local'
DBI_USER = `projectobjects'
MACHTYPE = `i686-pc-cygwin'
POSTGRES_LIB = `/usr/lib'
TEMP = `/cygdrive/c/WINDOWS/TEMP'
SHLVL = `1'
SHELL = `/bin/bash'
HOSTTYPE = `i686'
OSTYPE = `cygwin'
TERM = `cygwin'
PGDATA = `/usr/share/postgresql/data'
_ = `/usr/bin/cygcheck'
OLDPWD = `/home/projectobjects'
TZ = `EST5EDT4,M4.1.2/0,M10.5.0/0'

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\MenuOrd
er\Start Menu\&Programs\Cygnus Solutions
  (default) = (unsupported type)
HKEY_CURRENT_USER\Software\Cygnus Solutions
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2
  (default) = `/cygdrive'
  cygdrive flags = 0x00000022
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2\/usr/edrive
  (default) = `e:\cygwin'
  flags = 0x00000000
HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/
  (default) = `D:/cygwin'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin
  (default) = `D:/cygwin/bin'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib
  (default) = `D:/cygwin/lib'
  flags = 0x0000000a
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL setup\b15.0\mounts
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\00
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\01
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\02
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\03
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\04
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\05
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\06
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\07
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\08
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\09
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0A
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0B
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0C
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0D
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0E
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\0F
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\10
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\11
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\12
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\13
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\14
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\15
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\16
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\17
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\18
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\19
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\1A
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\1B
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\1C
HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\CYGWIN.DLL
setup\b15.0\mounts\1D

a:  fd           N/A    N/A
c:  hd  FAT     1372Mb  98% CP    UN           DRIVE0VOL00
d:  hd  FAT      999Mb  99% CP    UN           APPS
e:  hd  FAT      547Mb  89% CP    UN

D:\cygwin\bin  /usr/bin  system  binmode
D:\cygwin\lib  /usr/lib  system  binmode
D:\cygwin  /        system  binmode
e:\cygwin  /usr/edrive  user    textmode
c:    /cygdrive/c  user    binmode,noumount
d:    /cygdrive/d  user    binmode,noumount
e:    /cygdrive/e  user    binmode,noumount

Found: D:\cygwin\bin\bash.exe
Found: D:\cygwin\bin\cat.exe
Found: D:\cygwin\bin\cpp.exe
Found: D:\cygwin\bin\find.exe
Found: c:\WINDOWS\COMMAND\find.exe
Warning: D:\cygwin\bin\find.exe hides c:\WINDOWS\COMMAND\find.exe
Found: D:\cygwin\bin\gcc.exe
Found: D:\cygwin\bin\gdb.exe
Found: D:\cygwin\bin\ld.exe
Found: D:\cygwin\bin\ls.exe
Found: D:\cygwin\bin\make.exe
Found: D:\cygwin\bin\sh.exe

   56k 2000/12/02 D:\cygwin\bin\cygbz21.0.dll - os=4.0 img=1.0 sys=4.0
                  "cygbz21.0.dll" v0.0 ts=2000/11/20 18:53
   81k 2001/04/28 D:\cygwin\bin\cygitcl30.dll - os=4.0 img=1.0 sys=4.0
                  "cygitcl30.dll" v0.0 ts=2001/4/28 18:57
   35k 2001/04/28 D:\cygwin\bin\cygitk30.dll - os=4.0 img=1.0 sys=4.0
                  "cygitk30.dll" v0.0 ts=2001/4/28 18:57
  390k 2001/04/28 D:\cygwin\bin\cygtcl80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtcl80.dll" v0.0 ts=2001/4/28 18:56
    5k 2001/04/28 D:\cygwin\bin\cygtclpip80.dll - os=4.0 img=1.0 sys=4.0
   10k 2001/04/28 D:\cygwin\bin\cygtclreg80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtclreg80.dll" v0.0 ts=2001/4/28 18:56
  623k 2001/04/28 D:\cygwin\bin\cygtk80.dll - os=4.0 img=1.0 sys=4.0
                  "cygtk80.dll" v0.0 ts=2001/4/28 18:57
   18k 2000/10/22 D:\cygwin\bin\cyggdbm.dll - os=4.0 img=1.0 sys=4.0
                  "cyggdbm.dll" v0.0 ts=2000/10/22 22:26
   21k 2001/06/20 D:\cygwin\bin\cygintl.dll - os=4.0 img=1.0 sys=4.0
                  "cygintl.dll" v0.0 ts=2001/6/20 13:09
   45k 2001/07/04 D:\cygwin\bin\cygjbig1.dll - os=4.0 img=1.0 sys=4.0
                  "cygjbig1.dll" v0.0 ts=2001/7/3 23:25
  119k 2001/06/06 D:\cygwin\bin\cygjpeg6b.dll - os=4.0 img=1.0 sys=4.0
                  "cygjpeg6b.dll" v0.0 ts=2001/6/6 0:27
   45k 2001/04/25 D:\cygwin\bin\cygform5.dll - os=4.0 img=1.0 sys=4.0
                  "cygform5.dll" v0.0 ts=2001/4/25 1:28
   26k 2001/04/25 D:\cygwin\bin\cygmenu5.dll - os=4.0 img=1.0 sys=4.0
                  "cygmenu5.dll" v0.0 ts=2001/4/25 1:27
  156k 2001/04/25 D:\cygwin\bin\cygncurses++5.dll - os=4.0 img=1.0 sys=4.0
                  "cygncurses++5.dll" v0.0 ts=2001/4/25 1:29
  226k 2001/04/25 D:\cygwin\bin\cygncurses5.dll - os=4.0 img=1.0 sys=4.0
                  "cygncurses5.dll" v0.0 ts=2001/4/25 1:17
   15k 2001/04/25 D:\cygwin\bin\cygpanel5.dll - os=4.0 img=1.0 sys=4.0
                  "cygpanel5.dll" v0.0 ts=2001/4/25 1:27
   17k 2001/06/28 D:\cygwin\bin\cyghistory4.dll - os=4.0 img=1.0 sys=4.0
                  "cyghistory4.dll" v0.0 ts=2001/1/6 23:34
   21k 2001/06/28 D:\cygwin\bin\cyghistory5.dll - os=4.0 img=1.0 sys=4.0
                  "cyghistory5.dll" v0.0 ts=2001/6/27 22:27
  108k 2001/06/28 D:\cygwin\bin\cygreadline4.dll - os=4.0 img=1.0 sys=4.0
                  "cygreadline4.dll" v0.0 ts=2001/1/6 23:34
  135k 2001/06/28 D:\cygwin\bin\cygreadline5.dll - os=4.0 img=1.0 sys=4.0
                  "cygreadline5.dll" v0.0 ts=2001/6/27 22:27
  245k 2001/06/12 D:\cygwin\bin\cygtiff3.dll - os=4.0 img=1.0 sys=4.0
                  "cygtiff3.dll" v0.0 ts=2001/6/12 13:25
   41k 2001/07/04 D:\cygwin\bin\cygXpm-noX4.dll - os=4.0 img=1.0 sys=4.0
                  "cygXpm-noX4.dll" v0.0 ts=2001/7/3 21:21
   45k 2001/07/04 D:\cygwin\bin\cygXpm-X4.dll - os=4.0 img=1.0 sys=4.0
                  "cygXpm-X4.dll" v0.0 ts=2000/11/19 21:45
   49k 2001/02/03 D:\cygwin\bin\cygz.dll - os=4.0 img=1.0 sys=4.0
                  "cygz.dll" v0.0 ts=2001/2/3 15:35
  365k 2000/10/24 D:\cygwin\bin\cygdb3.dll - os=4.0 img=1.0 sys=4.0
                  "cygdb3.dll" v0.0 ts=2000/10/24 0:21
  463k 2000/10/24 D:\cygwin\bin\cygdb_cxx3.dll - os=4.0 img=1.0 sys=4.0
                  "cygdb_cxx3.dll" v0.0 ts=2000/10/24 0:22
  163k 2001/05/06 D:\cygwin\bin\cygpng2.dll - os=4.0 img=1.0 sys=4.0
                  "cygpng2.dll" v0.0 ts=2001/5/6 0:05
  701k 2001/09/13 D:\cygwin\bin\cygwin1.dll - os=4.0 img=1.0 sys=4.0
                  "cygwin1.dll" v0.0 ts=2001/9/12 23:54
    Cygwin DLL version info:
        dll major: 1003
        dll minor: 3
        dll epoch: 19
        dll bad signal mask: 19005
        dll old termios: 5
        dll malloc env: 28
        api major: 0
        api minor: 46
        shared data: 3
        dll identifier: cygwin1
        mount registry: 2
        cygnus registry name: Cygnus Solutions
        cygwin registry name: Cygwin
        program options name: Program Options
        cygwin mount registry name: mounts v2
        cygdrive flags: cygdrive flags
        cygdrive prefix: cygdrive prefix
        cygdrive default prefix:
        build date: Wed Sep 12 23:54:31 EDT 2001
        shared id: cygwin1S3

Use -h to see help about each section



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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-26  2:30   ` yahoo
@ 2001-09-26 14:44     ` Michael Hoffman
  2001-09-26 18:21       ` yahoo
  2001-09-27  6:03       ` Stipe Tolj
  0 siblings, 2 replies; 14+ messages in thread
From: Michael Hoffman @ 2001-09-26 14:44 UTC (permalink / raw)
  To: Dale Henderson; +Cc: cygwin

On Wed, 26 Sep 2001, yahoo wrote:

I get a successful connect with your test cases, even running under
Apache.

Instead of using two different test cases, why not use the same one? 

$ chmod a+x sqltest.cgi
$ ./sqltest.cgi
(do not use perl sqltest.cgi as that will be different than the
command apache runs)

Also, what are the results of this:

$ which perl
--
Michael Hoffman <grouse@mail.utexas.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/

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-26 14:44     ` Michael Hoffman
@ 2001-09-26 18:21       ` yahoo
  2001-09-27  6:03       ` Stipe Tolj
  1 sibling, 0 replies; 14+ messages in thread
From: yahoo @ 2001-09-26 18:21 UTC (permalink / raw)
  To: Michael Hoffman; +Cc: cygwin

$ which perl
/usr/bin/perl

$ ./sqltest.cgi
Content-type: text/html

<html>
<head><title>SQL Test</title></head>
<body>
successful connect <body><html>

----- Original Message ----- 
From: "Michael Hoffman" <grouse@mail.utexas.edu>
To: "Dale Henderson" <dalehend@yahoo.com>
Cc: <cygwin@cygwin.com>
Sent: Wednesday, September 26, 2001 4:44 PM
Subject: Re: perl/dbi Can't create TCP/IP socket


> On Wed, 26 Sep 2001, yahoo wrote:
> 
> I get a successful connect with your test cases, even running under
> Apache.
> 
> Instead of using two different test cases, why not use the same one? 
> 
> $ chmod a+x sqltest.cgi
> $ ./sqltest.cgi
> (do not use perl sqltest.cgi as that will be different than the
> command apache runs)
> 
> Also, what are the results of this:
> 
> $ which perl
> --
> Michael Hoffman <grouse@mail.utexas.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/

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-26 14:44     ` Michael Hoffman
  2001-09-26 18:21       ` yahoo
@ 2001-09-27  6:03       ` Stipe Tolj
  2001-09-27 18:54         ` Michael Hoffman
  1 sibling, 1 reply; 14+ messages in thread
From: Stipe Tolj @ 2001-09-27  6:03 UTC (permalink / raw)
  To: Michael Hoffman; +Cc: Dale Henderson, cygwin

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1318 bytes --]

Hi,

> I get a successful connect with your test cases, even running under
> Apache.
> 
> Instead of using two different test cases, why not use the same one?
> 
> $ chmod a+x sqltest.cgi
> $ ./sqltest.cgi
> (do not use perl sqltest.cgi as that will be different than the
> command apache runs)

I know what the problem may be.

Dale is running Win9x and it is known (at least reported to me some
time ago) that Apache for Cygwin behaves in some cases strange to
CGIs.

That would explain why Michael has no problems. He's probably running
WinNT4 or Win200?!

I may dig for the proposed patch that has been send to me regarding
this issue. Unfortunatly it did not make it into the port sources,
because I had no Win9x to test against.


Stipe

tolj@wapme-systems.de
-------------------------------------------------------------------
Wapme Systems AG

MÃ¼nsterstr. 248
40470 DÃ¼sseldorf

Tel: +49-211-74845-0
Fax: +49-211-74845-299

E-Mail: info@wapme-systems.de
Internet: http://www.wapme-systems.de
-------------------------------------------------------------------
wapme.net - wherever you are

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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-27  6:03       ` Stipe Tolj
@ 2001-09-27 18:54         ` Michael Hoffman
  0 siblings, 0 replies; 14+ messages in thread
From: Michael Hoffman @ 2001-09-27 18:54 UTC (permalink / raw)
  To: Stipe Tolj; +Cc: Dale Henderson, cygwin

On Thu, 27 Sep 2001, Stipe Tolj wrote:

> Dale is running Win9x and it is known (at least reported to me some
> time ago) that Apache for Cygwin behaves in some cases strange to
> CGIs.
> 
> That would explain why Michael has no problems. He's probably running
> WinNT4 or Win200?!

Yes, I am running Windows 2000.
--
Michael Hoffman <grouse@mail.utexas.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/

^ permalink raw reply	[flat|nested] 14+ messages in thread

* perl/dbi Can't create TCP/IP socket
@ 2001-10-04 16:56 dk henderson
  0 siblings, 0 replies; 14+ messages in thread
From: dk henderson @ 2001-10-04 16:56 UTC (permalink / raw)
  To: cygwin

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.

thanks for any replies,
dale


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

^ permalink raw reply	[flat|nested] 14+ messages in thread

[parent not found: <200109300523.WAA15774@hawk.mail.pas.earthlink.net>]

* Re: perl/dbi Can't create TCP/IP socket
       [not found] <200109300523.WAA15774@hawk.mail.pas.earthlink.net>
@ 2001-09-30  2:09 ` Stipe Tolj
  0 siblings, 0 replies; 14+ messages in thread
From: Stipe Tolj @ 2001-09-30  2:09 UTC (permalink / raw)
  To: dk henderson, cygwin

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1099 bytes --]

Hi,

> Is this bug  listed in the PR database at bugs.apache.org? I could not find
> any reference to cygwin/win9x.

yes it is. The guys who maintain the native Win32 port asked me if the
PR should be closed and I agreed without the need of incorporating the
Win9x specific small patch, due to the fact that we officially only
support WinNT based OS for Cygwin.

I will rewise this decission with the Win32 guys of Apache and
incorporate the patch if it works out for me on my (years old) Win9x
laptop installation.


Stipe

tolj@wapme-systems.de
-------------------------------------------------------------------
Wapme Systems AG

MÃ¼nsterstr. 248
40470 DÃ¼sseldorf

Tel: +49-211-74845-0
Fax: +49-211-74845-299

E-Mail: info@wapme-systems.de
Internet: http://www.wapme-systems.de
-------------------------------------------------------------------
wapme.net - wherever you are

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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
@ 2001-09-25  0:55 dk henderson
  2001-09-25  1:22 ` Michael Hoffman
  0 siblings, 1 reply; 14+ messages in thread
From: dk henderson @ 2001-09-25  0:55 UTC (permalink / raw)
  To: cygwin

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.

thanks,
dale 

>
>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.
>
>thanks for any replies,
>dale



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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-25  0:55 dk henderson
@ 2001-09-25  1:22 ` Michael Hoffman
  0 siblings, 0 replies; 14+ messages in thread
From: Michael Hoffman @ 2001-09-25  1:22 UTC (permalink / raw)
  To: Dale Henderson; +Cc: cygwin

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@mail.utexas.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/

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
@ 2001-09-22 15:49 yahoo
  0 siblings, 0 replies; 14+ messages in thread
From: yahoo @ 2001-09-22 15:49 UTC (permalink / raw)
  To: cygwin

 Yes it is 1.3.20 running on latest cygwin...

> >>Sorry, I cannot help much with this.  Looks more l>>ike an Apache =
> problem
> t>>han s.th. with cygwin.  Is the Apache running on >>cygwin, too?
>
> >
> >I can connect to a remote mysql server via the mysql client at a=20
> >cygwin shell prompt, but when I try from the localhost browser running
> >apache 1.3.20, I get the above error msg.=20
> >
> > $dbh =3D DBI->connect("$data_source", "$username", "$password",=20
> >{ RaiseError =3D> 1, PrintError =3D> 1, AutoCommit =3D> 1 });
> >where $data_source =3D 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.
> >
> >thanks for any replies,
> >dale
>
>
> Gerrit
>
>
>
> ------=_NextPart_000_0007_01C14396.57D4BE00
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial>Yes it is 1.3.20 running on latest =
> cygwin...</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial>&gt;&gt;Sorry, I cannot help much with =
> this.&nbsp; Looks=20
> more l&gt;&gt;ike an Apache problem<BR>t&gt;&gt;han s.th. with =
> cygwin.&nbsp; Is=20
> the Apache running on &gt;&gt;cygwin, too?<BR></DIV></FONT>
> <DIV><FONT face=3DArial>&gt;<BR>&gt;I can connect to a remote mysql =
> server via the=20
> mysql client at a <BR>&gt;cygwin shell prompt, but when I try from the =
> localhost=20
> browser running<BR>&gt;apache 1.3.20, I get the above error msg.=20
> <BR>&gt;<BR>&gt; $dbh =3D DBI-&gt;connect("$data_source", "$username",=20
> "$password", <BR>&gt;{ RaiseError =3D&gt; 1, PrintError =3D&gt; 1, =
> AutoCommit =3D&gt;=20
> 1 });<BR>&gt;where $data_source =3D DBI:mysql:&lt;database=20
> name&gt;:www.freesql.org:3306<BR>&gt;<BR>&gt;and &lt;database name&gt; =
> is&nbsp;=20
> a plain text name<BR>&gt;<BR>&gt;Is there any explanation for=20
> this?<BR>&gt;<BR>&gt;the apache httpd.conf has the same User as =
> $username in=20
> $dbh value.<BR>&gt;<BR>&gt;thanks for any=20
> replies,<BR>&gt;dale<BR><BR><BR>Gerrit<BR><BR></DIV></FONT></BODY></HTML>=
>
>
> ------=_NextPart_000_0007_01C14396.57D4BE00--


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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* perl/dbi Can't create TCP/IP socket
@ 2001-09-22  3:51 dk henderson
  2001-09-22  8:07 ` Gerrit P. Haase
  0 siblings, 1 reply; 14+ messages in thread
From: dk henderson @ 2001-09-22  3:51 UTC (permalink / raw)
  To: cygwin

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.

thanks for any replies,
dale


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

^ permalink raw reply	[flat|nested] 14+ messages in thread

* Re: perl/dbi Can't create TCP/IP socket
  2001-09-22  3:51 dk henderson
@ 2001-09-22  8:07 ` Gerrit P. Haase
  0 siblings, 0 replies; 14+ messages in thread
From: Gerrit P. Haase @ 2001-09-22  8:07 UTC (permalink / raw)
  To: dk henderson, cygwin

dk henderson schrieb am 2001-09-22, 7:50:

>
>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.
>
>thanks for any replies,
>dale

Sorry, I cannot help much with this.  Looks more like an Apache problem
than s.th. with cygwin.  Is the Apache running on cygwin, too?

Gerrit


-- 
=^..^=

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

^ permalink raw reply	[flat|nested] 14+ messages in thread

end of thread, other threads:[~2001-10-04 16:56 UTC | newest]

Thread overview: 14+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2001-09-25  2:25 perl/dbi Can't create TCP/IP socket dk henderson
2001-09-25 10:47 ` Michael Hoffman
2001-09-26  2:30   ` yahoo
2001-09-26 14:44     ` Michael Hoffman
2001-09-26 18:21       ` yahoo
2001-09-27  6:03       ` Stipe Tolj
2001-09-27 18:54         ` Michael Hoffman
  -- strict thread matches above, loose matches on Subject: below --
2001-10-04 16:56 dk henderson
     [not found] <200109300523.WAA15774@hawk.mail.pas.earthlink.net>
2001-09-30  2:09 ` Stipe Tolj
2001-09-25  0:55 dk henderson
2001-09-25  1:22 ` Michael Hoffman
2001-09-22 15:49 yahoo
2001-09-22  3:51 dk henderson
2001-09-22  8:07 ` Gerrit P. Haase

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).