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