[jira] [Updated] (RANGER-4765) GDS UI: Need a date filter to filter the records in history tab for dataset/datashare

2024-04-17 Thread Mugdha Varadkar (Jira)


 [ 
https://issues.apache.org/jira/browse/RANGER-4765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mugdha Varadkar updated RANGER-4765:

Attachment: 0001-RANGER-4765.patch

> GDS UI: Need a date filter to filter the records in history tab for 
> dataset/datashare
> -
>
> Key: RANGER-4765
> URL: https://issues.apache.org/jira/browse/RANGER-4765
> Project: Ranger
>  Issue Type: Task
>  Components: admin
>Reporter: Anand Nadar
>Assignee: Mugdha Varadkar
>Priority: Major
> Attachments: 0001-RANGER-4765.patch, 
> image-2024-04-02-18-39-01-410.png, image-2024-04-02-18-42-51-611.png
>
>
> Need date filter to filter the records the history tab in dataset and 
> datashare tabs.
> !image-2024-04-02-18-39-01-410.png|width=412,height=217!
> !image-2024-04-02-18-42-51-611.png|width=470,height=206!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


Review Request 74958: RANGER-4775 : Ranger Kms is failing with oracle23 Database

2024-04-17 Thread Dhaval Shah

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74958/
---

Review request for ranger, bhavik patel, Dineshkumar Yadav, Jayendra Parab, 
Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Pradeep 
Agrawal, Ramesh Mani, Sailaja Polavarapu, Vikas Kumar, and Velmurugan Periasamy.


Bugs: RANGER-4775
https://issues.apache.org/jira/browse/RANGER-4775


Repository: ranger


Description
---

Ranger KMS is failing with Oracle 23 database with below error.

```
2024-04-01 07:25:27,032 INFO  org.apache.hadoop.crypto.key.RangerMasterKey: 
Master Key doesn't exist in DB, Generating the Master Key
2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey: 
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Error while saving 
master key in Database!!!
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
at 
org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:673)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteCall(LOBValueWriter.java:79)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteSelectCalls(LOBValueWriter.java:190)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.flushSelectCalls(DatabaseAccessor.java:175)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:457)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:182)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:197)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 

```


Diffs
-

  kms/src/main/java/org/apache/ranger/entity/XXRangerKeyStore.java 6b541eca5 
  kms/src/main/java/org/apache/ranger/entity/XXRangerMasterKey.java 64fdd56e4 


Diff: https://reviews.apache.org/r/74958/diff/1/


Testing
---

Successful build with test cases.
Successfully validated with all the supported DB Flavor


Thanks,

Dhaval Shah



[jira] [Updated] (RANGER-4775) Ranger Kms is failing with oracle23 Database

2024-04-17 Thread Dhaval Shah (Jira)


 [ 
https://issues.apache.org/jira/browse/RANGER-4775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dhaval Shah updated RANGER-4775:

Description: 
Ranger KMS is failing with Oracle 23 database with below error.
{code:java}
2024-04-01 07:25:27,032 INFO  org.apache.hadoop.crypto.key.RangerMasterKey:  
Master Key doesn't exist in DB, Generating the Master Key
2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey: 
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Error while saving 
master key in Database!!!
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
at 
org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:673)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteCall(LOBValueWriter.java:79)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.buildAndExecuteSelectCalls(LOBValueWriter.java:190)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.flushSelectCalls(DatabaseAccessor.java:175)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:457)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:182)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:197)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:515)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:85)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:95)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:327)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:60)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:913) 
~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:812)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:110)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3] 
{code}

  was:
Ranger KMS is failing with Oracle 23 database with below error.


{code:java}
2024-04-01 07:25:27,032 INFO  org.apache.hadoop.crypto.key.RangerMasterKey: 
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Master Key doesn't 
exist in DB, Generating the Master Key
2024-04-01 07:25:27,169 ERROR org.apache.hadoop.crypto.key.RangerMasterKey: 
[ccycloud-1.hchavanor231.root.comops.site-startStop-1]: Error while saving 
master key in Database!!!
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
at 
org.eclipse.persistence.platform.database.oracle.Oracle8Platform.writeLOB(Oracle8Platform.java:194)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.helper.LOBValueWriter.fetchLocatorAndWriteValue(LOBValueWriter.java:94)
 ~[eclipselink-2.7.12.jar:2.7.12.v20230209-e5c4074ef3]
at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processResultSet(DatabaseAccessor.java:758)
 

[PR] RANGER-4776: SolrAuditDestination uses local SSLContext instead of se… [ranger]

2024-04-17 Thread via GitHub


turcsanyip opened a new pull request, #310:
URL: https://github.com/apache/ranger/pull/310

   …tting the system-wide default
   
   ## What changes were proposed in this pull request?
   
   In order to avoid setting the system-wide `SSLContext` in 
`SolrAuditDestination` (which may affect other components running in the same 
JVM negatively), use Solr's `HttpClientUtil.setSocketFactoryRegistryProvider()` 
to pass the `SSLContext` to the Solr client locally.
   
   ## How was this patch tested?
   
   We use the Ranger Plugin in Apache NiFi.
   Before the change, Azure components in NiFi failed with "unable to find 
valid certification path to requested target" error.
   After the change, the Ranger - Solr connection still works and the Azure 
components can also access the needed certificate in the system default 
truststore (cacerts).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@ranger.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org