monogramm / docker-erpnext Goto Github PK

View Code? Open in Web Editor NEW

93.0 3.0 36.0 373 KB

:whale: :snake: Docker image for ERPNext.

Home Page: https://erpnext.com/

License: GNU Affero General Public License v3.0

Dockerfile 16.53% Shell 83.47%

docker frappe erpnext python erp

docker-erpnext's Introduction

ERPNext Docker container

🐳 Docker image for ERPNext.

This image was inspired by several other containers developed by the community:

emadshaaban92/docker-compose-erpnext / BizzoTech/docker-erpnext for the "simple" docker-compose setup
donysukardi/docker-frappe for the alpine variant (actually the source for BizzoTech images)
pipech/erpnext-docker-debian for the complete setup of apps and sites

The concept is the following:

no need to provide any configuration file: everything will be automatically generated by the container through environnment variables
the application container sets all the environment variables, the other containers wait for setup to be done
provide postgresql compatibility

Check base image Monogramm/docker-frappe for details.

Check image Monogramm/docker-erpnext-ext to see how to expand this image and add custom frappe apps.

What is ERPNext ?

Open Source ERP built for the web.

erpnext.com

github erpnext

Supported tags

https://hub.docker.com/r/monogramm/docker-erpnext/

13.5.0-debian 13.5-debian 13-debian debian (images/13/debian/Dockerfile)
13.5.0-debian-slim 13.5-debian-slim 13-debian-slim debian-slim (images/13/debian-slim/Dockerfile)
13.5.0-alpine 13.5-alpine 13-alpine alpine 13.5.0 13.5 13 latest (images/13/alpine/Dockerfile)
12.22.0-debian 12.22-debian 12-debian (images/12/debian/Dockerfile)
12.22.0-debian-slim 12.22-debian-slim 12-debian-slim (images/12/debian-slim/Dockerfile)
12.22.0-alpine 12.22-alpine 12-alpine 12.22.0 12.22 12 (images/12/alpine/Dockerfile)
version-11-hotfix-debian 11.x-debian 11-debian (images/11/debian/Dockerfile)
version-11-hotfix-debian-slim 11.x-debian-slim 11-debian-slim (images/11/debian-slim/Dockerfile)
version-11-hotfix-alpine 11.x-alpine 11-alpine version-11-hotfix 11.x 11 (images/11/alpine/Dockerfile)
develop-debian (images/develop/debian/Dockerfile)
develop-debian-slim (images/develop/debian-slim/Dockerfile)
develop-alpine develop (images/develop/alpine/Dockerfile)

How to run this image ?

This image does not contain the database for ERPNext. You need to use either an existing database or a database container.

This image is designed to be used in a micro-service environment using docker-compose. There are basically 2 variants of the image you can choose from: alpine or debian.

Running this image with docker-compose

Select the version closest to what you want in the images folder
- In the docker-compose.yml, you can comment the build lines, uncomment the image lines and edit versions to download prebuilt docker container.
Feel free to edit variables defined in .env as you see fit.
Run the docker-compose with docker-compose up -d and that's it.
Now, go to http://localhost:80 to access the first run installation wizard.

Questions / Issues

If you got any questions or problems using the image, please visit our Github Repository and write an issue.

References

A list of a few issues encountered during the development of this container for future reference:

ERPNext installs fails with Postgresql due to missing column
- Solution: none so far...
- References:
  - frappe/erpnext#18028

docker-erpnext's People

Contributors

Stargazers

Watchers

docker-erpnext's Issues

Scheduler not running after migrating from v10->v11

I started with v10, restored the backup and started ERPNext. Everything worked as expected.
After migrating to v11, I got the error message in the ERPNext frontend as depicted here:

How To Reproduce
Start with v10 images,

docker-compose up -d
docker-compose down
docker-compose run --rm erpnext_app bench --force restore \
--with-public-files  /home/frappe/frappe-bench/sites/my.site/private/backups/my_site-files.tar \
--with-private-files /home/frappe/frappe-bench/sites/my.site/private/backups/my_site-private-files.tar \
                     /home/frappe/frappe-bench/sites/my.site/private/backups/my_site-database.sql.gz
docker-compose up

check, if everything was restored as expected
update docker-compose.yaml to v11
docker-compose up -d

After migration, i got the shown error message

Expected behavior
I would like to have the scheduler running.
If i fire the following command, the scheduler is up and running again:

docker-compose run --rm erpnext_app bench --site all enable-scheduler
Screenshots

Docker (please complete the following information):

Docker / Docker-compose Version: Docker Version: 19.03.2, docker-compose version 1.24.1, build 4667896
Images:
monogramm/docker-erpnext 11-alpine
monogramm/docker-erpnext 10-alpine

Desktop (please complete the following information):

OS: debian10
Browser safari
Version 13.02

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

«Sorry! We will be back soon.» after install

Several times built an image with various yml with default settings - the result is the same, on the lettering page:

Sorry!
We will be back soon.

Don't panic. It's not you, it's us.
Most likely, our engineers are updating the code, and it should take a minute for the new code to load into memory.

Try refreshing after a minute or two.

I suspect it is associated with variables in .env or the configuration of nginx. Help me please.

Adding Custom Domains to your Site

Thank you for your quick deployment.
Is there a quick way to add it?
I've tried this. https://frappe.io/docs/user/en/bench/guides/adding-custom-domains
But it didn't work.!!!
help....

[BUG] Bug #46: Environment variables REDIS_* are not applied to site_config.json

Describe the bug
See #46

Due to the lack of a mechanism equivalent to the erpnet-configure container of frappe/frappe_docker the contents of the environment variables

REDIS_CACHE_HOST=redis:6379/3
REDIS_QUEUE_HOST=redis:6379/4
REDIS_SOCKETIO_HOST=redis:6379/5

I don't understand why there have to be multiple containers with identical redis servers instead of using the same server for all three containers this is not working as expected. It's also required for a redundant setup where the redis server might not be running on the same host.

To Reproduce

Steps to reproduce the behavior:

Use a modified docker-compose.yml that is making use of the environment variables

REDIS_CACHE_HOST=redis:6379/3
REDIS_QUEUE_HOST=redis:6379/4
REDIS_SOCKETIO_HOST=redis:6379/5

Launch the containers accessing redis servers
Find the error described in #46

Expected behavior
Being able to specify a different redis server

Additional context
I know that "works with frappe/frappe_docker" is a weak argument but somehow fits it.
It is if course possible to edit

Database error Alpine Image

I got following error inside erpnext_app container... i am using alpine v 13 image ... Can you please suggest why?

Updating mariadDB users allowed hosts ...
ERROR 1356 at line 1 ; View 'mysql.user' references invalid tables(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

[Question] about bench operations

Hi.
First of all, thank you for sharing your work.
Could you please point me in the direction on how to perform "bench" operations on a deployment based on this? I guess it may something related to the command:

docker exec -it <container> <bench command>

But I haven't been able to figure it out which container I should pick.
My ultimate goal is to:

Create new sites
Perform backups and restore them.

Thank you!

[BUG] Site xxx does not exist

Describe the bug
Hi I am trying to install erpnext, but unfortunately I am stuck on the ErpNext installation all the time. I always get the error message : Site xxx does not exist
To Reproduce
Steps to reproduce the behavior:

my dockerfile:

FROM monogramm/docker-erpnext:12-alpine

RUN bench new-site \
    --mariadb-root-username root \
    --db-name erp_next \
    --mariadb-root-password xxx  \
    --admin-password xxx \
    --verbose \
    site.local

RUN bench --site site.local install-app erpnext 

CMD ["bench","start"]

# expose port
EXPOSE 8000 9000

The error:

Step 7/9 : RUN bench --site site.local install-app erpnext
 ---> Running in 6f1e8352656a
Site site.local does not exist

Docker (please complete the following information):

Docker / Docker-compose Version: Docker version 19.03.13, build 4484c46d9d
Image monogramm/docker-erpnext:12-alpine

Desktop (please complete the following information):

OS: (e.g. iOS) Ubuntu

Am I doing something wrong? Thanks for the help! :-)

