Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aYyva-0000jk-V4 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Feb 2016 16:38:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aYyva-0008Vk-9v for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Feb 2016 16:38:10 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aYyvY-0008Un-RF for pgsql-hackers@postgresql.org; Thu, 25 Feb 2016 16:38:08 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aYyvW-0002Tu-1H for pgsql-hackers@postgresql.org; Thu, 25 Feb 2016 16:38:07 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 3A50621C0912; Thu, 25 Feb 2016 19:38:04 +0300 (MSK) Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lRf8HufzNgTo; Thu, 25 Feb 2016 19:38:02 +0300 (MSK) Received: from [192.168.27.123] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 2A1C821C08BA; Thu, 25 Feb 2016 19:38:02 +0300 (MSK) Subject: Re: Password identifiers, protocol aging and SCRAM protocol To: michael.paquier@gmail.com References: Cc: pgsql-hackers@postgresql.org From: Valery Popov Message-ID: <56CF2DEA.8070204@postgrespro.ru> Date: Thu, 25 Feb 2016 19:38:02 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Hi, Michael 23.02.2016 10:17, Michael Paquier пишет: > Attached is a set of patches implementing a couple of things that have > been discussed, so let's roll in. > > Those 4 patches are aimed at putting in-core basics for the concept I > call password protocol aging, which is a way to allow multiple > password protocols to be defined in Postgres, and aimed at easing > administration as well as retirement of outdated protocols, which is > something that is not doable now in Postgres. > > The second set of patch 0005~0008 introduces a new protocol, SCRAM. > 9) 0009 is the SCRAM authentication itself.... The theme with password checking is interesting for me, and I can give review for CF for some features. I think that review of all suggested features will require a lot of time. Is it possible to make subset of patches concerning only password strength and its aging? The patches you have applied are non-independent. They should be apply consequentially one by one. Thus the patch 0009 can't be applied without git error before 0001. In this conditions all patches were successfully applied and compiled. All tests successfully passed. > The first 4 patches obviously are the core portion that I would like > to discuss about in this CF, as they put in the base for the rest, and > will surely help Postgres long-term. 0005~0008 are just refactoring > patches, so they are quite simple. 0009 though is quite difficult, and > needs careful review because it manipulates areas of the code where it > is not necessary to be an authenticated user, so if there are bugs in > it it would be possible for example to crash down Postgres just by > sending authentication requests. > -- Regards, Valery Popov Postgres Professional http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers