ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Problem with mariadb


#1

Hello Community ,
I was trying to install erp next on CentOS 7 , and I had this problem , I guess the major problem was with the configuration of etc/my.cnf ! I didn’t found symbolic-links=0 in order to write under it those commands : 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

I’m using this guide to help me : https://www.vultr.com/docs/how-to-install-erpnext-open-source-erp-on-centos-7
could you please help me ?

thank you all !


#2

Hi welcome to ERPNext,

The problem may be a result of you running as root which is not recommended.

Instead you best install from a user account with sudo privileges, for example user frappe.


#3

When I access that file , this is what I found


I created a user with sudo privileges


#5

Hello @Mohamed_Amine_Berrou,

Seems link you have a broken configuration file for mysql. either you can copy the default configuration file from here https://gist.github.com/oinume/fc9b72bd8b14ab07e94c … then continue add the settings.

or

use the easy install script from frappe to install the production version… I recommend using that…

the link you provided will install develop version… that is version 12…


#6

Did you create a user with sudo privileges means:

  • you created a user;
  • you logged in with that user;
  • you installed ERPNext with that user;

If you followed the steps I wrote above, you should install everything smoothly…
About MariaDB, I suggest to use version 10.2.x and not 10.3.x

I run different ERPNext instances on Centos and everything I installed was quite smooth with automatic installer.

take a look at: https://github.com/frappe/bench/issues/681