Обсуждение: IDENT authentication failed for user postgres
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 -====
* 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
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
* 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
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
> 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
* 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