manyfold
manyfold copied to clipboard
fix issues in default unRAID template
Describe the bug A clear and concise description of what the bug is.
To Reproduce Steps to reproduce the behavior:
-
Go to Unraid CA
-
Pull Manyfold template; fill in env variables
-
Scroll down to pg URL string
-
default string postgresql://manyfold:password@db/manyfold?pool=5
-
replace: manyfold by "database_name" password by "your_secret_password" db by "postgresql_docker_label"/"static_IP_of_container"
-
do a quick sql statement to create user, pw, db and grant all permissions in postgres
-
(redis is not setup yet but appears to be unrelated)
-
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
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