Are credentials confirmed working with the JDBC interpreter? I’m trying to get jdbc working with snowflake. If I hardcore my username and password into the default url everything works great… but this of course won’t work in a multi user environment.
However, if I try to use default username, default password, or zeppelin credentials I get stuck at " java.sql.SQLException: Missing user name.” Sounds like a different issue than the OP. http://www.placeiq.com/ http://www.placeiq.com/ http://www.placeiq.com/ Paul Brenner https://twitter.com/placeiq https://twitter.com/placeiq https://twitter.com/placeiq https://www.facebook.com/PlaceIQ https://www.facebook.com/PlaceIQ https://www.linkedin.com/company/placeiq https://www.linkedin.com/company/placeiq DATA SCIENTIST (217) 390-3033 http://www.placeiq.com/2015/05/26/placeiq-named-winner-of-prestigious-2015-oracle-data-cloud-activate-award/ http://placeiq.com/2015/12/18/accuracy-vs-precision-in-location-data-mma-webinar/ http://placeiq.com/2015/12/18/accuracy-vs-precision-in-location-data-mma-webinar/ http://placeiq.com/2015/12/18/accuracy-vs-precision-in-location-data-mma-webinar/ http://placeiq.com/2015/12/18/accuracy-vs-precision-in-location-data-mma-webinar/ http://placeiq.com/2016/03/08/measuring-addressable-tv-campaigns-is-now-possible/ http://placeiq.com/2016/04/13/placeiq-joins-the-network-advertising-initiative-nai-as-100th-member/ http://placeiq.com/2016/04/13/placeiq-joins-the-network-advertising-initiative-nai-as-100th-member/ http://placeiq.com/2016/04/13/placeiq-joins-the-network-advertising-initiative-nai-as-100th-member/ http://placeiq.com/2016/04/13/placeiq-joins-the-network-advertising-initiative-nai-as-100th-member/ http://placeiq.com/2016/04/13/placeiq-joins-the-network-advertising-initiative-nai-as-100th-member/ http://pages.placeiq.com/Location-Data-Accuracy-Whitepaper-Download.html?utm_source=Signature&utm_medium=Email&utm_campaign=AccuracyWP http://placeiq.com/2016/08/03/placeiq-bolsters-location-intelligence-platform-with-mastercard-insights/ http://placeiq.com/2016/10/26/the-making-of-a-location-data-industry-milestone/ http://placeiq.com/2016/12/07/placeiq-introduces-landmark-a-groundbreaking-offering-that-delivers-access-to-the-highest-quality-location-data-for-insights-that-fuel-limitless-business-decisions/ On Thu, Apr 20, 2017 at 8:49 PM moon soo Lee < mailto:moon soo Lee <m...@apache.org> > wrote: a, pre, code, a:link, body { word-wrap: break-word !important; } Hi, If you remove 'default.user' 'default.password' properties from jdbc interpreter setting, then Zeppelin will use database username and password from credential database for each user. I also created a patch [1] to use credential database when 'default'.user' and 'default.password' is empty string. Hope this helps. Best, moon [1] https://github.com/apache/zeppelin/pull/2269 On Mon, Apr 10, 2017 at 3:37 AM Arpad Beregszaszi < mailto:arpad.beregsza...@gmx.de > wrote: Hi all, I’m pretty new with Zeppeln and I need help with one problem regarding data source authorization as its described here: https://zeppelin.apache.org/docs/0.7.0/security/datasource_authorization.html I can successfully connect Zeppelin to my MySQL Server. Now I want to give different users access to their databases. For that I want the JDBC interpreter to use different database credentials, depending on the Zeppelin user as defined in shiro.ini. But when I create credential information, the JDBC interpreter doesn’t use them for the db connection, but the default username and password, which is empty. My Interpreter Is instantiated per user. Java.sql.SQLException: Access denied for user ‘ ‘ @ ‘IP‘ (using password: NO) Anyone an idea of whats wrong? Thanks, Arpad
