[
https://issues.apache.org/jira/browse/RANGER-5199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dhaval Shah updated RANGER-5199:
--------------------------------
Description:
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.
was:
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.
> 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: 10m
> 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)
