Cutom apps deployment using podman

ERPNext
, ,
1

Greetings
I am on Fedora 41 and trying to deploy ERPNext, HRMS and Helpdesk, I followed this guide on github.

Here are the steps I have done

  1. Cloned frappe_docker

     git clone https://github.com/frappe/frappe_docker 
 cd frappe_docker

  2. Created apps.json

    [
  {
    "url": "https://github.com/frappe/erpnext",
    "branch": "version-15"
  },
  { 
    "url": "https://github.com/frappe/hrms",
    "branch": "version-15"
  },
  { 
    "url": "https://github.com/frappe/helpdesk",
    "branch": "main"
  }
]

    2.1 Generate base64 string from json file:
    export APPS_JSON_BASE64=$(base64 -w 0 apps.json)

  3. Quick build image

     podman build \
    --build-arg=FRAPPE_PATH=https://github.com/frappe/frappe \
    --build-arg=FRAPPE_BRANCH=version-15 \
    --build-arg=APPS_JSON_BASE64=$APPS_JSON_BASE64 \
    --tag=custom-erpnext:v15 \
    --file=images/layered/Containerfile .

  4. Using the Image
    4.1 Setting Environment Variables

        export CUSTOM_IMAGE=custom-erpnext
    export CUSTOM_TAG=v15
    export PULL_POLICY=never

    4.2 Created.env file with the following content

     # Reference: https://github.com/frappe/frappe_docker/blob/main/docs/environment-variables.md
 ERPNEXT_VERSION=v15.40.0
 DB_PASSWORD=123456
 
 # Only if you use external database
 DB_HOST=
 DB_PORT=
 
 # Only if you use external Redis
 REDIS_CACHE=
 REDIS_QUEUE=
 
 # Only with HTTPS override
 LETSENCRYPT_EMAIL=mail@example.com
 
 # These environment variables are not required.
 # Default value is `$host` which resolves site by host. For example, if your host is `example.com`,
 
 # site's name should be `example.com`, or if host is `127.0.0.1` (local debugging), it should be `127.0.0.1`.
 
 # This variable allows to override described behavior. Let's say you create site named `mysite`
 
 # and do want to access it by `127.0.0.1` host. Than you would set this variable to `mysite`.
 FRAPPE_SITE_NAME_HEADER=frappe
 
 # Default value is `8080`.
 HTTP_PUBLISH_PORT=8085
 
 # Default value is `127.0.0.1`. Set IP address as our trusted upstream address.
 UPSTREAM_REAL_IP_ADDRESS=
 
 # Default value is `X-Forwarded-For`. Set request header field whose value will be used to replace the client address
 UPSTREAM_REAL_IP_HEADER=
 
 # Allowed values are on|off. Default value is `off`. If recursive search is disabled,
 
 # the original client address that matches one of the trusted addresses
 
 # is replaced by the last address sent in the request header field defined by the real_ip_header directive.
 
 # If recursive search is enabled, the original client address that matches one of the trusted addresses is replaced by the last non-trusted address sent in the request header field.
 
 UPSTREAM_REAL_IP_RECURSIVE=
 
 # All Values Allowed by nginx proxy_read_timeout are allowed, default value is 120s
 
 # Useful if you have longrunning print formats or slow loading sites
 
 PROXY_READ_TIMEOUT=
 
 # All Values allowed by nginx client_max_body_size are allowed, default value is 50m
 
 # Necessary if the upload limit in the frappe application is increased
 
 CLIENT_MAX_BODY_SIZE=
 
 # List of sites for letsencrypt certificates quoted with backtick (`) and separated by comma (,)
 
 # More https://doc.traefik.io/traefik/routing/routers/#rule
 
 # About acme https://doc.traefik.io/traefik/https/acme/#domain-definition
 SITES=`erp.example.com`

    4.3 Creating a compose file

     podman compose -f compose.yaml \
   -f overrides/compose.mariadb.yaml \
   -f overrides/compose.redis.yaml \
   -f overrides/compose.noproxy.yaml \
   config > ./docker-compose.yml

Finally when I try to start the containers using the new compose file (docker-compose.yml) I am facing the following issues

