Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.)

share|improve this question
    
What OS? If GNU/Linux, which distro? –  MadHatter Feb 11 '13 at 16:36
    
It is on Debian squeeze (I will update my question). –  user35042 Feb 11 '13 at 16:47

4 Answers 4

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

#ldd mysqld
share|improve this answer

Run

ldd `which mysqld`|grep ssl

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

share|improve this answer
    
Unfortunately, that command yielded nothing. –  user35042 Feb 11 '13 at 16:49
    
Then maybe your MySQL not compiled with SSL support, check out 3rd section here: dev.mysql.com/doc/refman/5.0/en/configuring-for-ssl.html try –  Stone Feb 11 '13 at 16:51
    
That was a good suggestion; it seems that my MySQL supports SSL but the have_ssl variable is DISABLED; I think there is something wrong with my MySQL installation or binary. –  user35042 Feb 11 '13 at 17:17
    
I got MySQL to work with SSL but there are no libraries linked in with mysqld that match ssl, –  user35042 Feb 12 '13 at 0:32

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.