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 enable "pgaudit" to provide audit record generation capabilities.

DISA Rule

SV-259167r935405_rule

Vulnerability Number

V-259167

Group Title

SRG-APP-000089-DB-000064

Rule Version

VCPG-80-000005

Severity

CAT II

CCI(s)

• CCI-000169 - Provide audit record generation capability for the event types the system is capable of auditing as defined in AU-2 a. on organization-defined information system components.

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 command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW shared_preload_libraries;"

Example result:

health_status_worker,pg_stat_statements,pgaudit

If the output from the command does not include pgaudit, this is a finding.

Vulnerability Number

V-259167

Documentable

False

Rule Version

VCPG-80-000005

Severity Override Guidance

At the command prompt, run the following command:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -A -t -c "SHOW shared_preload_libraries;"

Example result:

health_status_worker,pg_stat_statements,pgaudit

If the output from the command does not include pgaudit, this is a finding.

Check Content Reference

M

Target Key

5570