pgpool2.git / summary / log / commit / refs

commit    5bc38fe12a03da0397fbfe3b1e20595ba0d332f1
Author:   Tatsuo Ishii <ishii@sraoss.co.jp>
Date:     Sat May 23 03:59:47 2020 +0000

    Enhance scram/md5 auth regression test to use AES256 encrypted password.
    
    021.pool_passwd_auth used plain text password in pool_passwd. AES256
    encrypted password is more appropriate for the real world use case.


 src/test/regression/tests/021.pool_passwd_auth/test.sh | 14 +++++++++++---
 1 file changed, 11 insertions(+), 3 deletions(-)

diff --git a/src/test/regression/tests/021.pool_passwd_auth/test.sh b/src/test/regression/tests/021.pool_passwd_auth/test.sh
index bf3e292b0..b1c4c4540 100755
--- a/src/test/regression/tests/021.pool_passwd_auth/test.sh
+++ b/src/test/regression/tests/021.pool_passwd_auth/test.sh
@@ -33,9 +33,17 @@ echo "allow_clear_text_frontend_auth = off" >> etc/pgpool.conf
 echo "num_init_children = 1" >> etc/pgpool.conf
 echo "enable_pool_hba = on" >> etc/pgpool.conf
 
-#create pool_passwd file
-echo "scram_user:scram_password" >> etc/pool_passwd
-echo "md5_user:md5_password" >> etc/pool_passwd
+# create pgpoolkey file
+echo "pgpool secret key" > etc/pgpool_key
+chmod 0600 etc/pgpool_key
+export PGPOOLKEYFILE=$PWD/etc/pgpool_key
+
+#create pool_passwd file using AES256 encrypted password
+#echo "scram_user:scram_password" >> etc/pool_passwd
+#echo "md5_user:md5_password" >> etc/pool_passwd
+pg_enc -m -f etc/pgpool.conf -u scram_user scram_password
+pg_enc -m -f etc/pgpool.conf -u md5_user md5_password
+
 #copy the pool_hba to etc dir
 cp ../pool_hba.conf etc/
 ./startall


[parent: d1330ae3cbe7]