From kenny020307@gmail.com Fri May  15 23:22:31 2026
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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDJnD-00HSWR-Vu
	for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 08:41:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDJnB-00BRyn-VJ
	for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 08:41:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kenny020307@gmail.com>)
	id 1tDJnB-00BRye-HL
	for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 08:41:02 +0000
Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <kenny020307@gmail.com>)
	id 1tDJn9-002iKu-15
	for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 08:41:01 +0000
Received: by mail-io1-xd2a.google.com with SMTP id ca18e2360f4ac-83aac40e908so16330339f.1
        for <pgsql-general@lists.postgresql.org>; Tue, 19 Nov 2024 00:40:58 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1732005657; x=1732610457; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=3ooeOZKxEVJLwcindHOKvw6DK7ATT+MwT+HED4wSQ9Y=;
        b=ImCt3uOCFzapc2+QTyZeVvdykfnwuQXHtTIo95Ii7GwDz5IHrnSKHEQnN8o7mTidVw
         KiyVUCOJxENzRFooGw2+mdurARusmcNN+JWH6QY7GhoFYd2M80paF5QxXC678Zc1opvs
         d8z6bVV1a7Dkt92GFUTCKdo7qnZiRGSjXDE3h631WHzOVTwpscF4sfblLUG2dO/Frkdb
         KuybKKiLU9wyE01XLHlFIZ6RaFH/lcQGPCUaukKE+bZxcYSDSRscGDzV0UUzAqySzGPH
         Y/e8NNQai5NviVkbTD/rD2yniHfwUaoS1Ply96b/X+gtxE+dcl/wepVQiffewSM+WNwL
         WN+Q==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1732005657; x=1732610457;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=3ooeOZKxEVJLwcindHOKvw6DK7ATT+MwT+HED4wSQ9Y=;
        b=qVsiA6X/jW4ROktHeqP8AcdzECqeTs9p6u0pk+a9NNnhqFCD3Olfyrd3U6uqrYFJPm
         BY88DU8GPk0ibqpfXH3B4e646q9O2D8dds0rydk55OogiELzvS0aIOVW1Z3uCxf2aqe8
         PHVvJ/jChBKF2gMlHnIdJbnOtr2eZn8crT9Symi5aijP9/bnpDtvesNAZg1n4fyD8mfR
         kCZDfcdI/Fy1071oVkPyNbSfFAayi5QilrQxc+ogesPDgCnl96oMNTRtKYmM9Neb7HIB
         8/HcGJejTlTo+ygnIuEzPg/NZzHN5keJ61XN/GeW4eYZ/d7GslHkkxM6bRn2NWbn1gdn
         J82w==
X-Gm-Message-State: AOJu0YwYYIEBdMP1AGHjQ4v8bc+y+7/5L3KgvqL1kjyFhxqIC+P1nCpZ
	Yu4LZCv86zBthEL0anvYYXOpai2vX1oCZaQYkKxvyvVZCEouLG+5J2P356ZYTl3Vwiy91Sr/Dkt
	3au1rNJjMF5s0TqIdCguFyoHdsS7Nefx7
X-Google-Smtp-Source: AGHT+IHy87UZpUE9ZQ6OZwlaYP8VhVeBH2KzG+VnYvLezl55KiqkjXpbXnm3f7J1l55i7iETqCeVjpfEocYNxukEH5o=
X-Received: by 2002:a05:6602:6c19:b0:83a:aa8c:4ebb with SMTP id
 ca18e2360f4ac-83e6bf8fd18mr409226039f.0.1732005657112; Tue, 19 Nov 2024
 00:40:57 -0800 (PST)
MIME-Version: 1.0
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
 <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com>
In-Reply-To: <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com>
From: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>
Date: Tue, 19 Nov 2024 16:40:46 +0800
Message-ID: <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
Subject: Re: Re : Credcheck extension
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f0f59606273ffd87"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ%40mail.gmail.com>
Precedence: bulk

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

Sorry for the inconvenience, but I used make and make install to build the
credcheck--2.8.0.sql sources zip file. I would like to ask how I can update
and apply the changes to the system, as I modified the files in
credcheck/test/expected/06_reuse_interval.out and
credcheck/test/sql/06_reuse_interval.sql. However, after running make and
make install again, I don=E2=80=99t see any changes.


Adrian Klaver <adrian.klaver@aklaver.com>=E6=96=BC 2024=E5=B9=B411=E6=9C=88=
18=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=8D=8811:15=E5=AF=AB=E9=
=81=93=EF=BC=9A

> On 11/18/24 01:03, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> > Hello!
> >    I would like to inquire about the installation of the credcheck
> > third-party package to support password complexity and expiration date,
> > etc., when setting up open-source PostgreSQL. I am using the
> > credcheck--2.8.0.sql version from GitHub. After completing the setup, I
> > encountered the following issue: when an account exceeds the configured
> > number of incorrect login attempts, it gets locked. The command SELECT =
*
> > FROM pg_banned_role; should display the columns roleid, failure_count,
> > and banned_date, and the view is working properly and shows the
> > information. However, according to the example, the roleid does not
> > correctly display the corresponding oid for the account with failed
> > login attempts. I would like to ask if there is a solution for this
> > issue. Thank you!
>
> Have you looked a?:
>
> https://github.com/HexaCluster/credcheck/issues/39
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div><div>Sorry for the inconvenience, but I used make and make install to =
build the credcheck--2.8.0.sql sources zip file. I would like to ask how I =
can update and apply the changes to the system, as I modified the files in =
credcheck/test/expected/06_reuse_interval.out and credcheck/test/sql/06_reu=
se_interval.sql. However, after running make and make install again, I don=
=E2=80=99t see any changes.</div><br></div><div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">Adrian Klaver &lt;<a href=3D"mail=
to:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt;=E6=96=BC 20=
24=E5=B9=B411=E6=9C=8818=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=
=8D=8811:15=E5=AF=AB=E9=81=93=EF=BC=9A<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-=
style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)">On 11/18/2=
4 01:03, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:<br>
&gt; Hello!<br>
&gt;=C2=A0 =C2=A0 I would like to inquire about the installation of the cre=
dcheck <br>
&gt; third-party package to support password complexity and expiration date=
, <br>
&gt; etc., when setting up open-source PostgreSQL. I am using the <br>
&gt; credcheck--2.8.0.sql version from GitHub. After completing the setup, =
I <br>
&gt; encountered the following issue: when an account exceeds the configure=
d <br>
&gt; number of incorrect login attempts, it gets locked. The command SELECT=
 * <br>
