<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>David,</div><div><br></div><div>Apple's MySQL included with Mac OS X Server 10.5 does not have SSL support compiled in:</div><div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">mysql> SHOW VARIABLES LIKE '%ssl%';</span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">+---------------+-------+</span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| Variable_name | Value |</span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">+---------------+-------+</span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| have_openssl | NO | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| have_ssl | NO | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| ssl_ca | | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| ssl_capath | | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| ssl_cert | | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| ssl_cipher | | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">| ssl_key | | </span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">+---------------+-------+</span></font></div><div><font class="Apple-style-span" face="Monaco" size="2"><span class="Apple-style-span" style="font-size: 10px;">7 rows in set (0.00 sec)</span></font></div></div><div><br></div><div>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.</div><div><br></div><div>Regards,</div><div>Andrew</div><div><br></div><div><div>On 16/10/2008, at 9:35 AM, David Wikeley wrote:</div><br><blockquote type="cite"><div>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></div></blockquote></div><br><div apple-content-edited="true"> <div><div>=======================================</div><div>Andrew Wellington</div><div>Mac OS X Systems Administrator</div><div>Systems & Desktop Services</div><div>Division of Information</div><div>R.G Menzies Building (Bldg #2)</div><div>The Australian National University</div><div>Canberra ACT 0200 Australia</div><div><br></div><div>T: +61 2 6125 7805</div><div>W: <a href="http://information.anu.edu.au/">http://information.anu.edu.au/</a></div><div><br></div><div>CRICOS Provider #00120C</div></div><br> </div><br></body></html>