From owner-freebsd-current@FreeBSD.ORG Sun Jan 2 22:23:37 2011 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C8D221065679 for ; Sun, 2 Jan 2011 22:23:37 +0000 (UTC) (envelope-from jhellenthal@gmail.com) Received: from mail-gx0-f182.google.com (mail-gx0-f182.google.com [209.85.161.182]) by mx1.freebsd.org (Postfix) with ESMTP id 7DA6E8FC2F for ; Sun, 2 Jan 2011 22:23:37 +0000 (UTC) Received: by gxk8 with SMTP id 8so5436370gxk.13 for ; Sun, 02 Jan 2011 14:23:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:sender:message-id:date:from :organization:user-agent:mime-version:to:cc:subject:references :in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; bh=xP2b8sl4uxbaXtyIXPeBF0BgZTxLlxfTh7aUGp5W+II=; b=aZc38wINFEhWHDc0TUFIwMQ0pRyV7l7Y2kS1+6238mMcW/s24gU+Hv9fu2V6sxevdm ta2QsiyPNz4zONYW2si327y+sUa0v2QxRlckldQ/TMv6UM7LJJdw0FvLeZ/rv/y481l9 Jo4G6+hNxGogdOCWpU+qzsk0VnQB7DYfWYrY8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=sender:message-id:date:from:organization:user-agent:mime-version:to :cc:subject:references:in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=C0jAxsthkf6NjCez70FCSF81nC+srcmwQSx25a97lvY8luCzlM51IgYzaIAshxmly2 30AefPo0nv1Nwo3b7a587OW+xA9ofw4suiOCtxKNFcO2PzLUQell/rA6kSWp+ni9MIN+ YTREqxZ3mH1Q2Jb0ExWgZxAnrqj4hJrNUM1zY= Received: by 10.90.118.2 with SMTP id q2mr11591005agc.11.1294007016797; Sun, 02 Jan 2011 14:23:36 -0800 (PST) Received: from centel.dataix.local (adsl-99-181-155-97.dsl.klmzmi.sbcglobal.net [99.181.155.97]) by mx.google.com with ESMTPS id 8sm11737388yhx.3.2011.01.02.14.23.34 (version=SSLv3 cipher=RC4-MD5); Sun, 02 Jan 2011 14:23:35 -0800 (PST) Sender: "J. Hellenthal" Message-ID: <4D20FAE4.1070608@DataIX.net> Date: Sun, 02 Jan 2011 17:23:32 -0500 From: "J. Hellenthal" Organization: http://www.DataIX.net User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.9.2.13) Gecko/20101230 Lightning/1.0b1 Thunderbird MIME-Version: 1.0 To: "dsc fbsd.current" References: <003901cbaa8c$bb859bb0$3290d310$@gmail.com> In-Reply-To: <003901cbaa8c$bb859bb0$3290d310$@gmail.com> X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: freebsd-current@freebsd.org Subject: Re: jailing MYSQL error X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 Jan 2011 22:23:38 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, Just to be sure as the long detailed information that you laid before can lead to confusion, lets take this one step at a time. Assuming all your bases are covered and it sinks down to a permissions issue try this: chown root:wheel /path/to/jail/tmp /path/to/jail/var/tmp chmod 1777 /path/to/jail/tmp /path/to/jail/var/tmp rm -rf /path/to/jail/var/db/mysql - -Login to the jail here- make sure that rc.conf* only contains mysql_enable="YES" service mysql-server start ls -ld /var/db/mysql should convey mode 700 or drwx------ and uid/88 gid/88 mysql/mysql At this point your mysql server should be running and fully working. Another thing to make sure you eliminate just in case... would be any my.cnf files in /etc or /usr/local/etc Good luck - -- Regards, jhell,v JJH48-ARIN -----BEGIN PGP SIGNATURE----- iQEcBAEBAgAGBQJNIPrkAAoJEJBXh4mJ2FR+fLEH/0N91782PKGna/DZNoRF4hWJ 8tTh9bPFaHGjRu2ITC08gFJBLaAK8hE5oh9Tg5k6eysyzjE1EEHXUAJaL6B8Rg+N w5m66OGtvunX8JQqwu8d6ulDLk4EHex7Aaf0G2wfpW2OBDP4oCbeXxaakDJp+dzB GGf4a4ezODgQsr8Hxva71bgesfQ6a1BEirf/pwGcaQs9y1lCgoRK6M+iKDKqruLM Vyp4oNCHX52GTKa/cpx2VveZG/F21RabYtCVrBhU3Xq0EbDeDkiP2JjZt0xNPJVA dnCfCtTRECeruqlFHekH7MayF7uZ5nZIjJ3SEA6xHTCyt3PVC7oxr1NCmaETWJQ= =HFv4 -----END PGP SIGNATURE-----