msimerson / Mail-Toaster-6

Mail Toaster 6
https://github.com/msimerson/Mail-Toaster-6/wiki
BSD 3-Clause "New" or "Revised" License
46 stars 16 forks source link

Upgrade mariadb from 10.4 to 10.11 #551

Open kdkayat opened 1 year ago

kdkayat commented 1 year ago

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 commented 1 year ago

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

kdkayat commented 1 year ago

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 commented 10 months ago

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