From owner-freebsd-ports-bugs@freebsd.org Wed Aug 10 20:27:30 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 E541ABB4A50 for ; Wed, 10 Aug 2016 20:27:30 +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 BB83B1542 for ; Wed, 10 Aug 2016 20:27:30 +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 u7AKRUeo078567 for ; Wed, 10 Aug 2016 20:27:30 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 20:27:30 +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: rootservice@gmail.com 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 20:27:31 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D194305 --- Comment #15 from Markus Kohlmeyer --- (In reply to MMacD from comment #14) I don't know when and who decided to put the MySQL-Databases in /var/db/mys= ql but it was before MySQL 5.0 entered the portstree, so it was more then deca= de in the past, probably back to times when MySQL 3.23 was current, i don't kn= ow. What i know is, that it is absolutly no problem to fix it at least for new installs, but as we have seen with the change of my.cnf location for the My= SQL 5.7.12 port, it will give problems with existing installs and admins who us= ed to use /var/db/mysql and/or rc.conf for years. Additional there seems to be= a problem with binary-packages/pkg while updating from MySQL < 5.7.12 caused = by the my.cnf changes (as i don't use binary-packages/pkg i can't confirm that myself, but there exists a bugreport/comment). Personally i would be glad to get this completely fixed for new installs and "good admins" aka admins who read ports/UPDATING and pkg-message, but this = type of forced and agressive changes are against FreeBSD policys for some good reasons. I could provide these patches for MySQL 5.6 and 5.7 in the next days, but a= s i said, they will probably not be committed as they will break FreeBSD policy= by breaking existing expected behavior for existing installs. Without manual w= ork by admins of existing installs, there will be incompatibilities up to non-working installs and if all goes wrong there is even a (realy) small possiblity of dataloss. So, i can't and i don't want to decide anything here, but if the maintainers and portsteam decide to do this changes anyway, then i'm glad to provide patches at least for MySQL 5.6/5.7 which can easy be ported to MariaDB and Percona. --=20 You are receiving this mail because: You are the assignee for the bug.=