Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwSXB-0008Gl-7P for pgsql-committers@arkaria.postgresql.org; Fri, 07 Apr 2017 11:58:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwSXA-0005Ct-QH for pgsql-committers@arkaria.postgresql.org; Fri, 07 Apr 2017 11:58:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwSWv-0004AM-QT for pgsql-committers@postgresql.org; Fri, 07 Apr 2017 11:58:17 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwSWr-0003vM-Ly for pgsql-committers@postgresql.org; Fri, 07 Apr 2017 11:58:17 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cwSWp-0004My-8O for pgsql-committers@postgresql.org; Fri, 07 Apr 2017 11:58:12 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.84_2) (envelope-from ) id 1cwSWo-0001hG-Rq for pgsql-committers@postgresql.org; Fri, 07 Apr 2017 11:58:10 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Heikki Linnakangas Subject: pgsql: Use SASLprep to normalize passwords for SCRAM authentication. Message-Id: Date: Fri, 07 Apr 2017 11:58:10 +0000 X-Pg-Spam-Score: -6.9 (------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org VXNlIFNBU0xwcmVwIHRvIG5vcm1hbGl6ZSBwYXNzd29yZHMgZm9yIFNDUkFN IGF1dGhlbnRpY2F0aW9uLgoKQW4gaW1wb3J0YW50IHN0ZXAgb2YgU0FTTHBy ZXAgbm9ybWFsaXphdGlvbiwgaXMgdG8gY29udmVydCB0aGUgc3RyaW5nIHRv ClVuaWNvZGUgbm9ybWFsaXphdGlvbiBmb3JtIE5GS0MuIFVuaWNvZGUgbm9y bWFsaXphdGlvbiByZXF1aXJlcyBhIGZhaXJseQpsYXJnZSB0YWJsZSBvZiBj aGFyYWN0ZXIgZGVjb21wb3NpdGlvbnMsIHdoaWNoIGlzIGdlbmVyYXRlZCBm cm9tIGRhdGEKcHVibGlzaGVkIGJ5IHRoZSBVbmljb2RlIGNvbnNvcnRpdW0u IFRoZSBzY3JpcHQgdG8gZ2VuZXJhdGUgdGhlIHRhYmxlIGlzCnB1dCBpbiBz cmMvY29tbW9uL3VuaWNvZGUsIGFzIHdlbGwgdGVzdCBjb2RlIGZvciB0aGUg bm9ybWFsaXphdGlvbi4KQSBwcmUtZ2VuZXJhdGVkIHZlcnNpb24gb2YgdGhl IHRhYmxlcyBpcyBpbmNsdWRlZCBpbiBzcmMvaW5jbHVkZS9jb21tb24sCnNv IHlvdSBkb24ndCBuZWVkIHRoZSBjb2RlIGluIHNyYy9jb21tb24vdW5pY29k ZSB0byBidWlsZCBQb3N0Z3JlU1FMLCBvbmx5CmlmIHlvdSB3aXNoIHRvIG1v ZGlmeSB0aGUgbm9ybWFsaXphdGlvbiB0YWJsZXMuCgpUaGUgU0FTTHByZXAg aW1wbGVtZW50YXRpb24gZGVwZW5kcyBvbiB0aGUgVVRGLTggZnVuY3Rpb25z IGZyb20Kc3JjL2JhY2tlbmQvdXRpbHMvbWIvd2NoYXIuYy4gU28gdG8gdXNl IGl0LCB5b3UgbXVzdCBhbHNvIGNvbXBpbGUgYW5kIGxpbmsKdGhhdC4gVGhh dCBkb2Vzbid0IGNoYW5nZSBhbnl0aGluZyBmb3IgdGhlIGN1cnJlbnQgdXNl cnMgb2YgdGhlc2UKZnVuY3Rpb25zLCB0aGUgYmFja2VuZCBhbmQgbGlicHEs IGFzIHRoZXkgYm90aCBhbHJlYWR5IGxpbmsgd2l0aCB3Y2hhci5vLgpJdCB3 b3VsZCBiZSBnb29kIHRvIG1vdmUgdGhvc2UgZnVuY3Rpb25zIGludG8gYSBz ZXBhcmF0ZSBmaWxlIGluCnNyYy9jb21tbW9uLCBidXQgSSdsbCBsZWF2ZSB0 aGF0IGZvciBhbm90aGVyIGRheS4KCk5vIGRvY3VtZW50YXRpb24gY2hhbmdl cyBpbmNsdWRlZCwgYmVjYXVzZSB0aGVyZSBpcyBubyBkZXRhaWxzIG9uIHRo ZQpTQ1JBTSBtZWNoYW5pc20gaW4gdGhlIGRvY3MgYW55d2F5LiBBbiBvdmVy dmlldyBvbiB0aGF0IGluIHRoZSBwcm90b2NvbApzcGVjaWZpY2F0aW9uIHdv dWxkIHByb2JhYmx5IGJlIGdvb2QsIGV2ZW4gdGhvdWdoIFNDUkFNIGlzIGRv Y3VtZW50ZWQgaW4KZGV0YWlsIGluIFJGQzU4MDIuIEknbGwgd3JpdGUgdGhh dCBhcyBhIHNlcGFyYXRlIHBhdGNoLiBBbiBpbXBvcnRhbnQgdGhpbmcKdG8g bWVudGlvbiB0aGVyZSBpcyB0aGF0IHdlIGFwcGx5IFNBU0xwcmVwIGV2ZW4g b24gaW52YWxpZCBVVEYtOCBzdHJpbmdzLAp0byBzdXBwb3J0IG90aGVyIGVu Y29kaW5ncy4KClBhdGNoIGJ5IE1pY2hhZWwgUGFxdWllciBhbmQgbWUuCgpE aXNjdXNzaW9uOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdl LWlkL0NBQjduUHFTQnl5RW1BVkx0RWYxS3hUUmg9UFdOS2lXS0VLUVI9ZTF5 R2Voej13YnltUUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0 ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvNjBmMTFiODdhMjM0OTk4NTIzMGMwODYxNmZhOGEz NGZmZGU5MzRjOAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L2JhY2tlbmQvbGlicHEvYXV0aC1zY3JhbS5jICAgICAgICAgICAgICAgICAg ICB8ICAgNjMgKy0Kc3JjL2NvbW1vbi9NYWtlZmlsZSAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAgIDMgKy0Kc3JjL2NvbW1vbi9zYXNscHJl cC5jICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IDEyNzkgKysrCnNy Yy9jb21tb24vc2NyYW0tY29tbW9uLmMgICAgICAgICAgICAgICAgICAgICAg ICAgfCAgIDI1ICstCnNyYy9jb21tb24vdW5pY29kZS8uZ2l0aWdub3JlICAg ICAgICAgICAgICAgICAgICAgfCAgICA3ICsKc3JjL2NvbW1vbi91bmljb2Rl L01ha2VmaWxlICAgICAgICAgICAgICAgICAgICAgICB8ICAgNTMgKwpzcmMv Y29tbW9uL3VuaWNvZGUvUkVBRE1FICAgICAgICAgICAgICAgICAgICAgICAg IHwgICAzNSArCnNyYy9jb21tb24vdW5pY29kZS9nZW5lcmF0ZS1ub3JtX3Rl c3RfdGFibGUucGwgICAgfCAgMTAyICsKc3JjL2NvbW1vbi91bmljb2RlL2dl bmVyYXRlLXVuaWNvZGVfbm9ybV90YWJsZS5wbCB8ICAyMjYgKwpzcmMvY29t bW9uL3VuaWNvZGUvbm9ybV90ZXN0LmMgICAgICAgICAgICAgICAgICAgIHwg ICA4MCArCnNyYy9jb21tb24vdW5pY29kZV9ub3JtLmMgICAgICAgICAgICAg ICAgICAgICAgICAgfCAgNDM3ICsKc3JjL2luY2x1ZGUvY29tbW9uL3Nhc2xw cmVwLmggICAgICAgICAgICAgICAgICAgICB8ICAgMzAgKwpzcmMvaW5jbHVk ZS9jb21tb24vdW5pY29kZV9ub3JtLmggICAgICAgICAgICAgICAgIHwgICAy MSArCnNyYy9pbmNsdWRlL2NvbW1vbi91bmljb2RlX25vcm1fdGFibGUuaCAg ICAgICAgICAgfCA4ODU5ICsrKysrKysrKysrKysrKysrKysrKwpzcmMvaW50 ZXJmYWNlcy9saWJwcS8uZ2l0aWdub3JlICAgICAgICAgICAgICAgICAgIHwg ICAgMiArCnNyYy9pbnRlcmZhY2VzL2xpYnBxL01ha2VmaWxlICAgICAgICAg ICAgICAgICAgICAgfCAgICA0ICstCnNyYy9pbnRlcmZhY2VzL2xpYnBxL2Zl LWF1dGgtc2NyYW0uYyAgICAgICAgICAgICAgfCAgIDI3ICstCnNyYy90ZXN0 L2F1dGhlbnRpY2F0aW9uL3QvMDAyX3Nhc2xwcmVwLnBsICAgICAgICAgfCAg IDk4ICsKc3JjL3Rvb2xzL21zdmMvTWt2Y2J1aWxkLnBtICAgICAgICAgICAg ICAgICAgICAgICB8ICAgIDMgKy0KMTkgZmlsZXMgY2hhbmdlZCwgMTEzMjIg aW5zZXJ0aW9ucygrKSwgMzIgZGVsZXRpb25zKC0pCgoKLS0gClNlbnQgdmlh IHBnc3FsLWNvbW1pdHRlcnMgbWFpbGluZyBsaXN0IChwZ3NxbC1jb21taXR0 ZXJzQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBz dWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHBy ZWYvcGdzcWwtY29tbWl0dGVycwo=