I just upgraded to mariadb 10.4 and now pure-ftpd-mysql won't start. Code: Feb 07 18:07:26 mx systemd[1]: Starting pure-ftpd-mysql.service... -- Subject: Unit pure-ftpd-mysql.service has begun start-up -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit pure-ftpd-mysql.service has begun starting up. Feb 07 18:07:26 mx pure-ftpd-mysql[7810]: Starting ftp server: Running: /usr/sbin/pure-ftpd-mysql-virtualchroot -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -A -O clf:/var/log/pure-ftpd/transfer.log -J HIGH -b -E -Y 1 -u 1000 -D -8 UTF-8 Feb 07 18:07:26 mx pure-ftpd-mysql[7810]: /usr/sbin/pure-ftpd-mysql-virtualchroot: relocation error: /usr/sbin/pure-ftpd-mysql-virtualchroot: symbol my_make_scrambled_password, version libmariadbclient_18 not defined in file libmariadbcl Feb 07 18:07:26 mx systemd[1]: pure-ftpd-mysql.service: Control process exited, code=exited status=127 Feb 07 18:07:26 mx systemd[1]: Failed to start pure-ftpd-mysql.service. -- Subject: Unit pure-ftpd-mysql.service has failed -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit pure-ftpd-mysql.service has failed. -- -- The result is failed. Feb 07 18:07:26 mx systemd[1]: pure-ftpd-mysql.service: Unit entered failed state. Feb 07 18:07:26 mx systemd[1]: pure-ftpd-mysql.service: Failed with result 'exit-code'. (Debian Stretch) ISPConfig 3.2.2 Your thoughts would be most helpful Regards Fred
Code: apt install mariadb-client-10.4 Reading package lists... Done Building dependency tree Reading state information... Done mariadb-client-10.4 is already the newest version (1:10.4.17+maria~stretch). mariadb-client-10.4 set to manually installed. The db update was performed by adding the following to /etc/apt/sources.list, then I did an apt update, then an apt upgrade. Code: # MariaDB 10.4 for Debain 9 deb [arch=amd64,i386,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.4/debian stretch main deb-src http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.4/debian stretch main So I assume everything was updated when I performed an apt upgrade Regards Fred
Code: root@mx:~# uname -a Linux mx 4.9.0-14-amd64 #1 SMP Debian 4.9.246-2 (2020-12-17) x86_64 GNU/Linux (Debian Stretch) ISPConfig 3.2.2 Regards Fred
I have managed to resolve my issue by compiling and installing a patched version of pure-ftpd-mysql for mariadb 10.4 However now apt wants to upgrade to the newest version. How can I stop apt from upgrading pure-ftpd-mysql as I'm concerned I will be back to where I was. Code: mx:~# apt list --upgradable -a Listing... Done pure-ftpd-mysql/oldstable 1.0.43-3 amd64 [upgradable from: 1.0.43-3] pure-ftpd-mysql/now 1.0.43-3 amd64 [installed,upgradable to: 1.0.43-3] Regards Fred
The problem is using the bleeding edge version of mariadb and not pure-ftpd-mysql. This is a known problem which may cause error(s) not only to pure-ftpd-mysql but to other software(s) as well. The right fix is to revert back to the one shipped with your OS version. If you need "quite" the latest softwares, then perhaps upgrading your OS to latest stable version will help. It might not shipped the latest bleeding edge version of softwares but latest stable version of softwares suitable to the latest version of your OS.
