In HTTPS Change of data source not working on Table and Dashboards

[srikanth-reddy-m]

A clear and concise description of what the bug is.

CodeBase: Master Branch

When trying to change superset data source from HTTPS it is trying to open Url in HTTP in which it is creating the error.

Error: Unsafe attempt to load URL, Domains, protocols, and ports must match

Expected results

It should load URL's with only HTTps
what you expected to happen.

Actual results

what actually happens.

Screenshots

![supersetImage](

)

If applicable, add screenshots to help explain your problem.

How to reproduce the bug

1. Go to Superset sources and select Tables.
2. Click on any source this will open that source
3. Now click on Data Source drop-down and select change data source and select any data source.
4. This will show error

Environment

(please complete the following information):

• superset version: superset version
• python version: python --version
• node.js version: node -v
• npm version: npm -v

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[issue-label-bot]

Issue-Label Bot is automatically applying the label #bug to this issue, with a confidence of 0.94. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[srikanth-reddy-m]

This issue is solved, I have missed roxy_set_header X-Forwarded-Proto 'https' header setting in nginx.
If we are using nginx as a reverse proxy with https we have to add this header to flask-app builder to know schema information.

[syazshafei]

@srikanth-reddy-m Do you have problem when selecting the datasource?

[maltoze]

@syazwan0913 This worked for me.

# superset/config.py
ENABLE_PROXY_FIX = True
PROXY_FIX_CONFIG = {"x_for": 1, "x_proto": 1, "x_host": 1, "x_port": 1, "x_prefix": 1

[syazshafei]

@maltoze what is the version of superset you are using?

[maltoze]

@syazwan0913 I'm using 0.29.

I also change this in my code.

# superset/__init__.py
if app.config.get("ENABLE_PROXY_FIX"):
    from werkzeug.middleware.proxy_fix import ProxyFix

    app.wsgi_app = ProxyFix(app.wsgi_app, **app.config.get("PROXY_FIX_CONFIG"))

related #8117

[syazshafei]

@maltoze alright I got it. Thanks

[CaptainHoangLe]

I am using superset ver 0.36 and having the same problem when i create an api get user info below

i have used all solutions of you but it don't work :(. Someone help me , thanks all

[syazshafei]

@CaptainHoangLe are you using Nginx? can share your configuration?

[CaptainHoangLe]

@CaptainHoangLe are you using Nginx? can share your configuration?

Dear bro ,this is my config nginx

[syazshafei]

You need to add this line inside your Nginx config
proxy_set_header X-Forwarded-Proto https;

Also in superset_config.py you must enable this:

ENABLE_PROXY_FIX = True
PROXY_FIX_CONFIG = {"x_for": 1, "x_proto": 1, "x_host": 1, "x_port": 1, "x_prefix": 1

[CaptainHoangLe]

You need to add this line inside your Nginx config
proxy_set_header X-Forwarded-Proto https;

Also in superset_config.py you must enable this:

ENABLE_PROXY_FIX = True
PROXY_FIX_CONFIG = {"x_for": 1, "x_proto": 1, "x_host": 1, "x_port": 1, "x_prefix": 1

i have just done that but it can't help me to sloving this problem .i don't know where the error came from

[CaptainHoangLe]

it send request to https but response location is http