MIME-Version: 1.0
From: Emanuele Musella <emamuse86@gmail.com>
Date: Tue, 12 Nov 2024 14:41:00 +0100
Message-ID: <CA+ugDNyYtHOtWCqVD3YkSVYDWD_1fO8Jm_ahsDGA5dXhbDPwrQ@mail.gmail.com>
Subject: Parametrization minimum password lenght
To: pgsql-hackers@lists.postgresql.org
Content-Type: multipart/mixed; boundary="000000000000c4bc430626b75ec5"
Archived-At: <https://www.postgresql.org/message-id/CA%2BugDNyYtHOtWCqVD3YkSVYDWD_1fO8Jm_ahsDGA5dXhbDPwrQ%40mail.gmail.com>
Precedence: bulk

--000000000000c4bc430626b75ec5
Content-Type: multipart/alternative; boundary="000000000000c4bc410626b75ec3"

--000000000000c4bc410626b75ec3
Content-Type: text/plain; charset="UTF-8"

The goal about this patch is to parameterize the minimum password lenght on
users database and apply it on the general code.
The patch is applicable to the master branch.
We already tested it: it build and works as expected and nothing is found
broken,

Settings in postgresql.conf parametrization like following:

shared_preload_libraries = 'passwordcheck'
min_password_lenght = 12

example:

postgres=# create user prova with password 'eftghaki';
ERROR:  password is too short
postgres=# create user prova with password 'eftghaki1234';
CREATE ROLE


In attach the file patch.

Best regards

Emanuele Musella & Maurizio Boriani

--000000000000c4bc410626b75ec3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The goal about this patch is to parameterize the minimum p=
assword lenght on users database and apply it on the general code.<div>The =
patch is applicable to the master branch.</div><div>We already tested it: i=
t build and works as expected and nothing is found broken,</div><div><br></=
div><div>Settings in postgresql.conf parametrization like following:</div><=
div><br></div><div>shared_preload_libraries =3D &#39;passwordcheck&#39;<br>=
min_password_lenght =3D 12<br></div><div><br></div><div>example:</div><div>=
<br></div><div>postgres=3D# create user prova with password &#39;eftghaki&#=
39;;<br>ERROR: =C2=A0password is too short<br>postgres=3D# create user prov=
a with password &#39;eftghaki1234&#39;;<br>CREATE ROLE<br></div><div><br></=
div><div><br></div><div>In attach the file patch.</div><div><br></div><div>=
Best regards</div><div><br></div><div>Emanuele Musella &amp; Maurizio Boria=
ni</div><div><br></div></div>

--000000000000c4bc410626b75ec3--
--000000000000c4bc430626b75ec5
Content-Type: application/octet-stream; name="min_password_length_v1.patch"
Content-Disposition: attachment; filename="min_password_length_v1.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_m3ei2d7i0>
X-Attachment-Id: f_m3ei2d7i0

