[
https://issues.apache.org/jira/browse/RANGER-5199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18004819#comment-18004819
]
Abhishek Kumar commented on RANGER-5199:
----------------------------------------
[~dhavalshah9131] Could you please resolve the jira, thanks.
> Connection to Ranger KMS DB fails with secure MySQL/maria DB
> ------------------------------------------------------------
>
> Key: RANGER-5199
> URL: https://issues.apache.org/jira/browse/RANGER-5199
> Project: Ranger
> Issue Type: Improvement
> Components: kms, Ranger
> Reporter: Dhaval Shah
> Assignee: Dhaval Shah
> Priority: Major
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Facing below error while connecting to secure mysql/maria DB.
> {code:java}
> ERROR org.apache.hadoop.crypto.key.RangerKeyStoreProvider: [main]: ==>
> RangerKeyStoreProvider.reloadKeys() error :
> java.lang.RuntimeException: Error while generating Ranger Master key, Error -
> Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.7.12.v20230209-e5c4074ef3):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.cj.jdbc.exceptions.CommunicationsException:
> Communications link failure
> The last packet sent successfully to the server was 0 milliseconds ago. The
> driver has not received any packets from the server.
> Error Code: 0
> at
> org.apache.hadoop.crypto.key.RangerKeyStoreProvider.generateAndGetMasterKey(RangerKeyStoreProvider.java:296)
> ~[ranger-kms.jar:?]
> at
> org.apache.hadoop.crypto.key.RangerKeyStoreProvider.<init>(RangerKeyStoreProvider.java:263)
> ~[ranger-kms.jar:?]
> at
> org.apache.hadoop.crypto.key.RangerKeyStoreProvider$Factory.createProvider(RangerKeyStoreProvider.java:742)
> ~[ranger-kms.jar:?]
> at
> org.apache.hadoop.crypto.key.kms.server.KMSWebApp.createKeyProvider(KMSWebApp.java:111)
> ~[ranger-kms.jar:?]
> at
> org.apache.hadoop.crypto.key.kms.server.KMSWebApp.contextInitialized(KMSWebApp.java:175)
> ~[ranger-kms.jar:?] {code}
> We need ranger-kms backend side fix to append {{?useSSL=false}} when using
> mysql/mariadb databases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
