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"
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--