Custom app & Multi tenancy?

As far as I understand, the solution does not support custom app and a multi tenancy? Will support in the future?

Installation Instructions

Is your feature request related to a problem? Please describe.
I can't figure out how to install this. I feel like I've tried everything.

By brute-force trying everything (find -name "docker-compose*" | xargs -I{} docker compose -f {} up) I found that I can get some of them to boot up, but not function.

Describe the solution you'd like

A clear and concise description of how to install

What I've tried

Platform:

Debian 11.6, x86_64
Docker version 20.10.22, build 3a2c30b

Running ./template/docker-compose_postgres.yml:
Gives this error:

Expand log

root@saffron:~/erp/docker-erpnext/template# docker compose up
[+] Running 26/26
 ⠿ erpnext_redis_queue Pulled                                                                                                                      10.4s
   ⠿ 8921db27df28 Already exists                                                                                                                    0.0s
   ⠿ aa0a0152d355 Pull complete                                                                                                                     1.8s
   ⠿ 402c460b24b7 Pull complete                                                                                                                     2.9s
   ⠿ 2a51e6c2ffd9 Pull complete                                                                                                                     4.2s
   ⠿ b0ff5e2bc6cc Pull complete                                                                                                                     4.9s
   ⠿ 976b5457593c Pull complete                                                                                                                     6.4s
 ⠿ erpnext_redis_cache Pulled                                                                                                                      10.5s
 ⠿ erpnext_web Pulled                                                                                                                              14.2s
   ⠿ 83e90619bc2e Pull complete                                                                                                                     3.5s
   ⠿ d52adec6f48b Pull complete                                                                                                                     5.2s
   ⠿ 10eb2ce358fa Pull complete                                                                                                                     6.4s
   ⠿ a1be370d6a52 Pull complete                                                                                                                     6.9s
   ⠿ 689b9959905b Pull complete                                                                                                                     7.8s
   ⠿ c7a81ce22aac Pull complete                                                                                                                     9.4s
 ⠿ erpnext_redis_socketio Pulled                                                                                                                   10.2s
 ⠿ erpnext_db Pulled                                                                                                                               14.0s
   ⠿ ca7dd9ec2225 Already exists                                                                                                                    0.0s
   ⠿ 126ca7716c09 Pull complete                                                                                                                     1.4s
   ⠿ 72a45366ffb3 Pull complete                                                                                                                     1.9s
   ⠿ fe5f8c70e89a Pull complete                                                                                                                     6.3s
   ⠿ f2b8bcd3cdb2 Pull complete                                                                                                                     6.9s
   ⠿ 6c83c4f8fa74 Pull complete                                                                                                                     7.4s
   ⠿ d17dc8335598 Pull complete                                                                                                                     8.3s
   ⠿ 3c86850a05ef Pull complete                                                                                                                     8.7s
   ⠿ cae66d64382a Pull complete                                                                                                                     9.1s
[+] Building 3.9s (14/14) FINISHED
 => [template-erpnext_app internal] load build definition from Dockerfile                                                                           1.3s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => [template-erpnext_scheduler internal] load build definition from Dockerfile                                                                     3.4s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => [template-erpnext_worker_short internal] load build definition from Dockerfile                                                                  3.7s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => CANCELED [template-erpnext_worker_long internal] load build definition from Dockerfile                                                          3.8s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => CANCELED [template-sut internal] load build definition from Dockerfile                                                                          3.8s
 => => transferring dockerfile: 210B                                                                                                                0.0s
 => CANCELED [template-erpnext_worker_default internal] load build definition from Dockerfile                                                       3.7s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => CANCELED [template-erpnext_socketio internal] load build definition from Dockerfile                                                             3.7s
 => => transferring dockerfile: 2B                                                                                                                  0.0s
 => CANCELED [template-erpnext_app internal] load .dockerignore                                                                                     3.6s
 => => transferring context:                                                                                                                        0.1s
 => CANCELED [template-erpnext_scheduler internal] load .dockerignore                                                                               3.5s
 => => transferring context:                                                                                                                        0.2s
 => CANCELED [template-erpnext_worker_short internal] load .dockerignore                                                                            3.5s
 => => transferring context: 218B                                                                                                                   0.0s
 => CANCELED [template-erpnext_worker_long internal] load .dockerignore                                                                             3.5s
 => => transferring context: 218B                                                                                                                   0.0s
 => CANCELED [template-sut internal] load .dockerignore                                                                                             3.5s
 => => transferring context: 2B                                                                                                                     0.0s
 => CANCELED [template-erpnext_worker_default internal] load .dockerignore                                                                          3.5s
 => => transferring context: 218B                                                                                                                   0.0s
 => CANCELED [template-erpnext_socketio internal] load .dockerignore                                                                                3.5s
 => => transferring context: 218B                                                                                                                   0.0s
failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to read dockerfile: open /var/lib/docker/tmp/buildkit-mount3171846146/Dockerfile: no such file or directory

Running ./images/14/debian/docker-compose_postgres.yml:
Gives this error:

root@saffron:~/erp/docker-erpnext/images/14/debian# docker compose up
[+] Building 3.2s (15/15) FINISHED
 => [debian-sut internal] load build definition from Dockerfile                                                                                     0.3s
 => => transferring dockerfile: 193B                                                                                                                0.0s
 => [debian-erpnext_worker_short internal] load build definition from Dockerfile                                                                    1.7s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => CANCELED [debian-erpnext_socketio internal] load build definition from Dockerfile                                                               3.1s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => CANCELED [debian-erpnext_worker_default internal] load build definition from Dockerfile                                                         3.1s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => CANCELED [debian-erpnext_scheduler internal] load build definition from Dockerfile                                                              3.1s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => CANCELED [debian-erpnext_worker_long internal] load build definition from Dockerfile                                                            3.0s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => CANCELED [debian-erpnext_app internal] load build definition from Dockerfile                                                                    3.0s
 => => transferring dockerfile: 2.39kB                                                                                                              0.0s
 => [debian-sut internal] load .dockerignore                                                                                                        1.2s
 => => transferring context: 2B                                                                                                                     0.0s
 => CANCELED [debian-erpnext_worker_short internal] load .dockerignore                                                                              2.8s
 => => transferring context: 218B                                                                                                                   0.0s
 => CANCELED [debian-erpnext_worker_default internal] load .dockerignore                                                                            2.8s
 => CANCELED [debian-erpnext_scheduler internal] load .dockerignore                                                                                 2.8s
 => CANCELED [debian-erpnext_worker_long internal] load .dockerignore                                                                               2.8s
 => CANCELED [debian-erpnext_socketio internal] load .dockerignore                                                                                  2.8s
 => CANCELED [debian-erpnext_app internal] load .dockerignore                                                                                       2.8s
 => ERROR [debian-sut internal] load metadata for docker.io/monogramm/docker-erpnext:14-alpine                                                      1.2s
------
 > [debian-sut internal] load metadata for docker.io/monogramm/docker-erpnext:14-alpine:
------
failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to create LLB definition: docker.io/monogramm/docker-erpnext:14-alpine: not found

Running /images/14/debian/test/docker_test.sh:
Gives this error:

