Incubator-superset: Bypassing the login for Supreset using iframe

[goldymanikoth]

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

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

I am using Superset version 0.22.1. I create a slice and use its iframe to embed into my webpage. When I do so, it directs me to superset login on the webpage. Is there a way I can pass the username and credentials using iframe as a parameter if yes please let me know the iframe parameter name for that?

Superset version

0.22.1

Expected results

bypass authentication

Actual results

asking for authentication

[hughhhh]

I think you might need to leverage the Public role to allow others to see this slice/chart without logging in. Checkout this doc http://superset.apache.org/security.html#public for more information.

[goldymanikoth]

Thanks for your response , I could see from the documentation (http://superset.apache.org/security.html#public ) that
"_Public- It’s possible to allow logged out users to access some Superset features. By setting PUBLIC_ROLE_LIKE_GAMMA = True in your superset_config.py_"

So my next set of doubts --

1. Where is this superset_config.py location? Can I create this file and add this to export PYTHONPATH="/home/user/superset/:$PYTHONPATH" ... please help
2. Also struggling to find the superset installation location?

[mistercrunch]

pip/setuptools/python manages your pypi packages, no need to worry about that. superset_config.py can live anywhere, but you need to export PYTHONPATH=/wherever/your/superset_config/lives. As you fire up the superset command, you should see something like:
Loaded your LOCAL configuration at [/wherever/your/superset_config/lives/superset_config.pyc]

[goldymanikoth]

I got some reference to locate the superset install path and I figure out the location and updated the superset/config.py and edited the "PUBLIC_ROLE_LIKE_GAMMA = True" and add the data sources to the role manually to bypass the user login, it is working now , thanks for the support.

[mistercrunch]

You probably want to avoid changing superset/config.py (which means you're modifying the Superset package) and use superset_config.py which is intended to be the way to override the defaults in the configuration.

[goldymanikoth]

got it, I will do that. Thanks

[girishteja]

Hi @goldymanikoth and @mistercrunch , I have been into the same issue i modified "PUBLIC_ROLE_LIKE_GAMMA = True" in both superset/config.py and superset_config.py . Added the datasource to PUBLIC as per the link suggested.But still getting the AUTH login page while accessing the iframe .Can anyone explain me in more detail please.And also the following are my screenshots

config.py -

Add roles page -

[mistercrunch]

did you run superset init ? Public should then be like Gamma, to which you can start adding tables / databases

[girishteja]

Thank you so much @mistercrunch , superset init command did the magic we want!I could able to access the chart without authentication prompt now.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[raoofnaushad]

I am facing the same issue. But in my case Superset is installed via HDP. I am not able to find the superset location (config.py). And I am not sure where is it.? Help is very much appreciated.