From owner-freebsd-ports-bugs@freebsd.org Tue May 17 12:33:10 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 104D4B3FE01 for ; Tue, 17 May 2016 12:33:10 +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 DAC95137B for ; Tue, 17 May 2016 12:33:09 +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 u4HCX9XY036830 for ; Tue, 17 May 2016 12:33:09 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 209512] mysql57-server-5.7.12: Server not usable after installation Date: Tue, 17 May 2016 12:33:10 +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: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: 000.fbsd@quip.cz X-Bugzilla-Status: In Progress X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Flags: 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: Tue, 17 May 2016 12:33:10 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D209512 --- Comment #22 from Miroslav Lachman <000.fbsd@quip.cz> --- (In reply to Markus Kohlmeyer from comment #18) I think /etc/my.cnf and /etc/mysql/my.cnf should be removed. It was discuss= ed in Bug 182547 (according to hier(7)) /etc/my.cnf and /etc/mysql/my.cnf should be replaced by their /usr/local/ counterparts. /usr/local/etc/my.cnf and /usr/local/etc/mysql/my.cnf should = not be added to the end of the list. IMHO. We have this on all our MariaDB instances: my_print_defaults --help | grep -A1 'Default options' Default options are read from the following files in the given order: /usr/local/etc/my.cnf /usr/local/etc/mysql/my.cnf ~/.my.cnf And /var/db/mysql/my.cnf is specified as extra-file --defaults-extra-file=3D/var/db/mysql/my.cnf (In reply to Mahdi Mokhtari from comment #19) There is one dangerous problem with changing my.cnf locations and search pa= th. If you have working MySQL server with configuration in /usr/local/etc/my.cnf and you configure some non-default things for InnoDB like different file na= mes, number of files for innodb_data_file_path or innodb_log_files_in_group, or = size of innodb_log_file_size then if something with my.cnf is silently changed a= nd your MySQL server will restart after upgrade without this my.cnf file or if= it find some my.cnf file in location previously not scanned, your MySQL server will not start (if you are lucky) or start and try to create missing files.= It will end up in non working or half broken MySQL server and you will have ha= rd time to find what is going on. This is why changing my.cnf search path is dangerous. So the change is not related to hier(7) only.=20 Hier just says: /etc/ system configuration files and scripts Anything from ports / pkg should go to /usr/local prefix, and /usr/local/et= c/ should mimics /etc/ Searching for my.cnf in /etc/ and /etc/mysql/ is the same as searching httpd.conf in /etc/ and /etc/apache24/.=20 It is wrong on FreeBSD.=20 But it is OK on operating systems where base system and 3rd party packages = are not separated to /usr/local/. --=20 You are receiving this mail because: You are the assignee for the bug.=