Thread: IDENT authentication failed for user postgres

IDENT authentication failed for user postgres

From
"G.LeeJohnson"
Date:
Hi,  I have connection established between my windows ( where i am trying
to use pgadmin with pgmigration wizard) and linux and of course a
firewall that I believe is set correctly to allow ports connect (
113according to refusal error in postmaster)...
  I'm wondering if anyone can help me diagnose the error in Subject
line of this post....Ive tried editing both fiewall and pg_hba.conf to
get this working..no dice 

thx anyone
lee
-====





Re: IDENT authentication failed for user postgres

From
Gerhard Häring
Date:
* G.LeeJohnson <info@heartseed.org> [2002-09-27 19:10 -0700]:
> Hi,
>    I have connection established between my windows ( where i am trying
> to use pgadmin with pgmigration wizard) and linux and of course a
> firewall that I believe is set correctly to allow ports connect (
> 113according to refusal error in postmaster)...
> 
>    I'm wondering if anyone can help me diagnose the error in Subject
> line of this post....Ive tried editing both fiewall and pg_hba.conf to
> get this working..no dice 

You obviously can't use ident based authentication from an OS that
doesn't provide the ident service. So you'll have to edit the
pg_hba.conf and enable the md5 authentication mechanism, for example.

Your pg_hba.conf should contain the necessary comments to understand its
format.

HTH,

-- Gerhard


Re: IDENT authentication failed for user postgres

From
Steve Howe
Date:
Hello Gerhard,

Friday, September 27, 2002, 11:40:00 PM, you wrote:

GH> * G.LeeJohnson <info@heartseed.org> [2002-09-27 19:10 -0700]:
>> Hi,
>>    I have connection established between my windows ( where i am trying
>> to use pgadmin with pgmigration wizard) and linux and of course a
>> firewall that I believe is set correctly to allow ports connect (
>> 113according to refusal error in postmaster)...
>> 
>>    I'm wondering if anyone can help me diagnose the error in Subject
>> line of this post....Ive tried editing both fiewall and pg_hba.conf to
>> get this working..no dice 

GH> You obviously can't use ident based authentication from an OS that
GH> doesn't provide the ident service. So you'll have to edit the
Nope.
There are several ident servers for windows - like
http://identd.dyndns.org/identd/.

------------- 
Best regards,Steve Howe                           mailto:howe@carcass.dhs.org



Re: IDENT authentication failed for user postgres

From
Gerhard Häring
Date:
* Steve Howe <howe@carcass.dhs.org> [2002-09-27 23:47 -0300]:
> Nope.
> There are several ident servers for windows - like
> http://identd.dyndns.org/identd/.

Maybe. I'd recommend to the OP to still read the handbook section about
ident-based auth, including the warnings there [1].

-- Gerhard

[1] http://www.postgresql.org/idocs/index.php?auth-methods.html#AEN16445


Re: IDENT authentication failed for user postgres

From
Steve Howe
Date:
Hello Gerhard,

Saturday, September 28, 2002, 12:03:10 AM, you wrote:

GH> * Steve Howe <howe@carcass.dhs.org> [2002-09-27 23:47 -0300]:
>> Nope.
>> There are several ident servers for windows - like
>> http://identd.dyndns.org/identd/.

GH> Maybe. I'd recommend to the OP to still read the handbook section about
GH> ident-based auth, including the warnings there [1].
Not maybe, the ident servers exists.
Your recommendation is worth, however.

------------- 
Best regards,Steve Howe                           mailto:howe@carcass.dhs.org



Re: IDENT authentication failed for user

From
"G.LeeJohnson"
Date:
> There are several ident servers for windows - like
> http://identd.dyndns.org/identd/.
==========

okay thx..i'll check it out and thx..and thx to rec'd to read about
warnings also..;)

thx all
lee
-===
http://www.heartseed.org



Re: IDENT authentication failed for user postgres

From
Gerhard Häring
Date:
* Steve Howe <howe@carcass.dhs.org> [2002-09-27 23:47 -0300]:
> Nope.
> There are several ident servers for windows - like
> http://identd.dyndns.org/identd/.

Maybe. I'd recommend to the OP to still read the handbook section about
ident-based auth, including the warnings there [1].

-- Gerhard

[1] http://www.postgresql.org/idocs/index.php?auth-methods.html#AEN16445