The vRA PostgreSQL database must set the log_min_messages to warning.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-89429	VRAU-PG-000430	SV-100079r1_rule		Medium

Description
For completeness of forensic analysis, it is necessary to track failed attempts to log on to the DBMS. While positive identification may not be possible in a case of failed authentication, as much information as possible about the incident must be captured.

STIG	Date
VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide	2018-10-12

Details

Check Text ( C-89121r2_chk )
At the command prompt, execute the following command: # grep '^\s*log_min_messages\b' /storage/db/pgdata/postgresql.conf If "log_min_messages" is not "warning", this is a finding.

Fix Text (F-96171r1_fix)
At the command prompt, execute the following commands: # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET log_min_messages TO 'warning';" # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT pg_reload_conf();"