crypt vs password in pg_hba.conf

From: "Robert C(dot) Paulsen Jr(dot)" <robert(at)paulsenonline(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: crypt vs password in pg_hba.conf
Date: 2003-06-14 21:16:34
Message-ID: 20030614211634.GA17464@avalon.paulsen.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just compiled and installed version 7.3.3 and am having a problem with
encrypted logins.

I built it using "--with-openssl" on the .configure command.

All seemed to go OK during the build and install. I created a user with a
password and am able to connect with psql using the password if pg_hba.conf has
a line like this:

host all all 192.168.0.0 255.255.255.0 password

but if I change that line to this:

host all all 192.168.0.0 255.255.255.0 crypt

the connection fails with the message:

psql: FATAL: Password authentication failed for user "robert"

I am pretty sure I don't have the password wrong since I tried redoing it
several times using "ALTER USER".

I am using SuSE Linux 8.0 which comes with postgres 7.2. If I use the stock
SuSE installation I have no problem with encrypted passwords.

ldd `which psql` shows the following:

libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x40017000)
libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40043000)
libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40070000)
libz.so.1 => /lib/libz.so.1 (0x40141000)
libreadline.so.4 => /lib/libreadline.so.4 (0x40150000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4017a000)
libresolv.so.2 => /lib/libresolv.so.2 (0x401ad000)
libnsl.so.1 => /lib/libnsl.so.1 (0x401be000)
libdl.so.2 => /lib/libdl.so.2 (0x401d4000)
libm.so.6 => /lib/libm.so.6 (0x401d9000)
libc.so.6 => /lib/libc.so.6 (0x401fc000)
libncurses.so.5 => /lib/libncurses.so.5 (0x40324000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

This is my first experience with postgres. Can anyone give me a hint?

--
Robert C. Paulsen, Jr.
robert(at)paulsenonline(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jay O'Connor 2003-06-14 21:18:43 Re: full featured alter table?
Previous Message Tino Wildenhain 2003-06-14 21:08:06 Re: full featured alter table?