<HTML>
<HEAD>
<TITLE>Re: [UniMacTech] MySql and ssl</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Thanks to Andrew and Tony for the replys.<BR>
<BR>
Looks like its back to compiling MySql with ssl included. Not my preferred option, as I try to not run non standard servers, due to complications with later updates.<BR>
<BR>
<BR>
On 16/10/08 9:46 AM, "Andrew Wellington" <<a href="andrew.wellington@anu.edu.au">andrew.wellington@anu.edu.au</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>David,<BR>
<BR>
Apple's MySQL included with Mac OS X Server 10.5 does not have SSL support compiled in:<BR>
</SPAN></FONT><FONT SIZE="1"><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:7.5pt'>mysql> SHOW VARIABLES LIKE '%ssl%';<BR>
+---------------+-------+<BR>
| Variable_name | Value |<BR>
+---------------+-------+<BR>
| have_openssl | NO | <BR>
| have_ssl | NO | <BR>
| ssl_ca | | <BR>
| ssl_capath | | <BR>
| ssl_cert | | <BR>
| ssl_cipher | | <BR>
| ssl_key | | <BR>
+---------------+-------+<BR>
7 rows in set (0.00 sec)<BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
You will need to replace Apple's version with a custom compiled version, as it appears the binary provided by MySQL doesn't support SSL either.<BR>
<BR>
Regards,<BR>
Andrew<BR>
<BR>
On 16/10/2008, at 9:35 AM, David Wikeley wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Does anyone know how to enable ssl with mysql on 10.5?<BR>
<BR>
We need to only have ssl encryption with one or two mysql databases not<BR>
every database running.<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
<BR>
=======================================<BR>
Andrew Wellington<BR>
Mac OS X Systems Administrator<BR>
Systems & Desktop Services<BR>
Division of Information<BR>
R.G Menzies Building (Bldg #2)<BR>
The Australian National University<BR>
Canberra ACT 0200 Australia<BR>
<BR>
T: +61 2 6125 7805<BR>
W: <a href="http://information.anu.edu.au/">http://information.anu.edu.au/</a><BR>
<BR>
CRICOS Provider #00120C<BR>
<BR>
<BR>
<BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
-- <BR>
David Wikeley<BR>
IT Manager<BR>
Faculty of Health Science<BR>
University of Tasmania<BR>
43 Collins Street<BR>
Hobart, Tasmania.<BR>
T: 03 62264751<BR>
W: www.healthsci.utas.edu.au/<BR>
</SPAN></FONT>
</BODY>
</HTML>