Maria DB configuration

Shankar_guru · February 7, 2018, 11:41am

After installing frappe i tried to add site, I am getting this info what i want to do?
I need help regarding mariadb.

Zlash65 · February 7, 2018, 11:46am

Try doing this MariaDB conf for Frappe · frappe/bench Wiki · GitHub, and don’t forget to restart mariadb after saving the file.

abhijit_kumbhar · February 7, 2018, 11:51am

You need to edit my.cnf file.
Go to /etc/mysql/ and edit my.cnf and add following content

[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

and don’t forgot to restart maria db

Shankar_guru · February 7, 2018, 11:59am

How can i open my.cnf file ? please provide the instruction step by step.
Means how can i go to /etc/mysql/ in terminal ?
Please help me,i am new to ERPnext.

Shankar_guru · February 7, 2018, 12:01pm

I have tried ,I am getting these error.

Shankar_guru · February 7, 2018, 12:02pm

I have tried but got this error.

Zlash65 · February 7, 2018, 12:15pm

Try sudo nano /etc/mysql/my.cnf and editing it.

Shankar_guru · February 7, 2018, 12:25pm

I got this window how to edit my.cnf file.There is no information regarding barracuda.

MaysaaSafadi · February 7, 2018, 12:36pm

After copying the configration from the first photo>> go to the last line and press CTRL+SHIFT+V
Then CTRL+O Then CTRL_M to save
Then CTRL+X to exit

Zlash65 · February 7, 2018, 12:36pm

Simply paste this at the end of the file. Notice in line 1 its specified innodb-file-format=barracuda - hope this solves your issue

Shankar_guru · February 7, 2018, 12:39pm

Thank you for the usefull information.Thank you very much.

Shankar_guru · February 7, 2018, 12:47pm

Ihave entered CTRL+O
Then it’s asking what to do next??

CTRL_M command is not working it’s asking like this

Shankar_guru · February 7, 2018, 12:47pm

Can i save file under different name??

shelteradmin · February 7, 2018, 12:53pm

after ctrl+O the file is saved . you just have to exit the console pressing ctrl+X

raghukamath · February 8, 2018, 4:22am

copy the following by selecting this text below and doing ctrl v

[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

Open terminal by pressing ctrl + Alt + T
then in the prompt put sudo nano /etc/mysql/my.cnf press enter

The press down arrow to got to last line and do ctrl + shift + v

Then press Ctrl + X then Press Y

Then do systemctl restart mariadb

Hope that covers everything.

MaysaaSafadi · February 8, 2018, 1:59pm

It is worked fine for me in ubuntu 16.4.
Try to search for the right way according to your ubuntu version,