Solved v15.0 + postfix + mariadb

cbrace

cbrace

Hi all,
Just now I upgraded my VPS running Freebsd to 15.0-RELEASE. Postfix no longer compiles with (seamless) mariadb support. I am having great difficulty identifying exactly what the problem is and how to solve it. According to DeepSeek, the difference between 14.3 and the current release is that

MySQL 5.7 was still in ports. Now it's been removed. The MariaDB drop-in replacement still works, but the port dependency needs updating.
Click to expand...

DeepSeek has tried to help me update the dependency issue, but I have not solved it yet.

Is there anyone here who has faced a similar situation and came up with a solution?

TIA
 
Thanks. I have been using mariadb for some years, I am currently at: mariadb118-server-11.8.3_1

Previously to v15.0 postfix recompiled without a hitch.

# pkg unlock postfix
postfix-3.9.1,1: unlock this package? [y/N]: y
Unlocking postfix-3.9.1,1
root@mx1:/usr/ports/mail/postfix# make all reinstall
===> postfix-3.10.4,1 cannot install: unknown MySQL version: 105m.
*** Error code 1

Stop.
make: stopped making "all reinstall" in /usr/ports/mail/postfix
 
Build your mariadb first and install it
then make clean in postfix port and build it again.

cd /usr/ports/databases/mariadb118-server
make clean
make
# you may need to uninstall the old version first
make install
cd /usr/ports/mail/postfix
make clean
make
# you may need to uninstall the old version first
make install
Click to expand...

you can use portupgrade to automate this. Also make sure you have latest ports using git or gitup
 
Thank you again. What I have been doing for the past five or so years is using pkg for userland updates, with the exception of mail/dovecot and mail/postfix. Because I need some options not included by default in the packages, these two I compile from source and then LOCK them. I UNLOCK them, recompile, LOCK them again with each OS upgrade. This has worked OK up to now.

I updated the /usr/ports tree using
git clone --branch main https://git.freebsd.org/ports.git /usr/ports/

And:
$ pkg info mariadb118-server
mariadb118-server-11.8.3_1


Once again the mysql version error:
/usr/ports/mail/postfix $ make all reinstall
===> postfix-3.10.6,1 cannot install: unknown MySQL version: 105m.
*** Error code 1

Stop.
make: stopped making "all reinstall" in /usr/ports/mail/postfix


I am using mariadb basically just to manage domain names and aliases in postfix using web-based mail/postfixadmin
mysql_virtual_alias_maps.cf
mysql_virtual_domains_maps.cf
mysql_virtual_mailbox_maps.cf


I suppose to could revert to mysql and ditch mariadb. Or even go back to editing the map files by hand. What do you think?
 
hmmm...

/usr/ports/mail/postfix $ make clean
===> Cleaning for postfix-3.10.6,1
===> Cleaning for postfix-ldap-3.10.6,1
===> Cleaning for postfix-mongo-3.10.6,1
===> Cleaning for postfix-mysql-3.10.6,1
===> Cleaning for postfix-pgsql-3.10.6,1
===> Cleaning for postfix-sasl-3.10.6,1
===> Cleaning for postfix-sqlite-3.10.6,1
root@mx1 /usr/ports/mail/postfix $ make all reinstall
===> postfix-3.10.6,1 cannot install: unknown MySQL version: 105m.
*** Error code 1

Stop.
make: stopped making "all reinstall" in /usr/ports/mail/postfix
 
Where? I see this in /usr/ports/Mk/Uses/mysql.mk (unedited):

Code: 
DEFAULT_MYSQL_VER?=     ${MYSQL_DEFAULT:S/.//}
# MySQL client version currently supported.
# When adding a version, please keep the comment in
# Mk/bsd.default-versions.mk in sync.
MYSQL80_LIBVER=         21
MYSQL84_LIBVER=         24
MYSQL91_LIBVER=         24
MYSQL94_LIBVER=         24

.  for v in 106 1011 114 118
MYSQL${v}m_LIBVER=      3
.  endfor
 
You must log in or register to reply here.
Back
Top