I have setup ERPNext and unable to login getting 500 internal server error

,
1

Hi All,

I have setup ERPNext and unable to login getting 500 internal server error

Please suggest how can solve it

2023-10-31 12:12:47,107 ERROR frappe New Exception collected with id: 2023-10-31 12:12:46.748027-127.0.0.1-6e5
Site: site1.local
Form Dict: {‘cmd’: ‘login’, ‘usr’: ‘Administrator’, ‘device’: ‘desktop’}

2

Is your Database Server running?

Also check frappe-bench/logs/web-error.log

3

Hi Suresh Thakor,

There is no file created like web-error.log, where can I find the db is running or not?

image
image1920×1025 117 KB

4

@harisanchan

Run sudo service mariadb status in frappe-bench

5

@Hardik_Gadesha Is the above command is not working in windows, we have installed frappe with erpnext using docker, could you please provide the windows command
we have tried bench mariadb it shows the db,
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1257
Server version: 10.6.15-MariaDB-1:10.6.15+maria~ubu2004 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [_654158012986d6fb]> show databases
→ ;
±-------------------+
| Database |
±-------------------+
| _654158012986d6fb |
| information_schema |
±-------------------+
2 rows in set (0.112 sec)

MariaDB [_654158012986d6fb]> use mysql;
ERROR 1044 (42000): Access denied for user ‘_654158012986d6fb’@‘172.18.0.5’ to database ‘mysql’
MariaDB [_654158012986d6fb]> Ctrl-C – exit!

6

@Hardik_Gadesha Now the error was changed 401 UNAUTHORIZED given right credentials also getting Invalid login credentials
we have done bench setup requirements command the error was changed now