The extension advanced_password_check creation failed with error "password is too short"

Products

• VMware Tanzu Greenplum

Issue/Introduction

When creating extension advanced_password_check, it failed with error "password is too short":

[gpadmin@hostname][~]$ gpconfig -s shared_preload_libraries;
Values on all segments are consistent
GUC          : shared_preload_libraries
Master  value: metrics_collector,advanced_password_check
Segment value: metrics_collector,advanced_password_check
[gpadmin@support-gpddb6-mdw][~]$ psql
Timing is on.
psql (9.4.26)
Type "help" for help.

gpadmin=# create extension advanced_password_check;
ERROR:  password is too short
Time: 11.084 ms 

It still makes no difference even if the minimum password length is set to 1:

[gpadmin@hostname][~]$ gpconfig -c advanced_password_check.minimum_length -v 1
20230815:09:26:25:029660 gpconfig:support-gpddb6-mdw:gpadmin-[INFO]:-completed successfully with parameters '-c advanced_password_check.minimum_length -v 1'

[gpadmin@hostname][~]$ gpstop -u
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Starting gpstop with args: -u
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.24.5 build commit:10a085a6f1e2915c651f8a1ea65314d4deac15a4'
20230815:09:26:28:029713 gpstop:support-gpddb6-mdw:gpadmin-[INFO]:-Signalling all postmaster processes to reload

[gpadmin@hostname][~]$ gpconfig -s advanced_password_check.minimum_length
Values on all segments are consistent
GUC          : advanced_password_check.minimum_length
Master  value: 1
Segment value: 1

[gpadmin@hostname][~]$ psql
Timing is on.
psql (9.4.26)
Type "help" for help.

gpadmin=# create extension advanced_password_check;
ERROR:  password is too short
Time: 9.897 ms 

 

Environment

Product Version: 6.23

Resolution

The issue should have been fixed in 6.25.1. The extension can be created with 6.25.1:

[gpadmin@hostname][~]$ gpconfig -s shared_preload_libraries;
Values on all segments are consistent
GUC          : shared_preload_libraries
Master  value: metrics_collector,advanced_password_check
Segment value: metrics_collector,advanced_password_check

[gpadmin@support-gpddb6-mdw][~]$ gpconfig -s advanced_password_check.minimum_length
Values on all segments are consistent
GUC          : advanced_password_check.minimum_length
Master  value: 8
Segment value: 8

[gpadmin@hostname][~]$ psql
Timing is on.
psql (9.4.26)
Type "help" for help.

gpadmin=# select version();
                                                                                                version                                                                                                
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.4.26 (Greenplum Database 6.25.1 build commit:337d85331f0330dea32d229f450da438d5e948f6) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Jul 19 2023 21:12:28
(1 row)

Time: 10.562 ms
gpadmin=# create extension advanced_password_check;
CREATE EXTENSION
Time: 15.211 ms 

Password check extension refer page: 
https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-modules-adv_passwd_check.html