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

Re: [GENERAL] Auth problem in pg_hdba.conf

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Uros Gruber <uros(at)sir-mag(dot)com>
Cc: PostgreSQL odbc list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [GENERAL] Auth problem in pg_hdba.conf
Date: 2002-04-26 20:30:17
Message-ID: 200204262030.g3QKUH613896@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Can some ODBC person comment on this?  He says md5 authentication isn't
working in pgadmin.  Thanks.

---------------------------------------------------------------------------

Uros Gruber wrote:
> Hi,
> 
> I didn't install any odbc, because on pgadmin page says that
> i don't needed because its in operating system. I use WinXPa
> and it also write at begining that there is version 7.1.9.
> 
> 
> -- 
> lp,
>  Uros                            mailto:uros(dot)gruber(at)sir-mag(dot)com
> 
> 
> Friday, April 26, 2002, 4:29:28 AM, you wrote:
> 
> 
> BM> Interesting.  Does PGAdminII use ODBC that comes with 7.2?  That is the
> BM> only one that can do md5 passwords.
> 
> BM> Other than that, I am not sure what else to test.  I know ODBC 7.2 users
> BM> have used md5 and it works for them.
> 
> BM> ---------------------------------------------------------------------------
> 
> BM> Uros Gruber wrote:
> >> Hi!
> >> 
> >> I wan't to use md5 passwords so i set in pg_hba.conf
> >>   
> >> 
> >> host      all         0.0.0.0       0.0.0.0            md5
> >> 
> >> Then i add some users with PGAdminII and when i check in
> >> pg_shadow there were md5 hashes like this
> >> 
> >> md5053b5de16e........................
> >> 
> >> When i try to connect with that user it failed with error
> >> wrong password.
> >> 
> >> I have enableb in pgadmin use encrypted pass when possible.
> >> I also try to connect from console and i have the same error.
> >> 
> >> The i write in pg_shadow plain text passwords and now it
> >> works.
> >> 
> >> I wan't to know why md5 does not work or what i did wrong.
> >> 
> >> Is there any option to tell pgsql to use md5
> >> 
> >> i use postgresql 7.2
> >> 
> >> -- 
> >> tia,
> >>  Uros                          mailto:uros(at)sir-mag(dot)com
> >> 
> >> 
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 5: Have you checked our extensive FAQ?
> >> 
> >> http://www.postgresql.org/users-lounge/docs/faq.html
> >> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-04-27 23:05:02
Subject: Re: [GENERAL] Auth problem in pg_hdba.conf
Previous:From: Henshall, Stuart - WCPDate: 2002-04-26 08:15:33
Subject: Re: WindowsNT to PSQL(Linux) over SSH

pgsql-general by date

Next:From: Hillensbeck, PrestonDate: 2002-04-26 20:49:49
Subject: Re: delete column
Previous:From: Tom LaneDate: 2002-04-26 18:46:32
Subject: Re: icps, shmmax and shmall - Shared Memory tuning

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