Hi Justin, Your response is shared to me by Julian Reschke:
========= What leads you to believe that the data is encrypted? I suppose in theory it could be encrypted if you have a custom DataStore implementation or there is encryption done by the JDBC driver, but there's none in the standard DbDataStore itself. ========= The data is actually not encrypted, to be specific it is hashed. Our code interacts with Jack Rabbit API to insert the node key into VER_BUNDLE table, later the report file data is inserted into DS_JCR_DATASTORE. Let me share you a piece of code which would be useful for you to understand the scenario. =============== String path = uri2xpath(uri); session = openReadWriteSession(); createContentNode(uri, metadata, session); Node root = session.getRootNode(); Node newNode = root.getNode(path); // set the node type to file //and set the content of the file Node reportNode = newNode.addNode(FILE_NODE, NodeType.NT_FILE); Node fileNode = reportNode.addNode(Node.JCR_CONTENT, NodeType.NT_RESOURCE); ValueFactory valueFactory = session.getValueFactory(); Binary b = valueFactory.createBinary(fileIn); LOGGER.debug("CONTENT stored id JCR_DATA_STORE ="+b+ " , "+uri); fileNode.setProperty(Property.JCR_DATA, b); =============== è reportNode is what we are saving into VER_BUNDLE è fileNode is the actual file stored into DS_JCR_DATASTORE We are halted with our analysis as the API belongs to JCR and was not sure how to extract the data stored in VER_BUNDLE to DATASTORE. Could you please let us know on how the data is stored from VER_BUNDLE to DATASTORE. If you are still unclear on the case, I would like to invite you to a conference call so that I could loop my product expert as well. Thanks & Regards, Dilipkumar S From: Justin Edelson [mailto:jus...@justinedelson.com] Sent: Friday, July 14, 2017 9:17 PM To: d...@jackrabbit.apache.org; users@jackrabbit.apache.org Cc: Florence Tournikian-Lalanne <flala...@temenos.com>; Subhransu Samant <subhra...@temenos.com>; Umamaheswari Jayachandran <umamaheswa...@temenos.com>; Dilipkumar S <dilipkum...@temenos.com> Subject: Re: FW: Information on encryption methodology of Jack Rabbit Repository Hi, I responded to this email already. Did you see my response? On Fri, Jul 14, 2017 at 9:13 AM Dilipkumar S <dilipkum...@temenos.com<mailto:dilipkum...@temenos.com>> wrote: Hello Users & Dev, Could someone please assist with the below case. Thanks & Regards, Dilipkumar S From: Dilipkumar S Sent: Wednesday, July 12, 2017 11:01 AM To: 'users@jackrabbit.apache.org<mailto:users@jackrabbit.apache.org>' <users@jackrabbit.apache.org<mailto:users@jackrabbit.apache.org>>; 'd...@jackrabbit.apache.org<mailto:d...@jackrabbit.apache.org>' <d...@jackrabbit.apache.org<mailto:d...@jackrabbit.apache.org>> Cc: 'subhra...@temenos.com<mailto:subhra...@temenos.com>' <subhra...@temenos.com<mailto:subhra...@temenos.com>>; Florence Tournikian-Lalanne <flala...@temenos.com<mailto:flala...@temenos.com>>; 'umamaheswa...@temenos.com<mailto:umamaheswa...@temenos.com>' <umamaheswa...@temenos.com<mailto:umamaheswa...@temenos.com>> Subject: Information on encryption methodology of Jack Rabbit Repository Hello Jack Rabbit, Am posting this mail to you with comments posted by Julian Reschke<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_secure_ViewProfile.jspa-3Fname-3Dreschke&d=DwMFaQ&c=U-xfQUIl-0G8P2IcZBeK3A&r=fNhsuJAWxF0tPcVT9_ztXXjtr7KgHfe3fZmWonxucms&m=oJCz9AVI8M4Gh54XCD6xa1hGW3C3iKwdSpKO29W84ZY&s=QIlQ8XKgYAySdlig7zy88i-BGMPiULlqkLSq3A6PsaE&e=> under below JIRA, https://issues.apache.org/jira/browse/JCR-4161<https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_browse_JCR-2D4161&d=DwMFaQ&c=U-xfQUIl-0G8P2IcZBeK3A&r=fNhsuJAWxF0tPcVT9_ztXXjtr7KgHfe3fZmWonxucms&m=oJCz9AVI8M4Gh54XCD6xa1hGW3C3iKwdSpKO29W84ZY&s=uapdvkwwFpG6TtJhSeDnKRtWIAQ6MSnrEBRM9uGqTXQ&e=> We require your assistance with reference to Jack Rabbit repository. Here by am adding the detailed information of the case below: We have a Front end API using which the reports would be generated and the records will be stored in Jack Rabbit repository table DS_JCR_DATASTORE. Currently we are facing an issue under which the report generated with the Frontend API is not accessible using open/Save mode with below error appended in the logs: =========== 2017-07-03 15:10:31,462 | ERROR | defaultWIMFileBasedRealm/advisor | | | WebContainer : 1 | c.o.r.s.ContentRepositoryService | retrieveReport: Exception from the uderlying repository javax.jcr.PathNotFoundException: aaa/report/G7893420170703691287 ============= Based on the above error, we would like to perform analysis on whether the report generated exists or not with the repository table DS_JCR_DATASTORE, but we are restricted from performing the analysis due to below constraint: The records generated and stored with DS_JCR_DATASTORE are in encrypted format To do the analysis we need to map the relation between a session_id from the API against a record_id in repository table, therefore I request you to let us know the steps to decrypt the encrypted data in the table. I've attached the logs & sample data from DS_JCR_DATASTORE for your reference. Please let me know if you require any additional information. Thanks & Regards, Dilipkumar S The information in this e-mail and any attachments is confidential and may be legally privileged. It is intended solely for the addressee or addressees. Any use or disclosure of the contents of this e-mail/attachments by a not intended recipient is unauthorized and may be unlawful. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of TEMENOS. We recommend that you check this e-mail and any attachments against viruses. TEMENOS accepts no liability for any damage caused by any malicious code or virus transmitted by this e-mail. The information in this e-mail and any attachments is confidential and may be legally privileged. It is intended solely for the addressee or addressees. Any use or disclosure of the contents of this e-mail/attachments by a not intended recipient is unauthorized and may be unlawful. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of TEMENOS. We recommend that you check this e-mail and any attachments against viruses. TEMENOS accepts no liability for any damage caused by any malicious code or virus transmitted by this e-mail.