pg_hba.conf password authentication problem - Mailing list pgsql-general

From pranab
Subject pg_hba.conf password authentication problem
Date
Msg-id 394BD79A.40A39A7D@pla-net.net
Whole thread Raw
List pgsql-general
Hi,
   I am using postgresql7.0.2 compiled using cygwinb20 on
WinNT.Previously I was using postgres-6.5.3.
   The password based authentication is not working anymore.while
checking the mail archive I noticed someone else also had this problem.
So far I didn't see any workaround in the mail archive
   This link
http://www.postgresql.org/mhonarc/pgsql-general/2000-05/msg00809.html
suggested that after doing initdb the users have to be created with
passwords.
   Well after doing that it still doesn't authenticate based on the
password stored in pg_shadow.
While running postmaster in debug mode.I get these results
---------------------PSQL Client----------------------
bash-2.02$ psql -h localhost -U pkdhar testdb
Password:
psql: pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
--------------------POSTMASTER OUTPUT----------------------
bash-2.02$ postmaster -i -p 5432 -d 5
FindExec: searching PATH ...
ValidateBinary: can't stat "/cygnus/CYGWIN~1/H-I586~1/bin/postgres"
ValidateBinary: can't stat "//D/WINNT/system32/postgres"
ValidateBinary: can't stat "//D/WINNT/postgres"
ValidateBinary: can't stat "//E/Perl/bin//postgres"
ValidateBinary: can't stat "//E/OpenSSL/bin/postgres"
ValidateBinary: can't stat "//E/NETSCAPE/LDAPSDK/LIB/postgres"
ValidateBinary: can't stat "/usr/src/pgsql7/src/test/regress./postgres"
ValidateBinary: can't stat "//e/program
files/devstudio/sharedide/bin/ide/postgr
es"
ValidateBinary: can't stat "//e/program
files/devstudio/sharedide/bin/postgres"
ValidateBinary: can't stat "//e/program files/devstudio/vc/bin/postgres"
ValidateBinary: can't stat "//e/cvs/postgres"
ValidateBinary: can't stat "//E/Program Files/TCL/bin/postgres"
ValidateBinary: can't stat "//E/Program Files/pfe32/postgres"
ValidateBinary: can't stat "//e/jdk1.3/bin/postgres"
ValidateBinary: can't stat
"/cygnus/cygwin-b20/H-i586-cygwin32/bin/postgres"
ValidateBinary: can't stat "//E/qcslapd/bin/postgres"
ValidateBinary: can't stat "//C/WINDOWS/postgres"
ValidateBinary: can't stat "//C/WINDOWS/COMMAND/postgres"
ValidateBinary: can't stat "//D/WINUTILS/postgres"
ValidateBinary: can't stat "//D/JDK/JAVA/BIN/postgres"
ValidateBinary: can't stat "//D/MSDEV/BIN/postgres"
ValidateBinary: can't stat "//D/READIBMW/postgres"
FindExec: found "/cygnus/usr/local/pgsql/bin/postgres" using PATH
binding ShmemCreate(key=52e2c1, size=1115136)
DEBUG:  Data Base System is starting up at Sat Jun 17 14:51:49 2000
DEBUG:  Data Base System was shut down at Sat Jun 17 14:50:48 2000
DEBUG:  Data Base System is in production state at Sat Jun 17 14:51:49
2000
proc_exit(0)
shmem_exit(0)
exit(0)
postmaster: reaping dead processes...
postmaster: ServerLoop:         handling reading 9
postmaster: ServerLoop:         handling reading 9
postmaster: ServerLoop:         handling writing 9
postmaster: ServerLoop:         handling reading 10
postmaster: ServerLoop:         handling reading 10
postmaster: ServerLoop:         handling writing 10
postmaster: ServerLoop:         handling reading 10
postmaster: ServerLoop:         handling reading 10
'ATAL 1:  Bad abstime external representation '\N
proc_exit(0)
shmem_exit(0)
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
NOTICE:  IpcMemoryDetach: shmdt(0x???????): Invalid argument
exit(0)
-------------------------------------------------------------------------
   Any clues I might be missing here?????
Also I did a regression test on cygwin b20. There is some stuff which
doesn't work in NT i.e. timestamp,abstime ,transactions ,select etc.
Here is the regress.out result.
----------------------------------------------------------
=============== Notes...                              =================
postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for these tests by the client frontend.
Please report any apparent problems to ports@postgresql.org
See regress/README for more information.

=============== dropping old regression database...   =================
DROP DATABASE
=============== creating new regression database...   =================
CREATE DATABASE
=============== installing languages...               =================
installing PL/pgSQL .. ok
=============== running regression queries...         =================
boolean .. ok
char .. ok
name .. ok
varchar .. ok
text .. ok
int2 .. ok
int4 .. ok
int8 .. ok
oid .. ok
float4 .. ok
float8 .. ok
numeric .. ok
strings .. ok
numerology .. ok
point .. ok
lseg .. ok
box .. ok
path .. ok
polygon .. ok
circle .. ok
interval .. ok
timestamp .. failed
reltime .. ok
tinterval .. failed
inet .. ok
comments .. ok
oidjoins .. ok
type_sanity .. ok
opr_sanity .. ok
abstime .. failed
geometry .. ok
horology .. failed
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok
copy .. failed
constraints .. failed
triggers .. ok
create_misc .. ok
create_aggregate .. ok
create_operator .. ok
create_index .. ok
create_view .. ok
sanity_check .. ok
errors .. ok
select .. failed
select_into .. ok
select_distinct .. failed
select_distinct_on .. ok
select_implicit .. ok
select_having .. ok
subselect .. ok
union .. ok
case .. ok
join .. ok
aggregates .. failed
transactions .. failed
random .. ok
portals .. ok
arrays .. ok
btree_index .. failed
hash_index .. failed
misc .. failed
select_views .. ok
alter_table .. ok
portals_p2 .. ok
rules .. ok
foreign_key .. ok
limit .. ok
plpgsql .. failed
temp .. failed
-------------------------------------------------------------

pgsql-general by date:

Previous
From: Paul Caskey
Date:
Subject: Bigger sequences (int8)
Next
From: "Gagan"
Date:
Subject: