[ https://issues.apache.org/jira/browse/RANGER-5199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17950865#comment-17950865 ]
Dhaval Shah edited comment on RANGER-5199 at 5/13/25 2:28 PM: -------------------------------------------------------------- Successfully merged into apache master : [https://github.com/apache/ranger/commit/a82ec7b49d8f5b590fbd8a84e55a213b8cba6047] [https://github.com/apache/ranger/commit/42f7c064e467328074da794143241feac1004f96] was (Author: dhavalshah9131): Successfully merged into apache master : https://github.com/apache/ranger/commit/a82ec7b49d8f5b590fbd8a84e55a213b8cba6047 > 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)