GoodOlCap Posted November 5, 2021 Share Posted November 5, 2021 Hello again, i recently tried to reinstall my szurubooru instance and the API part throws a bunch of errors befor it shuts down. I noticed that this year the project went to the version 2.5 and I am wondering if the dockertemplate for unraid got updated or this is a problem on my end? Below the logoutput of the api docker: Traceback (most recent call last): File "/usr/bin/alembic", line 8, in <module> sys.exit(main()) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 588, in main CommandLine(prog=prog).main(argv=argv) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 582, in main self.run_cmd(cfg, options) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 559, in run_cmd fn( File "/usr/lib/python3.8/site-packages/alembic/command.py", line 320, in upgrade script.run_env() File "/usr/lib/python3.8/site-packages/alembic/script/base.py", line 563, in run_env util.load_python_file(self.dir, "env.py") File "/usr/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file module = load_module_py(module_id, path) File "/usr/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py spec.loader.exec_module(module) # type: ignore File "<frozen importlib._bootstrap_external>", line 848, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "/opt/app/szurubooru/migrations/env.py", line 23, in <module> import szurubooru.model.base # noqa: E402 File "/opt/app/szurubooru/migrations/../../szurubooru/model/__init__.py", line 1, in <module> import szurubooru.model.util File "/opt/app/szurubooru/migrations/../../szurubooru/model/util.py", line 6, in <module> from szurubooru.model.user import User File "/opt/app/szurubooru/migrations/../../szurubooru/model/user.py", line 4, in <module> from szurubooru.model.comment import Comment File "/opt/app/szurubooru/migrations/../../szurubooru/model/comment.py", line 3, in <module> from szurubooru.db import get_session File "/opt/app/szurubooru/migrations/../../szurubooru/db.py", line 10, in <module> _engine = sa.create_engine(config.config["database"]) # type: Any File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/__init__.py", line 520, in create_engine return strategy.create(*args, **kwargs) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 54, in create u = url.make_url(name_or_url) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 229, in make_url return _parse_rfc1738_args(name_or_url) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 288, in _parse_rfc1738_args return URL(name, **components) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 71, in __init__ self.port = int(port) ValueError: invalid literal for int() with base 10: '5433:5432' Would love to run my booru again :) Quote Link to comment
mrguymiah Posted January 2, 2023 Share Posted January 2, 2023 Is it safe to update Postgres? I'm concerned about the fact 11 is several versions behind, but also don't want to break things. Quote Link to comment
404fox Posted January 2, 2023 Share Posted January 2, 2023 6 hours ago, mrguymiah said: Is it safe to update Postgres? I'm concerned about the fact 11 is several versions behind, but also don't want to break things. There is a possibility of breakage if you're referring to major versions 12.x, 13.x, etc... 11.x versions should have no issues and are still supported officially. However, as of November, version 10 has been dropped, and 11 is likely to follow within the next year or so. Quote Link to comment
syko91 Posted March 31, 2023 Share Posted March 31, 2023 every time i upload something Internal Server Error Quote Link to comment
KanaeYe Posted May 24, 2023 Share Posted May 24, 2023 There's any way to edit the HTML on Unraid like the favicon method or would be necessary edit it before building the docker image? Quote Link to comment
jakami99 Posted June 5, 2023 Share Posted June 5, 2023 (edited) On 3/31/2023 at 4:39 PM, Tweak91 said: every time i upload something Internal Server Error It seems that you have to set privileges to the folder szurubooru-api is using (if not changed then /mnt/user/appdata/szurubooru/data) chown -R 1000:1000 /mnt/user/appdata/szurubooru/data I had the issue where I couldn't see the pictures. One clean install later and the above command solved it for me ^^ 6AM now 7AM Edit: I finally got my last issue solved. Surprisingly, it is also important to change the path for the client to the same folder as the API...^-^ 7AM now, but everything seems to work now ^^ Edited June 5, 2023 by jakami99 Quote Link to comment
rhyscorgi Posted July 25, 2023 Share Posted July 25, 2023 Hello! So I have the entire system up and running, however my issue is that the password reset link isn't working. The link it sends (minus domain) is below. https://link.example.com/us/?e=1qOU5Ur_cZs02F.vnTutv17aGvVB I've tried sending the link.example.com back to the server address via proxy and also just by DNS and both simply say that the page isn't found. How can I resolve this? Quote Link to comment
saiki k Posted August 28 Share Posted August 28 On 11/5/2021 at 5:43 AM, GoodOlCap said: Hello again, i recently tried to reinstall my szurubooru instance and the API part throws a bunch of errors befor it shuts down. I noticed that this year the project went to the version 2.5 and I am wondering if the dockertemplate for unraid got updated or this is a problem on my end? Below the logoutput of the api docker: Traceback (most recent call last): File "/usr/bin/alembic", line 8, in <module> sys.exit(main()) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 588, in main CommandLine(prog=prog).main(argv=argv) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 582, in main self.run_cmd(cfg, options) File "/usr/lib/python3.8/site-packages/alembic/config.py", line 559, in run_cmd fn( File "/usr/lib/python3.8/site-packages/alembic/command.py", line 320, in upgrade script.run_env() File "/usr/lib/python3.8/site-packages/alembic/script/base.py", line 563, in run_env util.load_python_file(self.dir, "env.py") File "/usr/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file module = load_module_py(module_id, path) File "/usr/lib/python3.8/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py spec.loader.exec_module(module) # type: ignore File "<frozen importlib._bootstrap_external>", line 848, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "/opt/app/szurubooru/migrations/env.py", line 23, in <module> import szurubooru.model.base # noqa: E402 File "/opt/app/szurubooru/migrations/../../szurubooru/model/__init__.py", line 1, in <module> import szurubooru.model.util File "/opt/app/szurubooru/migrations/../../szurubooru/model/util.py", line 6, in <module> from szurubooru.model.user import User File "/opt/app/szurubooru/migrations/../../szurubooru/model/user.py", line 4, in <module> from szurubooru.model.comment import Comment File "/opt/app/szurubooru/migrations/../../szurubooru/model/comment.py", line 3, in <module> from szurubooru.db import get_session File "/opt/app/szurubooru/migrations/../../szurubooru/db.py", line 10, in <module> _engine = sa.create_engine(config.config["database"]) # type: Any File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/__init__.py", line 520, in create_engine return strategy.create(*args, **kwargs) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 54, in create u = url.make_url(name_or_url) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 229, in make_url return _parse_rfc1738_args(name_or_url) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 288, in _parse_rfc1738_args return URL(name, **components) File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/url.py", line 71, in __init__ self.port = int(port) ValueError: invalid literal for int() with base 10: '5433:5432' Would love to run my booru again Very late reply to this, but if anyone else runs into this issue here's the explanation + solution I came up with: That error is being thrown when szurubooru-api tries reading your POSTGRES_HOST IP. szurubooru expects database URLs in a specific format, as specified in the repo's config.yaml.dist: ## usage: schema://user:password@host:port/database_name ## example: postgres://szuru:dog@localhost:5432/szuru_test Once you provide the postgres address in the specified format, that error should go away. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.