Local Docker Deployment

shareeef · March 13, 2021, 7:29pm

I was able to create the site, most of the errors are related to site-creator starting before mariadb is completed. I moved mariadb service to be first and added dependencies on that on other containers.

I also changed mariadb.cnf ot add barracuda.

I am now getting this error when I browse to the site.
2021-03-13 19:10:57 23 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.11’ (using password: YES)
2021-03-13 19:11:57 24 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.11’ (using password: YES)
2021-03-13 19:12:57 25 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.11’ (using password: YES)
2021-03-13 19:13:57 26 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.11’ (using password: YES)
2021-03-13 19:14:57 27 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.11’ (using password: YES)

shareeef · March 13, 2021, 7:36pm

The database _5da3170083d9d5b5 is not created in mysql…let me try some more…

Added Health Check to mariadb

and keeping fingers crossed

Now seeing bunch of access denied in the mariadb container:
2021-03-14 0:10:06 86 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.8’ (using password: YES)
2021-03-14 0:10:14 87 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)
2021-03-14 0:11:06 88 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.8’ (using password: YES)
2021-03-14 0:11:15 89 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)
2021-03-14 0:12:06 90 [Warning] Access denied for user ‘_5da3170083d9d5b5’@‘172.22.0.8’ (using password: YES)
2021-03-14 0:12:15 91 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)

UPDATE:
Finally figured out the dependencies, and was able to build the development stack consistently without the errors. The site-creator is taking nearly 2 hours to build the site. Is that normal?

revant_one · March 14, 2021, 6:08am

For v13-beta it creates 950+ tables in db.

In play with docker environment, it takes 4-5 minutes to create site and install ERPNext.

I’ve a system where database is hosted on separate server, in that case it takes 15-20 min to create a new site and install ERPNext.

shareeef · March 14, 2021, 6:14am

Thanks, @revant_one. I just wanted to double check. Now I will move on to swarm mode. How do you validate that ERPNext is properly installed in PWD environment. I didn’t see any health checks in docker compose.

Rahul_Singh_Yadav · March 26, 2021, 11:49am

I am trying with the env-local and still getting a 404. I’ve also tried manually configuring my etc/hosts file but to no avail, I am not able to reach mysite.localhost. One thing I do notice is that my test_site-creator_1 container immediately starts and then exits out.

Any help is much appreciated.

Jay_Patel · May 13, 2021, 1:58am

Hey Team…
I m Using a live server and DNS Record. But I Facing the Same problem. my .env file Mention below.

LETSENCRYPT_EMAIL=mail@gmail.com
ERPNEXT_VERSION=edge
FRAPPE_VERSION=edge
MARIADB_HOST=mariadb
MYSQL_ROOT_PASSWORD=admin
SITE_NAME=acc.xyz.in
SITES=`acc.xyz.in`
DB_ROOT_USER=root
ADMIN_PASSWORD=admin
INSTALL_APPS=erpnext
ENTRYPOINT_LABEL=traefik.http.routers.erpnext-nginx.entrypoints=websecure
CERT_RESOLVER_LABEL=traefik.http.routers.erpnext-nginx.tls.certresolver=myresolver
HTTPS_REDIRECT_RULE_LABEL=traefik.http.routers.http-catchall.rule=hostregexp(`{host:.+}`)
HTTPS_REDIRECT_ENTRYPOINT_LABEL=traefik.http.routers.http-catchall.entrypoints=web
HTTPS_REDIRECT_MIDDLEWARE_LABEL=traefik.http.routers.http- 
catchall.middlewares=redirect-to-https
HTTPS_USE_REDIRECT_MIDDLEWARE_LABEL=traefik.http.middlewares.redirect-to-https.redirectscheme.scheme=https
SKIP_NGINX_TEMPLATE_GENERATION=0

And Error Log is
Attempt 1 to connect to mariadb:3306

Attempt 1 to connect to redis-queue:6379


Attempt 1 to connect to redis-cache:6379


Attempt 1 to connect to redis-socketio:6379


Connections OK


Site acc.xyz.in already exists

xyz is just for Example.

revant_one · May 13, 2021, 3:57am

It means site-creator container ran 2nd time. First time it must have failed.

enter erpnex-python container and remove the site

docker exec -it <erpnext-python> bash
$ bench drop-site <site-name> --no-backup --archived-sites-path=/home/frappe/backups

or manually delete the files and directory and drop database from mariadb.

Try again after failed site is deleted.

Jay_Patel · May 13, 2021, 4:41am

