Site is not getting created , operating system linux mint 18

I am trying to install a new site in my frappe . But while installing it’s giving me this error .
I tried to solve the issue by creating my.cnf.d file under the etc folder and then also created the frappe.cnf folder under my.cnf.d and pasted the code .
But still it is not working for me .
can any one please suggest .

**Creation of your site - site2 failed because MariaDB is not properly **
**configured to use the Barracuda storage engine. **
**Please add the settings below to MariaDB’s my.cnf, restart MariaDB then **
run bench new-site site2 again.

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

-add this line to your my.cnf file with sudo permission.
-location /etc/mysql/my.cnf
-restart mysql service

Thanks

Like it mentions, Add the above to your my.cnf file. Check here for where this file should exists. You’d require sudo for most cases.

You might also need to restart mariadb depending on the init system your flavour uses.

Assuming it’s systemd

$ sudo systemctl start mariadb.service

Thank you @achillesrasquinha @sagar. The issue got solved.

1 Like