Re: Re : Credcheck extension - Mailing list pgsql-general

From 張宸瑋
Subject Re: Re : Credcheck extension
Date
Msg-id CAFsaSDgHR5mNZAsMUP-_y7Dj2bh572pgFNmLjxR5k5CJV-UmkQ@mail.gmail.com
Whole thread Raw
In response to Re: Re : Credcheck extension  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Re : Credcheck extension
List pgsql-general
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.


Adrian Klaver <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

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Default session role broken in PostgreSQL 14.14?
Next
From: Moreno Andreo
Date:
Subject: Re: Functions and Indexes