Upgrade mariadb from 10.4 to 10.11

[kdkayat]

Using TOASTER_MARIADB="1". Provisioning a new mysql jail fails because mariadb104-server is no longer available as a binary package.

The available stable/ga version of mariadb is 10.11.4 since Feb-2023.

Could it be an easy fix to replace mariadb104- with mariadb1011- ? This would affect mysql.sh and vpopmail.sh.

[msimerson]

Yes, that is the likely fix. It's needs to be tested.

[kdkayat]

Have been testing:

vpopmail jail does not work with mariadb1011-client. It's missing a shared library. Just sticking with the mysql-client seems to work in this case.

As for the mysql jail, the mariadb1011-server has a different behavior with thy my.cnf. It refuses to start:

Please merge existing /var/db/mysql/my.cnf file with /usr/local/etc/mysql/conf.d/server.cnf
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql

Merging the lines into server.cnf and removing the my.cnf does seem to work.

[Infern1]

Have been testing:

vpopmail jail does not work with mariadb1011-client. It's missing a shared library. Just sticking with the mysql-client seems to work in this case.

As for the mysql jail, the mariadb1011-server has a different behavior with thy my.cnf. It refuses to start:

Please merge existing /var/db/mysql/my.cnf file with /usr/local/etc/mysql/conf.d/server.cnf
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql

Merging the lines into server.cnf and removing the my.cnf does seem to work.

yes seeing that same behavior

On the client side we could easily stick to mysql-client