MySQL Bugs: #18195: MySQL on Windows not built with YaSSL correctly

Bug #18195	MySQL on Windows not built with YaSSL correctly
Submitted:	13 Mar 2006 17:44	Modified:	16 Mar 2006 17:29
Reporter:	Mike Gent
Status:	Closed
Category:	Server: Compiling	Severity:	S2 (Serious)
Version:	5.0.19	OS:	Microsoft Windows (Windows)
Assigned to:	Magnus Svensson	Target Version:

Description:
The MySQL FAQ for SEC 1 and 2 say that most MySQL binaries have SSL support, but under
Windows it will not work. The problem is that 2 definitions are missing in the Visual
Studio files (.sln, .vcproj).

A custom build with the suggested fix will result in binaries and libraries that meet the
security needs as well as match up to what's being advertised.

How to repeat:
mysqld --ssl-ca=CA-cert.pem --ssl-cert=Localhost-cert.pem --ssl-key=Localhost-key.pem

060313 10:38:52 [ERROR] mysqld: unknown variable 'ssl-ca=CA-cert.pem'  

Suggested fix:
For each of the solution components, enable HAVE_OPENSSL and HAVE_YASSL under
Configuration Properties -> C/C++ -> Preprocessor -> Preprocessor Definitions.

libmysql
libmysqld
mysql
mysqladmin
mysqlbinlog
mysqlcheck
mysqlclient
mysqld
mysqldump
mysqlimport
mysqlmanager
mysqlshow
mysqltest
test_libmysqld
vio

Thank you for the bug report.

From the Manual:

5.8.7.3. Using yaSSL
Using MySQL's built-in yaSSL support makes it easier to use secure connections. You don't
have to install
OpenSSL and perform the other steps described in Section 5.8.7.2, “Requirements
(OpenSSL)”.
Also, both MySQL and yaSSL employ the same licensing model.
Currently, yaSSL support is available for these platforms:
• Linux/x86-64 Red Hat Enterprise 3.0
• Linux RHAS21 Itanium-2 with gcc, statically linked
• Linux Itanium-2 with gcc
• Windows (all builds)
^^^^^^^^^^^^^^^^

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3827

Looks okay to push to me.

Pushed to 5.0.20

This patch was built in pushbuild and all the SSL related testcases passed.

Pushed to 5.1.8

Windows builds will now have SSL support enabled.

Noted in 5.0.20, 5.1.8 changelogs.

Windows builds now have SSL support enabled. (Bug#18195)

Using (for trials) MySQL 5.04.45-Community-NT MySQL Community Build.

My build was not built with SSL , The HAVE_SSL variables say 'NO'.
Is there a way to incorporate YaSSL into my server for trials ?

Thank you.