Run db migrations prior to first startup about immich

[nebulade]

Actually I didn't realize an optional config file exists. This solves it nicely for our use-case. Thanks a lot for pointing me in the right direction, sorry for the distraction.

For others https://immich.app/docs/install/config-file is the docs link.

[bo0tzz]

I think the hardcoded localhost is probably wrong since people might be developing against a database running on a different host. However for your use case, maybe it would be more appropriate to support some sort of trigger/hook that is called after server startup? That might also make it possible to use the API to configure things rather than needing to directly poke the database.

@jrasm91 thoughts?

[nebulade]

I agree, poking the database directly is not a great idea, so far was just the only way to pre-setup this on behalf of the user. Does immich have an API which can be used on localhost without access tokens where we could just call the openid settings endpoint (and potentially other things)? Or would this be more the job for the immich-admin to have subcommands for that?

[jrasm91]

I was not aware of a use case to manually run migrations through this command outside of development. We can make it possible to run against another host, but relying on it seems like a recipe for future issues. There is an API for setting and updating the configuration so maybe it is worth looking into a way to leverage the instead.

[nebulade]

Ideally we don't want to run the database migration manually up front. This is really only needed as the OpenID auth settings are pre-provisioned for the user on Cloudron to have SSO across many apps installed on a server.

Maybe to circumvent the database migration/app bootstrapping issue, does Immich have a way to pre-provision certain settings, like picking up those values from env variables instead of the database if provided? Briefly looked through the code but didn't catch anything like that.

[bo0tzz]

There is the config file, but I don't know whether that works for you as it fully locks the settings UI.