From owner-freebsd-ports-bugs@freebsd.org Wed Aug 10 17:49:20 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 3014ABB56A4 for ; Wed, 10 Aug 2016 17:49:20 +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 030271242 for ; Wed, 10 Aug 2016 17:49:20 +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 u7AHnI3E054066 for ; Wed, 10 Aug 2016 17:49:19 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 17:49:19 +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 17:49:20 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D194305 --- Comment #13 from Markus Kohlmeyer --- (In reply to Mahdi Mokhtari from comment #10) Yes, MySQL 5.7 is affected too. Affected are *all* MySQL, MariaDB and Percona ports. (In reply to Kubilay Kocak from comment #11) If i underatnd this all right, then it was/is like this: The rc.conf/initscript options had been introduced, because FreeBSD uses a different standard for the location of the databases (MySQL/MariaDB/Percona-Standard: /var/lib/mysql vs. FreeBSD-Standard: /var/db/mysql). As MySQL/MariaDB/Percona need to know the database location= on first startup and FreeBSD did not installed a default my.cnf in the past, t= here had to be a commandline param to pass and this commandline param had been m= ade configureable via the rc.conf option. In the progress on updating the MySQL 5.7 port from 5.7.10 to 5.7.12 i introduced a default my.cnf and changed the default location of the my.cnf = from the old FreeBSD-Location (/var/db/mysql/my.cnf) to the MySQL/MariaDB/Percona-Standard and according to hier(8) to /usr/local/etc/mysql/my.cnf This change and the new default my.cnf should first be ported to the other MySQL/MariaDB/Percona ports and then we can think about getting rid of the rc.conf/initscript options. But without this change and the default my.cnf = we have to stick with the 11 year old solution. Just my $0.02 --=20 You are receiving this mail because: You are the assignee for the bug.=