ERRORS

Running podman compose --project-name frappe -f ./docker-compose.yml up -d

>>>> Executing external compose provider "/usr/bin/podman-compose". Please see podman-compose(1) for how to disable this message. <<<<

1468e0d688d39b212d6baae0a041db5d6bfa3a3a8f9ae6f7a550009fe2c224b6
Resolved "mariadb" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/library/mariadb:10.6...
Getting image source signatures
Copying blob 7167d5a9dbcd done   |
Copying blob c5a65b879ae2 done   |
Copying blob ebf3425cfcb3 done   |
Copying blob d9802f032d67 done   |
Copying blob 7907d0087b00 done   |
Copying blob ca046fd35212 done   |
Copying blob 211ee8020ea4 done   |
Copying blob 850797b44462 done   |
Copying config 17085c4029 done   |
Writing manifest to image destination
045a096c09b55da04aabf966b31cc4f501841a60a94f856ea6551329248ddc16
frappe_db_1
Resolved "redis" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/library/redis:6.2-alpine...
Getting image source signatures
Copying blob cc3fe856cb76 done   |
Copying blob da9db072f522 done   |
Copying blob ebecd181d463 done   |
Copying blob d06bad13a9cb done   |
Copying blob 639d6884da44 done   |
Copying blob f0095eac60c5 done   |
Copying blob 4f4fb700ef54 done   |
Copying blob 7fe92cb740a4 done   |
Copying config 4100b5bd17 done   |
Writing manifest to image destination
10cdd2c305c90b71083d8d767c1322c7b7862ad269b25cc2fa5e4baa17f2777e
frappe_redis-cache_1
853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139
frappe_redis-queue_1
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 done   |
Copying blob c3aa3af0d581 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob 050728812782 done   |
Copying blob 442c5d63eafd skipped: already exists
Copying blob d68837d1402e done   |
Copying blob 848d19a36773 skipped: already exists
Copying blob 8ac1592c2236 done   |
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob baa32d39f6d8 done   |
Copying blob 4f4fb700ef54 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042
frappe_configurator_1
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container 63a2ebec1dfe5fbc305397407f5e137342b4d8a2e131f5ffbe923bcf57d883f0: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 10cdd2c305c90b71083d8d767c1322c7b7862ad269b25cc2fa5e4baa17f2777e not found in input list: no such container
Error: unable to start container "63a2ebec1dfe5fbc305397407f5e137342b4d8a2e131f5ffbe923bcf57d883f0": generating dependency graph for container 63a2ebec1dfe5fbc305397407f5e137342b4d8a2e131f5ffbe923bcf57d883f0: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 10cdd2c305c90b71083d8d767c1322c7b7862ad269b25cc2fa5e4baa17f2777e not found in input list: no such container
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container 68807e734812092c50e6e8fda018af7c3fdc4b5bd6249c12ecb8505b11a0daf1: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Error: unable to start container "68807e734812092c50e6e8fda018af7c3fdc4b5bd6249c12ecb8505b11a0daf1": generating dependency graph for container 68807e734812092c50e6e8fda018af7c3fdc4b5bd6249c12ecb8505b11a0daf1: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 045a096c09b55da04aabf966b31cc4f501841a60a94f856ea6551329248ddc16 not found in input list: no such container
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container 40331eef1ed350b6da46f4b4f34beedd51d78cc24d09c3e66afb7df7c2e91996: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Error: unable to start container "40331eef1ed350b6da46f4b4f34beedd51d78cc24d09c3e66afb7df7c2e91996": generating dependency graph for container 40331eef1ed350b6da46f4b4f34beedd51d78cc24d09c3e66afb7df7c2e91996: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container f1870a62e3b4af8c43bd0aa2cf7454a90962abd50414b3e632549b97e7ee00c7: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Error: unable to start container "f1870a62e3b4af8c43bd0aa2cf7454a90962abd50414b3e632549b97e7ee00c7": generating dependency graph for container f1870a62e3b4af8c43bd0aa2cf7454a90962abd50414b3e632549b97e7ee00c7: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container 5dd001c3dc4d76e4e12a7f64e47c410c7ab6513cf347a805a3161a06aed799d5: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Error: unable to start container "5dd001c3dc4d76e4e12a7f64e47c410c7ab6513cf347a805a3161a06aed799d5": generating dependency graph for container 5dd001c3dc4d76e4e12a7f64e47c410c7ab6513cf347a805a3161a06aed799d5: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container
Resolved "frappe/erpnext" as an alias (/home/linux_admin/.cache/containers/short-name-aliases.conf)
Trying to pull docker.io/frappe/erpnext:v15.40.0...
Getting image source signatures
Copying blob ccd5f9fe4548 skipped: already exists
Copying blob 442c5d63eafd skipped: already exists
Copying blob d68837d1402e skipped: already exists
Copying blob 4bfbe15b3e01 skipped: already exists
Copying blob 1f7ce2fa46ab skipped: already exists
Copying blob 848d19a36773 skipped: already exists
Copying blob 4f4fb700ef54 skipped: already exists
Copying blob 050728812782 skipped: already exists
Copying blob 8ac1592c2236 skipped: already exists
Copying blob baa32d39f6d8 skipped: already exists
Copying blob c3aa3af0d581 skipped: already exists
Copying config f4bb84f70b done   |
Writing manifest to image destination
Error: generating dependency graph for container 56fb23f532ba228ada627c2ebdedc827397bcd7d23079116efa769695b54467d: container 5dd001c3dc4d76e4e12a7f64e47c410c7ab6513cf347a805a3161a06aed799d5 depends on container 10cdd2c305c90b71083d8d767c1322c7b7862ad269b25cc2fa5e4baa17f2777e not found in input list: no such container
Error: unable to start container "56fb23f532ba228ada627c2ebdedc827397bcd7d23079116efa769695b54467d": generating dependency graph for container 56fb23f532ba228ada627c2ebdedc827397bcd7d23079116efa769695b54467d: container eebe0181e0adae9ee2265c9b17786cff2cd682c45ed09cbb782940a82eecb042 depends on container 853c7f7ed076facf2c8f595c116fd73666052fff81274794bb6d3c670ce66139 not found in input list: no such container

