Hi Sebastian
As per the 2.1 codebase
<https://github.com/apache/ambari/blob/branch-2.1/ambari-server/src/main/resources/common-services/RANGER/0.4.0/package/scripts/setup_ranger_xml.py#L194-L201>
the dba_script.py script should not be called if "Setup DB and DB user" is
unchecked. Can you verify if the changes were saved before calling the
setup.
You can also look for the INFO message Setting up Ranger DB and DB User" in
the logs. This log should ideally be not called, since you had set the flag
to OFF. Thanks.
On Mon, Feb 15, 2016 at 7:56 PM, <[email protected]> wrote:
> Hi,
>
> we ran into some trouble trying to install Ranger using Ambari (2.1.0)
> with a pre-setup Oracle database (we used the SQL files from
>
> https://github.com/apache/incubator-ranger/tree/ranger-0.5/security-admin/db/oracle
> for manual setup).
> By enterprise policy, we are unable to let the Ambari-setup do the
> table/user creation stuff.
>
> When starting the installation process, we cleared the "Setup DB and
> DB user" check box under “Advanced ranger-env”.
>
> First problem:
> In the setup procedure, Ambari runs some function called
> "verify_tablespace" (dba_script.py) where it checks whether the User
> tablespace equals the entered database name.
>
> Question: Why is this match necessary? After talking to our db-admins
> I was assured it is not uncommon that these two might differ - as it
> is in our case -> so the installation fails.
> We had to refactor the code to always return true (and so "skip" the
> validation) to proceed with the setup.
>
> Second problem:
> After successfully working around the verify_tablespace problem, we
> ran into another problem: it looks like Ambari tries to run some
> database-patches, even though we cleared the "Setup DB and User" check
> box! Of course, the patching fails (and so the installation fails),
> because the ranger db-user has no privileges to run ALTER TABLE etc.!
>
> Question: Why does Ambari run db patches, even with unchecked "Setup
> db/user" properties?
>
> Any help/hints appreciated.
>
> -Sebastian
>
--
Regards,
Gautam.
