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.
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!