From owner-freebsd-questions@FreeBSD.ORG Tue Oct 21 07:45:22 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1B16F106569C for ; Tue, 21 Oct 2008 07:45:22 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id 61FF58FC12 for ; Tue, 21 Oct 2008 07:45:21 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id m9L7j00r038236; Tue, 21 Oct 2008 08:45:12 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.7.2 smtp.infracaninophile.co.uk m9L7j00r038236 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1224575112; bh=OZnEfHfMqGb2uf jsWwXZZ640IwKA/7PWU2Tr+eSMFLs=; h=Message-ID:Date:From:MIME-Version: To:CC:Subject:References:In-Reply-To:Content-Type:Cc:Content-Type: Date:From:In-Reply-To:Message-ID:Mime-Version:References:To; z=Mes sage-ID:=20<48FD8876.5090805@infracaninophile.co.uk>|Date:=20Tue,=2 021=20Oct=202008=2008:44:54=20+0100|From:=20Matthew=20Seaman=20|Organization:=20Infracaninophile|User -Agent:=20Thunderbird=202.0.0.17=20(X11/20080929)|MIME-Version:=201 .0|To:=20John=20Almberg=20|CC:=20freebsd-ques tions@freebsd.org|Subject:=20Re:=20mysql=20connection=20through=20s sl=20tunnel|References:=20<8B945891-5F96-4FBF-8175-15F67F03DD92@ide ntry.com>=09<48D8F881.1010000@unsane.co.uk>=09<912A74FB-0292-4A53-B 480-34FE69D9C465@identry.com>=09<20081020212103.GA13334@icarus.home .lan>=20<007ABF71-6D85-4849-A9E7-933D18236EE8@identry.com>|In-Reply -To:=20<007ABF71-6D85-4849-A9E7-933D18236EE8@identry.com>|X-Enigmai l-Version:=200.95.6|Content-Type:=20multipart/signed=3B=20micalg=3D pgp-sha256=3B=0D=0A=20protocol=3D"application/pgp-signature"=3B=0D= 0A=20boundary=3D"------------enigA550958C8AD7EC3325AB56A6"; b=1gzgZ RiAZeiGxziACUMWbJJCkknzXq6ZRistHuCO4nW0eVEQhetCjYVrBiOluKMalgzO/a8K O6N+Y1NaBNoaVbUVXv9TMYAond4uFzzw28c/IqwMrOk5kRz3USBuQ78K4GmXno6pHnK VY3JAnESlyFJB6Eztr/xvCHfNRkfdVC8= Message-ID: <48FD8876.5090805@infracaninophile.co.uk> Date: Tue, 21 Oct 2008 08:44:54 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.17 (X11/20080929) MIME-Version: 1.0 To: John Almberg References: <8B945891-5F96-4FBF-8175-15F67F03DD92@identry.com> <48D8F881.1010000@unsane.co.uk> <912A74FB-0292-4A53-B480-34FE69D9C465@identry.com> <20081020212103.GA13334@icarus.home.lan> <007ABF71-6D85-4849-A9E7-933D18236EE8@identry.com> In-Reply-To: <007ABF71-6D85-4849-A9E7-933D18236EE8@identry.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enigA550958C8AD7EC3325AB56A6" X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0.1 (smtp.infracaninophile.co.uk [IPv6:::1]); Tue, 21 Oct 2008 08:45:12 +0100 (BST) X-Virus-Scanned: ClamAV 0.94/8457/Tue Oct 21 04:05:55 2008 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: mysql connection through ssl tunnel X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Oct 2008 07:45:22 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigA550958C8AD7EC3325AB56A6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable John Almberg wrote: > I do know that Mysql supports SSL... somehow this got discounted early = > in the discussion, perhaps mistakenly? I believe the thinking was that although MySQL claims to support SSL, it does in fact make a pretty bodge of it, and a more effective approach = is to pipe MySQL traffic through an encrypted tunnel. Personally I just use IPSec for this, but people might also like to consider stunnel (http://www.stunnel.org/) or OpenVPN=20 (http://openvpn.net/) Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enigA550958C8AD7EC3325AB56A6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAkj9iHwACgkQ8Mjk52CukIxcSwCdGhr95bT7u9SuZRPacTu7pWSC u28An2JdfsVsBMLvQL/h4oAtZo+YoHLB =KbZR -----END PGP SIGNATURE----- --------------enigA550958C8AD7EC3325AB56A6--