problems with non-trust authentication methods in 7.3devel?

From: Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problems with non-trust authentication methods in 7.3devel?
Date: 2002-04-24 11:17:22
Message-ID: 20020424131722.A17373@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Version:
7.3 devel, updated today, 7:00 am warsaw time.

Operating System:
Linux polpot 2.2.20 #1 Sun Mar 17 11:56:15 UTC 2002 i686
Pentium_III_(Coppermine)

Compiler and libraries:
$ ldd work/bin/postmaster | sed 's/^.* => //' | awk '{print $1}' | xargs ls -l
lrwxrwxrwx 1 root root 11 lut 26 11:00 /lib/ld-linux.so.2 -> ld-2.2.5.so
lrwxrwxrwx 1 root root 17 lut 26 11:00 /lib/libcrypt.so.1 -> libcrypt-2.2.5.so
lrwxrwxrwx 1 root root 13 lut 26 11:00 /lib/libc.so.6 -> libc-2.2.5.so
lrwxrwxrwx 1 root root 14 lut 26 11:00 /lib/libdl.so.2 -> libdl-2.2.5.so
lrwxrwxrwx 1 root root 13 lut 26 11:00 /lib/libm.so.6 -> libm-2.2.5.so
lrwxrwxrwx 1 root root 15 lut 26 11:00 /lib/libnsl.so.1 -> libnsl-2.2.5.so
lrwxrwxrwx 1 root root 18 lut 21 10:43 /lib/libreadline.so.4 -> libreadline.so.4.2
lrwxrwxrwx 1 root root 18 lut 26 11:00 /lib/libresolv.so.2 -> libresolv-2.2.5.so
lrwxrwxrwx 1 root root 15 kwi 17 2001 /lib/libtinfo.so.5 -> libtinfo.so.5.2
lrwxrwxrwx 1 root root 13 kwi 3 10:29 /lib/libz.so.1 -> libz.so.1.1.4

$ rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} %{VENDOR}\n" glibc
gcc ncurses zlib readline
glibc-2.2.5-7 PLD
gcc-2.95.4-0.20010823.3 PLD
ncurses-5.2-27 PLD
zlib-1.1.4-2 PLD
readline-4.2a-4 PLD

database admin username:
pgdba

problem:
after setting pgdba's password using:
alter user pgdba with password 'aaa';
or
alter user pgdba with encrypted password 'aaa';
and modifying pg_hba.conf to contain:
local all all xxx
host all all 127.0.0.1 255.255.255.255 xxx

where xxx was "password", "crypt" or "md5" - all tested,
i couldn't stard postmaster.
to start i use this script:

$ cat run.sh
#!/bin/sh
FILEDATE=`/bin/date +"%Y-%m-%d_%H-%M"`
LOGDIR="/home/users/pgdba/Logs/"
LOGFILE=$LOGDIR"/stderr.log-"$FILEDATE".log"
READABLELOG="/home/users/pgdba/stderr.log"
DATADIR='/home/users/pgdba/data/'
/bin/ln -sf $LOGFILE $READABLELOG
pg_ctl start -D "$DATADIR" -w -l "$LOGFILE"

$

upon starting it keeps on asking for password; even if the password was
100% correct:
$ ./run.sh
waiting for postmaster to start....Password:
.Password:
.Password:

logs show this:
$ cat stderr.log-2002-04-24_13-15.log
FATAL: The database system is starting up
LOG: database system was shut down at 2002-04-24 13:15:26 CEST
LOG: checkpoint record is at 0/5A5508
LOG: redo record is at 0/5A5508; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 180; next oid: 16844
LOG: database system is ready
FATAL: Bad abstime external representation '"depesz'
FATAL: Password authentication failed for user "pgdba"
LOG: fast shutdown request
LOG: shutting down
LOG: database system is shut down

interesting part is that it wrote only once about authentication for
pgdba ...

is it a bug or compilation failure?

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ... [enjoy the silence]
... words are meaningless and forgettable ... [depeche mode]

Browse pgsql-bugs by date

  From Date Subject
Next Message John Maddalozzo 2002-04-24 13:48:02 Re: Bug #643: spin lock aborts in 7.0.3
Previous Message Dmitry Tsitelov 2002-04-24 09:17:25 Re: Bug #644: Incorrect result in math operation