Running podman ps
Three containers are showing up

 CONTAINER ID  IMAGE                               COMMAND               CREATED        STATUS                  PORTS       NAMES
045a096c09b5  docker.io/library/mariadb:10.6      --character-set-s...  7 minutes ago  Up 7 minutes (healthy)  3306/tcp    frappe_db_1
10cdd2c305c9  docker.io/library/redis:6.2-alpine  redis-server          7 minutes ago  Up 7 minutes            6379/tcp    frappe_redis-cache_1
853c7f7ed076  docker.io/library/redis:6.2-alpine  redis-server          7 minutes ago  Up 7 minutes            6379/tcp    frappe_redis-queue_1

At this point when I try to open Firefox and check for localhost:8085 I get the following error:

frappe does not exist
frappe does not exist861×404 13.9 KB

The output from the above command shows that some containers, such as backend, frontend, and more, are not running. Therefore I restarted the whole container again using podman-desktop application:

Running podman ps

linux_admin@fedora:~/frappe_docker$ podman ps
CONTAINER ID  IMAGE                               COMMAND               CREATED         STATUS                  PORTS                   NAMES
045a096c09b5  docker.io/library/mariadb:10.6      --character-set-s...  15 minutes ago  Up 4 minutes (healthy)  3306/tcp                frappe_db_1
10cdd2c305c9  docker.io/library/redis:6.2-alpine  redis-server          14 minutes ago  Up 4 minutes            6379/tcp                frappe_redis-cache_1
853c7f7ed076  docker.io/library/redis:6.2-alpine  redis-server          14 minutes ago  Up 4 minutes            6379/tcp                frappe_redis-queue_1
63a2ebec1dfe  docker.io/frappe/erpnext:v15.40.0   /home/frappe/frap...  10 minutes ago  Up 4 minutes                                    frappe_backend_1
f1870a62e3b4  docker.io/frappe/erpnext:v15.40.0   bench schedule        10 minutes ago  Up 4 minutes                                    frappe_scheduler_1
56fb23f532ba  docker.io/frappe/erpnext:v15.40.0   nginx-entrypoint....  9 minutes ago   Up 4 minutes            0.0.0.0:8085->8080/tcp  frappe_frontend_1

