Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 10 Aug 2016 20:27:30 +0000
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
Message-ID:  <bug-194305-13-HAbHhQMrWk@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-194305-13@https.bugs.freebsd.org/bugzilla/>
References:  <bug-194305-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=3D194305

--- Comment #15 from Markus Kohlmeyer <rootservice@gmail.com> ---
(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.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-194305-13-HAbHhQMrWk>