search

Monogramm / docker-erpnext

:whale: :snake: Docker image for ERPNext.
https://erpnext.com/
GNU Affero General Public License v3.0
92 stars 36 forks source link

Installation Instructions #49

Open stonegray opened 1 year ago

stonegray commented 1 year ago

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:

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 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 "", line 1006, in _gcd_import erpnext_app | File "", line 983, in _find_and_load erpnext_app | File "", line 953, in _find_and_load_unlocked erpnext_app | File "", line 219, in _call_with_frames_removed erpnext_app | File "", line 1006, in _gcd_import erpnext_app | File "", line 983, in _find_and_load erpnext_app | File "", 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 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 "", line 1006, in _gcd_import erpnext_app | File "", line 983, in _find_and_load erpnext_app | File "", line 953, in _find_and_load_unlocked erpnext_app | File "", line 219, in _call_with_frames_removed erpnext_app | File "", line 1006, in _gcd_import erpnext_app | File "", line 983, in _find_and_load erpnext_app | File "", 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 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 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?

madmath03 commented 1 year ago

There are instructions in the README (cf "running this image with docker-compose"). Though they it be improved, a few things I can already mention based on your description:

Can you try first with the instructions mentioned and with version 11?