search

sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.64k stars 733 forks source link

CSV Exports failing when running PGWeb behind SSO #587

Closed tomellis91 closed 1 year ago

tomellis91 commented 1 year ago

Hi There,

We have placed PGWeb behind an SSO Authentication system.

When navigating to PGWeb via SSO it appends a token to the end of the URL string

eg. pgweb.example.com/?code=xyz

When hitting the export CSV button a new window opens with an invalid url which means the download is unable to proceed Example output url : pgweb.example.com/?code=xyzapi/query?format=csv...

I believe the issues is coming from this line here.

Is it possible to get the URL to take into account additional Query params when redirecting to the download screen?

sosedoff commented 1 year ago

Hi @tomellis91, yes def possible. What kind of SSO are you running in front of pgweb?

tomellis91 commented 1 year ago

Amazing, thanks @sosedoff .

We are using oauth2 with an authorization code grant.

Cheers, Tom

sosedoff commented 1 year ago

Cool, i will have a look. Mind sharing details on how you run pgweb and oauth? This is one of core features missing from pgweb and i would like to incorporate it somehow.On Nov 28, 2022, at 6:07 PM, Tom Ellis @.***> wrote: Amazing, thanks @sosedoff . We are using oauth2 with an authorization code grant. Cheers, Tom

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: @.***>