Debian Codegraph @

mysql-test/suite/auth_sec/include/set_ciphers.inc

raw
1 #
2 # Usage:
3 # --let $CIPHER_DB = <db>
4 # --let $CIPHER_TABLE = <table>
5 # --let $TLS_VERSION = "TLSv1.2" or "TLSv1.3"
6 # --let $BLOCKED_CIPHERS = 0 or 1
7 # --let #OPENSSL_102 = 0 or 1
8 #
9 # --source ../inc/set_ciphers.inc
10 #
11
12 --let $records = `SELECT JSON_LENGTH(ciphers) FROM $cipher_db.$cipher_table`
13 if ($records != "") {
14 --let $i = 0
15 --disable_query_log
16 --eval SELECT JSON_UNQUOTE(JSON_EXTRACT(ciphers, '$[$i]')) FROM $cipher_db.$cipher_table INTO @ciphers
17 --inc $i
18 while ($i < $records) {
19 --eval SELECT CONCAT(@ciphers, ':', JSON_UNQUOTE(JSON_EXTRACT(ciphers, '$[$i]'))) FROM $cipher_db.$cipher_table INTO @ciphers
20 --inc $i
21 }
22
23 --let $CIPHERS = `SELECT @ciphers`
24 --echo # Setting server ciphers: $CIPHERS
25 SELECT @@global.ssl_cipher INTO @saved_ciphers;
26 SELECT @@global.tls_ciphersuites INTO @saved_ciphersuites;
27 SELECT @@global.admin_ssl_cipher INTO @saved_admin_ciphers;
28 SELECT @@global.admin_tls_ciphersuites INTO @saved_admin_ciphersuites;
29
30 if ($TLS_VERSION == "TLSv1.2") {
31 SET GLOBAL ssl_cipher=@ciphers;
32 SET GLOBAL admin_ssl_cipher=@ciphers;
33 }
34
35 if ($TLS_VERSION == "TLSv1.3") {
36 SET GLOBAL tls_ciphersuites=@ciphers;
37 SET GLOBAL admin_tls_ciphersuites=@ciphers;
38 }
39
40 if ($BLOCKED_CIPHERS == 0) {
41 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
42 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
43 }
44 if ($BLOCKED_CIPHERS == 1) {
45 --error ER_DA_SSL_LIBRARY_ERROR
46 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
47 --error ER_DA_SSL_LIBRARY_ERROR
48 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
49
50 # Reset ciphers to last known good values
51 if ($TLS_VERSION == "TLSv1.2") {
52 SET GLOBAL ssl_cipher=@saved_ciphers;
53 SET GLOBAL admin_ssl_cipher=@saved_admin_ciphers;
54 }
55 if ($TLS_VERSION == "TLSv1.3") {
56 SET GLOBAL tls_ciphersuites=@saved_ciphersuites;
57 SET GLOBAL admin_tls_ciphersuites=@saved_admin_ciphersuites;
58 }
59 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
60 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
61 }
62 --enable_query_log
63 }