/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


MySQL command line for access database K1000 with SSL

08/06/2017 1436 views
I create SSL use Digicert and I have activated Enable database access and Enable Secure database access (SSL) in K1000. I have create MySQL command line in Windows cmd to access database K1000.

1. If i run command line mysql -N -u R12 -pXXXXXX -h XXXXXXXXX.XXX -e "SQL query" ORG12 I succed connect to database kace and get result what i want.
2. After enable Enable Secure database access (SSL) in K1000 i get ca certificate and i save in ca.pem. If run command line mysql --ssl-ca="ca.pem" -N -u R12 -pXXXXXX -h XXXXXXXXX.XXX -e "SQL query" ORG12 I get result Error 2026 (HY000): SSL connection error. How to connect to database kace with SSL?

ADb91F.jpeg
0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