Skip to content

OIDC SSO lose Query parameter of original page #962

@T-Doschke

Description

@T-Doschke

Introduction

Sqlpage adress called with Query parameters ...page.sql?Param=1
OIDC is configured with microsoft Azure EntraID
Browser will be redirected to Microsoft OIDC page, authorization is fine, cookie will be set and as last step browser will be redirected to ...page.sql without the original ?Param=1 part.

To Reproduce

using SQLpage v0.35.2 in combination with OIDC SSO and having cookies deleted in Browser.
Browse to a sqlpage.sql?param=1 webseite,
All the OIDC stuff is working perfect but the last redirect back is only to sqlpage.sql without the original query param=1 part.

Can't test, but i think is is true for other OIDC providers too.
Have not tested if its the same for Post Parameters.

Expected behavior

the question is, is it possible to have the last redirect back to the sqlpage page with the original query parameters?
is there any other solution for combining OIDC login and parameters for an sqlpage page?

Version information

  • OS: Windows Server 2025
  • Database MS SQL 2022 enterprise
  • SQLPage Version v0.35.2
  • OIDC SSO with Microsoft Azure EntraID
    Configuration is with ARR and URL Rewrite to handle multiple SQLPages instances on different Ports and URL Parts on same Host, but the issue is same in "native" mode, so it has nothing to do with ARR and URLRewrite.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions