Changes are coming to https://stigviewer.com.
Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey
The vRA PostgreSQL database must set log_connections to on.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
|---|---|---|---|---|
| V-240325 | VRAU-PG-000425 | SV-240325r879874_rule | Medium |
| Description |
|---|
| For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to the DBMS. |
| STIG | Date |
|---|---|
| VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide | 2023-09-20 |
Details
| Check Text ( C-43558r668817_chk ) |
|---|
| At the command prompt, execute the following command: # grep '^\s*log_connections\b' /storage/db/pgdata/postgresql.conf If log_connections is not on, this is a finding. |
| Fix Text (F-43517r668818_fix) |
|---|
| At the command prompt, execute the following commands: # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET log_connections TO 'on';" # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT pg_reload_conf();" |