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: