[UniMacTech] MySql and ssl

[David Wikeley]

Thanks to Andrew and Tony for the replys.

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.


On 16/10/08 9:46 AM, "Andrew Wellington" <andrew.wellington at anu.edu.au> wrote:

David,

Apple's MySQL included with Mac OS X Server 10.5 does not have SSL support compiled in:
mysql> SHOW VARIABLES LIKE '%ssl%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl  | NO    |
| have_ssl      | NO    |
| ssl_ca        |       |
| ssl_capath    |       |
| ssl_cert      |       |
| ssl_cipher    |       |
| ssl_key       |       |
+---------------+-------+
7 rows in set (0.00 sec)

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.

Regards,
Andrew

On 16/10/2008, at 9:35 AM, David Wikeley wrote:

Does anyone know how to enable ssl with mysql on 10.5?

We need to only have ssl encryption with one or two mysql databases not
every database running.


=======================================
Andrew Wellington
Mac OS X Systems Administrator
Systems & Desktop Services
Division of Information
R.G Menzies Building (Bldg #2)
The Australian National University
Canberra ACT 0200 Australia

T: +61 2 6125 7805
W: http://information.anu.edu.au/

CRICOS Provider #00120C





--
David Wikeley
IT Manager
Faculty of Health Science
University of Tasmania
43 Collins Street
Hobart, Tasmania.
T: 03 62264751
W: www.healthsci.utas.edu.au/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://auc.uow.edu.au/pipermail/unimactech/attachments/20081016/4d774256/attachment.html