Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u1gc4-006QOa-UK for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Apr 2025 07:09:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u1gc3-00CH7L-Do for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Apr 2025 07:09:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u1gc3-00CH7D-4v for pgsql-hackers@lists.postgresql.org; Mon, 07 Apr 2025 07:09:43 +0000 Received: from dd48506.kasserver.com ([85.13.164.188]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u1gc1-003QH8-2B for pgsql-hackers@postgresql.org; Mon, 07 Apr 2025 07:09:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=oopsware.de; s=kas202503021101; t=1744009780; bh=uF6NHnQbnKSMphOHrQN2XV1tHZytsAngS5r/ulrIuPs=; h=Subject:From:To:Cc:Date:In-Reply-To:References:From; b=4uvyF+wZqeuyYjxTrJY0vQkZn0GAFzygHkson2E/Rf4rIzIsie9/J+cXF6giB3HLV XhF2GB0ZQTnWM7oNKkZuZTcnR6pq9jSyTdD9ao6ZvSr2w1bzzgkRXvJcLeOyuCgD1u xV7Z1zl/n2KVW3mOAz0kFmNJqQILG5zmyQGGfM5q3LXA1QQFm5oxG90bsyU/MFChHP szdRroJzJnxdBt7bKxplDsW/oAI9ANbpPt5tHzEyEVYtk5HprovjQghruE1LNIS18s mYNdfBZMQhRziTxJGqXGrA1w1308kGI+RKZmlpB/TOuKCDwqCDlpIFMyfTUxKRwCW7 ko9L1SuS3/MiA== Received: from sethos.at.struktu.ro (sethos.at.struktu.ro [46.4.183.126]) by dd48506.kasserver.com (Postfix) with ESMTPSA id 2B25D86658AE; Mon, 7 Apr 2025 09:09:40 +0200 (CEST) Received: from [192.168.1.186] (i5C75098A.versanet.de [92.117.9.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by sethos.at.struktu.ro (Postfix) with ESMTPSA id CB59F41F892F; Mon, 7 Apr 2025 09:09:39 +0200 (CEST) Message-ID: Subject: Re: Modern SHA2- based password hashes for pgcrypto From: Bernd Helmle To: Andres Freund , Alvaro Herrera Cc: Japin Li , PostgreSQL Development Date: Mon, 07 Apr 2025 09:09:39 +0200 In-Reply-To: References: <7efa840e08ee30cb2fc964c56a1954bece2dd1b4.camel@oopsware.de> <202504051722.3jv3ashzaibd@alvherre.pgsql> Autocrypt: addr=mailings@oopsware.de; prefer-encrypt=mutual; keydata=mQGiBEIM4dYRBACEnxQZ/CfR1xbCJzGOIjvh3fZpLALMm+tt237QlZm9nlLaEwCn317sT 1khPAJwhyBHSHbNFbH+LOL6ezYrg4V2Q9KHyYJDStJtC8c+D7vHVB5Jfslynx89DnCH6jb3H0j+U0 iNYmRmT18PWTZhD5RuXT+Toyz/0hH4YnJzha4VUwCggikXRuhIQ0KIzrps7/PsvasTPjUD/1aoEHR wVyk2C2hXh6GWJYq+1l+sB2d0TOnFJf2xy3Xo03Hi+BEJJdYGqJKqzd0KfsFyJYhO2GIGScSEj1hs TqAiY8OZeRqRGHe69OQEguUSVXp/jPaqU8fel8dbDDMnXkgULq8oO4T9e4GJSFqIvrlx0sJqSMFdi ihV+xCzDS40BACBrTq9tyXmyxJWzQ1/0Hx9S4sU+yeR8ztZH9xgWi1wksfHpEgZBdAkQynlI80/bC tgxfVu+LKgxeqGfMSnT9t8agpr1IGcmSbDntbn/K+3EmCze0jq8EQrZHJWiwCqraM8mnmILSEl5zn aoVoBIF062b60zZicuNeYaVgEKSHfirQgQmVybmQgSGVsbWxlIDxiZXJuZEBvb3Bzd2FyZS5kZT6I XgQTEQIAHgUCQhyP2gIbAwYLCQgHAwIDFQIDAxYCAQIeAQIXgAAKCRBRdc2OhdlKzMm4AJ9mW1np2 RXi66WzEvcIanaJkDT+xgCfZmXG/Sziz5FchI3OjXfXDZfwnNm0J0Jlcm5kIEhlbG1sZSA8YmVybm QuaGVsbWxlQG9vcHN3YXJlLmRlPoheBBMRAgAeBQJCDOHWAhsDBgsJCAcDAgMVAgMDFgIBAh4BAhe AAAoJEFF1zY6F2UrMWZgAn3MVwDBzRS5dZu1yjx7WU3E3JSheAJ41CUYMIkX/oYfWssUVYnOuedgn 8LQlQmVybmQgSGVsbWxlIDxiaEBzY2huYWVwcGNoZW5qYWdkLmRlPoheBBMRAgAeBQJCHI+pAhsDB gsJCAcDAgMVAgMDFgIBAh4BAheAAAoJEFF1zY6F2UrMYMUAn0rk8fEEY2tHGSUD7PNbk+Fwkd7MAJ 4wMfOerrvsKTrB9xmFnZ2ZUy67w7QjQmVybmQgSGVsbWxlIDxtYWlsaW5nc0Bvb3Bzd2FyZS5kZT6 IXgQTEQIAHgUCQhyPxgIbAwYLCQgHAwIDFQIDAxYCAQIeAQIXgAAKCRBRdc2OhdlKzOhrAJ4w+A3H cjTJb54lUDpyyQu6Y5dlVQCeJCFKygOVbpn4HSp4Z+R6+s4Rul60J0Jlcm5kIEhlbG1sZSA8YmVyb mQuaGVsbWxlQGN5YmVydGVjLmF0Poh4BBMRAgA4FiEEcLVWcrwQIdBqHtvMUXXNjoXZSswFAmDe1D kCGwMFCwkIBwIGFQoJCAsCBBYCAwECHgECF4AACgkQUXXNjoXZSszs9QCfbbpKT0/Mh4PhfS6rRbm NNQC1zS8An2x1PLHPS6649DRkiYOMWTXzAlSE Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 X-Spamd-Bar: / List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Sonntag, dem 06.04.2025 um 23:02 -0400 schrieb Andres Freund: > Hi, >=20 > On 2025-04-05 19:22:58 +0200, Alvaro Herrera wrote: > > I have pushed this now, hoping it won't explode. >=20 > I have a WIP patch that adds gcc specific allocator attributes for > palloc et > al. Just rebased that. It warns on the new code as follows: >=20 > [1489/1804 42=C2=A0 82%] Compiling C object > contrib/pgcrypto/pgcrypto.so.p/crypt-sha.c.o > ../../../../../home/andres/src/postgresql/contrib/pgcrypto/crypt- > sha.c: In function 'px_crypt_shacrypt': > ../../../../../home/andres/src/postgresql/contrib/pgcrypto/crypt- > sha.c:605:13: warning: pointer 'cp' may be used after 'pfree' [-Wuse- > after-free] > =C2=A0 605 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 *cp =3D '\0'= ; > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 ~~~~^~~~~~ > ../../../../../home/andres/src/postgresql/contrib/pgcrypto/crypt- > sha.c:533:9: note: call to 'pfree' here > =C2=A0 533 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 pfree(s_byte= s); > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 ^~~~~~~~~~~~~~ >=20 > And it sure seems to have a point.=C2=A0 I'm surprised this isn't causing > wider > issues... Indeed. I think this assignment is useless anyways, since s_bytes is already allocated with palloc0. I must have overseen this one when rearranging code...but yes, strange that it didn't cause drama. Thanks Bernd