From owner-freebsd-questions@freebsd.org Fri Dec 25 16:56:38 2015 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 2C86BA52EF7 for ; Fri, 25 Dec 2015 16:56:38 +0000 (UTC) (envelope-from galtsev@kicp.uchicago.edu) Received: from cosmo.uchicago.edu (cosmo.uchicago.edu [128.135.70.90]) by mx1.freebsd.org (Postfix) with ESMTP id 082EA134F for ; Fri, 25 Dec 2015 16:56:37 +0000 (UTC) (envelope-from galtsev@kicp.uchicago.edu) Received: by cosmo.uchicago.edu (Postfix, from userid 48) id 5966CCB8CA4; Fri, 25 Dec 2015 10:39:39 -0600 (CST) Received: from 76.193.16.122 (SquirrelMail authenticated user valeri) by cosmo.uchicago.edu with HTTP; Fri, 25 Dec 2015 10:39:39 -0600 (CST) Message-ID: <64399.76.193.16.122.1451061579.squirrel@cosmo.uchicago.edu> In-Reply-To: <567D61D0.5050204@FreeBSD.org> References: <567D61D0.5050204@FreeBSD.org> Date: Fri, 25 Dec 2015 10:39:39 -0600 (CST) Subject: Re: Mysql server in a jail From: "Valeri Galtsev" To: freebsd-questions@freebsd.org Reply-To: galtsev@kicp.uchicago.edu User-Agent: SquirrelMail/1.4.8-5.el5.centos.7 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Dec 2015 16:56:38 -0000 On Fri, December 25, 2015 9:33 am, Matthew Seaman wrote: > On 24/12/2015 21:18, David Mehler wrote: >> Is anyone running MySQL 5.6 server in a jail? I'm attempting to do so >> and can not get it to start. I've googled this and found others with >> this problem, but they had permissions issues which I am not having. >> I'm getting no MySQL output at all even when I comment out the >> /dev/null options in the MySQL startup file, I have no additional >> information except that the server is not starting in the jail. > > Works for me -- absolutely no problem. > > Did you look at the error log? That's usually found in > /var/db/mysql/${hostname}.err > > There's plenty of configuration errors that can prevent mysql starting > up -- if you're upgrading from an older version of mysql, even though it > may have used to work, watch out for some configuration parameters > needing to be modified due to changed requirements from the program. > mysql will tell you exactly what the problem is in that case. > > Oh, and at some point the old my.cnf location of /var/db/mysql/my.cnf, > already deprecated, will switch to /usr/local/etc/my.cnf -- you might > not be the config file you thought you were. > Works for me as well. It is ver. 5.6 that I run in jail on FreeBSD 10.2. Jails I have installed "by the book" (meaning FreeBSD online handbook, not by using ezjail or other jail creation scripts), mysql56-server-5.6.27 installed in jail using pkg. Jails on that box have the following parameters: allow.raw_sockets = 1; mount.devfs; Did you try to run mysql daemon from command line in jail? What did you get in that case? Good luck! Valeri > Cheers, > > Matthew > > > ++++++++++++++++++++++++++++++++++++++++ Valeri Galtsev Sr System Administrator Department of Astronomy and Astrophysics Kavli Institute for Cosmological Physics University of Chicago Phone: 773-702-4247 ++++++++++++++++++++++++++++++++++++++++