Results 1 to 10 of 10

Thread: mysql ssl won't enable

Threaded View

  1. #1
    Join Date
    Apr 2009
    Beans
    7

    Talking [solved] mysql ssl won't enable

    I'm trying to get SSL enabled for MySQL on one of my servers. I have it enabled on my other server and it was easy enough to do. But for whatever reason, mysqld on this server just won't cooperate. Here's what

    Code:
    show variables like "%ssl%";
    gives me:
    Code:
    +---------------+-----------------------+
    | Variable_name | Value                 |
    +---------------+-----------------------+
    | have_openssl  | DISABLED              |
    | have_ssl      | DISABLED              |
    | ssl_ca        | /etc/mysql/ca.crt     |
    | ssl_capath    |                       |
    | ssl_cert      | /etc/mysql/server.crt |
    | ssl_cipher    | DHE-RSA-AES256-SHA    |
    | ssl_key       | /etc/mysql/server.key |
    +---------------+-----------------------+
    I've tried verifying my certificate:
    Code:
    $ openssl verify -verbose  -CAfile ca.crt server.crt
    server.crt: OK
    And I've tried copying the keys and ssl config to the other server (it works).

    Here's the relevant section of my.cnf:
    Code:
    #ssl
    ssl-ca=/etc/mysql/ca.crt
    ssl-cert=/etc/mysql/server.crt
    ssl-key=/etc/mysql/server.key
    ssl-cipher=DHE-RSA-AES256-SHA
    I've tried uncommenting the top "ssl" line but it has no effect. I know this will turn out to be some silly little thing that's been staring me in the face, and any hints, tips, or trick will be greatly appreciated.
    Last edited by reverendryan; April 10th, 2009 at 06:47 PM.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •