Can't upgrade from MariaDB 10.11 to MariaDB 11.4 on HestiaCP

Community Support Database
1

Hey,

I have installed fresh Debian 12.7 (x86_64) with HestiaCP and tried this multiple times, but it always fails no matter what. I also tried other version such as 11.5, but they fail as well. Notice that I don’t add any websites or databases before this process. The installation is fresh and nothing is modified.

Steps to reproduce:

  1. apt update & apt upgrade

  2. What is installed: PHP-FPM, iptables, HestiaAPI, VSFTPD, MariaDB, Fail2Ban, Intreactive install, Hostname

  3. Run HestiaCP (v1.8.12) installation and reboot the server after successful installation

  4. nano /usr/local/hestia/install/upgrade/manual/upgrade_mariadb.sh (modify target ver to 11.4)

  5. bash /usr/local/hestia/install/upgrade/manual/upgrade_mariadb.sh

  6. Here is full output and errors PrivateBin

Tried to remove unknown variables from the error logs, but it did not help. Any suggestions what I did wrong? Thank you!

2

You can modify the install script and set the wanted mariadb version directly.

3

Install the plugins:

apt install mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo mariadb-plugin-provider-snappy
4

I tried to do this, but it still installed 10.11.6-MariaDB-0+deb12u1 Debian 12 after running mariadb -v or mysql -v.

Steps to reproduce:

  1. Get Debian installation config, instead of default one
    wget https://raw.githubusercontent.com/hestiacp/hestiacp/release/install/hst-install-debian.sh

  2. Modify DB_VERSION=‘10.6’ to DB_VERSION=‘11.4’ and save changes.
    nano hst-install-debian.sh

  3. Run the modified installer
    bash hst-install-debian.sh

Not sure what I did incorrectly, but it seems like it refused to install newer version. No errors or warning there show during installation.

5

Unfortunately this didn’t work either. Here is full output and I am still getting same errors.

6

I think Hestia 1.8.x is still using Debian MariaDB from “Debian” package server

So in that case the the main branch and and copy the part where it install mariadb repo

7

As @eris pointed out, when using Debian 12, Hestia installer doesn’t use the MariaDB repo, uses Debian repo.

Edit hst-install-debian.sh and on line 748 remove the comment on #deb:

From this:

 echo "#deb [arch=$ARCH signed-by=/usr/share/keyrings/mariadb-keyring.gpg] https://dlm.mariadb.com/repo/mariadb-server/$mariadb_v/repo/$VERSION $codename main" > $apt/mariadb.list

to this:

 echo "deb [arch=$ARCH signed-by=/usr/share/keyrings/mariadb-keyring.gpg] https://dlm.mariadb.com/repo/mariadb-server/$mariadb_v/repo/$VERSION $codename main" > $apt/mariadb.list
8

Thank you for clarification, since I didn’t understand exactly that eris said :smiley:

I just tried it once again and it worked. The only warning during installation was:

[ * ] Configuring MariaDB database server...
/usr/bin/mysql_install_db: Deprecated program name. It will be removed in a future release, use 'mariadb-install-db' instead

Once again thanks everyone in this thread. Really like the community! :love_letter:

9

Yeah for now it is fine …