[HACKERS] Re: [COMMITTERS] pgsql: Add TAP tests for password-basedauthentication methods. - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject [HACKERS] Re: [COMMITTERS] pgsql: Add TAP tests for password-basedauthentication methods.
Date
Msg-id b859f0ec-ca4d-2885-5f06-65f287bf843d@iki.fi
Whole thread Raw
In response to [HACKERS] Re: [COMMITTERS] pgsql: Add TAP tests for password-basedauthentication methods.  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 03/18/2017 02:55 PM, Michael Paquier wrote:
> On Fri, Mar 17, 2017 at 6:37 PM, Heikki Linnakangas
> <heikki.linnakangas@iki.fi> wrote:
>> Add TAP tests for password-based authentication methods.
>>
>> Tests all combinations of users with MD5, plaintext and SCRAM verifiers
>> stored in pg_authid, with plain 'password', 'md5' and 'scram'
>> authentication methods.
>
> This patch has forgotten two things:
> 1) src/test/authentication/.gitignore.
> 2) A refresh of vcregress.pl to run this test suite on Windows.
> Please find attached a patch to address both issues.

The tests don't actually work on Windows, and will all be skipped if 
try. So "vcregress authcheck" as in this patch is pretty useless.

With some effort, we could make it work on Windows. It currently assumes 
unix domain sockets, when it rewrites pg_hba.conf - that would need to 
use TCP instead. And to make it secure, use a long-enough random 
password instead of a hard-coded constant. I'm not volunteering to do 
that, though.

- Heikki




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] WIP: Faster Expression Processing v4
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Logical decoding on standby