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:	Sun, 5 Aug 2001 21:11:32 -0400
From:	Jason Tishler <jason AT tishler DOT net>
To:	Markus Hoenicka <Markus DOT Hoenicka AT uth DOT tmc DOT edu>
Cc:	cygwin AT cygwin DOT com
Subject:	Re: postgres connection problem
Message-ID:	<20010805211132.A1564@dothill.com>
Mail-Followup-To:	Markus Hoenicka <Markus DOT Hoenicka AT uth DOT tmc DOT edu>,
	cygwin AT cygwin DOT com
Mime-Version:	1.0
In-Reply-To:	<15208.8759.467000.79427@gargle.gargle.HOWL>
User-Agent:	Mutt/1.3.18i
Organization:	Dot Hill Systems Corp.

Markus,

On Wed, Aug 01, 2001 at 03:37:27PM +0000, Markus Hoenicka wrote:
> So from the "postgres" account I can connect as user "markus" just
> fine. From my "markus" account this results in a refused connection
> unless I use a TCP/IP based connection by providing a
> hostname/IP-address.
> 
> Is this the expected behaviour?

On Wed, Apr 04, 2001 at 10:02:50PM +0400, Egor Duda wrote:
>   this patch prevents local users from connecting to cygwin-emulated
> AF_UNIX socket if this user have no read rights on socket's file.
> it's done by adding 128-bit random secret cookie to !<socket>port
> string in file. later, each processes which is negotiating connection
> via connect() or accept() must signal its peer that it knows this
> secret cookie.

My WAG (without actually trying out the hypothesis) is that user markus
does not have the appropriate permissions to read the Unix domain socket
file that was created by user postgres.

Would you be willing to run the following:

    $ strace -o psql.log psql template1

and report back to the list?

Thanks,
Jason

-- 
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: jason AT tishler DOT net
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

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

- Raw text -