[Warning] Access denied for user '_5e5899d8398b5f7b'@'172.18.0.7' (using password: YES)

42
  • Enter into the backend container
  • execute, bench new-site --db-root-password=admin --install-app=erpnext --admin-password=admin --no-mariadb-socket --force frontend

That should create the site.

Next challenge will be getting it available on localhost:8080 on your browser.

Try it. Do not proceed using it. It is a very unreliable setup and you will risk losing all the data. You need basic backups configured for production.

Too many things to explain on this forum topic for a simple thing that is already resolved in troubleshoot for people who can figure it out.

43

it will be pwd.yml or any of the setups under frappe_docker. None of them have TLS enabled for mariadb.

44

TLS is enabled on the SERVER.

45

if it is pwd.yml there is no tls.

if it is easy-install.py there is traefik and tls. which is not related to mariadb needing certificates.

There is no tls for frappe-bench connecting to mariadb under frappe/frappe_docker, all mariadb containers run with non-tls configurations. you connect to it without any certificates.

46

I have deleted volume, containers and images multiple times already.
also uninstalled docker desktop multiple times to have a fresh install.
however, I picked up a potential issue.
I don’t think this command works or worked.

RENAME USER ‘_5e5899d8398b5f7b’@‘172.18.0.7’ TO ‘_5e5899d8398b5f7b’@‘%’;
when I input this nothing happens. I assumed it worked but I think it is not changing.
how to test if it worked

47

Run the command SELECT User, Host FROM mysql.user; to test it. Verify if your user has % in the host case. If it’s still and IP address, rewrite your RENAME query and make sure you put the right values in the query and test it again by running SELECT User, Host FROM mysql.user;

After confirming that everything is fine, exit the container, stop erpnext and and start it again.

48

question.
please explain where does the MySQL server and database run?
If I delete all my containers, images etc and also uninstall docker. does
MySQL server and database also get deleted? or does this run elsewhere?

because now after reinstalling ERP next the usual passwords that always worked
when logging into the containers does not work anymore.

49

the password used to log into the database container is either set in the docker-compose file used to create the container or in the command you used to create the container. MySQL run inside docker if it’s part of your erpnext installation meaning that if you delete docker, it’s deleted along with it.