STIGQter: STIG Summary: VMware vSphere 8.0 vCenter Appliance PostgreSQL Security Technical Implementation Guide Version: 1 Release: 1 Benchmark Date: 31 Oct 2023:

The vCenter PostgreSQL service must generate audit records.

DISA Rule

SV-259169r935411_rule

Vulnerability Number

V-259169

Group Title

SRG-APP-000091-DB-000066

Rule Version

VCPG-80-000007

Severity

CAT II

CCI(s)

• CCI-000172 - Generate audit records for the event types defined in AU-2 c that include the audit record content defined in AU-3.

Weight

10

Fix Recommendation

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

Check Contents

At the command prompt, run the following commands:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_catalog;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_parameter;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_statement_once;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_level;"

If "pgaudit.log_catalog" is not set to "on", this is a finding.

If "pgaudit.log" is not set to "all, -misc", this is a finding.

If "pgaudit.log_parameter" is not set to "on", this is a finding.

If "pgaudit.log_statement_once" is not set to "off", this is a finding.

If "pgaudit.log_level" is not set to "log", this is a finding.

Vulnerability Number

V-259169

Documentable

False

Rule Version

VCPG-80-000007

Severity Override Guidance

At the command prompt, run the following commands:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_catalog;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_parameter;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_statement_once;"
# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW pgaudit.log_level;"

If "pgaudit.log_catalog" is not set to "on", this is a finding.

If "pgaudit.log" is not set to "all, -misc", this is a finding.

If "pgaudit.log_parameter" is not set to "on", this is a finding.

If "pgaudit.log_statement_once" is not set to "off", this is a finding.

If "pgaudit.log_level" is not set to "log", this is a finding.

Check Content Reference

M

Target Key

5570