Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-cygwinpgsql-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

pgsql-cygwin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group