Bench new-site giving error

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.

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

my bench verison is 5.22.9
erpnext 14.1.2
frappe 14.7.0

Please update to the latest versions and try.