Dhaval Shah created RANGER-5199:
-----------------------------------
Summary: 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
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-2.4.0.7.3.1.200-83.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)