&gt; FROM pg_banned_role; should display the columns roleid, failure_count,=
 <br>
&gt; and banned_date, and the view is working properly and shows the <br>
&gt; information. However, according to the example, the roleid does not <b=
r>
&gt; correctly display the corresponding oid for the account with failed <b=
r>
&gt; login attempts. I would like to ask if there is a solution for this <b=
r>
&gt; issue. Thank you!<br>
<br>
Have you looked a?:<br>
<br>
<a href=3D"https://github.com/HexaCluster/credcheck/issues/39" rel=3D"noref=
errer" target=3D"_blank">https://github.com/HexaCluster/credcheck/issues/39=
</a><br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div></div>

--000000000000f0f59606273ffd87--






From adrian.klaver@aklaver.com Fri May  15 23:23:29 2026
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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDR2X-000fUY-5q
	for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 16:25:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDR2V-00EV7E-SY
	for pgsql-general@arkaria.postgresql.org; Tue, 19 Nov 2024 16:25:19 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tDR2V-00EV4z-F7
	for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 16:25:19 +0000
Received: from fhigh-b1-smtp.messagingengine.com ([202.12.124.152])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tDR2S-002mFC-Qp
	for pgsql-general@lists.postgresql.org; Tue, 19 Nov 2024 16:25:18 +0000
Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51])
	by mailfhigh.stl.internal (Postfix) with ESMTP id A183D254015F;
	Tue, 19 Nov 2024 11:25:15 -0500 (EST)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-11.internal (MEProxy); Tue, 19 Nov 2024 11:25:15 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm2; t=1732033515;
	 x=1732119915; bh=iJDV3TZ8hPt7kL+w0dw9RBFqgjnkfmQwA5OGZPe8WNY=; b=
	1ogDu2yBA9m3zexI/GHdqao8i43xJGkE6sd0ACTJ3C95DqsCfgK+Bbs3kNr2sWTg
	O5LzmHAsiUujLE/xHhbK8ZgZHoL7M2CPIZlVyewTJyYN3qeiLKuVRbl42I6d/tnL
	1PQ8IjmKVUzuoUDcpvLyGPB6Sv5UyM4yPv3ypzY3w13b9jJIwaZ3Ptde1FCF3Ip+
	xlnFjofMdK7FO2LXrQbfX8NJcqM1I9WzG3b8+sYINtP7mlyEoOzsqFb6v1wb/oTW
	1YqysdHDTnNGcq01F7YO5nHGbnWhmLNqTImIWNJ2qIifP8HYamBKu3jr8i4DTMDM
	3Dje+4SZxKI8Pj3kq0Ktwg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1732033515; x=
	1732119915; bh=iJDV3TZ8hPt7kL+w0dw9RBFqgjnkfmQwA5OGZPe8WNY=; b=E
	R2a/xb3uM9AZMX2EUEfsC+TKTbsD8veD82kLxzbnpcyhMkt9fgvaWIQWVQb4ledo
	dZehUqowCHBhSldyEns9I8fo/DyQ3m8c5dtC/OeBHseUoPnSsBarAvszO1sQ/w/6
	fnYmhU+vJgmzT0UP3pO7815VgbRFoTNqFvFTj2DlALhXjlWt0MQUbSD8pQuU/37u
	NQDqI4ayeKPjzcI9JVFw1GhPoBS6RUFL/IP9rx0Ax+EJhtQahgP7pRSbt/w57dQc
	XXIGV1iFQEw1Vmz0i7Z2kqasW6/C4TwvqfiEuyV6BzaZT3QLjsU+zEVJvHzqGN1v
	gyAMAvdYq6UMKqnD5UVUA==
X-ME-Sender: <xms:67s8ZzAOoZrGDLGQbXOXMlWrxicx8KKiN2zAXm5bOok28NohXGNm-w>
    <xme:67s8Z5hGiIUr4m9T8ouE_P-4vRa9Ty324LZK-Fb8_07OlN5_2iBievYiufCfaXa-1
    vmXElLVrWLgYQA>
X-ME-Received: <xmr:67s8Z-n28iVIh20LQ2j8VsQYEPGTBsr5Tk_-fzmo-apkm0UQm4Q3GNoANsnTuu-OzW8cFfDCJ7xzC17FALTcarreGXDnkkVa>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrfedvgdekiecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr
    tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuf
    fvvehfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghr
    uceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrth
    htvghrnhepfedvudevudegteegveejleeuueefhffggfeijeffvdeuiedugfelfeejveeg
    geeinecuffhomhgrihhnpehgihhthhhusgdrtghomhenucevlhhushhtvghrufhiiigvpe
    dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhl
    rghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprh
    gtphhtthhopehkvghnnhihtddvtdeftdejsehgmhgrihhlrdgtohhmpdhrtghpthhtohep
    phhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg
X-ME-Proxy: <xmx:67s8Z1zj92OZEZC90_vtHGF2WFEsctgm6m-t0WwkW2G5XZbOJVTKBw>
    <xmx:67s8Z4Q65OMPDZPWBqFe3ZxiiyLo2sHxg_LMS5YW_z1FbNcdVCMmxA>
    <xmx:67s8Z4YeVv8ADLeyovHFx8ejNquB4HXA2LE3zNYM8D3e4XahMf2c2w>
    <xmx:67s8Z5T0POGGnAlfHKnXPx4STi3dSfOK-Se81VPXwPLHnwvgsdDdGA>
    <xmx:67s8ZzeUok45-nqjSEn2s3Hm9mrGsmzvpiahS1DPDVIynWtGMFP_0lZ9>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue,
 19 Nov 2024 11:25:14 -0500 (EST)
Message-ID: <3b615ed5-1186-46f2-92bd-363b9b7769a6@aklaver.com>
Date: Tue, 19 Nov 2024 08:25:14 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Re : Credcheck extension
To: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
 <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com>
 <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/3b615ed5-1186-46f2-92bd-363b9b7769a6%40aklaver.com>
Precedence: bulk

On 11/19/24 00:40, 張宸瑋 wrote:
> Sorry for the inconvenience, but I used make and make install to build 
> the credcheck--2.8.0.sql sources zip file. I would like to ask how I can 
> update and apply the changes to the system, as I modified the files in 
> credcheck/test/expected/06_reuse_interval.out and 
> credcheck/test/sql/06_reuse_interval.sql. However, after running make 
> and make install again, I don’t see any changes.

Pretty sure you need to do:

make clean

first, then the rest of the install process.

That process is shown here:

https://github.com/hexacluster/credcheck?tab=readme-ov-file#installation


> 
> 
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>於 2024年11月18日 週一，下午11:15寫道：
> 
>     On 11/18/24 01:03, 張宸瑋 wrote:
>      > Hello!
>      >    I would like to inquire about the installation of the credcheck
>      > third-party package to support password complexity and expiration
>     date,
>      > etc., when setting up open-source PostgreSQL. I am using the
>      > credcheck--2.8.0.sql version from GitHub. After completing the
>     setup, I
>      > encountered the following issue: when an account exceeds the
>     configured
>      > number of incorrect login attempts, it gets locked. The command
>     SELECT *
>      > FROM pg_banned_role; should display the columns roleid,
>     failure_count,
>      > and banned_date, and the view is working properly and shows the
>      > information. However, according to the example, the roleid does not
>      > correctly display the corresponding oid for the account with failed
>      > login attempts. I would like to ask if there is a solution for this
>      > issue. Thank you!
> 
>     Have you looked a?:
> 
>     https://github.com/HexaCluster/credcheck/issues/39
>     <https://github.com/HexaCluster/credcheck/issues/39>
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com







From kenny020307@gmail.com Fri May  15 23:23:51 2026
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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDayB-001r58-GB
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 03:01:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDay8-001JZH-4i
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 03:01:28 +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 <kenny020307@gmail.com>)
	id 1tDay7-001JYp-Im
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 03:01:27 +0000
Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <kenny020307@gmail.com>)
	id 1tDay4-002o58-Kd
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 03:01:26 +0000
Received: by mail-io1-xd29.google.com with SMTP id ca18e2360f4ac-83aac40e908so18830439f.1
        for <pgsql-general@lists.postgresql.org>; Tue, 19 Nov 2024 19:01:24 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1732071684; x=1732676484; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=XNEDepPoAw6MQe4nCYIF447rhAFVMwZbxion8pTY8cs=;
        b=j3xcm0pYbBUVauMr6pZy++emQdZmVTwnq1wlbRppmIeo+1KvPLbCpyzjEVIMXlOOwV
         AIG9Gnc1TCKDRa4/9v3y/2ZOdo7kOyZf7UMJZnFhYHnkwUejMzYwBPdiHbqpfxQqbZlY
         DDCFcgJCL4ENoT71SYf72RQ8EWJqDDmczBaPibEQ1AoVo9VEHXwD4IJMudtN+O00+uQl
         WGlnnYvxDjJ3Cc6yVDrfPPIuO51KQwOJJyDVccojByCUdFxkmYxmLj4/jm4oYIqKKrRE
         a99KspAc9ETNxOKkUYGlcrTVBMOE/Z9mp7/z49pNMMzFhnsPRvLTi3zXGcdicHwTqrfF
         sn1A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1732071684; x=1732676484;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=XNEDepPoAw6MQe4nCYIF447rhAFVMwZbxion8pTY8cs=;
        b=N5YicWwcmKOOqDnElTo0nqSMouOcRFJy21ZE8Zbfb8+rvfFEiwqSN7+oPSg55Fooy6
         17k576uAXdL5O2JSL+rzVLIKLF/fg4ZU+eBD2hRaZ/rHmsbgqPm3aFAj7sfWjveW1+Al
         6kqEaJ+vmt8n7aT5VX9dWEohWAGVxEXe2I4q2jXwoUxnJCs4yRlb8hK7IEO0awnDrNPf
         1TaV4XTEFwW9z7mPjGEBke+QgShPbqCD6EnBQLGPTNfn+dzT889pKr5VYcqywaFykCnq
         4kEqXSVYIFWRdjqbYxbzfQnd1lUoNBbBq0Y3bAMyUguLSlqeEQ/se+TUeUCGJzP4HAwl
         ON0w==
X-Gm-Message-State: AOJu0YzoIce27/i9pnEIuXt4R8FyIixdrv6p1gO/9RH/2iKJVGQ66u0k
	gxS/UfRjpNKQzjYbv/L0EsPzwf+r4EgeFZ6q0NOe8X4oL+CbatrtqjmwYk76gyT75Ns1rWZ1l8R
	yH6kB7frLQrKVszInqGmvGA3HefW9cg==
X-Gm-Gg: ASbGncuKJQ8BVHaXyGlF/DdgC3iohUMYRgei4baSWBmHwaRkl7pV31aQjs1LMQ5yRLW
	/xbll6uitGeGdCPAItlJ/hjmouYFqREj11U9GUmWLnl1EZ84BwKaneGR8aqfNbCY=
X-Google-Smtp-Source: AGHT+IHWOAs3wkBBmGZJX1C+VgLmJ1X2RiB+LqL/QpRYJ2cs8N0eFbziqJ9mt6mm1YLNNARrLcVwnVMYv5ndhPvmFLc=
X-Received: by 2002:a05:6602:1684:b0:83a:abd1:6af2 with SMTP id
 ca18e2360f4ac-83eb60d8ceemr38312339f.3.1732071683598; Tue, 19 Nov 2024
 19:01:23 -0800 (PST)
MIME-Version: 1.0
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
 <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com> <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
 <3b615ed5-1186-46f2-92bd-363b9b7769a6@aklaver.com>
In-Reply-To: <3b615ed5-1186-46f2-92bd-363b9b7769a6@aklaver.com>
From: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>
Date: Wed, 20 Nov 2024 11:01:12 +0800
Message-ID: <CAFsaSDiG9PQXUZZzw2k8TukTKHGDTRK4s6R1wXY-rLUp0NzRcw@mail.gmail.com>
Subject: Re: Re : Credcheck extension
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006d2fd006274f5dd5"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFsaSDiG9PQXUZZzw2k8TukTKHGDTRK4s6R1wXY-rLUp0NzRcw%40mail.gmail.com>
Precedence: bulk

--0000000000006d2fd006274f5dd5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you for your help!After applying the patch, the above issue has been
resolved.

 I have another question: After identifying who is in the banned_role, the
GitHub example uses the command SELECT pg_banned_role_reset(); to unlock
everyone. I would like to know if there is a way to unlock a specific
individual rather than unlocking everyone.

