docker-erpnext
docker-erpnext copied to clipboard
Published
20 hours ago •
Monogramm
Monogramm
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?
