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