Re: Re : Credcheck extension

2024-11-20 Thread Adrian Klaver
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

Re: Re : Credcheck extension

2024-11-19 Thread 張宸瑋
Thank you for your help.Problem solved! Adrian Klaver 於 2024年11月20日 週三,下午12:04寫道: > 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 Gi

Re: Re : Credcheck extension

2024-11-19 Thread Adrian Klaver
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 kno

Re: Re : Credcheck extension

2024-11-19 Thread 張宸瑋
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 spec

Re: Re : Credcheck extension

2024-11-19 Thread 張宸瑋
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_interv

Re: Re : Credcheck extension

2024-11-18 Thread Adrian Klaver
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 completin

Re: Re : Credcheck extension

2024-11-18 Thread Julien Rouhaud
Hi, On Mon, Nov 18, 2024 at 5:03 PM 張宸瑋 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

Re : Credcheck extension

2024-11-18 Thread 張宸瑋
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 follo