ERPNext VM internal server error

You can start the service using

sudo service mysql start

image

Can you show the mysqld log files?

From “What to Do if MariaDB Doesn’t Start”
In most cases you should be able to find out the place of the error file by doing:

mysqld --help --verbose | grep ‘log-error’ | tail -1
mysqld --help --verbose | grep ‘datadir’ | tail -1

From the same article…you might also need to check if you have SELinux running
To verify if SELinux is running:

getenforce

image

no datadir found
image

Could you share your /etc/mysql/my.cnf file?

sudo cat /etc/mysql/my.cnf

sure here it is
image

In the config file, you’ll need a section that has (approximately) the following…
(I have adjusted it to the 2GB of RAM that you have in your system)

then try a restart of the DB

sudo systemctl restart mariadb

sorry where i can find config file…

The file is here…
/etc/mysql/my.cnf

image

image

image

i can’t find some config lines like
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

innodb_log_file_size=256M

OK, from an ERPNext perspective, those are essential, so you need to add them in to your config and then restart the mariadb service

SELinux is not running

where i can find and delete these two files binlog and tc.log i am using Ubuntu 14.04

The line
innodb_flush_method = O_DIRECT
should probably also be commented out

linux ‘find’ and ‘grep’ are ideal to dig around and discover what is where for example

https://discuss.erpnext.com/search?q=%40clarkej%20find%20.%20-name%20%27*.%27

I tried everything but it is simply to unstable. I moved to the Bitnami Installation package on a clean Ubuntu VM installation. Very stable!

https://bitnami.com/stack/erpnext/installer

This is exactly what I was searching for. I especially love the little tool to start and stop all relevant services. This way I can shutdown the machine safely anytime I want. For me as a little start-up this is exaclty what I need. I don’t want a machine running 24/7 if I need it 3 hours a week. Save the planet :slight_smile: … and good luck with your installation.