Re: ident fails on win2k host...

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <rsanford(at)nolimitsystems(dot)com>
Cc: <pgsql-cygwin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: ident fails on win2k host...
Date: 2001-12-03 20:27:28
Message-ID: 61746.193.195.77.162.1007411248.squirrel@ssl.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-general

It's rumoured that Robert J. Sanford, Jr. once said:
> i have set up my win2k box with postgres with 7.1.3 cygwin pre-built. i
> have opened a port in my firewall to allow postgres requests to go
> through. a remote user is attempting to hit the box but is getting an
> ident error. in the admin.pdf doc i find the following about ident
> authentication...
>
> "The ident server on the client host is asked
> for the identity of the connecting user.
> Postgres then verifies whether the so identified
> operating system user is allowed to connect as
> the database user that is requested. This is only
> available for TCP/IP connections. The
> authentication option following the ident keyword
> specifies the name of an ident map that specifies
> which operating system users equate with which
> database users. See below for details."
>
> does ident authentication work under win2k?

I don't believe it does.

> if so, does this mean that i need to add my remote user as a user on my
> win2k machine?
>
> if so, what rights do they need to have? and do i need to configure my
> firewall to allow a different port to be opened up?
>
> if i cannot use ident based authentication under cygwin, how do i allow
> remote users who are using the win32 ODBC driver to connect to the
> database? should i switch to kerberos? if so, which version?
>
> he'p me! he'p me! i been hyp-mo-tized!

The easiest option would be to use password authentication, and add the
user to your PostgreSQL system using CREATE USER xxx WITH PASSWORD 'yyy'.

Regards, Dave.

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Dave Page 2001-12-03 20:37:30 Re: [GENERAL] ident fails on win2k host...
Previous Message Tom Lane 2001-12-03 18:03:08 Re: [GENERAL] ident fails on win2k host...

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2001-12-03 20:37:30 Re: [GENERAL] ident fails on win2k host...
Previous Message Peter Darley 2001-12-03 19:46:29 Re: Installing DBD::Pg module without Pg Database server