Impossible to install mathesar

[jeromeperez]

Description

Impossible to install last release

Expected behavior

an installed and usable application mathesar

To Reproduce

sudo docker compose -f /mnt/data

Environment

• OS: debian 12
• Browser: (eg. Safari; Firefox)
• Browser Version: (eg. 13; 73)
• Other info:

Additional context

sudo docker compose -f docker-compose.yml up
[+] Running 3/0
✔ Container mathesar_db Created 0.0s
✔ Container mathesar_service Created 0.0s
✔ Container mathesar-caddy-reverse-proxy-1 Created 0.0s
Attaching to caddy-reverse-proxy-1, mathesar_db, mathesar_service
mathesar_db |
mathesar_db | PostgreSQL Database directory appears to contain a database; Skipping initialization
mathesar_db |
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6093478,"msg":"using provided configuration","config_file":"/etc/caddy/Caddyfile","config_adapter":"caddyfile"}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6108546,"logger":"admin","msg":"admin endpoint started","address":"localhost:2019","enforce_origin":false,"origins":["//localhost:2019","//[::1]:2019","//127.0.0.1:2019"]}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6109264,"logger":"http.auto_https","msg":"server is listening only on the HTTPS port but has no TLS connection policies; adding one to enable TLS","server_name":"srv0","https_port":443}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.610935,"logger":"http.auto_https","msg":"enabling automatic HTTP->HTTPS redirects","server_name":"srv0"}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.61099,"logger":"tls.cache.maintenance","msg":"started background certificate maintenance","cache":"0xc000172700"}
mathesar_db | 2024-02-13 14:00:50.615 UTC [1] LOG: starting PostgreSQL 13.14 (Debian 13.14-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
mathesar_db | 2024-02-13 14:00:50.615 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
mathesar_db | 2024-02-13 14:00:50.615 UTC [1] LOG: listening on IPv6 address "::", port 5432
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6193373,"logger":"pki.ca.local","msg":"root certificate is already trusted by system","path":"storage:pki/authorities/local/root.crt"}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6194456,"logger":"http","msg":"enabling HTTP/3 listener","addr":":443"}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6197035,"msg":"failed to sufficiently increase receive buffer size (was: 208 kiB, wanted: 2048 kiB, got: 416 kiB). See https://github.com/quic-go/quic-go/wiki/UDP-Buffer-Sizes for details."}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.619911,"logger":"http.log","msg":"server running","name":"srv0","protocols":["h1","h2","h3"]}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6199572,"logger":"http.log","msg":"server running","name":"remaining_auto_https_redirects","protocols":["h1","h2","h3"]}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6199656,"logger":"http","msg":"enabling automatic TLS certificate management","domains":["MyIP"]}
caddy-reverse-proxy-1 | {"level":"warn","ts":1707832850.6204915,"logger":"tls","msg":"stapling OCSP","error":"no OCSP stapling for [MyIP]: no OCSP server specified in certificate","identifiers":["MyIP"]}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6206715,"msg":"autosaved config (load with --resume flag)","file":"/config/caddy/autosave.json"}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6206858,"msg":"serving initial configuration"}
caddy-reverse-proxy-1 | {"level":"warn","ts":1707832850.6426978,"logger":"tls","msg":"storage cleaning happened too recently; skipping for now","storage":"FileStorage:/data/caddy","instance":"ad48cdae-b75e-4fd5-b495-4a5a0e56b3e2","try_again":1707919250.6426942,"try_again_in":86399.999999209}
caddy-reverse-proxy-1 | {"level":"info","ts":1707832850.6428475,"logger":"tls","msg":"finished cleaning storage units"}
mathesar_db | 2024-02-13 14:00:50.673 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mathesar_db | 2024-02-13 14:00:50.736 UTC [27] LOG: database system was shut down at 2024-02-13 13:56:54 UTC
mathesar_db | 2024-02-13 14:00:50.771 UTC [1] LOG: database system is ready to accept connections
mathesar_service | /usr/local/bin/python: Error while finding module specification for 'mathesar.install' (ModuleNotFoundError: No module named 'mathesar')
mathesar_service exited with code 1

[seancolsen]

Thanks for reporting this, @jeromeperez. We'll have someone look into this ASAP.

[Anish9901]

Hey @jeromeperez! I'd like to know a little more about what your setup for installing Mathesar looks like,

• Are you installing Mathesar on GCP/AWS?
• I notice that you are trying to set up a domain that is hidden by "MyIP", is this IP pointed to by a domain/subdomain on a DNS?
• Are there any other settings except the SECRET_KEY & DOMAIN_NAME that you have altered in the docker-compose.yml file?

[jeromeperez]

Hey @jeromeperez! I'd like to know a little more about what your setup for installing Mathesar looks like,

• Are you installing Mathesar on GCP/AWS? No i'am installing on local lan server
• I notice that you are trying to set up a domain that is hidden by "MyIP", is this IP pointed to by a domain/subdomain on a DNS?
  It's the Ip of my server and it was working on another local lan server with 0.1.3 version using .env and the same version upgraded to 0.1.4 version
• Are there any other settings except the SECRET_KEY & DOMAIN_NAME that you have altered in the docker-compose.yml file?
  DB settings

