You can read about configuring your MemSQL cluster to use SSL here: https://docs.memsql.com/security/v6.0/ssl/
ERROR 2026 (HY000): SSL connection error: SSL is required but the server doesn't support it
This error occurs when a user attempts to create a connection into the affected memsql node AND one of the following is true:
- The user has not added the required SSL configurations to the memsql.cnf file
- OR the user has added the required SSL configurations to the memsql.cnf file but has NOT restarted the target memsql node.
master-agg-and-leaf-ip-10-0-0-50 /ebs/memsql/master-3306-MI04cf7e86 $ memsql -uroot -h0 --ssl-ca=/tmp/certs/ca-cert.pem
ERROR 2026 (HY000): SSL connection error: SSL is required but the server doesn't support it
Solutions:
- Check to make sure the correct ssl configurations have been written to the memsql.cnf file of the target memsql node
- Check to make sure the target memsql node has been restarted since updating its memsql.cnf file
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed
This error occurs when the incorrect path is provided for the ca-cert-pem file when using the --ssl-ca flag in the connection string to the MemSQL node.
master-agg-and-leaf-ip-10-0-2-239 /ebs/memsql/master-3306 $ mysql -uroot -h0 --ssl-ca=ca-cert.pem
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed
Solution:
- Verify you are using the correct path to the ca-cert.pem file.