ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pradeep Agrawal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (RANGER-271) Script and process to migrate existing audit from RDBMS to Solr
Date Fri, 04 Mar 2016 04:14:40 GMT

    [ 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)

Mime
View raw message