sqlpage.oidc_logout_url http instead https

[sarz4fun]

Hello, i used the new function

sqlpage.oidc_logout_url

I set OIDC with Keycloak.
Sqlpage Is behind Nginx.

https://mysite.sqlpage.com as example

Sqlpage Is on 80, Nginx exposes only https on 443 Port with compliant certificate.

Login works perfecty, redirect too after login.

When i call sqlpage.oidc_logout_url('/')
the redirect url is:

http://mysite.sqlpage.com (http instead https)

Keycloak rejects logout because redirect url is invalid.
I set logout uri as * in keycloak but Firefox doesn't load the destination page because is on Port 80 and is It closed on my firewall.

Anyone can help me?

Thank you

• OS: debian 13
• Database Mssql
• SQLPage Version 0.41.0

[lovasoa]

Hi ! Can you give me a little bit more info ?
In your browser's developer tools, you can open the network inspector while you reproduce the bug, and then click the download icon export HAR (sanitized). getting the keycloak error log would be helpful too.

I suspect the url returned by oidc_logout_url is correct, but the second url it redirects you to is not

[sarz4fun]

Hi ! Can you give me a little bit more info ? In your browser's developer tools, you can open the network inspector while you reproduce the bug, and then click the download icon export HAR (sanitized). getting the keycloak error log would be helpful too.

I suspect the url returned by oidc_logout_url is correct, but the second url it redirects you to is not

Hello, here you can find the har file After pressing logout button.

pg.xxxx.com_Archive [26-01-08 13-24-20] (1).har.zip

[lovasoa]

Thanks ! Indeed, I see it's the post_logout_redirect_uri parameter in the url parameters passed to keycloak that is wrong. I'll fix it, thanks for the report !