Adrian Klaver <adrian.klaver@aklaver.com>=E6=96=BC 2024=E5=B9=B411=E6=9C=88=
20=E6=97=A5 =E9=80=B1=E4=B8=89=EF=BC=8C=E4=B8=8A=E5=8D=8812:25=E5=AF=AB=E9=
=81=93=EF=BC=9A

> On 11/19/24 00:40, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> > Sorry for the inconvenience, but I used make and make install to build
> > the credcheck--2.8.0.sql sources zip file. I would like to ask how I ca=
n
> > update and apply the changes to the system, as I modified the files in
> > credcheck/test/expected/06_reuse_interval.out and
> > credcheck/test/sql/06_reuse_interval.sql. However, after running make
> > and make install again, I don=E2=80=99t see any changes.
>
> Pretty sure you need to do:
>
> make clean
>
> first, then the rest of the install process.
>
> That process is shown here:
>
> https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#installatio=
n
>
>
> >
> >
> > Adrian Klaver <adrian.klaver@aklaver.com
> > <mailto:adrian.klaver@aklaver.com>>=E6=96=BC 2024=E5=B9=B411=E6=9C=8818=
=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=8D=8811:15=E5=AF=AB=E9=81=
=93=EF=BC=9A
> >
> >     On 11/18/24 01:03, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> >      > Hello!
> >      >    I would like to inquire about the installation of the credche=
ck
> >      > third-party package to support password complexity and expiratio=
n
> >     date,
> >      > etc., when setting up open-source PostgreSQL. I am using the
> >      > credcheck--2.8.0.sql version from GitHub. After completing the
> >     setup, I
> >      > encountered the following issue: when an account exceeds the
> >     configured
> >      > number of incorrect login attempts, it gets locked. The command
> >     SELECT *
> >      > FROM pg_banned_role; should display the columns roleid,
> >     failure_count,
> >      > and banned_date, and the view is working properly and shows the
> >      > information. However, according to the example, the roleid does
> not
> >      > correctly display the corresponding oid for the account with
> failed
> >      > login attempts. I would like to ask if there is a solution for
> this
> >      > issue. Thank you!
> >
> >     Have you looked a?:
> >
> >     https://github.com/HexaCluster/credcheck/issues/39
> >     <https://github.com/HexaCluster/credcheck/issues/39>
> >
> >     --
> >     Adrian Klaver
> >     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div dir=3D"auto">Thank you for your help!After applying the patch, the abo=
ve issue has been resolved.=C2=A0</div><div dir=3D"auto"><br></div><div dir=
=3D"auto">=C2=A0I have another question: After identifying who is in the ba=
nned_role, the GitHub example uses the command SELECT pg_banned_role_reset(=
); to unlock everyone. I would like to know if there is a way to unlock a s=
pecific individual rather than unlocking everyone.</div><div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Adrian Klaver &lt;<a=
 href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt=
;=E6=96=BC 2024=E5=B9=B411=E6=9C=8820=E6=97=A5 =E9=80=B1=E4=B8=89=EF=BC=8C=
=E4=B8=8A=E5=8D=8812:25=E5=AF=AB=E9=81=93=EF=BC=9A<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;=
border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)=
">On 11/19/24 00:40, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:<br>
&gt; Sorry for the inconvenience, but I used make and make install to build=
 <br>
&gt; the credcheck--2.8.0.sql sources zip file. I would like to ask how I c=
an <br>
&gt; update and apply the changes to the system, as I modified the files in=
 <br>
&gt; credcheck/test/expected/06_reuse_interval.out and <br>
&gt; credcheck/test/sql/06_reuse_interval.sql. However, after running make =
<br>
&gt; and make install again, I don=E2=80=99t see any changes.<br>
<br>
Pretty sure you need to do:<br>
<br>
make clean<br>
<br>
first, then the rest of the install process.<br>
<br>
That process is shown here:<br>
<br>
<a href=3D"https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#in=
stallation" rel=3D"noreferrer" target=3D"_blank">https://github.com/hexaclu=
ster/credcheck?tab=3Dreadme-ov-file#installation</a><br>
<br>
<br>
&gt; <br>
&gt; <br>
&gt; Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a> <br>
&gt; &lt;mailto:<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_bla=
nk">adrian.klaver@aklaver.com</a>&gt;&gt;=E6=96=BC 2024=E5=B9=B411=E6=9C=88=
18=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=8D=8811:15=E5=AF=AB=E9=
=81=93=EF=BC=9A<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0On 11/18/24 01:03, =E5=BC=B5=E5=AE=B8=E7=91=8B wrot=
e:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; Hello!<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 I would like to inquire about th=
e installation of the credcheck<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; third-party package to support password compl=
exity and expiration<br>
&gt;=C2=A0 =C2=A0 =C2=A0date,<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; etc., when setting up open-source PostgreSQL.=
 I am using the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; credcheck--2.8.0.sql version from GitHub. Aft=
er completing the<br>
&gt;=C2=A0 =C2=A0 =C2=A0setup, I<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; encountered the following issue: when an acco=
unt exceeds the<br>
&gt;=C2=A0 =C2=A0 =C2=A0configured<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; number of incorrect login attempts, it gets l=
ocked. The command<br>
&gt;=C2=A0 =C2=A0 =C2=A0SELECT *<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; FROM pg_banned_role; should display the colum=
ns roleid,<br>
&gt;=C2=A0 =C2=A0 =C2=A0failure_count,<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; and banned_date, and the view is working prop=
erly and shows the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; information. However, according to the exampl=
e, the roleid does not<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; correctly display the corresponding oid for t=
he account with failed<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; login attempts. I would like to ask if there =
is a solution for this<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; issue. Thank you!<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0Have you looked a?:<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0<a href=3D"https://github.com/HexaCluster/credcheck=
/issues/39" rel=3D"noreferrer" target=3D"_blank">https://github.com/HexaClu=
ster/credcheck/issues/39</a><br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;<a href=3D"https://github.com/HexaCluster/credc=
heck/issues/39" rel=3D"noreferrer" target=3D"_blank">https://github.com/Hex=
aCluster/credcheck/issues/39</a>&gt;<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0-- <br>
&gt;=C2=A0 =C2=A0 =C2=A0Adrian Klaver<br>
&gt;=C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"mailto:adri=
an.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;<=
br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div></div>

--0000000000006d2fd006274f5dd5--






