From owner-freebsd-ports@freebsd.org Fri Mar 25 20:13:52 2016 Return-Path: Delivered-To: freebsd-ports@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 B4D55ADD731 for ; Fri, 25 Mar 2016 20:13:52 +0000 (UTC) (envelope-from zaphod@berentweb.com) Received: from mail-wm0-x22a.google.com (mail-wm0-x22a.google.com [IPv6:2a00:1450:400c:c09::22a]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 74F8B1102 for ; Fri, 25 Mar 2016 20:13:52 +0000 (UTC) (envelope-from zaphod@berentweb.com) Received: by mail-wm0-x22a.google.com with SMTP id l68so35902425wml.0 for ; Fri, 25 Mar 2016 13:13:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=berentweb-com.20150623.gappssmtp.com; s=20150623; h=sender:date:from:to:subject:message-id:mime-version :content-transfer-encoding; bh=vyiYocIz8foRNBNaWWveRgG7LSObGA5a8Px1nMK6cW4=; b=fj6SmLnaGnB1qJSoLwz45sfYzp1gADg1b2eX/oLNVk6kPPjS2iTFRdR89zLUefsGqu xKTINadW26S8qM46OVoKq/wrqsMVe6QV++jFnDk6R2lqVBGlar2sg35AzNQHW+41FpSo XZ4JN8jN3T4kjdXq4UVd7lTEO6hcXX4pacLNl+1y7pUbItBhkUm+r+6zjug9XofMuDEA Cv0MgqNFPy2yS77QXt+g82PmQWwXWAMIEQO23VzNvh9Og2uW6jtPifaXFz7L641SQjoz HmwdxfZ+hhnnNbKQ9ZF9Ym4p4gct71cgRqI/wLDPWeWuWPaS5xqNnRXHcDCNE/1GQH4H Hljg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:sender:date:from:to:subject:message-id :mime-version:content-transfer-encoding; bh=vyiYocIz8foRNBNaWWveRgG7LSObGA5a8Px1nMK6cW4=; b=fbQdiVAxqcUT/NJ1EVJdWJ1O2gu4ItXRewDwnkFm3pm3cQc8V5LcsE1miSKc7dvKzH QIgL+hMzDMUxNc8fs5KYnzlkuouF+jZOPThyU4saghVQHtS5WPHG0DrLXjGlIX5YjAxl VpM1f0aA5AtuuUXaZzJUzU69qzK+XNHjlexZK2TIHwfGZYQw0n8ARMQlQHiU248D2uXL zCR64rOcRosJF/9MSn9hPUj2/fv+fNQJTVIK2bg4QeItUt+wC6QYuYMu2gobSv+/qnGG 2ZsgUWYRLTkELupuXXWXALaOgj13hPyNOYI7SR5lAUW3fCjDFYqh+bSKXXxKHc4Q+vZb HAFg== X-Gm-Message-State: AD7BkJJG54rUTRQYJI4o7JGkaksMd1rRzK9hfiemU5zuFtTJasWHjwdDupsC1TfRSBR7KQ== X-Received: by 10.194.21.197 with SMTP id x5mr16211935wje.90.1458936830655; Fri, 25 Mar 2016 13:13:50 -0700 (PDT) Received: from rsbsd.rsb ([78.161.186.52]) by smtp.gmail.com with ESMTPSA id e127sm267619wma.20.2016.03.25.13.13.49 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 25 Mar 2016 13:13:49 -0700 (PDT) Sender: "Raif S. Berent" Date: Fri, 25 Mar 2016 22:13:45 +0200 From: Beeblebrox To: freebsd-ports@freebsd.org Subject: databases/mariadb100-server fails to start inside jail Message-ID: <20160325221346.168804f0@rsbsd.rsb> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.21 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Mar 2016 20:13:52 -0000 Hi. I run mariadb100-server-10.0.23 in a jail on 11-current. Some strange e= rrors with error-check prompted me to backup the DB and create a fresh new = instance to which I plan to restore the data later. Now MDB fails to start = in the jail, but does start on native. I've narrowed the problem thus: * Start the SQL jail & #jexec sql-jail csh root@sql-jail# mysqld_safe --nowatch --skip-grant-tables MDB does not start, sql-jail/var/log/mysql-safe.log shows: - mysqld_safe Starting mysqld daemon with databases from /var/db/mysql - [Note] Initializing built-in plugins - [ERROR] mysqld: Can't create/write to file '/var/db/mysql/aria_log_contro= l' (Errcode: 13 "Permission denied") - [ERROR] mysqld: Got error 'Can't create file' when trying to use aria con= trol file '/var/db/mysql/aria_log_control' .... - [ERROR] Aria engine is not enabled or did not start. The Aria engine must= be enabled to continue as mysqld was configured with --with-aria-tmp-tables - [ERROR] Aborting ---------------------- The error message makes no sense because: root@sql-jail# su -m mysql (or "sudo -u mysql sh") $ id --> uid=3D88(mysql) gid=3D88(mysql) groups=3D88(mysql) /var/db/mysql$ touch aria.log --> -rw-r--r-- 1 mysql mysql aria.log sql-jail/etc/passwd mysql entry: mysql:*:88:88:MySQL Daemon:/var/db/mysql:/usr/sbin/nologin sql-jail/var/log/messages has this: su: _secure_path: cannot stat /var/db/mysql/.login_conf: Permission denied I have 5 more jails with different services but none of them have any such = problem, so I'm convinced it's a MariaDB issue. It's also worth noting that= MDB had several difficulties creating the initial control tables in the ja= il, so I had to actually complete that stage on native, then copy the mysql= folder to the jail's path. Everything is on ZFS, I even tried a modified mount point for mysql with no= effect as "aclinherit =3D passthrough" Regards. --=20 FreeBSD_amd64_11-Current_RadeonKMS Please CC my email when responding, mail from list is not delivered.