@Adi Jabkowsky This did the trick! Thank you. Now it works. ... View more

After running ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar Everything works - restart & service check ! Thank you so much ! ... View more

1. I'm have upgraded to HDP-2.5.3.0 with Ranger 0.6.0.2.5 1-2 months ago. I have the same issue with users=external and groups=internal, and unfortunately I don't have access to the jira.com link. Should I do anything for this to start working normally ? 2. Users "First Name", "Last Name" and "Email" + Groups "Description" is not synced correctly - where do I change this ? 3. Filters on User + Group sync doesn't seem to have effect eventhough I have configured: - User Config -> User Search Filter: "membersOf=CN=<GROUP>,OU=<OU1>,OU=<OU2>,DC=<DC1>,DC=<DC2>" - Group Configs -> Group Search Filter: "CN=<PART_OF_GROUP*>" Perhaps these are all related... otherwise just disregard question 2+3 🙂 Thanks in advance 🙂 ! ... View more

@suresh krish Also make sure that rangerlogger user has permissions to connect from the second hive server (in the Ranger's DB... the default is mysql). The best way to do it is to try to connect to mysql on the first hive server from the second server using: mysql -u rangerlogger -p -h <second hive server> If permissions is denied - then login to mysql using root and run the following: GRANT ALL PRIVILEGES ON *.* TO 'rangerlogger'@'<second hive server>' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION; FLUSH PRIVILEGES; Then check again. ... View more

Thank you ! It was the missing link ! ... View more

Thank you both so much for the response! The querying part using the processors you recommended is pretty straightforward - the problem is - what to use after the querying ? How do i transform the data into csv or other format which i can insert into hadoop ? There is no ConvertAvroToCSV processor and ConvertAvroToOrc is not available in the 1.0 Beta release. Where can i get the 1.0 GA release ?? ... View more

So if a processor fails with a yellow warning - i am not supposed to get an email ? it is considered as "retry" and not "failure"? ... View more

What error(s) are you seeing? If it mentions Avro, then if your column names are in Chinese, it's likely that Avro does not accept them. This may be alleviated in NiFi 1.1.0 with NIFI-2262, but it would just replace non-Avro-compatible characters with underscores, so you may face a "duplicate field" exception. In that case you would need column aliases in your SELECT statement to use Avro-compatible names for the columns. ... View more