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

[jacobotha777]

[jacobotha777]

did what you asked, i noticed that there are still actual images and containers left in docker.
should they not dissapear?

[Thevoice]

yes, they should all disappear, some of them still carry the old config files, you need to delete all of them before reinstalling erpnext

[jacobotha777]

thank you again for your patience!!
will uninstalling docker completely, and reinstalling docker again not solve this issue?
I assumed doing that will install a completely new instance of erp next.
I’ve tried those multiple times also but still no good result. does docker store the databases somewhere that does not get removed when uninstalling docker itself?

[Thevoice]

Yes, you can uninstall and reinstall docker, it will delete all docker files from your system

[revant_one]

Did you read through these posts?

Container Basics

Why? People who don’t know containers land up successfully installing ERPNext with containers and get stuck later. Read for container basics. Prerequisites Unix/Linux basics, init system, processes, mount points, bash shell. podman or docker, podman-compose or docker compose is installed. Go for rootless podman if you can. Standard docker will work. Make sure you’re NOT using snap to install docker, it’ll not work as expected through snap. Install, docker docker compose Or alternatively …

Container Builds

Read Container Basics before you begin. Let’s build a simple frappe py server that returns 404 Not Found Create a Dockerfile in current working directory. FROM python:3-alpine # Install required os packages to install frappe RUN apk add -U git build-base linux-headers && \ # Create directory for apps and sites mkdir -p /opt/simple-server/apps /opt/simple-server/sites && \ # Create python env python3 -m venv /opt/simple-server/env && \ # install frappe version-14 /opt/simple-serve…

I don’t think they’ll be any useful because they also run on Linux machine.

[jacobotha777]

I Have done this multiple times but still can’t get Erp next to run as it did the first time.
I will have to dig deeper then.

[revant_one]

@Thevoice

docker volume pune -a

docker image prune -a

docker system prune -a

To reset everything change above sequence to following.

# stop container
docker stop $(docker ps -qa)
# remove all containers
docker system prune -f
# remove all volumes
docker volume prune -f --all
# remove all images
docker image prune -f --all

Clearing the volumes and images first will only clear them for deleted containers.

[jacobotha777]

@revant_one

docker image prune -f --all

Hi @revant_one

I followed your instructions. containers, images and volumes show nothing now.
Docker desktop also has a delete button to delete them, which I have done many times before.
am I ready now to reinstall erp next again?

And this is done by running the following command after changing to the corresponding directory?

docker compose -f pwd.yml up -d

I am using the zipped file from (GitHub - frappe/frappe_docker: Docker images for production and development setups of the Frappe framework and ERPNext)

[jacobotha777]

@Thevoice the voice
still attempting to get erp next running.
completely new installation:
docker reinstalled.
cloned the github repository.
installed that as per the instructions.
see attached screenshot please.

[jacobotha777]

[jacobotha777]

the two containers, create site and configurator stops. they have complaints in the log files.
are they suppose to run or is it normal to not run?
what is the next step? where do i start faultfinding?

when logging into mariadb manually i can access it. the ip adress is also showing the % value. so it is not linked to one specific ip adress

[Thevoice]

Hey @jacobotha777 I have this error everytime I complete a new installation of ERPnext and this answer is the solution:

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

Hi, this issue is not caused by the password itself. If you’re using mariadb, it is sensitive to the host address. For a reason a ignore, anytime you restart erpnext, the host ip associated with the database user created by ERPnext changes. What you can do is log into your mariadb server and run this command to untie the user to a particular host: RENAME USER ‘_5e5899d8398b5f7b’@‘172.18.0.7’ TO ‘_5e5899d8398b5f7b’@‘%’; It should resolve your problem. If you’re still facing the same issue, then…

You need to rename the user to ensure it does not have any particular host linked to it. After that, all you need is stop the container completely and restart it again.

[jacobotha777]

hi @Thevoice thanks again for the speedy response.
this is done. when checked it shows the %
should i send a screenshot confirming?

what else could be the issue?

[jacobotha777]

is all in order as per your request to rename the user?

[jacobotha777]

i have followed these instructions multiple times.
so currently it is a brand new installation, showing the acces denied error.

[Thevoice]

are you sure you are logged to the right mariadb container? cause the erpnext user is not in the table

[jacobotha777]

underlined with red. i believe this is correct?

[Thevoice]

Delete your volumes cause apparently, ERPnext is trying to connect to a database with a user that is inexistent inside. Delete your volumes and reinstall ERPNext. Then if you have the issue again, simply log into the database, ensure the user is there and then use the rename command to remove the host ip address.

To delete your volumes, fist stop all containers and then use the command: docker volume prune -a

[jacobotha777]

this is a new installation. so I am going to try the remove host ip again