Feedback-ID: i76984098:Fastmail
Message-ID: <bc81b050-b072-4e09-aac6-be57ca4a0df1@aklaver.com>
Date: Mon, 18 Nov 2024 07:15:30 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Re : Credcheck extension
To: =?UTF-8?B?5by15a6455GL?= <kenny020307@gmail.com>,
 pgsql-general@lists.postgresql.org
References: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/bc81b050-b072-4e09-aac6-be57ca4a0df1%40aklaver.com>
Precedence: bulk

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