TMA-MYSQL-9.2

Ensure 'SOURCE_SSL_VERIFY_SERVER_CERT' is Set to 'YES' or '1'

高等級 1自動化mysql

說明

In the MySQL REPLICA (SLAVE is deprecated as of 8.0.22) context the setting SOURCE_SSL_VERIFY_SERVER_CERT (MASTER_SSL_VERIFY_SERVER_CERT is deprecated as of 8.0.22) indicates whether the REPLICA should verify the SOURCE's certificate. This configuration item may be set to Yes or No, and unless SSL has been enabled on the REPLICA, the value will be ignored. Counts replication channels that do not verify the source certificate; passes on servers that are not replicas. Runs mysql -NBe with the client defaults: put an administrative account in ~/.my.cnf (mode 0600) or a mysql_config_editor login path, not MYSQL_PWD (see 1.4/1.6).

檢查方式

稽核方法: SQL 查詢

sql_query

out=$(mysql -NBe "SELECT COUNT(*) FROM mysql.slave_master_info WHERE Ssl_verify_server_cert <> 1" 2>/dev/null) || exit 1; printf '%s\n' "$out"

預期輸出: 0

修補方式

修補方法: 操作指南或基礎設施修補檔

STOP REPLICA; CHANGE REPLICATION SOURCE TO SOURCE_SSL_VERIFY_SERVER_CERT = 1; START REPLICA;

屬性

作業系統: 不限
標籤: mysqldatabasereplicationtls
參考資料: CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 9.2 Ensure 'SOURCE_SSL_VERIFY_SERVER_CERT' is Set to 'YES' or '1'

檢查此主機

請在您有權稽核的機器上執行此指令。掃描為唯讀操作。

shell

tmaegis scan --target mysql