I was Tried But…
mentioned logs of site_crator.

DocTypes for erpnext       : [========================================] 100%


Updating customizations for Address


Updating customizations for Contact


*** Scheduler is disabled ***

End This Error and container stopped. Then I restarted again.

and Again got same error.

revant_one · May 13, 2021, 4:46am

This is not error, site got created successfully

site-creator container will run once only. It should fail after that, if it doesn’t it’ll keep re installing site on each restart.

If you’re using portainer then use the docs from docker-swarm setup. https://github.com/frappe/frappe_docker/blob/develop/docs/docker-swarm.md

Jay_Patel · May 18, 2021, 9:43am

Thanks…Thank A Lot…Successfully Installed.

irukandji · March 8, 2022, 10:43am

Hi @aa_prashant I just came across your post, have you managed to get this one sorted?
I think if you are using windows you need to use backslash instead of forward slash /
So for you in your powershell command you have to do.

docker-compose --project-name laxmierp -f installation\docker-compose-common.yml -f installation\docker-compose-erpnext.yml -f installation\docker-compose-networks.yml --project-directory installation up -d

And one more thing, if you are specifying project-directory parameter and using the installation directory, make sure that you have the .env file inside that installation directory, otherwise if your .env file is in the root folder of the frappe_docker then you can omit that parameter and just do.

docker-compose --project-name laxmierp -f installation\docker-compose-common.yml -f installation\docker-compose-erpnext.yml -f installation\docker-compose-networks.yml up -d

Hope that helps.

EugeneP · April 14, 2022, 4:23pm

I’ve had a similar requirement and managed to install it after a bit of help…

Ashok_Surwase · April 16, 2022, 7:19pm

Hii friends,

I am trying to deploy frappe ,erp, and custom app using docker on my ubuntu instance , anyone please help me for this or share steps for this.

Thankyou

murtaza_bk · April 22, 2022, 12:00pm

murtaza_bk · April 27, 2022, 5:16am

@Ashok_Surwase - above are the steps to deploy Frappe & ERPNext respectively.

revant_one · April 27, 2022, 5:25am

these are latest official container based installation steps

github.com

frappe/frappe_docker/blob/main/docs/single-server-example.md

### Single Server Example

In this use case we have a single server with a static IP attached to it. It can be used in scenarios where one powerful VM has multiple benches and applications or one entry level VM with single site. For single bench, single site setup follow only up to the point where first bench and first site is added. If you choose this setup you can only scale vertically. If you need to scale horizontally you'll need to backup the sites and restore them on to cluster setup.

We will setup the following:

- Install docker and docker compose v2 on linux server.
- Install traefik service for internal load balancer and letsencrypt.
- Install MariaDB with containers.
- Setup project called `erpnext-one` and create sites `one.example.com` and `two.example.com` in the project.
- Setup project called `erpnext-two` and create sites `three.example.com` and `four.example.com` in the project.

Explanation:

Single instance of **Traefik** will be installed and act as internal loadbalancer for multiple benches and sites hosted on the server. It can also load balance other applications along with frappe benches, e.g. wordpress, metabase, etc. We only expose the ports `80` and `443` once with this instance of traefik. Traefik will also take care of letsencrypt automation for all sites installed on the server. _Why choose Traefik over Nginx Proxy Manager?_ Traefik doesn't need additional DB service and can store certificates in a json file in a volume.

Single instance of **MariaDB** will be installed and act as database service for all the benches/projects installed on the server.

Each instance of ERPNext project (bench) will have its own redis, socketio, gunicorn, nginx, workers and scheduler. It will connect to internal MariaDB by connecting to MariaDB network. It will expose sites to public through Traefik by connecting to Traefik network.

This file has been truncated. show original

murtaza_bk · April 29, 2022, 11:27am

Installed using these commands on a Digital Ocean droplet.
Works fine, however getting some difficulties in executing few bench commands, it gives some .py files error.
Will look into it again and send the complete trace

Ashok_Surwase · August 9, 2022, 5:19pm

@murtaza_bk
Thank you.
I will try this steps.

agya09 · August 24, 2023, 7:32am

Hello @revant_one, I am trying to access my site ims.localhost within my LAN. I am running frappe inside docker and unable to access the IP:8000 from other PCs inside the LAN. I am trying this for local LAN deployment.Can you please help me with it?

revant_one · August 24, 2023, 8:15am

refer this https://github.com/frappe/frappe_docker/blob/main/docs/port-based-multi-tenancy.md