Internal Server Error on installation

Install / Update
1

I installed ERPNext on ubuntu 16.04 and the installation was successful but when i try to access the application it starts and after some second i get the error message: “Internal Server Error”. i have checked to see which services are running and nginx seems to be running. see the list below:

$ sudo netstat -plnt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1129/sshd
tcp 0 0 127.0.0.1:11000 0.0.0.0:* LISTEN 2080/redis-server 1
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 2781/master
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 2069/python
tcp 0 0 127.0.0.1:12000 0.0.0.0:* LISTEN 2091/redis-server 1
tcp 0 0 127.0.0.1:13000 0.0.0.0:* LISTEN 2085/redis-server 1
tcp 0 0 127.0.0.1:6379 0.0.0.0:* LISTEN 1257/redis-server 1
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 1810/nginx -g daemo
tcp 0 0 0.0.0.0:53 0.0.0.0:* LISTEN 1053/dnsmasq
tcp6 0 0 :::22 :::* LISTEN 1129/sshd
tcp6 0 0 :::25 :::* LISTEN 2781/master
tcp6 0 0 :::9000 :::* LISTEN 2070/node
tcp6 0 0 :::53 :::* LISTEN 1053/dnsmasq

2

additional information:

i noticed mysql is down when i checked:

service mysql status
● mariadb.service - MariaDB 10.2.22 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: timeout) since Thu 2019-03-21 09:13:48 EDT; 16min ago
Docs: man:mysqld(8)
systemd - MariaDB Knowledge Base
Process: 1630 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (
Process: 1165 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin
Process: 1156 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exit
Process: 1124 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exite
Main PID: 1630 (code=exited, status=0/SUCCESS)

Mar 21 09:12:15 erpnext systemd[1]: Starting MariaDB 10.2.22 database server…
Mar 21 09:12:18 erpnext mysqld[1630]: 2019-03-21 9:12:18 140109290084544 [Note] /usr/sbin/mysqld (m
Mar 21 09:12:18 erpnext mysqld[1630]: 2019-03-21 9:12:18 140109290084544 [Warning] Could not increa
Mar 21 09:12:18 erpnext mysqld[1630]: 2019-03-21 9:12:18 140109290084544 [Warning] Changed limits:
Mar 21 09:13:47 erpnext systemd[1]: mariadb.service: Start operation timed out. Terminating.
Mar 21 09:13:48 erpnext systemd[1]: Failed to start MariaDB 10.2.22 database server.
Mar 21 09:13:48 erpnext systemd[1]: mariadb.service: Unit entered failed state.
Mar 21 09:13:48 erpnext systemd[1]: mariadb.service: Failed with result ‘timeout’.

3

Can you start the server manually?

sudo systemctl start mysqld

4

No. i get this error:
Job for mariadb.service failed because a timeout was exceeded. See “systemctl status mariadb.service” and “journalctl -xe” for details.

5

and when i run “systemctl status mariadb.service” i get this error

mariadb.service - MariaDB 10.2.22 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: timeout) since Thu 2019-03-21 09:52:04 EDT; 3min 11s ago
Docs: man:mysqld(8)
systemd - MariaDB Knowledge Base
Process: 3853 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (
Process: 3579 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin
Process: 3572 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exit
Process: 3566 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exite
Main PID: 3853 (code=exited, status=0/SUCCESS)

Mar 21 09:50:32 erpnext systemd[1]: Starting MariaDB 10.2.22 database server…
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Note] /usr/sbin/mysqld (m
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Warning] Could not increa
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Warning] Changed limits:
Mar 21 09:52:03 erpnext systemd[1]: mariadb.service: Start operation timed out. Terminating.
Mar 21 09:52:04 erpnext systemd[1]: Failed to start MariaDB 10.2.22 database server.
Mar 21 09:52:04 erpnext systemd[1]: mariadb.service: Unit entered failed state.
Mar 21 09:52:04 erpnext systemd[1]: mariadb.service: Failed with result ‘timeout’.

6

Can you show the end of these 3 lines?

7

Mar 21 09:50:32 erpnext systemd[1]: Starting MariaDB 10.2.22 database server…
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Note] /usr/sbin/mysqld (mysqld 10.2.22-MariaDB-10.2.22+mari
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Warning] Could not increase number of max_open_files to mor
Mar 21 09:50:33 erpnext mysqld[3853]: 2019-03-21 9:50:33 139930333771968 [Warning] Changed limits: max_open_files: 16364 max_connect
Mar 21 09:52:03 erpnext systemd[1]: mariadb.service: Start operation timed out. Terminating.
Mar 21 09:52:04 erpnext systemd[1]: Failed to start MariaDB 10.2.22 database server.
Mar 21 09:52:04 erpnext systemd[1]: mariadb.service: Unit entered failed state.
Mar 21 09:52:04 erpnext systemd[1]: mariadb.service: Failed with result ‘timeout’.

8

Have a look here…