From owner-freebsd-questions@FreeBSD.ORG  Thu Oct  8 03:32:34 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 89539106566B
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Oct 2009 03:32:34 +0000 (UTC)
	(envelope-from Olivier.Nicole@cs.ait.ac.th)
Received: from mail.cs.ait.ac.th (mail.cs.ait.ac.th [192.41.170.16])
	by mx1.freebsd.org (Postfix) with ESMTP id 371668FC13
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Oct 2009 03:32:33 +0000 (UTC)
Received: from localhost (localhost [127.0.0.1])
	by mail.cs.ait.ac.th (Postfix) with ESMTP id E55323A383C
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Oct 2009 10:32:29 +0700 (ICT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cs.ait.ac.th; h=
	subject:subject:from:from:message-id:date:date:received:received
	:received; s=selector1; t=1254972749; x=1256787149; bh=NfSXsVKIY
	6PuhyeCDXtKSe9/+v/1EyW6833KwMJaxOU=; b=QeTrDfyt3VvVfMmYfynDwqeYA
	jjMF3swy7cQpVx1CQfFXnLasWPKqk+BKWS0D1S91y/ydH0u3e4MHH7osrNdn23o2
	CzUW2qvJVe6dXai+gbcxrlxXEO5uNSQqDV2utYxHJODftq0IPXhndPzd5aDOMoIy
	gIeIRnrbw20OJxxIWc=
X-Virus-Scanned: amavisd-new at cs.ait.ac.th
Received: from mail.cs.ait.ac.th ([127.0.0.1])
	by localhost (mail.cs.ait.ac.th [127.0.0.1]) (amavisd-new, port 10026)
	with ESMTP id nJ8lNOVr+2RM for <freebsd-questions@freebsd.org>;
	Thu,  8 Oct 2009 10:32:29 +0700 (ICT)
Received: from banyan.cs.ait.ac.th (banyan.cs.ait.ac.th [192.41.170.5])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.cs.ait.ac.th (Postfix) with ESMTPS id 3952B3A3836
	for <freebsd-questions@freebsd.org>;
	Thu,  8 Oct 2009 10:32:29 +0700 (ICT)
Received: (from on@localhost)
	by banyan.cs.ait.ac.th (8.14.3/8.14.3/Submit) id n983WTW3018483;
	Thu, 8 Oct 2009 10:32:29 +0700 (ICT) (envelope-from on)
Date: Thu, 8 Oct 2009 10:32:29 +0700 (ICT)
Message-Id: <200910080332.n983WTW3018483@banyan.cs.ait.ac.th>
From: Olivier Nicole <Olivier.Nicole@cs.ait.ac.th>
To: freebsd-questions@freebsd.org
Subject: MySQL + SSL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 08 Oct 2009 03:32:34 -0000

Hi,

I have been strugling to find the correct syntax for the mysql(1)
command to connect with SSL.

My server is accepting SSL connections:

  db2<root>: mysql -u root -p
  Enter password: 
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 1
  Server version: 5.4.2-beta FreeBSD port: mysql-server-5.4.2
  
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  
  mysql> SHOW VARIABLES LIKE '%ssl%';
  +---------------+-------------------------------------------+
  | Variable_name | Value                                     |
  +---------------+-------------------------------------------+
  | have_openssl  | YES                                       |
  | have_ssl      | YES                                       |
  | ssl_ca        | /usr/local/ssl/ca/ait-itserv.crt          |
  | ssl_capath    |                                           |
  | ssl_cert      | /usr/local/ssl/crt/db2.cs.ait.ac.th.crt   |
  | ssl_cipher    | DHE-RSA-AES256-SHA:AES128-SHA             |
  | ssl_key       | /database/mysql/database.cs.ait.ac.th.key |
  +---------------+-------------------------------------------+
  7 rows in set (0.00 sec)
  
  mysql> quit
  Bye
  db2<root>:
 
TIA,

Olivier