SV-259176r1015952_rule
V-259176
SRG-APP-000171-DB-000074
VCPG-80-000038
CAT I
10
A script is included with vCenter to generate a PostgreSQL STIG configuration.
At the command prompt, run the following commands:
# chmod +x /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py
# /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py --action stig_enable --pg-data-dir /storage/db/vpostgres
# chmod -x /opt/vmware/vpostgres/current/bin/vmw_vpg_config/vmw_vpg_config.py
Restart the PostgreSQL service by running the following command:
# vmon-cli --restart vmware-vpostgres
At the command prompt, run the following command:
$ /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW password_encryption;"
Expected result:
scram-sha-256
If the output does not match the expected result, this is a finding.
Note: Prior to Update 2, "md5" is the expected result.
V-259176
False
VCPG-80-000038
At the command prompt, run the following command:
$ /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW password_encryption;"
Expected result:
scram-sha-256
If the output does not match the expected result, this is a finding.
Note: Prior to Update 2, "md5" is the expected result.
M
5570