Ensure that auditing is enabled for YCQL

MediaNivel 2Automatizadayugabytedb

Descripción

Audit logging can be used to record information about YCQL statements or events (such as login events) and log the records on a per-node basis into the YB-Tserver logs. Audit logging can be enabled on YugabyteDB cluster by setting the ycql_enable_audit_log TServer flag to true. By default, each TServer records all login events and YCQL commands issued to the server. The benchmark rates this recommendation Manual; the automated check covers its objective pass criterion. 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 ycql_enable_audit_log=true.

Cómo se verifica

Método de auditoría: Comando de 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 -- '--ycql_enable_audit_log=(true)([^[:alnum:]_]|$)'; then echo compliant; else echo noncompliant; fi

Salida esperada: compliant

Cómo se corrige

Método de corrección: Guía o parche de infraestructura

Add --ycql_enable_audit_log=true to every YB-TServer and restart it.

Propiedades

Sistemas operativos: Cualquiera
Etiquetas: yugabytedbloggingaudit
Referencia: CIS YugabyteDB Benchmark v2.0.0 - 3.3 Ensure that auditing is enabled for YCQL

Verificar este host

Ejecute esto en un equipo que tenga permiso para auditar. El escaneo es de solo lectura.

shell

tmaegis scan --target yugabytedb --level 2