I'm using the current CVS (as of ~1930 EDT, 29AUG02) on RedHat's latest
beta (null). I find that I need to use the -U option when trying to use
psql and the new PGPASSWORDFILE variable.
Here's what I have in my ~/.pgpw file (pointed to by PGPASSWORDFILE):
localhost:*:az_audit:gar:test
This my Linux userid is 'gar', so it should work, and indeed the error
message in the server log is:
Aug 29 21:02:10 tb02 postgres[18440]: [1] LOG: connection received: host=127.0.0.1
port=1084
Aug 29 21:02:10 tb02 postgres[18440]: [2] FATAL: Password authentication failed for
user "gar"
Which is odd, because psql clearly knows my userid is 'gar', and
transmits it to the backend correctly.
If I add the '-U gar', then all is well.
Stepping through psql with gdb, I see that in the case where I don't set
-U, the returned password (from is garbled:
(gdb) print conn->pgpass
$11 = 0x806d228 "test�\021B"
Whereas when I set '-U', the returned password is fine!
(gdb) print conn->pgpass
$15 = 0x806cf08 "test"
It appears that the problem is in PasswordFromFile() in fe_connect.c, but
I'm not sure, as gdb insists that 't' and 'ret' are not in the current
scope when I get to the end of the function. :-(
But the behaviour is consisten.
Thanks,
Gordon.
--
"Far and away the best prize that life has to offer
is the chance to work hard at work worth doing."
-- Theodore Roosevelt
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
