Hi, Which version of Zeppelin are you using? Have you tried remove 'default.user' and 'default.password' property from interpreter menu and create entity in credential menu?
Thanks, moon On Fri, Apr 21, 2017 at 11:55 AM Paul Brenner <pbren...@placeiq.com> wrote: > 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 <(217)%20390-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/>[image: > PlaceIQ:Location Data Accuracy] > <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 <moon soo Lee > <moon+soo+lee+%3cm...@apache.org%3E>> wrote: > >> 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 < >> 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 >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >
