[HACKERS] Authentication tests, and plain 'password' authentication with aSCRAM verifier

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема [HACKERS] Authentication tests, and plain 'password' authentication with aSCRAM verifier
Дата
Msg-id e973b21c-ee5a-b7eb-d24e-8dc1c8a424ca@iki.fi
обсуждение исходный текст
Ответы [HACKERS] Re: Authentication tests, and plain 'password' authentication with aSCRAM verifier  (Michael Paquier <michael.paquier@gmail.com>)
Re: [HACKERS] Authentication tests, and plain 'password'authentication with a SCRAM verifier  (Jeff Janes <jeff.janes@gmail.com>)
[HACKERS] Re: Authentication tests, and plain 'password' authentication with aSCRAM verifier  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
Hi,

I didn't include the authentication TAP tests that Michael wrote in the 
main SCRAM commit last week. The main issue was that the new test was 
tacked on the src/test/recovery test suite, for lack of a better place. 
I propose that we add a whole new src/test/authentication directory for 
it. It would also be logical to merge src/test/ssl into it, but the SSL 
test suite has some complicated setup steps, to create the certificates, 
and it cannot be safely run on a multi-user system. So probably best to 
keep it separate, after all.

While looking at the test, I noticed that the SCRAM patch didn't include 
support for logging in with plain 'password' authentication, when the 
user has a SCRAM verifier stored in pg_authid. That was an oversight. If 
the client gives the server the plain password, it's easy for the server 
to verify that it matches the SCRAM verifier.

Attached patches add the TAP test suite, and implement plain 'password' 
authentication for users with SCRAM verifier. Any comments?

- Heikki


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Sharma
Дата:
Сообщение: Re: [HACKERS] Page Scan Mode in Hash Index
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] IF NOT EXISTS option for CREATE SERVER and CREATE USERMAPPING statements