manyfold icon indicating copy to clipboard operation
manyfold copied to clipboard

fix issues in default unRAID template

Open feroxib opened this issue 8 months ago • 13 comments

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. Go to Unraid CA

  2. Pull Manyfold template; fill in env variables

  3. Scroll down to pg URL string

  4. default string postgresql://manyfold:password@db/manyfold?pool=5

  5. replace: manyfold by "database_name" password by "your_secret_password" db by "postgresql_docker_label"/"static_IP_of_container"

  6. do a quick sql statement to create user, pw, db and grant all permissions in postgres

  7. (redis is not setup yet but appears to be unrelated)

  8. spin up docker container and manifold pg_connection error occurs in logs attached

Expected behavior replace custom variables and enjoy manifold since the unraid template should provide a default "state" almost ready to use.

Screenshots image

Desktop (please complete the following information):

  • OS: fedora40, kde plasma
  • Browser firefox
  • Version 127

Additional context Putting this on here to document the current state of the unraid template provided via the CA plugin. On request of the maintainer fixes, changes, tests are done.

with quickly trying to spin up the manifold container i noticed following:

the default url is provided and includes the pool parameter: postgresql://manyfold:password@db/manyfold?pool=5

please verify that this is intended since a quick research " PGSQL does not provide connection pooling. it is usually handled by a connection pooling tool or middleware" using this string without the pool appears to work fine in the first moment.

however though with the current image ghcr.io/manyfold3d/manyfold:latest (tag:0.69.0) following error appears: PG::ConnectionBad: connection to server at "172.1.0.2", port 5432 failed: FATAL: database "db/production.sqlite3" does not exist (PG::ConnectionBad)

noticable about this is: docker label got translated to ip correctly port default 5432 is correct

the database "db/production.sqlite3" causes some inexplicable behavior. what does database mean in this context? since the defined database_name is in the connection string. in the manyfold docs the statement "PostgreSQL is the production database, though sqlite3 is used in dev" is found. Does this indicate a improper search for an sqlite3 database even though, manyfold tries to connect to pg?

thanks for response point out errors since i do make mistakes

regards feroxib

feroxib avatar Jun 26 '24 13:06 feroxib