From owner-freebsd-ports-bugs@freebsd.org Wed Aug 10 19:38:54 2016 Return-Path: Delivered-To: freebsd-ports-bugs@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 CEBF8BB5A40 for ; Wed, 10 Aug 2016 19:38:54 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id B2083181F for ; Wed, 10 Aug 2016 19:38:54 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id u7AJcr8V044350 for ; Wed, 10 Aug 2016 19:38:54 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 194305] databases/mariadb55-server (probably mysql too) ignores datadir directive in my.cnf Date: Wed, 10 Aug 2016 19:38:54 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: needs-patch, needs-qa X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: scratch65535@att.net X-Bugzilla-Status: Open X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? merge-quarterly? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.22 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 Aug 2016 19:38:54 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D194305 --- Comment #14 from MMacD --- In rx to Markus (also Kubilay and Mahdi): "FreeBSD uses a different standard for the location of the databases (MySQL/MariaDB/Percona-Standard: /var/lib/mysql vs. FreeBSD-Standard: /var/db/mysql" That's not the FreeBSD standard, per hier(7). Non-system databases shouldn= 't be in /var/db: "[/var/]db [holds] miscellaneous automatically generated system-specific database files". The MariaDB docs do say that /var/lib/mysql is the default location, but th= ey make clear that the datadir directive in my.cfg is meant to be set to provi= de the real location: "The data directory location is controlled by the datadir variable. ... The default is /var/lib/mysql but it is often changed, like f= or example if you are using a RAID array." Since hier(7) specifies that only scratch database files generated by and f= or the system are meant to go in /var/db, MariaDB's /var/lib is more appropria= te as a temporary staging area-- hier(7) doesn't allocate that subtree.=20=20 The center of the problem, though, is that datadir in my.cnf is and has been being ignored, making it hard on nitwits like me who didn't/don't know about the non-standard /etc/rc.conf kludge. --=20 You are receiving this mail because: You are the assignee for the bug.=