TMA-YUGABYTEDB-5.6

Ensure ysql_enable_auth is set to true

严重级别 1自动化yugabytedb

说明

The ysql_enable_auth GFlag controls whether password authentication is required for YSQL connections. When set to false (the default), connections are accepted without authentication, which is only appropriate for isolated development environments. In all other environments, this flag must be enabled to enforce password-based access control for the YSQL interface. Reads the YB-TServer GFlags from the web UI at ${YB_TSERVER_WEB:-127.0.0.1:9000}/varz; run it against every TServer. Passes when ysql_enable_auth=true.

检查方式

审计方法: Shell 命令

shell

out=$(curl -sf "http://${YB_TSERVER_WEB:-127.0.0.1:9000}/varz?raw=1" 2>/dev/null) || exit 1; if printf '%s\n' "$out" | grep -qE -- '--ysql_enable_auth=(true)([^[:alnum:]_]|$)'; then echo compliant; else echo noncompliant; fi

预期输出: compliant

修复方式

修复方法: 操作指南或基础设施补丁

Add --ysql_enable_auth=true to every YB-TServer startup configuration and restart it; then change the default yugabyte password (5.7).

属性

操作系统: 任意
标签: yugabytedbauthentication
参考: CIS YugabyteDB Benchmark v2.0.0 - 5.6 Ensure ysql_enable_auth is set to true

检查本机

请在您有权审计的机器上运行此命令。扫描为只读操作。

shell

tmaegis scan --target yugabytedb