Auth problem in pg_hdba.conf

Interesting. Does PGAdminII use ODBC that comes with 7.2? That is the
only one that can do md5 passwords.

Other than that, I am not sure what else to test. I know ODBC 7.2 users
have used md5 and it works for them.

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

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@sir-mag.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

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

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.gruber@sir-mag.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 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.gruber@sir-mag.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:

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.gruber@sir-mag.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@sir-mag.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@postgresql.org)

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

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.

Just a confirmation.
Did you use the original password not the above md5053b5de... ?

regards,
Hiroshi Inoue

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

Just a confirmation.
Did you use the original password not the above md5053b5de... ?

Also, is the user using CREATE/ALTER USER to set the password rather
than updating pg_shadow. If they are updating pg_shadow, I assume they
are prepending 'md5' to the string.

Also, does md5 work from psql?

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