Обсуждение: Auth problem in pg_hdba.conf
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
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 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 >>
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 >>