title: MySQL and SSL connection failing ERROR 2026 (HY000)
body: <p>I have a wildcard cert issued from rapidssl, using CN=*.mydomain.com. I have a web server and a mysql db server. The certs are working fine for web site access. Now I want to enable ssl for my app to mysql. I've enabled ssl in the mysql server without issue:</p>
  
  <pre><code>+---------------+---------------------------------+
  | Variable_name | Value                           |
  +---------------+---------------------------------+
  | have_openssl  | YES                             |
  | have_ssl      | YES                             |
  </code></pre>
  
  <p>However, when I try to connect using the client/ssl, I get:
  ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)</p>
  
  <p>This appears to be documented here:
  <a href="http://dev.mysql.com/doc/refman/5.5/en/creating-ssl-certs.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.5/en/creating-ssl-certs.html</a></p>
  
  <p>It says I can't use the same CN for the certs. I don't understand how a wildcard cert can be used then. Does that mean I also have to purchase host specific certs just for the mysql connection?</p>
  
  <p>I don't work with SSL very much so I'm finding it difficult figuring out how this is supposed to be set up. Any pointers, even obvious ones, will likely help at this stage.</p>
  
  <p>Running:
  mysql  Ver 15.1 Distrib 5.5.32-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1
  ubuntu 12.04</p>