From adrian.klaver@aklaver.com Fri May  15 23:22:36 2026
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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDbwr-001z39-5R
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 04:04:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDbwo-001vmD-TC
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 04:04:10 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tDbwn-001vm2-Dp
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 04:04:10 +0000
Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tDbwj-002rLN-KA
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 04:04:08 +0000
Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42])
	by mailfhigh.phl.internal (Postfix) with ESMTP id A586D11401EB;
	Tue, 19 Nov 2024 23:04:03 -0500 (EST)
Received: from phl-mailfrontend-02 ([10.202.2.163])
  by phl-compute-02.internal (MEProxy); Tue, 19 Nov 2024 23:04:03 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm2; t=1732075443;
	 x=1732161843; bh=eINwVQO+ErPpuADAovfQ6vir2eeXMgMgx9FYzv1wzNo=; b=
	UbJsGAxtJFTf56aO8CMsiPj1cjEjSBrk9X0Nli/zCsKG9iqL1spm8a9UZtZhfit+
	OaHRu5vcM/Z6NKduAP2k/DzNGj0vB6eqUZhU4zcYQS0BU3pQ6t66DIG76lJpg6A3
	BLkVHExgSEpQfdi2h+KQnsozDxTovpo2yGpjKuNhx/ZDCSbsiGPxEZO7nlTATmWu
	yv7J3MDBlqdmxkUHZXEeSuWzAq/gjmH4bm2eTb4Ru/mzi2Xe1xfoGl2BcDs8RabG
	NR5HNsnWbqO6d9p53rnZysB4dtGTFSggE94q+Dh5+WnLgA3uS0CcgbMqEQGqEfNC
	iWA118Nuh6bbaOHAjzKSXQ==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1732075443; x=
	1732161843; bh=eINwVQO+ErPpuADAovfQ6vir2eeXMgMgx9FYzv1wzNo=; b=O
	ICyxjBp/Yg6j9CE+iqHKNRxfeUe7FR12iBUqP2Dx14QHuOLVfCMN3OHBy6s2eIMU
	c961bY0YAzYc+0rSCAJ5UXYFiqWB5fF/tE9oZ2eBgeHg+7dvRY36JyTBygz5xiDZ
	AhnQO8IpAGlv8zfDPz15guwpApx68wTOy6S9UzaGvFnkvPOx3Ta52uBzFL5QNgNq
	PuvE6DDaKdUqb21zMQqFfvUnFHnxdCt0qGbVyXg+ENbWH9EbsWFIu5dcUSfaYaDX
	J4dtlTDmFXxme2Bg7KJ49YVyOaB+/IyBJPRYjqH+A1JE5m8ySOR2NzGb0iOqB6II
	dMpfhkjoF+V+bR7+6S97w==
X-ME-Sender: <xms:s189ZyhRSvu8Bu7FJVaRjqeUP5Dxc5mnWtdwGAcAEafOwedTkt84wg>
    <xme:s189ZzCaZIzr3TxQsPgK6U6GjIMrG3QmpYrmESbtYobIlH5ITRQq8fY6zEj2BLMXs
    cq4m6ein5omtb8>
X-ME-Received: <xmr:s189Z6Ee_eReOT6BEjeTjnIYaZjWGURSiAPyrjKu0c1oXkYJjX9ewU4dnM5c9BBGLFOC18MobMjKqO4sY-u9L5TnwI9JsK58>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrfeefgdeihecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr
    tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuf
    fvvehfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghr
    uceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrth
    htvghrnhepfedvudevudegteegveejleeuueefhffggfeijeffvdeuiedugfelfeejveeg
    geeinecuffhomhgrihhnpehgihhthhhusgdrtghomhenucevlhhushhtvghrufhiiigvpe
    dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhl
    rghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprh
    gtphhtthhopehkvghnnhihtddvtdeftdejsehgmhgrihhlrdgtohhmpdhrtghpthhtohep
    phhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg
X-ME-Proxy: <xmx:s189Z7QcmggrcuiJIGWQ4yU2JpvDQDdL1qZNpb8vgCE13EyEAOyxJA>
    <xmx:s189Z_y0m-lv_8x4jrDI9HdGQNOz8SuOOjl962135qzIPxM5nH2_fQ>
    <xmx:s189Z54THT0oPQRvPU5u4JBCjQwJJCugcov1x4Ch2GlpnGqzSlhJEw>
    <xmx:s189Z8zfRrEL_O2Y1LoE56tz4cWukbDDdRilnq5ePr93lNDh-YiaZA>
    <xmx:s189Z6_lsTt8507aqzdgCo4pidpVTKHbkkEKa0BF_riGJ6c57LxqgBHd>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue,
 19 Nov 2024 23:04:02 -0500 (EST)
Message-ID: <7870eb0d-6092-44df-9c88-4ba498e14de2@aklaver.com>
Date: Tue, 19 Nov 2024 20:04:02 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Re : Credcheck extension
To: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
 <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com>
 <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
 <3b615ed5-1186-46f2-92bd-363b9b7769a6@aklaver.com>
 <CAFsaSDiG9PQXUZZzw2k8TukTKHGDTRK4s6R1wXY-rLUp0NzRcw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFsaSDiG9PQXUZZzw2k8TukTKHGDTRK4s6R1wXY-rLUp0NzRcw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/7870eb0d-6092-44df-9c88-4ba498e14de2%40aklaver.com>
Precedence: bulk

On 11/19/24 19:01, 張宸瑋 wrote:
> Thank you for your help!After applying the patch, the above issue has 
> been resolved.
> 
>   I have another question: After identifying who is in the banned_role, 
> the GitHub example uses the command SELECT pg_banned_role_reset(); to 
> unlock everyone. I would like to know if there is a way to unlock a 
> specific individual rather than unlocking everyone.

It's in the docs:

https://github.com/hexacluster/credcheck?tab=readme-ov-file#examples

Authentication failure ban

"A superuser can also reset the content of the banned user cache by 
calling a function named public.pg_banned_role_reset(). If it is called 
without an argument, all the banned cache will be cleared. To only 
remove the record registered for a single user, just pass his name as 
parameter. This function returns the number of records removed from the 
cache. A restart of PostgreSQL also clear the cache."

I would suggest reading the entire documentation.

> 
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>於 2024年11月20日 週三，上午12:25寫道：
> 
>     On 11/19/24 00:40, 張宸瑋 wrote:
>      > Sorry for the inconvenience, but I used make and make install to
>     build
>      > the credcheck--2.8.0.sql sources zip file. I would like to ask
>     how I can
>      > update and apply the changes to the system, as I modified the
>     files in
>      > credcheck/test/expected/06_reuse_interval.out and
>      > credcheck/test/sql/06_reuse_interval.sql. However, after running
>     make
>      > and make install again, I don’t see any changes.
> 
>     Pretty sure you need to do:
> 
>     make clean
> 
>     first, then the rest of the install process.
> 
>     That process is shown here:
> 
>     https://github.com/hexacluster/credcheck?tab=readme-ov-file#installation <https://github.com/hexacluster/credcheck?tab=readme-ov-file#installation>
> 
> 
>      >
>      >
>      > Adrian Klaver <adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>
>      > <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>>>於 2024年11月18日 週一，下午
>     11:15寫道：
>      >
>      >     On 11/18/24 01:03, 張宸瑋 wrote:
>      >      > Hello!
>      >      >    I would like to inquire about the installation of the
>     credcheck
>      >      > third-party package to support password complexity and
>     expiration
>      >     date,
>      >      > etc., when setting up open-source PostgreSQL. I am using the
>      >      > credcheck--2.8.0.sql version from GitHub. After completing the
>      >     setup, I
>      >      > encountered the following issue: when an account exceeds the
>      >     configured
>      >      > number of incorrect login attempts, it gets locked. The
>     command
>      >     SELECT *
>      >      > FROM pg_banned_role; should display the columns roleid,
>      >     failure_count,
>      >      > and banned_date, and the view is working properly and
>     shows the
>      >      > information. However, according to the example, the roleid
>     does not
>      >      > correctly display the corresponding oid for the account
>     with failed
>      >      > login attempts. I would like to ask if there is a solution
>     for this
>      >      > issue. Thank you!
>      >
>      >     Have you looked a?:
>      >
>      > https://github.com/HexaCluster/credcheck/issues/39
>     <https://github.com/HexaCluster/credcheck/issues/39>
>      >     <https://github.com/HexaCluster/credcheck/issues/39
>     <https://github.com/HexaCluster/credcheck/issues/39>>
>      >
>      >     --
>      >     Adrian Klaver
>      > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
>      >
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com







From kenny020307@gmail.com Fri May  15 23:23:46 2026
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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDeRs-002IRF-V9
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 06:44:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tDeRr-002fYy-Bs
	for pgsql-general@arkaria.postgresql.org; Wed, 20 Nov 2024 06:44:23 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kenny020307@gmail.com>)
	id 1tDeRq-002fYq-Tz
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 06:44:23 +0000
Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <kenny020307@gmail.com>)
	id 1tDeRo-002sUh-0r
	for pgsql-general@lists.postgresql.org; Wed, 20 Nov 2024 06:44:22 +0000
Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-3a7675c5a94so1319575ab.2
        for <pgsql-general@lists.postgresql.org>; Tue, 19 Nov 2024 22:44:19 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1732085058; x=1732689858; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=AwyV69M7w4ewnw9usWG2ZPbn0ShzHcLmvMIeeJBdgOI=;
        b=gyIICg0JWBemT09XM+uRxZi1KsS4eUxhHl7gHDOCSM1mNVkunEHpnLUI9TZSAqYbgD
         fswmHYtMhxtnUICXoVzIDR9u3gwRgfWOiWj56uDrDlR/35GrCBA5as81OLbQQX9wB+2h
         fpvnnVOsWBfMM0y3gfzqv9+i925bkVjP7om+4Bsaq9MUXftkFFLL2cKRtBLfro9UeUlU
         XnYhpcJawIXY67I3KuE+B4dHkGX3mo12hnYH9Pnw1r+JfVpEeEfaABLFQo+RnYPWarZe
         Z/4XeHyNDxFLu1wZv4CniUg/sTvQUIVz1nL8OVgHwGNKnh1V6XRCmHmmfHhP2adt7n19
         OJqg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1732085058; x=1732689858;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=AwyV69M7w4ewnw9usWG2ZPbn0ShzHcLmvMIeeJBdgOI=;
        b=RQQ+0WD/Xf09+RqNXrMQlcvyawgGRWPasKX/LZDdyD1naOFMK0FmuMzH5Y0MbCY3bM
         wySuX/QcV1xO4W2r2kewUvuR7ORU1ph6H75y/m2WpzyDxyoSkAif7p5Aq9dPH/XF0mof
         1zTUI98ZUcwGV46pgNJSh9SBUabvxgTYiEUlj1fVdoTEfrIhhP/xJmDCcd6jFe+tS71G
         6HD7aYXGUuVC7TjXyjqgRewQQJQqUurvq5VI1V7xvlsif83Gt9EWbCI0CXWte69tBUvJ
         z/QE+A1W/To05HlsuUvu9o0acxl2yYmUvKk/gB4XVxhOaST00Duwp1UPEcl4qmdvp429
         ozLg==
X-Gm-Message-State: AOJu0YyU6c6BWHdy7/qVKZo5urBIcp4aKK94eCo/UT6ODWPEdrW2XANz
	Uot2SL7AFCeVybkxhuXEENwgr8tylHqr/gSTPbzGj0kWU+QJsdo+ImiW5ereTiHjDSBAZwNhyAu
	/2IwLRWls+wHoJaDQHSmF9O5Raxw=
X-Gm-Gg: ASbGncskLR+Z5ENpBxfRIqbEoz4VAvrNWumylYVysRWshkoVj268bZ2O0leT62MMafr
	2miIPSqFjzf7nW0iB4wdwPhCPGEy8PUqeImrwQ85bhim6Yy8erIZIuTLaMGP5qDA=
X-Google-Smtp-Source: AGHT+IEzWuYU8OaiTbY6G64511UxVzcdLi3mCMqQaU5MZHLLC/JzMObGBzBStfnhW49Rpc/XR/0yRkvCxmyw/bdGnGs=
X-Received: by 2002:a05:6602:2cce:b0:83a:acc8:5faf with SMTP id
 ca18e2360f4ac-83eb612e606mr57138339f.5.1732085058080; Tue, 19 Nov 2024
 22:44:18 -0800 (PST)
MIME-Version: 1.0
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
 <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com> <CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com>
 <3b615ed5-1186-46f2-92bd-363b9b7769a6@aklaver.com> <CAFsaSDiG9PQXUZZzw2k8TukTKHGDTRK4s6R1wXY-rLUp0NzRcw@mail.gmail.com>
 <7870eb0d-6092-44df-9c88-4ba498e14de2@aklaver.com>
