Bench new-site giving error

Frappe Framework
, , ,
1

I recently upgraded my server to ubuntu 24 and mariadb version got upgraded to mysql Ver 15.1 Distrib 10.11.8-MariaDB

now when I try to create new-site getting following error. All the configurations are already present in cnf file.

bench new-site sitename
MySQL root password:
For key innodb_file_format. Expected value Barracuda, found value None
For key innodb_large_prefix. Expected value ON, found value None

Creation of your site - sitename failed because MariaDB is not properly
configured. If using version 10.2.x or earlier, make sure you use the
the Barracuda storage engine.

2

What version of frappe are you using?

Do check with bench version

The current versions don’t check for this, it was dropped quite a while ago: fix: Buggy Mariadb version check by marination · Pull Request #20059 · frappe/frappe · GitHub

3

my bench verison is 5.22.9
erpnext 14.1.2
frappe 14.7.0

4

Please update to the latest versions and try.

5

Here is how I got pass this. Updating the frappe-bench version did not solve this so I went into frappe app code, in this file frappe/frappe/database/mariadb/setup_db.py in the function bootstrap_database comment this line out as seen below:

def bootstrap_database(db_name, verbose, source_sql=None):
	frappe.connect(db_name=db_name)
	# if not check_database_settings():
	# 	print('Database settings do not match expected values; stopping database setup.')
	# 	sys.exit(1)

	import_db_from_sql(source_sql, verbose)

	frappe.connect(db_name=db_name)
	if not 'tabDefaultValue' in frappe.db.get_tables():
		print('''Database not installed, this can due to lack of permission, or that the database name exists.
			Check your mysql root password, or use --force to reinstall''')
		sys.exit(1)

Run the new-site command again.

NB!! Remeber to remove the comment after