Home / server / Questions / 477677
Accepted
user35042
Asked: 2013-02-12 08:33:04 +0800 CST

How to determine which SSL library MySQL is using?

  • 772

My Debian squeeze server is running mysqld version 5.1. How do I determine if the SSL libraries it is using are OpenSSL or yaSSL?

(I am pretty sure this MySQL supports SSL as the User table has the ssl_type column.)

mysql

4 Answers

  1. Best Answer

    Run LDD on the MySql executable to see what it is linked against.

    #ldd mysqld
    • 3

  2. If you want to know from within MySQL you can check the status variable Rsa_public_key as it only exists in builds with OpenSSL:

    SHOW STATUS LIKE 'Rsa_public_key';

    (See the relevant documentation: http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html#statvar_Rsa_public_key)

    PS: Currently, the MySQL Community Edition binaries built by MySQL are using yaSSL, but e.g. Percona XtraDB Cluster binaries are built using OpenSSL. YMMV

    • 1

  3. Run

    ldd `which mysqld`|grep ssl

    it will show that your MySQL is linked to witch SSL library.

    • 0

  4. According to this blog post, the MySQL packages in Debian don't include TLS support due to licensing issues. That post is fairly old, but based on the mysql-server-core-5.1 package not having a dependency on OpenSSL or GnuTLS I suspect that this is still true.

    • 0