root@saffron:~/erp/docker-erpnext/images/14/debian/test# bash docker_test.sh
Waiting to ensure everything is fully ready for the tests...
Checking content of sites directory...
Apps and site are not initalized?!
ls: cannot access './sites': No such file or directory

I figured maybe I had the wrong dockerfile, so just to be sure, I tried the brute force approach:

find -name "docker-compose*"  | xargs -I{} docker compose -f {} up

The first file seems to run, but doesn't work. (Shows 404 when you visit):

Expand log

root@saffron:~/erp/docker-erpnext# find -name "docker-compose*"  | xargs -I{} docker compose -f {} up
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
WARN[0000] The "IMAGE_NAME" variable is not set. Defaulting to a blank string.
service "erpnext_scheduler" has neither an image nor a build context specified: invalid compose project
[+] Running 10/0
 ⠿ Container erpnext_redis_socketio  Running                                                                                                               0.0s
 ⠿ Container erpnext_redis_queue     Running                                                                                                               0.0s
 ⠿ Container erpnext_db              Created                                                                                                               0.0s
 ⠿ Container erpnext_redis_cache     Running                                                                                                               0.0s
 ⠿ Container erpnext_app             Running                                                                                                               0.0s
 ⠿ Container erpnext_worker_short    Running                                                                                                               0.0s
 ⠿ Container erpnext_socketio        Running                                                                                                               0.0s
 ⠿ Container erpnext_worker_default  Running                                                                                                               0.0s
 ⠿ Container erpnext_worker_long     Running                                                                                                               0.0s
 ⠿ Container erpnext_scheduler       Running                                                                                                               0.0s
