[Support] FoxxMD - szurubooru

[GoodOlCap]

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 :)

[mrguymiah]

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.

[404fox]

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.

[Tweak91]

every time i upload something Internal Server Error

[KanaeYe]

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?

[jakami99]

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

[rhyscorgi]

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?