ZGlmZiAtLWdpdCBhL2NvbnRyaWIvcGFzc3dvcmRjaGVjay9wYXNzd29yZGNoZWNrLmMgYi9jb250
cmliL3Bhc3N3b3JkY2hlY2svcGFzc3dvcmRjaGVjay5jCmluZGV4IDlkOGM1OGRlZDAuLjU3MmNm
OGU3YTggMTAwNjQ0Ci0tLSBhL2NvbnRyaWIvcGFzc3dvcmRjaGVjay9wYXNzd29yZGNoZWNrLmMK
KysrIGIvY29udHJpYi9wYXNzd29yZGNoZWNrL3Bhc3N3b3JkY2hlY2suYwpAQCAtMzAsNyArMzAs
NyBAQCBQR19NT0RVTEVfTUFHSUM7CiBzdGF0aWMgY2hlY2tfcGFzc3dvcmRfaG9va190eXBlIHBy
ZXZfY2hlY2tfcGFzc3dvcmRfaG9vayA9IE5VTEw7CiAKIC8qIHBhc3N3b3JkcyBzaG9ydGVyIHRo
YW4gdGhpcyB3aWxsIGJlIHJlamVjdGVkICovCi0jZGVmaW5lIE1JTl9QV0RfTEVOR1RIIDgKK2V4
dGVybiBpbnQgbWluX3Bhc3N3b3JkX2xlbmdodDsKIAogZXh0ZXJuIHZvaWQgX1BHX2luaXQodm9p
ZCk7CiAKQEAgLTk1LDcgKzk1LDcgQEAgY2hlY2tfcGFzc3dvcmQoY29uc3QgY2hhciAqdXNlcm5h
bWUsCiAjZW5kaWYKIAogCQkvKiBlbmZvcmNlIG1pbmltdW0gbGVuZ3RoICovCi0JCWlmIChwd2Rs
ZW4gPCBNSU5fUFdEX0xFTkdUSCkKKwkJaWYgKHB3ZGxlbiA8IG1pbl9wYXNzd29yZF9sZW5naHQp
CiAJCQllcmVwb3J0KEVSUk9SLAogCQkJCQkoZXJyY29kZShFUlJDT0RFX0lOVkFMSURfUEFSQU1F
VEVSX1ZBTFVFKSwKIAkJCQkJIGVycm1zZygicGFzc3dvcmQgaXMgdG9vIHNob3J0IikpKTsKZGlm
ZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjLmMgYi9zcmMvYmFja2VuZC91dGls
cy9taXNjL2d1Yy5jCmluZGV4IGFjYmNiOGJiODEuLjVkYzc0YjJjMmQgMTAwNjQ0Ci0tLSBhL3Ny
Yy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9n
dWMuYwpAQCAtMTYwLDYgKzE2MCwxMCBAQCBjaGFyCSAgICpHVUNfY2hlY2tfZXJybXNnX3N0cmlu
ZzsKIGNoYXIJICAgKkdVQ19jaGVja19lcnJkZXRhaWxfc3RyaW5nOwogY2hhcgkgICAqR1VDX2No
ZWNrX2VycmhpbnRfc3RyaW5nOwogCisvKiBtaW5fcGFzc3dvcmRfbGVuZ2h0IG1pbmltdW0gcGFz
c3dvcmQgbGVuZ3RoICovCisKK2ludCBtaW5fcGFzc3dvcmRfbGVuZ2h0OworCiBzdGF0aWMgdm9p
ZCBkb19zZXJpYWxpemUoY2hhciAqKmRlc3RwdHIsIFNpemUgKm1heGJ5dGVzLCBjb25zdCBjaGFy
ICpmbXQsLi4uKSBwZ19hdHRyaWJ1dGVfcHJpbnRmKDMsIDQpOwogCiBzdGF0aWMgdm9pZCBzZXRf
Y29uZmlnX3NvdXJjZWZpbGUoY29uc3QgY2hhciAqbmFtZSwgY2hhciAqc291cmNlZmlsZSwKQEAg
LTM2NTMsNiArMzY1NywxNyBAQCBzdGF0aWMgc3RydWN0IGNvbmZpZ19pbnQgQ29uZmlndXJlTmFt
ZXNJbnRbXSA9CiAJCU5VTEwsIE5VTEwsIE5VTEwKIAl9LAogCisJeworCQl7Im1pbl9wYXNzd29y
ZF9sZW5naHQiLCBQR0NfVVNFUlNFVCwgUVVFUllfVFVOSU5HX0dFUU8sCisJCQlnZXR0ZXh0X25v
b3AoIk1pbmltdW0gcGFzc3dvcmQgbGVuZ3RoLiIpLAorCQkJTlVMTCwKKwkJCUdVQ19FWFBMQUlO
CisJCX0sCisJCSZtaW5fcGFzc3dvcmRfbGVuZ2h0LAorCQk4LCAwLCBJTlRfTUFYLAorCQlOVUxM
LCBOVUxMLCBOVUxMCisJfSwKKwogCS8qIEVuZC1vZi1saXN0IG1hcmtlciAqLwogCXsKIAkJe05V
TEwsIDAsIDAsIE5VTEwsIE5VTEx9LCBOVUxMLCAwLCAwLCAwLCBOVUxMLCBOVUxMLCBOVUxMCg==
--000000000000c4bc430626b75ec5--