In-Reply-To: <7870eb0d-6092-44df-9c88-4ba498e14de2@aklaver.com>
From: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>
Date: Wed, 20 Nov 2024 14:44:04 +0800
Message-ID: <CAFsaSDgypXJHFjk4-=C+WCeTUXmqJH8mwrF=Kiz+Wxt-wKccJw@mail.gmail.com>
Subject: Re: Re : Credcheck extension
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000009b99800627527a93"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFsaSDgypXJHFjk4-%3DC%2BWCeTUXmqJH8mwrF%3DKiz%2BWxt-wKccJw%40mail.gmail.com>
Precedence: bulk

--0000000000009b99800627527a93
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you for your help.Problem solved!

Adrian Klaver <adrian.klaver@aklaver.com>=E6=96=BC 2024=E5=B9=B411=E6=9C=88=
20=E6=97=A5 =E9=80=B1=E4=B8=89=EF=BC=8C=E4=B8=8B=E5=8D=8812:04=E5=AF=AB=E9=
=81=93=EF=BC=9A

> On 11/19/24 19:01, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> > Thank you for your help!After applying the patch, the above issue has
> > been resolved.
> >
> >   I have another question: After identifying who is in the banned_role,
> > the GitHub example uses the command SELECT pg_banned_role_reset(); to
> > unlock everyone. I would like to know if there is a way to unlock a
> > specific individual rather than unlocking everyone.
>
> It's in the docs:
>
> https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#examples
>
> Authentication failure ban
>
> "A superuser can also reset the content of the banned user cache by
> calling a function named public.pg_banned_role_reset(). If it is called
> without an argument, all the banned cache will be cleared. To only
> remove the record registered for a single user, just pass his name as
> parameter. This function returns the number of records removed from the
> cache. A restart of PostgreSQL also clear the cache."
>
> I would suggest reading the entire documentation.
>
> >
> > Adrian Klaver <adrian.klaver@aklaver.com
> > <mailto:adrian.klaver@aklaver.com>>=E6=96=BC 2024=E5=B9=B411=E6=9C=8820=
=E6=97=A5 =E9=80=B1=E4=B8=89=EF=BC=8C=E4=B8=8A=E5=8D=8812:25=E5=AF=AB=E9=81=
=93=EF=BC=9A
> >
> >     On 11/19/24 00:40, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> >      > Sorry for the inconvenience, but I used make and make install to
> >     build
> >      > the credcheck--2.8.0.sql sources zip file. I would like to ask
> >     how I can
> >      > update and apply the changes to the system, as I modified the
> >     files in
> >      > credcheck/test/expected/06_reuse_interval.out and
> >      > credcheck/test/sql/06_reuse_interval.sql. However, after running
> >     make
> >      > and make install again, I don=E2=80=99t see any changes.
> >
> >     Pretty sure you need to do:
> >
> >     make clean
> >
> >     first, then the rest of the install process.
> >
> >     That process is shown here:
> >
> >
> https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#installatio=
n <
> https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#installatio=
n>
> >
> >
> >      >
> >      >
> >      > Adrian Klaver <adrian.klaver@aklaver.com
> >     <mailto:adrian.klaver@aklaver.com>
> >      > <mailto:adrian.klaver@aklaver.com
> >     <mailto:adrian.klaver@aklaver.com>>>=E6=96=BC 2024=E5=B9=B411=E6=9C=
=8818=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=8D=88
> >     11:15=E5=AF=AB=E9=81=93=EF=BC=9A
> >      >
> >      >     On 11/18/24 01:03, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:
> >      >      > Hello!
> >      >      >    I would like to inquire about the installation of the
> >     credcheck
> >      >      > third-party package to support password complexity and
> >     expiration
> >      >     date,
> >      >      > etc., when setting up open-source PostgreSQL. I am using
> the
> >      >      > credcheck--2.8.0.sql version from GitHub. After completin=
g
> the
> >      >     setup, I
> >      >      > encountered the following issue: when an account exceeds
> the
> >      >     configured
> >      >      > number of incorrect login attempts, it gets locked. The
> >     command
> >      >     SELECT *
> >      >      > FROM pg_banned_role; should display the columns roleid,
> >      >     failure_count,
> >      >      > and banned_date, and the view is working properly and
> >     shows the
> >      >      > information. However, according to the example, the rolei=
d
> >     does not
> >      >      > correctly display the corresponding oid for the account
> >     with failed
> >      >      > login attempts. I would like to ask if there is a solutio=
n
> >     for this
> >      >      > issue. Thank you!
> >      >
> >      >     Have you looked a?:
> >      >
> >      > https://github.com/HexaCluster/credcheck/issues/39
> >     <https://github.com/HexaCluster/credcheck/issues/39>
> >      >     <https://github.com/HexaCluster/credcheck/issues/39
> >     <https://github.com/HexaCluster/credcheck/issues/39>>
> >      >
> >      >     --
> >      >     Adrian Klaver
> >      > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> >     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com
> >>
> >      >
> >
> >     --
> >     Adrian Klaver
> >     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

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

<div dir=3D"auto">Thank you for your help.Problem solved!</div><div><br><di=
v class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Adrian Klaver=
 &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com=
