ERPNext installation Mariadb config issue

mufeez · March 17, 2021, 9:14am

I have installed and configured collation in my.conf. still getting collation error.
Attached is the error screen shot

revant_one · March 17, 2021, 9:34am

Check if this helps MariaDB conf for Frappe · frappe/bench Wiki · GitHub

mufeez · March 17, 2021, 10:04am

Thanks @revant_one, i have all the entries in my.cnf, still no luck

brian_pond · March 17, 2021, 8:56pm

What version of MariaDB server?

Suresh_Thakor · March 17, 2021, 9:40pm

See the collection-server

sudo nano /etc/mysql/my.cnf

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
 
 #this block should be in bottom
 [mysql]
 default-character-set = utf8mb4

 systemctl restart mariadb

mufeez · March 18, 2021, 6:33am

Thanks for your comments, i resolved this issue by copying my.cnf to mariadb.conf.d directory