Still, some containers such as websocket were not running and couldn’t be started. Here is the output from Firefox
Internal server error

I tried to create A site while those containers running:
Running podman compose --project-name frappe exec backend bench new-site frappe --mariadb-root-password 123456 --admin-password 123123

 Traceback (most recent call last):
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 649, in connect
    sock = socket.create_connection(
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/socket.py", line 851, in create_connection
    raise exceptions[0]
  File "/usr/local/lib/python3.11/socket.py", line 836, in create_connection
    sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
    main()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 102, in new_site
    _new_site(
  File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 90, in _new_site
    install_db(
  File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 170, in install_db
    setup_database(force, verbose, mariadb_user_host_login_scope)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/__init__.py", line 21, in setup_database
    return frappe.database.mariadb.setup_db.setup_database(force, verbose, mariadb_user_host_login_scope)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/setup_db.py", line 32, in setup_database
    if force or (db_name not in dbman.get_database_list()):
                                ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/db_manager.py", line 50, in get_database_list
    return self.db.sql("SHOW DATABASES", pluck=True)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 206, in sql
    self.connect()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 111, in connect
    self._conn: "MariadbConnection" | "PostgresConnection" = self.get_connection()
                                                             ^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 107, in get_connection
    conn = self._get_connection()
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 113, in _get_connection
    return self.create_connection()
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 116, in create_connection
    return pymysql.connect(**self.get_connection_settings())
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 361, in __init__
    self.connect()
  File "/home/frappe/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 716, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 111] Connection refused)")
Error: executing /usr/bin/podman-compose --project-name frappe exec backend bench new-site frappe --mariadb-root-password 123456 --admin-password 123123: exit status 1

It seems the connection to the database is being blocked. But the logs from MariaDB container doesn’t say much

2024-11-12 11:07:50+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.19+maria~ubu2004 started.
2024-11-12 11:07:50+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-11-12 11:07:50+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.19+maria~ubu2004 started.
2024-11-12 11:07:50+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
�2024-11-12 11:07:50 0 [Note] Starting MariaDB 10.6.19-MariaDB-ubu2004 source revision 8f020508c87461bbeee551c3001acac56d506ae7 server_uid TVh3dURd68gD8ng3vgKGsbafM3g= as process 1
2024-11-12 11:07:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-11-12 11:07:50 0 [Note] InnoDB: Number of pools: 1
2024-11-12 11:07:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-11-12 11:07:50 0 [Note] InnoDB: Using Linux native AIO
2024-11-12 11:07:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2024-11-12 11:07:50 0 [Note] InnoDB: Completed initialization of buffer pool
2024-11-12 11:07:50 0 [Note] InnoDB: 128 rollback segments are active.
2024-11-12 11:07:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-11-12 11:07:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-11-12 11:07:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-11-12 11:07:50 0 [Note] InnoDB: 10.6.19 started; log sequence number 42688; transaction id 16
2024-11-12 11:07:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-11-12 11:07:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-11-12 11:07:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
2024-11-12 11:07:50 0 [Note] InnoDB: Buffer pool(s) load completed at 241112 11:07:50
2024-11-12 11:07:50 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-11-12 11:07:50 0 [Note] Server socket created on IP: '::'.
2024-11-12 11:07:50 0 [Note] mariadbd: ready for connections.
Version: '10.6.19-MariaDB-ubu2004'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Overview

overview podman desktop
overview podman desktop1358×655 76.1 KB

What am I missing here, I appreciate your support guys. Thanks

2

@Varun is the podman user.

1 Like
3

@revant_one btw podman compose -f pwd.yml up -d just works fine, but since I am using apps like hrms and helpdesk that’s why I am building custom image

4

After trying several times, I really could successfully access erpnext and hrms. The issue was with the domain I was accessing on browsers. I needed to set frappe in /etc/hosts. But I don’t think that could cause a problem here because currently, I can still access the next through localhost:8085, which was not working the first time.

1 Like