mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-03 20:36:16 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			21 lines
		
	
	
	
		
			717 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			21 lines
		
	
	
	
		
			717 B
		
	
	
	
		
			Text
		
	
	
	
	
	
create procedure have_ssl()
 | 
						|
select if(variable_value > '','yes','no') as 'have_ssl'
 | 
						|
  from information_schema.session_status
 | 
						|
where variable_name='ssl_cipher';
 | 
						|
mysql --ssl-ca=cacert.pem -e "call test.have_ssl()"
 | 
						|
have_ssl
 | 
						|
no
 | 
						|
mysql --ssl -e "call test.have_ssl()"
 | 
						|
have_ssl
 | 
						|
no
 | 
						|
mysql --ssl-ca=cacert.pem --ssl-verify-server-cert -e "call test.have_ssl()"
 | 
						|
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
 | 
						|
mysql --ssl --ssl-verify-server-cert -e "call test.have_ssl()"
 | 
						|
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
 | 
						|
#
 | 
						|
# MDEV-27105 --ssl option set as default for mariadb CLI
 | 
						|
#
 | 
						|
mysql -e "call test.have_ssl()"
 | 
						|
have_ssl
 | 
						|
no
 | 
						|
drop procedure have_ssl;
 |