password auth woes on sparc64/FreeBSD
От | Volodymyr Kostyrko |
---|---|
Тема | password auth woes on sparc64/FreeBSD |
Дата | |
Msg-id | 46658C55.1070007@synergetica.dn.ua обсуждение исходный текст |
Ответы |
Re: password auth woes on sparc64/FreeBSD
|
Список | pgsql-bugs |
It seems to me that auth on the local interface(?) is broken somehow on sparc64. [data/pg_hba.conf] local postgres,template1 all trust local postgres,template1 all md5 host postgres,template1 all 0.0.0.0/0 md5 host postgres,template1 all ::/0 md5 [--] Well, what I really want to do is to remove the trust line from config. But that way i need a .pgpass file so the server can start/control itself without asking me for password. And if i want .pgpass file i need some auth. [session transcript/same machine] > psql -U pgsql postgres Welcome to psql 8.2.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# alter role pgsql password 'somepass'; ALTER ROLE postgres=# \q > psql -h localhost -U pgsql postgres Password for user pgsql: psql: FATAL: password authentication failed for user "pgsql" [--] It fails for any user and any password. [session transcript/other machine] > psql -h blade -U pgsql postgres Password for user pgsql: Welcome to psql 8.2.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit postgres=# [--] But I can log from another machine flawlessly... > uname -a FreeBSD blade.lan 6.2-STABLE FreeBSD 6.2-STABLE #13: Tue Jun 5 17:06:57 EEST 2007 arcade@blade.lan:/usr/obj/usr/src/sys/BLADE sparc64 PS: Can assist in debugging if someone would point me what and how. -- Sphinx of black quartz judge my vow!
В списке pgsql-bugs по дате отправления: