ranger Decrypt the password coming from x_service_config

When the connection is established for presto service, the password is stored in x_service_config_map MySQL table. Autocomplete will still not work if the password is not decrypted. Added the step to decrypt the password.

Aug 01 '19 20:08 JituS

@JituS what autocomplete does it fix? I tried this patch but autocomplete of catalog/schema/table names still did not work when adding new policies @bolkedebruin any idea?

Mar 31 '20 19:03 tooptoop4

Autocomplete just works here without this patch so I suspect misconfiguration

Mar 31 '20 20:03 bolkedebruin

@bolkedebruin Have you tried it with presto? I faced the issue related to auto complete while configuring the policies for presto tables. Adding that changes actually fixed the issue. I don't have a stack trace now as it was a long way back. But you can refer HiveClient.java:716 class where we are decrypting the password before creating the connection.

Apr 13 '20 21:04 JituS

@JituS I wrote the support for Presto in Ranger so yes I did. But maybe I am missing the special case here?

Apr 13 '20 21:04 bolkedebruin

Decrypt the password coming from x_service_config_map