Date: Tue, 17 May 2016 12:33:10 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 209512] mysql57-server-5.7.12: Server not usable after installation Message-ID: <bug-209512-13-npMtUw0T99@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-209512-13@https.bugs.freebsd.org/bugzilla/> References: <bug-209512-13@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
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.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-209512-13-npMtUw0T99>