x-config: &config
  (REQUIRED) Replace '?' with '-' followed by a 50 character random string.
   You can generate one at https://djecrety.ir/ or by running:
     echo $(cat /dev/urandom | LC_CTYPE=C tr -dc 'a-zA-Z0-9' | head -c 50)
  SECRET_KEY: ${SECRET_KEY:-SECRETKEY}

   (Optional) Replace 'http://localhost' with custom domain(s) e.g.
   'yourdomain.com, 127.0.0.1' to manage the host(s) at which you want to
   access Mathesar over http or https
  DOMAIN_NAME: ${DOMAIN_NAME:-162.38.X.X, Data-X-X, 127.0.0.1}

   Edit the POSTGRES_* variables if you are not using the db service provided
   below, or if you want to use a custom database user.

   (Optional) Replace 'mathesar_django' with any custom name for the internal
   database managed by mathesar web-service
  POSTGRES_DB: ${POSTGRES_DB:-mathesar_django}

   (Optional) Replace 'mathesar' with any custom username for the
   aforementioned database
  POSTGRES_USER: ${POSTGRES_USER:-mathesar}

   (Optional) Replace 'mathesar' with any custom password for the
   aforementioned database

  POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-PASSWORD}
   (Optional) Replace 'mathesar_db' with the name of the host running postgres
  POSTGRES_HOST: ${POSTGRES_HOST:-162.38.X.X}

   (Optional) Replace '5432' with the port on which postgres is running
  POSTGRES_PORT: ${POSTGRES_PORT:-5432}

If i put only IP in domain_name it's the same

[Anish9901]

If i put only IP in domain_name it's the same

That's true @jeromeperez, however you'd have to specify http:// before those IP(s) as the reverse proxy will try to serve any traffic for those IPs over https hence making the service inaccessible as SSL certificates for those IP(s) couldn't be obtained. Once you have made the change mathesar should then be available at http://162.38.X.X

I am also noticing the following error from your error logs:

mathesar_service | /usr/local/bin/python: Error while finding module specification for 'mathesar.install' (ModuleNotFoundError: No module named 'mathesar')
mathesar_service exited with code 1

Are you trying to mount any volumes to the service? specifically to the /code/ directory that lives inside the mathesar_service container?

[jeromeperez]

If i put only IP in domain_name it's the same

That's true @jeromeperez, however you'd have to specify http:// before those IP(s) as the reverse proxy will try to serve any traffic for those IPs over https hence making the service inaccessible as SSL certificates for those IP(s) couldn't be obtained. Once you have made the change mathesar should then be available at http://162.38.X.X

I am also noticing the following error from your error logs:

mathesar_service | /usr/local/bin/python: Error while finding module specification for 'mathesar.install' (ModuleNotFoundError: No module named 'mathesar')
mathesar_service exited with code 1

Are you trying to mount any volumes to the service? specifically to the /code/ directory that lives inside the mathesar_service container?
I don't know how to do that
i added http:// before the IP but mathesar is unreachable (i use a vpn because i am out of office) today but i have the same error

sudo docker compose -f docker-compose.yml up
[sudo] Mot de passe de jerome.perez : 
[+] Running 3/0
 ✔ Container mathesar_db                     Created                                                                                                                                                                                  0.0s 
 ✔ Container mathesar-caddy-reverse-proxy-1  Created                                                                                                                                                                                  0.0s 
 ✔ Container mathesar_service                Created                                                                                                                                                                                  0.0s 
Attaching to caddy-reverse-proxy-1, mathesar_db, mathesar_service
mathesar_db            | 
mathesar_db            | PostgreSQL Database directory appears to contain a database; Skipping initialization
mathesar_db            | 
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1273003,"msg":"using provided configuration","config_file":"/etc/caddy/Caddyfile","config_adapter":"caddyfile"}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1282218,"logger":"admin","msg":"admin endpoint started","address":"localhost:2019","enforce_origin":false,"origins":["//localhost:2019","//[::1]:2019","//127.0.0.1:2019"]}
caddy-reverse-proxy-1  | {"level":"warn","ts":1707918948.1282744,"logger":"http.auto_https","msg":"server is listening only on the HTTP port, so no automatic HTTPS will be applied to this server","server_name":"srv0","http_port":80}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1283703,"logger":"tls.cache.maintenance","msg":"started background certificate maintenance","cache":"0xc00071f080"}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1285214,"logger":"http.log","msg":"server running","name":"srv0","protocols":["h1","h2","h3"]}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1285973,"msg":"autosaved config (load with --resume flag)","file":"/config/caddy/autosave.json"}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.1285994,"msg":"serving initial configuration"}
caddy-reverse-proxy-1  | {"level":"warn","ts":1707918948.3772845,"logger":"tls","msg":"storage cleaning happened too recently; skipping for now","storage":"FileStorage:/data/caddy","instance":"f60e6e50-f47d-4c78-ac78-c9ab1f66b270","try_again":1708005348.377282,"try_again_in":86399.999999303}
caddy-reverse-proxy-1  | {"level":"info","ts":1707918948.377629,"logger":"tls","msg":"finished cleaning storage units"}
mathesar_db            | 2024-02-14 13:55:48.446 UTC [1] LOG:  starting PostgreSQL 13.14 (Debian 13.14-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
mathesar_db            | 2024-02-14 13:55:48.446 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
mathesar_db            | 2024-02-14 13:55:48.446 UTC [1] LOG:  listening on IPv6 address "::", port 5432
mathesar_db            | 2024-02-14 13:55:48.491 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
mathesar_db            | 2024-02-14 13:55:48.555 UTC [27] LOG:  database system was shut down at 2024-02-14 13:54:54 UTC
mathesar_db            | 2024-02-14 13:55:48.589 UTC [1] LOG:  database system is ready to accept connections
mathesar_service       | /usr/local/bin/python: Error while finding module specification for 'mathesar.install' (ModuleNotFoundError: No module named 'mathesar')
mathesar_service exited with code 1