From owner-freebsd-ports-bugs@freebsd.org Thu Aug 11 11:12:38 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 67ADCBB574D for ; Thu, 11 Aug 2016 11:12:38 +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 2D795125C for ; Thu, 11 Aug 2016 11:12:38 +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 u7BBCbWZ030380 for ; Thu, 11 Aug 2016 11:12:38 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: Thu, 11 Aug 2016 11:12:37 +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: Thu, 11 Aug 2016 11:12:38 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D194305 --- Comment #21 from MMacD --- in rx to Kubilay's 18: As I said to Markus, for my part just re-enabling datadir in my.cnf without doing anything else solves 99% of the problem. find / -name is very good at locating things that aren't where they're expected to be. As long as they = can be moved when found, there's no real problem, just inconvenience. And I very much agree with Markus that a default my.cnf should be supplied --and sample ones for different configs as well: there's nothing like having good examples in front of you when you're trying to work out how to do something. If desired, the samples could probably be nicked from the Windo= ws port.=20 But re-enabling datadir in my.cnf, while a sufficiently complete patch from= my perspective, is not really the best from a general perspective. I hope we can agree that practice should never contradict documentation.=20 Documentation should always provide information, not fairy tales or misinformation. So if /var/db is to be the place for all databases, then at a minimum hier(= 7) must be re-written to reflect that. But I'd mildly prefer, with Markus, th= at /var/lib/mysql be used as a transient staging area (which would be hier(7) = and MySQL/MariaDB docs conformant). Confirming /var/db as the official home would increase entropy, which doesn= 't seem like a good idea: per hier(7), /var is dedicated to "multi-purpose lo= g, temporary, transient, and spool files". Making it also the home of non-sys= tem databases is hard to understand, given the stated (and somewhat obvious to inspection) purpose of /var and the constantly reinforced /usr/local convention.=20=20 Most people familiar with the /usr/local convention would expect the databa= se files to be in /usr/local/mysql/data|databases, not /var. Even people who = know that maintainers put db files into /var/db would not be surprised to find a= new release announcing that it was putting them in /usr/local/mysql/data instead because /usr/local is a stronger and thus anti-entropic convention. It's "= more expected". The less entropy, the better, and the sooner the better. But for the momen= t, just having a functional datadir directive in my.cnf is enough for me. I c= an bear the messiness and entropy if everyone else can. --=20 You are receiving this mail because: You are the assignee for the bug.=