[jira] [Commented] (RANGER-271) Script and process to migrate existing audit from RDBMS to Solr

["Pradeep Agrawal (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/RANGER-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179284#comment-15179284 ] 

Pradeep Agrawal commented on RANGER-271:
----------------------------------------

*Proposed Solution:*
Make sure below given property are having required values in conf/ranger-admin-site.xml , if you have upgraded Ranger with DB to Solr support then there is possibility that you might not be having required values in some of the below given properties. you can refer previous (before upgrade) conf/ranger-admin-site.xml and manually copy-paste the value of required properties which are not populated after upgrade.

||Property Name||Sample Value||Description
|ranger.audit.solr.urls|http://127.0.0.1:6083/solr/ranger_audits|Solr url, should be there if you have setup Ranger with audit source as solr|
|ranger.audit.source.type|solr|Required to connect and write logs to solr|
|ranger.jpa.audit.jdbc.url|jdbc:log4jdbc:mysql://127.0.0.1/ranger_audit|make sure audit db URL is according to your DB flavour.|
|ranger.jpa.audit.jdbc.user|rangerlogger|audit db user|
|ranger.jpa.audit.jdbc.password|rangerlogger|audit db password|
|ranger.jpa.audit.jdbc.dialect|org.eclipse.persistence.platform.database.MySQLPlatform|JDBC dialect class name according to your DB flavour|
|ranger.jpa.audit.jdbc.driver|com.mysql.jdbc.Driver|make sure driver class is according to your DB flavour.|

*Command :*
cd <ranger-install-dir>
{code:java}
java -Dlogdir=ews/logs -Dlog4j.configuration=db_patch.log4j.xml -cp ews/webapp/WEB-INF/classes/conf:ews/webapp/WEB-INF/classes/lib/*:ews/webapp/WEB-INF/:ews/webapp/META-INF/:ews/webapp/WEB-INF/lib/*:ews/webapp/WEB-INF/classes/:ews/webapp/WEB-INF/classes/META-INF:/usr/share/java/mysql-connector-java.jar org.apache.ranger.patch.cliutil.DbToSolrMigrationUtil
{code}

> Script and process to migrate existing audit from RDBMS to Solr
> ---------------------------------------------------------------
>
>                 Key: RANGER-271
>                 URL: https://issues.apache.org/jira/browse/RANGER-271
>             Project: Ranger
>          Issue Type: Sub-task
>            Reporter: Don Bosco Durai
>            Assignee: Pradeep Agrawal
>
> We would need to the instruction and scripts to move the audit logs from database to Solr



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)