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

高レベル 1手動レビューyugabytedb

説明

A large number of authentication METHODs are available for hosts connecting using TCP/IP sockets, including: - trust - reject - md5 - scram-sha-256 - password - gss - sspi - ident - pam - ldap - radius - cert METHODs trust, password, and ident are not to be used for remote logins.

チェック方法

監査方法: 手動レビュー

この推奨事項は自動ではチェックできません。--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.

修正方法

修正方法: ガイダンスまたは IaC パッチ

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.

プロパティ

オペレーティングシステム: すべて
タグ: yugabytedbauthentication
参照: CIS YugabyteDB Benchmark v2.0.0 - 6.2 Ensure login via "host" TCP/IP Socket is configured correctly