Attaching to erpnext_app, erpnext_db, erpnext_redis_cache, erpnext_redis_queue, erpnext_redis_socketio, erpnext_scheduler, erpnext_socketio, erpnext_web, erpnext_worker_default, erpnext_worker_long, erpnext_worker_short, sut
erpnext_db              | 2023-01-31 16:35:35+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.10.2+maria~ubu2204 started.
erpnext_db              | 2023-01-31 16:35:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
erpnext_db              | 2023-01-31 16:35:36+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.10.2+maria~ubu2204 started.
erpnext_app             | 2023/01/31 11:35:36 Problem with dial: dial tcp 172.19.0.2:3306: connect: connection refused. Sleeping 1s
erpnext_db              | 2023-01-31 16:35:37+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
erpnext_db              | 2023-01-31 16:35:37+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
erpnext_db              | 2023-01-31 16:35:37 0 [Note] Using unique option prefix 'character_set_client' is error-prone and can break in the future. Please use the full name 'character-set-client-handshake' instead.
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] mariadbd: ignoring option '--character-set-client-handshake' due to invalid value 'utf8'
erpnext_db              | 2023-01-31 16:35:37 0 [Note] mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204) starting as process 1 ...
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Number of transaction pools: 1
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Using generic crc32 instructions
erpnext_db              | 2023-01-31 16:35:37 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Completed initialization of buffer pool
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: 128 rollback segments are active.
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: log sequence number 46622; transaction id 14
erpnext_db              | 2023-01-31 16:35:37 0 [Note] Plugin 'FEEDBACK' is disabled.
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
erpnext_db              | 2023-01-31 16:35:37 0 [Note] Server socket created on IP: '0.0.0.0'.
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] 'user' entry 'root@2e4f7f458f81' ignored in --skip-name-resolve mode.
erpnext_db              | 2023-01-31 16:35:37 0 [Warning] 'proxies_priv' entry '@% root@2e4f7f458f81' ignored in --skip-name-resolve mode.
erpnext_db              | 2023-01-31 16:35:37 0 [Note] InnoDB: Buffer pool(s) load completed at 230131 16:35:37
erpnext_web             | /docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
erpnext_web             | /docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
erpnext_db              | 2023-01-31 16:35:37 0 [Note] mariadbd: ready for connections.
erpnext_db              | Version: '10.10.2-MariaDB-1:10.10.2+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
erpnext_web             | /docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
erpnext_app             | 2023/01/31 11:35:37 Connected to tcp://erpnext_db:3306
erpnext_db              | 2023-01-31 16:35:37 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_web             | 10-listen-on-ipv6-by-default.sh: info: can not modify /etc/nginx/conf.d/default.conf (read-only file system?)
erpnext_web             | /docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
erpnext_app             | [app] [2023-01-31T11:35:37-05:00] Reinstalling with fresh database...
erpnext_web             | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
erpnext_web             | /docker-entrypoint.sh: Configuration complete; ready for start up
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: using the "epoll" event method
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: nginx/1.23.3
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: built by gcc 12.2.1 20220924 (Alpine 12.2.1_git20220924-r4)
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: OS: Linux 5.10.0-20-amd64
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: start worker processes
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: start worker process 21
erpnext_web             | 2023/01/31 11:35:38 [notice] 1#1: start worker process 22
sut                     | [sut] [2023-01-31T11:35:39] Reset docker entrypoint logs
sut                     | [sut] [2023-01-31T11:35:39] Setup logs folders and files owner to frappe...
sut                     | [sut] [2023-01-31T11:35:39] Waiting for frappe current site to be set...
sut                     | [sut] [2023-01-31T11:35:39] Waiting for frappe apps to be set...
sut                     | [sut] [2023-01-31T11:35:39] Waiting apps...
erpnext_worker_long     | [worker-long] [2023-01-31T11:35:40-05:00] Waiting apps...
erpnext_db              | 2023-01-31 16:35:40 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_db              | 2023-01-31 16:35:40 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_db              | 2023-01-31 16:35:40 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_db              | 2023-01-31 16:35:40 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_app             | Traceback (most recent call last):
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
erpnext_app             |     "__main__", mod_spec)
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
erpnext_app             |     exec(code, run_globals)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 99, in <module>
erpnext_app             |     main()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
erpnext_app             |     click.Group(commands=commands)(prog_name='bench')
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
erpnext_app             |     return self.main(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
erpnext_app             |     rv = self.invoke(ctx)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
erpnext_app             |     return ctx.invoke(self.callback, **ctx.params)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
erpnext_app             |     return callback(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
erpnext_app             |     return f(get_current_context(), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 26, in _func
erpnext_app             |     ret = f(frappe._dict(ctx.obj), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 171, in reinstall
erpnext_app             |     _reinstall(site, admin_password, mariadb_root_username, mariadb_root_password, yes, verbose=context.verbose)
erpnext_db              | 2023-01-31 16:35:58 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_app             | Traceback (most recent call last):
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 68, in get_app_commands
erpnext_app             |     app_command_module = importlib.import_module(app + '.commands')
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/importlib/__init__.py", line 127, in import_module
erpnext_app             |     return _bootstrap._gcd_import(name[level:], package, level)
erpnext_app             |   File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
erpnext_app             |   File "<frozen importlib._bootstrap>", line 983, in _find_and_load
erpnext_app             |   File "<frozen importlib._bootstrap>", line 953, in _find_and_load_unlocked
erpnext_app             |   File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
erpnext_app             |   File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
erpnext_app             |   File "<frozen importlib._bootstrap>", line 983, in _find_and_load
erpnext_app             |   File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
erpnext_app             | ModuleNotFoundError: No module named 'erpnext'
erpnext_app             | Traceback (most recent call last):
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
erpnext_app             |     "__main__", mod_spec)
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
erpnext_app             |     exec(code, run_globals)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 99, in <module>
erpnext_app             |     main()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
erpnext_app             |     click.Group(commands=commands)(prog_name='bench')
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
erpnext_app             |     return self.main(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
erpnext_app             |     rv = self.invoke(ctx)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
erpnext_app             |     return ctx.invoke(self.callback, **ctx.params)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
erpnext_app             |     return callback(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
erpnext_app             |     return f(get_current_context(), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 26, in _func
erpnext_app             |     ret = f(frappe._dict(ctx.obj), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 130, in doctor
erpnext_app             |     return _doctor(site=site)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/doctor.py", line 111, in doctor
erpnext_app             |     if is_scheduler_disabled():
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 106, in is_scheduler_disabled
erpnext_app             |     return not frappe.utils.cint(frappe.db.get_single_value("System Settings", "enable_scheduler"))
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 559, in get_single_value
erpnext_app             |     `tabSingles` where `doctype`=%s and `field`=%s""", (doctype, fieldname))
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 122, in sql
erpnext_app             |     self.connect()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 75, in connect
erpnext_app             |     self._conn = self.get_connection()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 91, in get_connection
erpnext_app             |     local_infile = frappe.conf.local_infile)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect
erpnext_app             |     return Connection(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 325, in __init__
erpnext_app             |     self.connect()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 598, in connect
erpnext_app             |     self._get_server_information()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 975, in _get_server_information
erpnext_app             |     packet = self._read_packet()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
erpnext_app             |     packet.check_error()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
erpnext_app             |     err.raise_mysql_exception(self._data)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
erpnext_app             |     raise errorclass(errno, errval)
erpnext_app             | pymysql.err.InternalError: (1130, "Host '172.19.0.6' is not allowed to connect to this MariaDB server")
erpnext_app             | -----Checking scheduler status-----
erpnext_app             | [app] [2023-01-31T11:35:59-05:00] Error(s) detected in your Frappe environment and background workers!!!
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:35:59 -0500] "GET / HTTP/1.1" 502 5444 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 2023/01/31 11:35:59 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.4.109, server: localhost, request: "GET / HTTP/1.1", upstream: "http://172.19.0.6:8000/", host: "192.168.4.108"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:36:00 -0500] "GET / HTTP/1.1" 502 5444 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 2023/01/31 11:36:00 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.4.109, server: localhost, request: "GET / HTTP/1.1", upstream: "http://172.19.0.6:8000/", host: "192.168.4.108"
erpnext_db              | 2023-01-31 16:36:01 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_app             | Traceback (most recent call last):
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 68, in get_app_commands
erpnext_app             |     app_command_module = importlib.import_module(app + '.commands')
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/importlib/__init__.py", line 127, in import_module
erpnext_app             |     return _bootstrap._gcd_import(name[level:], package, level)
erpnext_app             |   File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
erpnext_app             |   File "<frozen importlib._bootstrap>", line 983, in _find_and_load
erpnext_app             |   File "<frozen importlib._bootstrap>", line 953, in _find_and_load_unlocked
erpnext_app             |   File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
erpnext_app             |   File "<frozen importlib._bootstrap>", line 1006, in _gcd_import
erpnext_app             |   File "<frozen importlib._bootstrap>", line 983, in _find_and_load
erpnext_app             |   File "<frozen importlib._bootstrap>", line 965, in _find_and_load_unlocked
erpnext_app             | ModuleNotFoundError: No module named 'erpnext'
erpnext_app             | Traceback (most recent call last):
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
erpnext_app             |     "__main__", mod_spec)
erpnext_app             |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
erpnext_app             |     exec(code, run_globals)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 99, in <module>
erpnext_app             |     main()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
erpnext_app             |     click.Group(commands=commands)(prog_name='bench')
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
erpnext_app             |     return self.main(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
erpnext_app             |     rv = self.invoke(ctx)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_app             |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
erpnext_app             |     return ctx.invoke(self.callback, **ctx.params)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
erpnext_app             |     return callback(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
erpnext_app             |     return f(get_current_context(), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 26, in _func
erpnext_app             |     ret = f(frappe._dict(ctx.obj), *args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 130, in doctor
erpnext_app             |     return _doctor(site=site)
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/doctor.py", line 111, in doctor
erpnext_app             |     if is_scheduler_disabled():
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 106, in is_scheduler_disabled
erpnext_app             |     return not frappe.utils.cint(frappe.db.get_single_value("System Settings", "enable_scheduler"))
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 559, in get_single_value
erpnext_app             |     `tabSingles` where `doctype`=%s and `field`=%s""", (doctype, fieldname))
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 122, in sql
erpnext_app             |     self.connect()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 75, in connect
erpnext_app             |     self._conn = self.get_connection()
erpnext_app             |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 91, in get_connection
erpnext_app             |     local_infile = frappe.conf.local_infile)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect
erpnext_app             |     return Connection(*args, **kwargs)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 325, in __init__
erpnext_app             |     self.connect()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 598, in connect
erpnext_app             |     self._get_server_information()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 975, in _get_server_information
erpnext_app             |     packet = self._read_packet()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
erpnext_app             |     packet.check_error()
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
erpnext_app             |     err.raise_mysql_exception(self._data)
erpnext_app             |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
erpnext_app             |     raise errorclass(errno, errval)
erpnext_app             | pymysql.err.InternalError: (1130, "Host '172.19.0.6' is not allowed to connect to this MariaDB server")
erpnext_app             | -----Checking scheduler status-----
erpnext_db              | 2023-01-31 16:36:04 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.6' (This connection closed normally without authentication)
erpnext_app             | -----Checking scheduler status-----
erpnext_app             | [app] [2023-01-31T11:36:04-05:00] The application 'erpnext' was not found but cannot be removed because it is protected!!
erpnext_app             | [app] [2023-01-31T11:36:04-05:00] Starting app on port 8000...
erpnext_app             | [2023-01-31 11:36:05 -0500] [345] [INFO] Starting gunicorn 19.10.0
erpnext_app             | [2023-01-31 11:36:05 -0500] [345] [INFO] Listening at: http://0.0.0.0:8000 (345)
erpnext_app             | [2023-01-31 11:36:05 -0500] [345] [INFO] Using worker: sync
erpnext_app             | [2023-01-31 11:36:05 -0500] [352] [INFO] Booting worker with pid: 352
erpnext_app             | [2023-01-31 11:36:05 -0500] [353] [INFO] Booting worker with pid: 353
erpnext_app             | [2023-01-31 11:36:05 -0500] [354] [INFO] Booting worker with pid: 354
erpnext_app             | [2023-01-31 11:36:06 -0500] [355] [INFO] Booting worker with pid: 355
sut                     | Checking content of sites directory...
sut                     | Checking main containers are reachable...
sut                     | PING erpnext_db (172.19.0.2): 56 data bytes
sut                     |
sut                     | --- erpnext_db ping statistics ---
sut                     | 10 packets transmitted, 10 packets received, 0% packet loss
sut                     | round-trip min/avg/max = 0.113/0.148/0.321 ms
sut                     | PING erpnext_app (172.19.0.6): 56 data bytes
erpnext_db              | 2023-01-31 16:36:59 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.10' (This connection closed normally without authentication)
sut                     |
sut                     | --- erpnext_app ping statistics ---
sut                     | 10 packets transmitted, 10 packets received, 0% packet loss
sut                     | round-trip min/avg/max = 0.102/0.152/0.370 ms
sut                     | PING erpnext_web (172.19.0.12): 56 data bytes
sut                     |
sut                     | --- erpnext_web ping statistics ---
sut                     | 10 packets transmitted, 10 packets received, 0% packet loss
sut                     | round-trip min/avg/max = 0.100/0.145/0.293 ms
sut                     | Checking bench environment...
erpnext_db              | 2023-01-31 16:37:22 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.13' (This connection closed normally without authentication)
sut                     | -----Checking scheduler status-----
sut                     | Traceback (most recent call last):
sut                     |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
sut                     |     "__main__", mod_spec)
sut                     |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
sut                     |     exec(code, run_globals)
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 99, in <module>
sut                     |     main()
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
sut                     |     click.Group(commands=commands)(prog_name='bench')
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
sut                     |     return self.main(*args, **kwargs)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
sut                     |     rv = self.invoke(ctx)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
sut                     |     return _process_result(sub_ctx.command.invoke(sub_ctx))
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
sut                     |     return _process_result(sub_ctx.command.invoke(sub_ctx))
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
sut                     |     return ctx.invoke(self.callback, **ctx.params)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
sut                     |     return callback(*args, **kwargs)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
sut                     |     return f(get_current_context(), *args, **kwargs)
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 26, in _func
sut                     |     ret = f(frappe._dict(ctx.obj), *args, **kwargs)
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 130, in doctor
sut                     |     return _doctor(site=site)
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/doctor.py", line 111, in doctor
sut                     |     if is_scheduler_disabled():
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/scheduler.py", line 106, in is_scheduler_disabled
sut                     |     return not frappe.utils.cint(frappe.db.get_single_value("System Settings", "enable_scheduler"))
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 566, in get_single_value
sut                     |     `tabSingles` where `doctype`=%s and `field`=%s""", (doctype, fieldname))
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 122, in sql
sut                     |     self.connect()
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 75, in connect
sut                     |     self._conn = self.get_connection()
sut                     |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 91, in get_connection
sut                     |     local_infile = frappe.conf.local_infile)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect
sut                     |     return Connection(*args, **kwargs)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 325, in __init__
sut                     |     self.connect()
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 598, in connect
sut                     |     self._get_server_information()
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 975, in _get_server_information
sut                     |     packet = self._read_packet()
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
sut                     |     packet.check_error()
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
sut                     |     err.raise_mysql_exception(self._data)
sut                     |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
sut                     |     raise errorclass(errno, errval)
sut                     | pymysql.err.InternalError: (1130, "Host '172.19.0.13' is not allowed to connect to this MariaDB server")
sut exited with code 1
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:27 -0500] "GET / HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:28 -0500] "GET / HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:29 -0500] "GET / HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:35 -0500] "GET / HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:38 -0500] "GET /index.html HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:37:49 -0500] "GET /index.html HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_db              | 2023-01-31 16:37:59 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.10' (This connection closed normally without authentication)
erpnext_db              | 2023-01-31 16:39:00 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.10' (This connection closed normally without authentication)
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:39:14 -0500] "GET /index.html HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_web             | 192.168.4.109 - - [31/Jan/2023:11:39:27 -0500] "GET / HTTP/1.1" 404 140 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Safari/605.1.15" "-"
erpnext_db              | 2023-01-31 16:40:00 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '172.19.0.10' (This connection closed normally without authentication)
q^CGracefully stopping... (press Ctrl+C again to force)

Other files seem to alternate between not working and not starting, so I'm thinking this is user error?

[BUG] Redis connection to localhost:12000 failed and redis.exceptions.ConnectionError: Error 99 connecting to localhost:11000. Cannot assign requested address

When starting the v13 docker-compose, the erpnext_socketio as well as the erpnext_worker_short and erpnext_worker_long fail to start up correctly.

Both seem to have some kind of trouble connecting with the redis instance. As a result the complete ERPNext system does only show the 'Sorry...' page.

I use the nginx and redis config files as provided in the repo and set up my .env file.

Any hints on solving this issue would be greatly appreciated!

Here's what the erpnext_socketio outputs:

erpnext_socketio          | [node-socketio] [2021-10-24T17:01:16+02:00] Setup logs folders and files owner to frappe...
erpnext_socketio          | [node-socketio] [2021-10-24T17:01:17+02:00] Waiting for frappe current site to be set...
erpnext_socketio          | [node-socketio] [2021-10-24T17:01:17+02:00] Waiting for frappe apps to be set...
erpnext_socketio          | [node-socketio] [2021-10-24T17:01:17+02:00] Waiting for docker container init...
erpnext_socketio          | [node-socketio] [2021-10-24T17:01:17+02:00] Waiting for frappe current site to be set...
erpnext_socketio          | [node-socketio] [2021-10-24T17:01:17+02:00] Starting socketio...
erpnext_socketio          | listening on *: 9000
erpnext_socketio          | events.js:291
erpnext_socketio          |       throw er; // Unhandled 'error' event
erpnext_socketio          |       ^
erpnext_socketio          | 
erpnext_socketio          | Error: Redis connection to localhost:12000 failed - connect ECONNREFUSED 127.0.0.1:12000
erpnext_socketio          |     at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1145:16)
erpnext_socketio          | Emitted 'error' event on RedisClient instance at:
erpnext_socketio          |     at RedisClient.on_error (/home/frappe/frappe-bench/apps/frappe/node_modules/redis/index.js:406:14)
erpnext_socketio          |     at Socket.<anonymous> (/home/frappe/frappe-bench/apps/frappe/node_modules/redis/index.js:279:14)
erpnext_socketio          |     at Socket.emit (events.js:314:20)
erpnext_socketio          |     at emitErrorNT (internal/streams/destroy.js:92:8)
erpnext_socketio          |     at emitErrorAndCloseNT (internal/streams/destroy.js:60:3)
erpnext_socketio          |     at processTicksAndRejections (internal/process/task_queues.js:84:21) {
erpnext_socketio          |   errno: 'ECONNREFUSED',
erpnext_socketio          |   code: 'ECONNREFUSED',
erpnext_socketio          |   syscall: 'connect',
erpnext_socketio          |   address: '127.0.0.1',
erpnext_socketio          |   port: 12000
erpnext_socketio          | }
erpnext_socketio exited with code 0

And the workers both output:

erpnext_worker_short      | Traceback (most recent call last):
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/connection.py", line 550, in connect
erpnext_worker_short      |     sock = self._connect()
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/connection.py", line 606, in _connect
erpnext_worker_short      |     raise err
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/connection.py", line 594, in _connect
erpnext_worker_short      |     sock.connect(socket_address)
erpnext_worker_short      | OSError: [Errno 99] Cannot assign requested address
erpnext_worker_short      | 
erpnext_worker_short      | During handling of the above exception, another exception occurred:
erpnext_worker_short      | 
erpnext_worker_short      | Traceback (most recent call last):
erpnext_worker_short      |   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
erpnext_worker_short      |     "__main__", mod_spec)
erpnext_worker_short      |   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
erpnext_worker_short      |     exec(code, run_globals)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 99, in <module>
erpnext_worker_short      |     main()
erpnext_worker_short      |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
erpnext_worker_short      |     click.Group(commands=commands)(prog_name='bench')
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
erpnext_worker_short      |     return self.main(*args, **kwargs)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
erpnext_worker_short      |     rv = self.invoke(ctx)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_worker_short      |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
erpnext_worker_short      |     return _process_result(sub_ctx.command.invoke(sub_ctx))
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
erpnext_worker_short      |     return ctx.invoke(self.callback, **ctx.params)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
erpnext_worker_short      |     return callback(*args, **kwargs)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 167, in start_worker
erpnext_worker_short      |     start_worker(queue, quiet = quiet)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 151, in start_worker
erpnext_worker_short      |     Worker(queues, name=get_worker_name(queue)).work(logging_level = logging_level)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/rq/worker.py", line 535, in work
erpnext_worker_short      |     self.register_birth()
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/rq/worker.py", line 278, in register_birth
erpnext_worker_short      |     if self.connection.exists(self.key) and \
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/client.py", line 1581, in exists
erpnext_worker_short      |     return self.execute_command('EXISTS', *names)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/client.py", line 898, in execute_command
erpnext_worker_short      |     conn = self.connection or pool.get_connection(command_name, **options)
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/connection.py", line 1182, in get_connection
erpnext_worker_short      |     connection.connect()
erpnext_worker_short      |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/redis/connection.py", line 554, in connect
erpnext_worker_short      |     raise ConnectionError(self._error_message(e))
erpnext_worker_short      | redis.exceptions.ConnectionError: Error 99 connecting to localhost:11000. Cannot assign requested address.

Docker and other software versions:

Docker version 20.10.9, build c2ea9bc
docker-compose version 1.27.4
CentOS (Stream)

[BUG] Module import failed for Naming Series (erpnext.setup.doctype.naming_series.naming_series Error: cannot import name 'validate_series'

Describe the bug

Hi there, upon starting the container (debian, alpine, or slim), the build is successful but when the container is started, ERPNext fails to install with the following error: Module import failed for Naming Series (erpnext.setup.doctype.naming_series.naming_series Error: cannot import name 'validate_series' from 'frappe.core.doctype.doctype.doctype' (/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py

To Reproduce
Steps to reproduce the behavior:

Build any of the images and set all .env
sudo docker-compose up --force-recreate
The error shows in the logs when attempting to install ERPNext
When logged into Frappe web interface and click About, ERPNext is not installed, only the frappe framework.

Provide Docker commands or docker-compose file if possible.

version: "2.3"

services:
  # https://docs.docker.com/docker-hub/builds/automated-testing/
#  sut:
#    build:
#      context: ./test
#      dockerfile: Dockerfile
#    command: sh /docker_test.sh
#    # Only for travis-ci, do not name test container in dockerhub
#    container_name: sut
#    depends_on:
#      - erpnext_db
#      - erpnext_app
#      - erpnext_web
#      - erpnext_scheduler
#      - erpnext_worker_default
#      - erpnext_worker_long
#      - erpnext_worker_short
#      - erpnext_socketio
#      - erpnext_redis_cache
#      - erpnext_redis_queue
#      - erpnext_redis_socketio
#    environment:
#      # Container setup
#      - NODE_TYPE=sut
#      # Docker setup
#      - DOCKER_APPS_TIMEOUT=900
#      - DOCKER_DEBUG=1
#    volumes_from:
#      - erpnext_app
#    volumes:
#      - /etc/localtime:/etc/localtime:ro
#      - /etc/timezone:/etc/timezone:ro

  erpnext_app:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_app
    command: app
    #restart: always
    ports:
      - 8551:8000
    depends_on:
      - erpnext_db
    links:
      - erpnext_db
    environment:
      # Docker setup
      - DOCKER_DB_ALLOWED_HOSTS=
      - DOCKER_GUNICORN_TIMEOUT=600
      # Frappe setup
      - FRAPPE_APP_INIT=erpnext
      - FRAPPE_APP_RESET=1
      - FRAPPE_DEFAULT_PROTOCOL=https://
      - FRAPPE_DEFAULT_SITE=${ERPNEXT_SITE}
      - FRAPPE_SOCKETIO_PORT=3000
      - FRAPPE_LOGGING=1
      - DEVELOPER_MODE=0
      - ALLOW_TESTS=1
      #- ADMIN_USER=Administrator
      - ADMIN_PASSWORD=${ERPNEXT_ADMIN_PWD}
      - ENCRYPTION_KEY=${ERPNEXT_ENCRYPTION_KEY}
      # Database setup
      - DB_TYPE=mariadb
      - DB_HOST=erpnext_db
      - DB_PORT=3306
      - DB_NAME=${ERPNEXT_DB_NAME}
      - DB_PASSWORD=${ERPNEXT_DB_PWD}
      - DB_ROOT_PASSWORD=${ERPNEXT_DB_ROOT_PWD}
      # Mail setup
      - MAIL_HOST=${ERPNEXT_MAIL_HOST}
      - MAIL_PORT=587
      - MAIL_USE_SSL=tls
      - MAIL_LOGIN=${ERPNEXT_SMTP_USER}
      - MAIL_PASSWORD=${ERPNEXT_SMTP_PWD}
      # Redis setup
      - REDIS_CACHE_HOST=erpnext_redis_cache
      - REDIS_QUEUE_HOST=erpnext_redis_queue
      - REDIS_SOCKETIO_HOST=erpnext_redis_socketio
    volumes:
      - ./erpnext/frappe/sites:/home/frappe/frappe-bench/sites
      - .//erpnext/frappe/logs:/home/frappe/frappe-bench/logs
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_web:
    image: nginx:alpine
    container_name: erpnext_web
    #restart: always
    volumes:
      - ./nginx.conf:/etc/nginx/conf.d/default.conf:ro
      # If you need SSL connection, you can provide your own certificates
      # - ./certs:/etc/letsencrypt
      # - ./certs-data:/data/letsencrypt
    volumes_from:
      - erpnext_app
    ports:
      - 8552:80
      # If you need SSL connection
      # - '443:443'
    links:
      - erpnext_app
      - erpnext_socketio

  erpnext_db:
    image: mariadb:10
    container_name: erpnext_db
    #restart: always
    command: --character_set_client=utf8 --bind-address=0.0.0.0 --character-set-client-handshake=FALSE --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --sql-mode="ALLOW_INVALID_DATES"
    environment:
      - MYSQL_ROOT_PASSWORD=${ERPNEXT_DB_ROOT_PWD}
      # Following parameters are not needed with Frappe 12 or higher since it will create DB itself
      - MYSQL_DATABASE=${ERPNEXT_DB_NAME}
      - MYSQL_USER=${ERPNEXT_DB_NAME}
      - MYSQL_PASSWORD=${ERPNEXT_DB_PWD}
    volumes:
      - ./erpnext/db:/var/lib/mysql

  erpnext_scheduler:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_scheduler
    command: scheduler
    #restart: always
    depends_on:
      - erpnext_app
    volumes_from:
      - erpnext_app
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_worker_default:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_worker_default
    command: worker-default
    #restart: always
    depends_on:
      - erpnext_app
    environment:
      # Docker setup
      - DOCKER_APPS_TIMEOUT=900
    volumes_from:
      - erpnext_app
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_worker_long:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_worker_long
    command: worker-long
    #restart: always
    depends_on:
      - erpnext_app
    environment:
      # Docker setup
      - DOCKER_APPS_TIMEOUT=900
    volumes_from:
      - erpnext_app
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_worker_short:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_worker_short
    command: worker-short
    #restart: always
    depends_on:
      - erpnext_app
    environment:
      # Docker setup
      - DOCKER_APPS_TIMEOUT=900
    volumes_from:
      - erpnext_app
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_socketio:
    # For development or CI, build from local Dockerfile
    build: ./
    # For production, download prebuilt image
    #image: monogramm/docker-erpnext:13-alpine
    container_name: erpnext_socketio
    command: node-socketio
    #restart: always
    ports:
      - 3000:3000
    depends_on:
      - erpnext_app
    environment:
      # Docker setup
      - DOCKER_APPS_TIMEOUT=900
    volumes_from:
      - erpnext_app
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_redis_cache:
    image: redis:alpine
    container_name: erpnext_redis_cache
    command: ["redis-server","/etc/conf.d/redis.conf"]
    #restart: always
    volumes:
      - ./services/erpnext/conf/redis_cache.conf:/etc/conf.d/redis.conf:ro
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_redis_queue:
    image: redis:alpine
    container_name: erpnext_redis_queue
    #restart: always
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

  erpnext_redis_socketio:
    image: redis:alpine
    container_name: erpnext_redis_socketio
    #restart: always
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

Expected behavior

ERPNext and Frappe framework are both installed without the import failed issue.

Screenshots
If applicable, add screenshots to help explain your problem.

Stack trace
If applicable, add stack trace using docker logs or docker-compose logs to identify the problem.

erpnext_app | Module import failed for Naming Series (erpnext.setup.doctype.naming_series.naming_series Error: cannot import name 'validate_series' from 'frappe.core.doctype.doctype.doctype' (/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py))
erpnext_app | ✔ Built js/data_import_tools.min.js
erpnext_app | Error: File to import not found or unreadable: frappe/public/scss/common/mixins.
erpnext_app | UNRESOLVED_IMPORT : 'onscan.js' is imported by ../erpnext/erpnext/selling/page/point_of_sale/pos_item_selector.js, but could not be resolved – treating it as an external dependency

Docker (please complete the following information):

Docker / Docker-compose Version: (e.g. Docker version 18.03.0-ce, build 0520e24)
Image (e.g. 7.0-apache)

Docker version = Docker version 20.10.2, build 2291f61
Docker Compose version = 1.27.4, build 40524192

Desktop (please complete the following information):

OS: (e.g. iOS)
Browser (e.g. chrome, safari)
Version (e.g. 22)

Smartphone (please complete the following information):

Device: (e.g. iPhone6)
OS: (e.g. iOS8.1)
Browser (e.g. stock browser, safari)
Version (e.g. 22)

Additional context
Add any other context about the problem here.

Authentication error after installing

Hi,

immediately after the installation I get Internal Server Error in the app:

erpnext_app | Traceback (most recent call last):
erpnext_app | File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 135, in handle
erpnext_app | self.handle_request(listener, req, client, addr)
erpnext_app | File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
erpnext_app | respiter = self.wsgi(environ, resp.start_response)
erpnext_app | File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/werkzeug/local.py", line 231, in application
erpnext_app | return ClosingIterator(app(environ, start_response), self.cleanup)
erpnext_app | File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/werkzeug/wrappers/base_request.py", line 237, in application
erpnext_app | resp = f(*args[:-2] + (request,))
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 85, in application
erpnext_app | response = handle_exception(e)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 212, in handle_exception
erpnext_app | http_status_code=http_status_code)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 35, in render
erpnext_app | raise_if_disabled(path)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/website/render.py", line 371, in raise_if_disabled
erpnext_app | 'route': ['like', '%{0}'.format(path)]
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 535, in get_all
erpnext_app | return frappe.get_all(*args, **kwargs)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1349, in get_all
erpnext_app | return get_list(doctype, *args, **kwargs)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1322, in get_list
erpnext_app | return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 96, in execute
erpnext_app | result = self.build_and_run()
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 110, in build_and_run
erpnext_app | args = self.prepare_args()
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 136, in prepare_args
erpnext_app | self.set_optional_columns()
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 302, in set_optional_columns
erpnext_app | columns = get_table_columns(self.doctype)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/model/meta.py", line 49, in get_table_columns
erpnext_app | return frappe.db.get_table_columns(doctype)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 879, in get_table_columns
erpnext_app | columns = self.get_db_table_columns('tab' + doctype)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 870, in get_db_table_columns
erpnext_app | where table_name = %s ''', table)]
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/postgres/database.py", line 104, in sql
erpnext_app | return super(PostgresDatabase, self).sql(*args, **kwargs)
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 122, in sql
erpnext_app | self.connect()
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 75, in connect
erpnext_app | self._conn = self.get_connection()
erpnext_app | File "/home/frappe/frappe-bench/apps/frappe/frappe/database/postgres/database.py", line 70, in get_connection
erpnext_app | self.host, self.user, self.user, self.password, self.port
erpnext_app | File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/psycopg2/init.py", line 126, in connect
erpnext_app | conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
erpnext_app | psycopg2.OperationalError: FATAL: password authentication failed for user "erpnext"

Installation Instructions

I cant install your sample because I cant tell the installation sequence

A clear and concise description of an installation sequence will be really helpful.

Please update, such as V12.6, thank you!

Hi,Please update, such as V12.6, thank you!

Installation fails

Greetings.

I'm having issues trying to get any of these debian images to run and wondered if you could offer some insight as to what I may be doing wrong please?

Here is the output after running

$docker-compose up -d

Creating network "debian_default" with the default driver
Creating erpnext_redis_queue    ... done
Creating erpnext_redis_socketio ... done
Creating erpnext_db             ... done
Creating erpnext_redis_cache    ... done
Creating erpnext_app            ... error

ERROR: for erpnext_app  Cannot start service erpnext_app: b'OCI runtime create failed: container_linux.go:349: starting container process caused "process_linux.go:449: container init caused \\"rootfs_linux.go:58: mounting \\\\\\"/etc/timezone\\\\\\" to rootfs \\\\\\"/var/lib/docker/overlay2/9e66de137b0fab610167aeb53b08361d87a5807229ae2fc0aea700e46492de2d/merged\\\\\\" at \\\\\\"/var/lib/docker/overlay2/9e66de137b0fab610167aeb53b08361d87a5807229ae2fc0aea700e46492de2d/merged/etc/timezone\\\\\\" caused \\\\\\"not a directory\\\\\\"\\"": unknown: Are you trying to mount a directory onto a file (or vice-versa)? Check if the specified host path exists and is the expected type'

ERROR: for erpnext_app  Cannot start service erpnext_app: b'OCI runtime create failed: container_linux.go:349: starting container process caused "process_linux.go:449: container init caused \\"rootfs_linux.go:58: mounting \\\\\\"/etc/timezone\\\\\\" to rootfs \\\\\\"/var/lib/docker/overlay2/9e66de137b0fab610167aeb53b08361d87a5807229ae2fc0aea700e46492de2d/merged\\\\\\" at \\\\\\"/var/lib/docker/overlay2/9e66de137b0fab610167aeb53b08361d87a5807229ae2fc0aea700e46492de2d/merged/etc/timezone\\\\\\" caused \\\\\\"not a directory\\\\\\"\\"": unknown: Are you trying to mount a directory onto a file (or vice-versa)? Check if the specified host path exists and is the expected type'
ERROR: Encountered errors while bringing up the project.

[HELP] connect to server from public ip is rejected

Hello team,

Thanks for your awesome work.
i'm unable to connect to erpnext from public ip address. can you please help checking this issue

khanhlh@benchmark-memdb:~/erpnext/docker-erpnext/images/12/debian$ docker logs erpnext_web 
/docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
/docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
/docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
10-listen-on-ipv6-by-default.sh: error: can not modify /etc/nginx/conf.d/default.conf (read-only file system?)
/docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
/docker-entrypoint.sh: Configuration complete; ready for start up
2020/09/03 10:02:35 [error] 21#21: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.32.1, server: localhost, request: "GET / HTTP/1.1", upstream: "http://192.168.32.6:8000/", host: "localhost"
192.168.32.1 - - [03/Sep/2020:10:02:35 +0000] "GET / HTTP/1.1" 502 5444 "-" "curl/7.68.0" "-"
192.168.32.1 - - [03/Sep/2020:10:03:02 +0000] "GET / HTTP/1.1" 200 16164 "-" "curl/7.68.0" "-"
192.168.32.1 - - [03/Sep/2020:10:03:06 +0000] "GET / HTTP/1.1" 200 16164 "-" "curl/7.68.0" "-"
2020/09/03 10:03:19 [error] 21#21: *7 upstream prematurely closed connection while reading response header from upstream, client: 113.161.55.181, server: localhost, request: "GET / HTTP/1.1", upstream: "http://192.168.32.6:8000/", host: "167.172.180.123"
113.161.55.181 - - [03/Sep/2020:10:03:19 +0000] "GET / HTTP/1.1" 502 5444 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" "-"
2020/09/03 10:03:23 [error] 21#21: *9 upstream prematurely closed connection while reading response header from upstream, client: 167.172.180.123, server: localhost, request: "GET / HTTP/1.1", upstream: "http://192.168.32.6:8000/", host: "167.172.180.123"
167.172.180.123 - - [03/Sep/2020:10:03:23 +0000] "GET / HTTP/1.1" 502 5444 "-" "curl/7.68.0" "-"

[BUG] ERPNext Setup with Debian image failed

Describe the bug
Setup Wizard:
Setup failed
Could not start up: Error in setup
To Reproduce
Steps to reproduce the behavior:

Install like in description
Use Debian image - all versions from 12.0 to 13.0 are affected (!)
docker-compose up -d
Follow wizard on the page
Error in logs raise up a

Provide Docker commands or docker-compose file if possible.

Expected behavior
Setup finishes normaly

Stack trace
If applicable, add stack trace using docker logs or docker-compose logs to identify the problem.

erpnext_app               | [2020-05-03 16:23:57 +0200] [664] [CRITICAL] WORKER TIMEOUT (pid:671)
erpnext_app               | [2020-05-03 16:23:57 +0200] [671] [ERROR] Error handling request /api/method/frappe.desk.page.setup_wizard.setup_wizard.setup_complete
erpnext_app               | Traceback (most recent call last):
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 60, in application
erpnext_app               |     response = frappe.api.handle()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/api.py", line 55, in handle
erpnext_app               |     return frappe.handler.handle()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 22, in handle
erpnext_app               |     data = execute_cmd(cmd)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 61, in execute_cmd
erpnext_app               |     return frappe.call(method, **frappe.form_dict)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1051, in call
erpnext_app               |     return fn(*args, **newargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/page/setup_wizard/setup_wizard.py", line 71, in setup_complete
erpnext_app               |     task.get('fn')(task.get('args'))
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/setup/setup_wizard/setup_wizard.py", line 95, in setup_company
erpnext_app               |     fixtures.install_company(args)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/setup/setup_wizard/operations/install_fixtures.py", line 395, in install_company
erpnext_app               |     make_records(records)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/page/setup_wizard/setup_wizard.py", line 384, in make_records
erpnext_app               |     doc.insert(ignore_permissions=True)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 260, in insert
erpnext_app               |     self.run_post_save_methods()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 926, in run_post_save_methods
erpnext_app               |     self.run_method("on_update")
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 794, in run_method
erpnext_app               |     out = Document.hook(fn)(self, *args, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1065, in composer
erpnext_app               |     return composed(self, method, *args, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1048, in runner
erpnext_app               |     add_to_return_value(self, fn(self, *args, **kwargs))
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 788, in <lambda>
erpnext_app               |     fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/setup/doctype/company/company.py", line 103, in on_update
erpnext_app               |     self.create_default_accounts()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/setup/doctype/company/company.py", line 154, in create_default_accounts
erpnext_app               |     create_charts(self.name, self.chart_of_accounts, self.existing_company)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/chart_of_accounts.py", line 61, in create_charts
erpnext_app               |     _import_accounts(chart, None, None, root_account=True)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/chart_of_accounts.py", line 56, in _import_accounts
erpnext_web               | 92.211.132.152 - - [03/May/2020:16:23:57 +0200] "POST /api/method/frappe.desk.page.setup_wizard.setup_wizard.setup_complete HTTP/1.1" 500 141 "http://mydomain.com/desk" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:75.0) Gecko/20100101 Firefox/75.0" "-"
erpnext_app               |     _import_accounts(child, account.name, root_type)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/chart_of_accounts.py", line 56, in _import_accounts
erpnext_app               |     _import_accounts(child, account.name, root_type)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/chart_of_accounts.py", line 56, in _import_accounts
erpnext_app               |     _import_accounts(child, account.name, root_type)
erpnext_app               |   [Previous line repeated 1 more time]
erpnext_app               |   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/doctype/account/chart_of_accounts/chart_of_accounts.py", line 52, in _import_accounts
erpnext_app               |     account.insert()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 254, in insert
erpnext_app               |     self.run_method("after_insert")
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 794, in run_method
erpnext_app               |     out = Document.hook(fn)(self, *args, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1065, in composer
erpnext_app               |     return composed(self, method, *args, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1050, in runner
erpnext_app               |     add_to_return_value(self, f(self, method, *args, **kwargs))
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/cache_manager.py", line 133, in build_table_count_cache
erpnext_app               |     }, as_dict=1)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 932, in multisql
erpnext_app               |     return self.sql(query, values, **kwargs)
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 171, in sql
erpnext_app               |     self._cursor.execute(query)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
erpnext_app               |     result = self._query(query)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
erpnext_app               |     conn.query(q)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
erpnext_app               |     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
erpnext_app               |     result.read()
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
erpnext_app               |     first_packet = self.connection._read_packet()
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 657, in _read_packet
erpnext_app               |     packet_header = self._read_bytes(4)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 691, in _read_bytes
erpnext_app               |     data = self._rfile.read(num_bytes)
erpnext_app               |   File "/usr/local/lib/python3.7/socket.py", line 589, in readinto
erpnext_app               |     return self._sock.recv_into(b)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/gunicorn/workers/base.py", line 202, in handle_abort
erpnext_app               |     sys.exit(1)
erpnext_app               | SystemExit: 1
erpnext_app               | 
erpnext_app               | During handling of the above exception, another exception occurred:
erpnext_app               | 
erpnext_app               | Traceback (most recent call last):
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 135, in handle
erpnext_app               |     self.handle_request(listener, req, client, addr)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/gunicorn/workers/sync.py", line 176, in handle_request
erpnext_app               |     respiter = self.wsgi(environ, resp.start_response)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/werkzeug/local.py", line 231, in application
erpnext_app               |     return ClosingIterator(app(environ, start_response), self.cleanup)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/werkzeug/wrappers/base_request.py", line 237, in application
erpnext_app               |     resp = f(*args[:-2] + (request,))
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 88, in application
erpnext_app               |     frappe.db.rollback()
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 753, in rollback
erpnext_app               |     self.sql("rollback")
erpnext_app               |   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 171, in sql
erpnext_app               |     self._cursor.execute(query)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
erpnext_app               |     result = self._query(query)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
erpnext_app               |     conn.query(q)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 516, in query
erpnext_app               |     self._execute_command(COMMAND.COM_QUERY, sql)
erpnext_app               |   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 750, in _execute_command
erpnext_app               |     raise err.InterfaceError("(0, '')")
erpnext_app               | pymysql.err.InterfaceError: (0, '')
erpnext_app               | [2020-05-03 16:23:57 +0200] [671] [INFO] Worker exiting (pid: 671)
erpnext_db                | 2020-05-03 14:23:57 57 [Warning] Aborted connection 57 to db: 'erpnext' user: 'erpnext' host: '172.18.0.6' (Got an error reading communication packets)

Docker (please complete the following information):
docker-compose version 1.17.1
Docker version 19.03.8, build afacb8b7f0

monogramm / docker-erpnext Goto Github PK

docker-erpnext's Introduction

ERPNext Docker container

What is ERPNext ?

Supported tags

How to run this image ?

Running this image with docker-compose

Questions / Issues

References

docker-erpnext's People

Contributors

Stargazers

Watchers

Forkers

docker-erpnext's Issues

Recommend Projects

Recommend Topics

Recommend Org