When attempting to install ERPNext 15 on Ubuntu 24.0.2 LTS, I encountered significant challenges with MariaDB version compatibility. Despite following recommended installation guides, Ubuntu’s package management system consistently defaults to MariaDB 10.11, which is not compatible with ERPNext’s requirements.
Does anyone know any workarounds for this?
I’m following this one by the way:
@sideroomghost we always encourage to use ubuntu 22 . it’s more stable and compatible with frappe . switching to ubuntu 22 will solve your issue , otherwise you will have a hard time fixing all packages versions , not only mariadb .
You can use MariaDB 10.11 and Python 3.12 without any problem. No need to care about GitHub - D-codE-Hub/-Frappe-ERPNext-Version-15--in-Ubuntu-24.04-LTS
Yeah, ERPNext 15 requires MariaDB 10.6. You’ll need to manually install it since Ubuntu 24.04 defaults to 10.11. Try removing the existing MariaDB, then add the MariaDB 10.6 repo and install it manually. Something like this:
sudo apt remove mariadb-server
sudo apt update
sudo apt install software-properties-common
sudo add-apt-repository 'deb [arch=amd64] http://archive.mariadb.org/mariadb-10.6/repo/ubuntu focal main'
sudo apt update
sudo apt install mariadb-server
Might need some tweaking depending on dependencies, but this should get you going!
The newer MariaDB versions are fine; you just have to review your my.cnf configurations.
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[mysql]
default-character-set = utf8mb4
For example, I am currently using ERPNext V15 + MariaDB 11.2.2 in a production environment, and it works just fine. This is far beyond the suggested 10.6 version.
Just out of curiosity, what tangible benefits are there to using the version you mention. I see that frappe is still on 10.6.
I think it is better to know if there is any version dependent development or configuration which I think there is not as the framework is even compatible with PostGre. If there is a solid drawback or functionality in error, better to report it as we have LTS24 systems on latest update mariadb without any problem running for ages.
If you feel the need to ask why, well, I’d like to stay on the cuttting adge.
I cannot cite any direct, tangible benefits.
I chose to install the MariaDB version I did because:
It seemed unwise to install a brand-new database server, but then deliberately choose a version from nearly 4 years ago (April 2021). Instead, I’d like to take advantage of whatever improvements the MariaDB Team has made since then.
In the past 8 years, I’ve experienced many performance problems and headaches with MariaDB. If I continued using 10.6, nothing would change. If I installed the latest stable, the situation would either: Improve, get Worse, or Stay the Same.
The only way to find out was to try, and see.
Also, Frappe/ERPNext is not doing anything strange or special with MariaDB; just normal SQL requests and syntax. So I was not concerned at all with moving from 10.6 to 11.X. If queries and statements worked before, they would certainly work now on the newer version. The only thing you have to be mindful of are configuration changes, like the previously mentioned collations, unicode/UTF things.
And if I was wrong? Well, then I’d go fix whatever Python/SQL needed fixing. No problem.
(fyi, it turned out that things did -not- improve, so I’m giving up on MariaDB entirely, and switching to Postgres. but that’s a whole other story. MariaDB 11.2 is running equally well, compared to 10.6)
Since I can restore a site backup taken from a mariadb running site on a postgres site, I can live with it 
Have you ever tried @brian_pond ?
No, I have not: interesting! I’ve just been using pgloader.