02-11-2022 05:34 PM
I am adding a credential to access MongoDB through the Python MongoDB Spark connector. It is stored as a secret and the `users` group has `MANAGE` ACL privileges. I turned on table ACLs and created a `High Concurrency` compute cluster. I then run a script that attempts to read from MongoDB, but fails due to authentication issues. If I put in the password manually, it succeeds. If I use the same script on a non-High Concurrency (aka no table ACL) cluster, it succeeds. Only when I use table ACLs does it fail. Anyone know if I'm missing a setting?
02-14-2022 12:12 PM
| Check if privileges are set properly.
I added `MANAGE` permissions for `users` to the secret scope and also gave `users` restart access to the compute cluster. Are there other permissions I should be setting?
| Also, maybe check that passwords are exactly same - the one in your script and the one you're pasting manually.
Thanks for getting back. I checked that they are the same by copy-pasting and pasting the same one during `secrets put` and in the notebook (I made sure to remove the extra line from the file). It is working correctly when I don't use the high-concurrency cluster as noted before, so that suggests the secrets is correct.
02-13-2022 02:26 PM
Interesting. Check if privileges are set properly.
Also, maybe check that passwords are exactly same - the one in your script and the one you're pasting manually.
02-14-2022 12:12 PM
| Check if privileges are set properly.
I added `MANAGE` permissions for `users` to the secret scope and also gave `users` restart access to the compute cluster. Are there other permissions I should be setting?
| Also, maybe check that passwords are exactly same - the one in your script and the one you're pasting manually.
Thanks for getting back. I checked that they are the same by copy-pasting and pasting the same one during `secrets put` and in the notebook (I made sure to remove the extra line from the file). It is working correctly when I don't use the high-concurrency cluster as noted before, so that suggests the secrets is correct.
03-15-2022 10:26 PM
@Erik Louie looks the issue is resolved. Please let me know if you need further help on this. Thanks!
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group