ERPNext VM internal server error

[trentmu]

You can start the service using

sudo service mysql start

[Mulatu_mekonnen]

[trentmu]

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

[Mulatu_mekonnen]

[Mulatu_mekonnen]

no datadir found

[trentmu]

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

sudo cat /etc/mysql/my.cnf

[Mulatu_mekonnen]

sure here it is

[trentmu]

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)

[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
#Set buffer pool size to 50-80% of your computer’s memory
innodb_buffer_pool_size=1G
#Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=256M
innodb_log_buffer_size=128M
max_allowed_packet=32M

then try a restart of the DB

sudo systemctl restart mariadb

[Mulatu_mekonnen]

sorry where i can find config file…

[trentmu]

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

[Mulatu_mekonnen]

[Mulatu_mekonnen]

[Mulatu_mekonnen]

[Mulatu_mekonnen]

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

[trentmu]

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

[Mulatu_mekonnen]

SELinux is not running

[Mulatu_mekonnen]

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

[trentmu]

The line
innodb_flush_method = O_DIRECT
should probably also be commented out

[clarkej]

@Mulatu_mekonnen

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

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

Where do I go to setup Backups in new v8

@bkm I grok your frustration finding your way in file systems IMHO to reduce frustration ‘find’ rocks, and used with ‘grep’ the two commands are a joy frappe@erpnext:~/frappe-bench$ cd ~ frappe@erpnext:~$ find . -name frappe-bench ./frappe-bench frappe@erpnext:~$ find . -name backups ./frappe-bench/apps/frappe/frappe/desk/page/backups ./frappe-bench/sites/erpnext.vm/private/backups frappe@erpnext:~/frappe-bench$ find . -name *.py | xargs grep ‘def get_hooks’ ./apps/frappe/frappe/init.py…

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

[XcepTi]

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

ERPNext

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 … and good luck with your installation.