</a>&gt;=E6=96=BC 2024=E5=B9=B411=E6=9C=8820=E6=97=A5 =E9=80=B1=E4=B8=89=EF=
=BC=8C=E4=B8=8B=E5=8D=8812:04=E5=AF=AB=E9=81=93=EF=BC=9A<br></div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-widt=
h:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,20=
4,204)">On 11/19/24 19:01, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote:<br>
&gt; Thank you for your help!After applying the patch, the above issue has =
<br>
&gt; been resolved.<br>
&gt; <br>
&gt;=C2=A0 =C2=A0I have another question: After identifying who is in the b=
anned_role, <br>
&gt; the GitHub example uses the command SELECT pg_banned_role_reset(); to =
<br>
&gt; unlock everyone. I would like to know if there is a way to unlock a <b=
r>
&gt; specific individual rather than unlocking everyone.<br>
<br>
It&#39;s in the docs:<br>
<br>
<a href=3D"https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#ex=
amples" rel=3D"noreferrer" target=3D"_blank">https://github.com/hexacluster=
/credcheck?tab=3Dreadme-ov-file#examples</a><br>
<br>
Authentication failure ban<br>
<br>
&quot;A superuser can also reset the content of the banned user cache by <b=
r>
calling a function named public.pg_banned_role_reset(). If it is called <br=
>
without an argument, all the banned cache will be cleared. To only <br>
remove the record registered for a single user, just pass his name as <br>
parameter. This function returns the number of records removed from the <br=
>
cache. A restart of PostgreSQL also clear the cache.&quot;<br>
<br>
I would suggest reading the entire documentation.<br>
<br>
&gt; <br>
&gt; Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a> <br>
&gt; &lt;mailto:<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_bla=
nk">adrian.klaver@aklaver.com</a>&gt;&gt;=E6=96=BC 2024=E5=B9=B411=E6=9C=88=
20=E6=97=A5 =E9=80=B1=E4=B8=89=EF=BC=8C=E4=B8=8A=E5=8D=8812:25=E5=AF=AB=E9=
=81=93=EF=BC=9A<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0On 11/19/24 00:40, =E5=BC=B5=E5=AE=B8=E7=91=8B wrot=
e:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; Sorry for the inconvenience, but I used make =
and make install to<br>
&gt;=C2=A0 =C2=A0 =C2=A0build<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; the credcheck--2.8.0.sql sources zip file. I =
would like to ask<br>
&gt;=C2=A0 =C2=A0 =C2=A0how I can<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; update and apply the changes to the system, a=
s I modified the<br>
&gt;=C2=A0 =C2=A0 =C2=A0files in<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; credcheck/test/expected/06_reuse_interval.out=
 and<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; credcheck/test/sql/06_reuse_interval.sql. How=
ever, after running<br>
&gt;=C2=A0 =C2=A0 =C2=A0make<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; and make install again, I don=E2=80=99t see a=
ny changes.<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0Pretty sure you need to do:<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0make clean<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0first, then the rest of the install process.<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0That process is shown here:<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0<a href=3D"https://github.com/hexacluster/credcheck=
?tab=3Dreadme-ov-file#installation" rel=3D"noreferrer" target=3D"_blank">ht=
tps://github.com/hexacluster/credcheck?tab=3Dreadme-ov-file#installation</a=
> &lt;<a href=3D"https://github.com/hexacluster/credcheck?tab=3Dreadme-ov-f=
ile#installation" rel=3D"noreferrer" target=3D"_blank">https://github.com/h=
exacluster/credcheck?tab=3Dreadme-ov-file#installation</a>&gt;<br>
&gt; <br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; Adrian Klaver &lt;<a href=3D"mailto:adrian.kl=
aver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a><br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;mailto:<a href=3D"mailto:adrian.klaver@aklaver.=
com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; &lt;mailto:<a href=3D"mailto:adrian.klaver@ak=
laver.com" target=3D"_blank">adrian.klaver@aklaver.com</a><br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;mailto:<a href=3D"mailto:adrian.klaver@aklaver.=
com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;&gt;&gt;=E6=96=BC 2=
024=E5=B9=B411=E6=9C=8818=E6=97=A5 =E9=80=B1=E4=B8=80=EF=BC=8C=E4=B8=8B=E5=
=8D=88<br>
&gt;=C2=A0 =C2=A0 =C2=A011:15=E5=AF=AB=E9=81=93=EF=BC=9A<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0On 11/18/24 01:03, =E5=BC=
=B5=E5=AE=B8=E7=91=8B wrote:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; Hello!<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 I would=
 like to inquire about the installation of the<br>
&gt;=C2=A0 =C2=A0 =C2=A0credcheck<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; third-party package =
to support password complexity and<br>
&gt;=C2=A0 =C2=A0 =C2=A0expiration<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0date,<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; etc., when setting u=
p open-source PostgreSQL. I am using the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; credcheck--2.8.0.sql=
 version from GitHub. After completing the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0setup, I<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; encountered the foll=
owing issue: when an account exceeds the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0configured<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; number of incorrect =
login attempts, it gets locked. The<br>
&gt;=C2=A0 =C2=A0 =C2=A0command<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0SELECT *<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; FROM pg_banned_role;=
 should display the columns roleid,<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0failure_count,<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; and banned_date, and=
 the view is working properly and<br>
&gt;=C2=A0 =C2=A0 =C2=A0shows the<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; information. However=
, according to the example, the roleid<br>
&gt;=C2=A0 =C2=A0 =C2=A0does not<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; correctly display th=
e corresponding oid for the account<br>
&gt;=C2=A0 =C2=A0 =C2=A0with failed<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; login attempts. I wo=
uld like to ask if there is a solution<br>
&gt;=C2=A0 =C2=A0 =C2=A0for this<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0 &gt; issue. Thank you!<br=
>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0Have you looked a?:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; <a href=3D"https://github.com/HexaCluster/cre=
dcheck/issues/39" rel=3D"noreferrer" target=3D"_blank">https://github.com/H=
exaCluster/credcheck/issues/39</a><br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;<a href=3D"https://github.com/HexaCluster/credc=
heck/issues/39" rel=3D"noreferrer" target=3D"_blank">https://github.com/Hex=
aCluster/credcheck/issues/39</a>&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0&lt;<a href=3D"https://git=
hub.com/HexaCluster/credcheck/issues/39" rel=3D"noreferrer" target=3D"_blan=
k">https://github.com/HexaCluster/credcheck/issues/39</a><br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;<a href=3D"https://github.com/HexaCluster/credc=
heck/issues/39" rel=3D"noreferrer" target=3D"_blank">https://github.com/Hex=
aCluster/credcheck/issues/39</a>&gt;&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0--<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;=C2=A0 =C2=A0 =C2=A0Adrian Klaver<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt; <a href=3D"mailto:adrian.klaver@aklaver.com" =
target=3D"_blank">adrian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"mailt=
o:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a=
>&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0&lt;mailto:<a href=3D"mailto:adrian.klaver@aklaver.=
com" target=3D"_blank">adrian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"=
mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.c=
om</a>&gt;&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 &gt;<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0-- <br>
&gt;=C2=A0 =C2=A0 =C2=A0Adrian Klaver<br>
&gt;=C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a> &lt;mailto:<a href=3D"mailto:adri=
an.klaver@aklaver.com" target=3D"_blank">adrian.klaver@aklaver.com</a>&gt;<=
br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div></div>

--0000000000009b99800627527a93--






