Ensure login via "host" TCP/IP Socket is configured correctly

How it is checked

Audit method: Manual review

This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.

Test TCP logins: ysqlsh 'host=localhost user=yugabyte sslmode=disable' and 'sslmode=require', then repeat from a remote host. Every host rule in the HBA configuration (--ysql_hba_conf_csv / pg_hba_file_rules) must require a strong method (scram-sha-256 or cert), unencrypted sessions should be rejected (hostssl), and failed attempts must be logged.

How it is fixed

Fix method: Guidance or infrastructure patch

Confirm a login attempt has been made by looking for a logged error message detailing the nature of the authenticating failure. In the case of failed login attempts, whether encrypted or unencrypted, check the following: - The server should be sitting on a port exposed to the remote connecting host i.e.