Advertisement
Guest User

Untitled

a guest
May 9th, 2016
743
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. mysql> show variables like "%ssl%";
  2. +---------------+--------------------------------------+
  3. | Variable_name | Value |
  4. +---------------+--------------------------------------+
  5. | have_openssl | YES |
  6. | have_ssl | YES |
  7. | ssl_ca | /etc/mysql/ssl-mysql/ca-cert.pem |
  8. | ssl_capath | |
  9. | ssl_cert | /etc/mysql/ssl-mysql/server-cert.pem |
  10. | ssl_cipher | |
  11. | ssl_key | /etc/mysql/ssl-mysql/server-key.pem |
  12. +---------------+--------------------------------------+
  13.  
  14. $ mysql -h 1.2.3.4 --ssl-ca=/etc/mysql/ssl-mysql/ca-cert.pem --ssl-cert=/etc/mysql/ssl-mysql/client-cert.pem --ssl-key=/etc/mysql/ssl-mysql/client-key.pem -u root -p
  15. Enter password:
  16. ERROR 2026 (HY000): SSL connection error
  17.  
  18. SSL error: Unable to get certificate from '/etc/mysql/ssl-mysql/client-cert.pem'
  19. [ERROR] Slave I/O: error connecting to master 'replica@1.2.3.4:3306' - retry-time: 60 retries: 1, Error_code:2026
  20.  
  21. mysql -h 1.2.3.4 --ssl-ca=/etc/mysql/ssl-mysql/ca-cert.pem -u replica -p
  22.  
  23. mysql> s
  24. --------------
  25. mysql Ver 14.14 Distrib 5.6.27, for Linux (x86_64) using EditLine wrapper
  26.  
  27. Connection id: 6873
  28. Current database:
  29. Current user: replica@1.2.3.5
  30. SSL: Cipher in use is DHE-RSA-AES256-SHA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement