[Bug 267835] databases/mariadb106-server non standard location of socket breaks connection from PHP

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=267835

            Bug ID: 267835
           Summary: databases/mariadb106-server non standard location of
                    socket breaks connection from PHP
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: brnrd@freebsd.org
          Reporter: 000.fbsd@quip.cz
             Flags: maintainer-feedback?(brnrd@freebsd.org)
          Assignee: brnrd@freebsd.org

We upgraded some of our machines from MariaDB 10.3 to 10.6 and then realized
that all web sites are broken, cannot connect to database, because MariaDB
newer than 10.3 changed location of socket mysql.sock. PHP (and some other
apps) does not use settings from my.cnf (which changed location a breaks the
setup as well). These applications and PHP must be manually reconfigured to be
able to connect to database server again. Something that works for 20+ years is
broken now.
If MariaDB was meant as drop-in replacement for MySQL then it is no longer the
case. It diverged from default MySQL install too much. Now we have MySQL and
MariaDB in many versions in the ports tree but they are not interchangeable and
dependent ports like PHP (again many versions) cannot be built to work for all
MySQL + MariaDB versions.
I thing it will be much better to have things like config files (my.cnf) and
socket (mysql.sock) the same for all versions of MySQL and MariaDB in the ports
tree.
The current state complicated things too much and the gain of changes is
nothing, just the change for the change.

More cooperation between MariaDB and MySQL maintainers is needed.

-- 
You are receiving this mail because:
You are the assignee for the bug.