user authentication crash

Hi Erik,

Three questions :

a) Did the database pass the regression test after you compiled it?

b) Are the PostgreSQL specific environment variables "correct"? i.e.
PGDATA, PGUSER, etc?

c) Would you consider upgrading to PostgreSQL 7.1.3? What you describe
may be a bug (or combination thereof) in the older 7.1 version.

Regards and best wishes,

Justin Clift

Erik Luke wrote:

Operating system: SuSE 7.2 Professional with postgres v7.1 installed
manually.
(I prefer to manually set up software)
Directory: /postgres
Data Directory: /var/lib/pgsql/data
Options: ODBC emabled
Server startup line: postmaster -i -D /var/lib/pgsql/data > logfile.txt &
Port: 9427
System: AMD Athalon 1.4 Ghz, 512 MB Ram, D-Link network card

Upon trying to connect to the postgres backend by psql (with password
authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
external representation ' '". I have also gotten '@!' and '/g!' in addition
to the ' '. The Postgres backend then terminates abnormally.

The '' was reported at debug_level 0, the '@!' was reported at debug_level
5, and the '/g!' was reported at debug_level 9. The psql string used to
connect was simply psql (database name). Adding additional paramaters, such
as -U have resulted in the same problem. When trying to channel the info
into a logfile, I did not have any luck, as the output file was empty.
Installation instructions were followed exactly.

Thanks

Erik Luke
eluke@cs.montana.edu

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

"Erik Luke" <eluke@cs.montana.edu> writes:

Upon trying to connect to the postgres backend by psql (with password
authentication enabled), postgres crashes saying "FATAL 1: Bad abstime
external representation ' '". I have also gotten '@!' and '/g!' in addition
to the ' '.

It would seem that there's bogus info in the "valid until" column of
your password file. What's in $PGDATA/pg_pwd?

regards, tom lane

I said:

It would seem that there's bogus info in the "valid until" column of
your password file. What's in $PGDATA/pg_pwd?

Ooops, make that $PGDATA/global/pg_pwd

regards, tom lane