Debian Codegraph @

mysql-test/suite/auth_sec/t/admin_ssl_crl.test

raw
1 --source include/allowed_ciphers.inc
2
3 CREATE USER admin_user IDENTIFIED BY 'abcd';
4 GRANT SERVICE_CONNECTION_ADMIN ON *.* TO admin_user;
5
6 --echo # test --crl for the client : should connect
7 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
8 --replace_regex $ALLOWED_CIPHERS_REGEX
9 --exec $MYSQL -uadmin_user -pabcd --host=127.0.0.1 --port=$MASTER_ADMINPORT --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/crl-ca-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/crl-client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/crl-client-cert.pem test --ssl-crl=$MYSQL_TEST_DIR/std_data/crl-client-revoked.crl -e "SELECT 1;"
10
11 --echo # test --crlpath for the client : should connect
12 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
13 --replace_regex $ALLOWED_CIPHERS_REGEX /$MYSQL_TEST_DIR/MYSQL_TEST_DIR/
14 --exec $MYSQL -uadmin_user -pabcd --host=127.0.0.1 --port=$MASTER_ADMINPORT --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/crl-ca-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/crl-client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/crl-client-cert.pem --ssl-crlpath=$MYSQL_TEST_DIR/std_data/crldir test -e "SELECT 1;"
15
16 --echo # try logging in with a certificate in the server's --ssl-crl : should fail
17 --error 1
18 --exec $MYSQL -uadmin_user -pabcd --host=127.0.0.1 --port=$MASTER_ADMINPORT --ssl-mode=VERIFY_CA --ssl-ca=$MYSQL_TEST_DIR/std_data/crl-ca-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/crl-client-revoked-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/crl-client-revoked-cert.pem test -e "SELECT 1;"
19
20 --connection default
21 DROP USER admin_user;