Problem updating ISPconfig: mysql: unknown variable 'innodb_buffer_pool_size = 1G'

Hi I am getting the following error when trying to update ISPconfig from 3.1 to 3.2:

In the /etc/mysql/mariadb.conf.d/50-server.cnf file all the "general_log_file = /var/log/mysql/mysql.log" are commented.

It has been working perfect for 5 months with The Perfect Server - Debian 10 guide, Is it possible that it is due to having it on a Raspberry Pi 4GB (ARM) with Raspbian?

To update I do it with the guide of https://www.howtoforge.com/updating-ispconfig-3-1-to-ispconfig-3-2/ where the only thing that I cannot install in rar, but I don't know if it is part of the problem?

If the mariadb status is necessary, which always has the following information:

Expand: systemctl status mysql.service

Thank you

 

Was the original version latest 3.1 before upgrade? Upgrade to 3.2 is best supported from 3.1.15.
Maybe innodb_buffer_pool_size is no longer in recent versions of mariadb? How old is this installation and did it have older version of mysql or mariadb before? Did you upgrade also the OS?

 

Hi @Taleman
- Sorry, I was not specified, the current version of ISPconfig is 3.1.15p3

- The installation takes 5 months, only normal updates (update, upgrade) and kernel (dist-upgrade).

- The installation is Raspbian GNU/Linux 10.6 (buster) Linux 5.4.72-v7l + armv7l

- I have maridb, but it is Interesting, I try to see the installed version but it gives an error:
# mariadb --version
mariadb: unknown variable 'innodb_buffer_pool_size = 1G'

# apt install mariadb-server
mariadb-server is already the newest version (1: 10.3.25-0 + deb10u1).

Even with that mariadb error, ISPconfig always works fine, emails and even nextcloud works without problems.

Note:
I have another same installation on another PC and ISPconfig updated without problem:
# mariadb --version
mariadb Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2


Thanks

 

Remove or comment out that innodb_buffer_pool_size setting.

 

Thank you @Taleman, that was the solution to update.