Support path-based reverse proxy (site_prefix) for SQLPage OIDC flows

[rinshadka]

OIDC does not respect SQLPAGE_SITE_PREFIX when behind path-based reverse proxy

I’m running SQLPage behind an Nginx path-based reverse proxy (for example /123) with OIDC enabled.

Non-auth pages work correctly when started with:

SQLPAGE_SITE_PREFIX=/123

Environment:

SQLPage version: v0.39.1
Auth: OIDC (tested with Zitadel)
Reverse proxy: Nginx
Deployment type: Path-based proxy (/123)
OS: Linux

However, during OIDC login, the callback URL is generated as:

/sqlpage/oidc_callback instead of: /123/sqlpage/oidc_callback

Because of this, authentication only works when SQLPage is served from the root path. Any workaround to this?

I need to run multiple oidc based sqlpages under path based nginx proxy

Thanks.

[lovasoa]

This is a bug in the oidc code, it should take the path prefix into account. I'll work on it!

[rinshadka]

This is a bug in the oidc code, it should take the path prefix into account. I'll work on it!

Thanks @lovasoa , expecting the fix and a release soon :)

[lovasoa]

It's going to be in the next release. In the meantime, the easiest way for you to test and confirm the fix is to use the lovasoa/sqlpage:main docker image.