You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ranger.apache.org by Hafiz Mujadid <ha...@gmail.com> on 2015/11/28 14:04:25 UTC

ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with
following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User
Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
Administrator.


Any suggestion?

thanks

Re: ranger-admin setup failed

Posted by Hafiz Mujadid <ha...@gmail.com>.
Yes, the issue is resolved now,

thanks Velmurugan Periasamy

On Sat, Nov 28, 2015 at 9:38 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:

> Yes. Patch is committed in master branch.
>
> From: Hafiz Mujadid <ha...@gmail.com>
> Reply-To: "user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> Date: Saturday, November 28, 2015 at 11:37 AM
>
> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
> Subject: Re: ranger-admin setup failed
>
> do i need to pull latest code?
>
>
>
> On Sat, Nov 28, 2015 at 9:35 PM, Velmurugan Periasamy <
> vperiasamy@hortonworks.com> wrote:
>
>> Patch is committed. Could you please try again?
>>
>> From: Hafiz Mujadid <ha...@gmail.com>
>> Reply-To: "user@ranger.incubator.apache.org" <
>> user@ranger.incubator.apache.org>
>> Date: Saturday, November 28, 2015 at 9:17 AM
>>
>> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
>> Subject: Re: ranger-admin setup failed
>>
>> thanks, I am waiting for the solution
>>
>> On Sat, Nov 28, 2015 at 7:16 PM, Velmurugan Periasamy <
>> vperiasamy@hortonworks.com> wrote:
>>
>>> Thanks for reporting the issue Hafiz. This issue needs to be fixed. I
>>> have created https://issues.apache.org/jira/browse/RANGER-751
>>>
>>> From: Hafiz Mujadid <ha...@gmail.com>
>>> Reply-To: "user@ranger.incubator.apache.org" <
>>> user@ranger.incubator.apache.org>
>>> Date: Saturday, November 28, 2015 at 8:47 AM
>>>
>>> To: "user@ranger.incubator.apache.org" <user@ranger.incubator.apache.org
>>> >
>>> Subject: Re: ranger-admin setup failed
>>>
>>> Added these lines and got following error
>>>
>>> Traceback (most recent call last):
>>>   File "update_property.py", line 40, in <module>
>>>
>>> write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
>>>   File "update_property.py", line 21, in write_properties_to_xml
>>>     if(os.path.isfile(xml_path)):
>>>   File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
>>>     st = os.stat(path)
>>> TypeError: coercing to Unicode: need string or buffer, NoneType found
>>> 2015-11-28 18:46:39,743  [E] Update property failed for:
>>>
>>>
>>> On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <
>>> vperiasamy@hortonworks.com> wrote:
>>>
>>>> In that case, these properties should have been already there. Not sure
>>>> if you are using an old version of install.properties. Can you add the
>>>> below lines in install.properties and try again?
>>>>
>>>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>>>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>>>
>>>> From: Hafiz Mujadid <ha...@gmail.com>
>>>> Reply-To: "user@ranger.incubator.apache.org" <
>>>> user@ranger.incubator.apache.org>
>>>> Date: Saturday, November 28, 2015 at 8:34 AM
>>>> To: "user@ranger.incubator.apache.org" <
>>>> user@ranger.incubator.apache.org>
>>>> Subject: Re: ranger-admin setup failed
>>>>
>>>> i am using apache ranger main branch code
>>>>
>>>> On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <
>>>> vperiasamy@hortonworks.com> wrote:
>>>>
>>>>> What version of ranger you are setting up?
>>>>>
>>>>> Can you add the below lines in install.properties and try again?
>>>>>
>>>>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>>>>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>>>>
>>>>> From: Hafiz Mujadid <ha...@gmail.com>
>>>>> Reply-To: "user@ranger.incubator.apache.org" <
>>>>> user@ranger.incubator.apache.org>
>>>>> Date: Saturday, November 28, 2015 at 8:04 AM
>>>>> To: "user@ranger.incubator.apache.org" <
>>>>> user@ranger.incubator.apache.org>
>>>>> Subject: ranger-admin setup failed
>>>>>
>>>>> Hi!
>>>>>
>>>>> I am running ./setup.sh script for ranger-admin but it is failing with
>>>>> following exception
>>>>>
>>>>> 2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
>>>>> 'ranger_audit'
>>>>> 2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and
>>>>> User Creation Process Completed..  ----------
>>>>> 2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
>>>>> Traceback (most recent call last):
>>>>>   File "db_setup.py", line 1725, in <module>
>>>>>     main(sys.argv)
>>>>>   File "db_setup.py", line 1587, in main
>>>>>     sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
>>>>> KeyError: 'sqlanywhere_core_file'
>>>>> 2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
>>>>> Administrator.
>>>>>
>>>>>
>>>>> Any suggestion?
>>>>>
>>>>> thanks
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards: HAFIZ MUJADID
>>>>
>>>
>>>
>>>
>>> --
>>> Regards: HAFIZ MUJADID
>>>
>>
>>
>>
>> --
>> Regards: HAFIZ MUJADID
>>
>
>
>
> --
> Regards: HAFIZ MUJADID
>



-- 
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
Yes. Patch is committed in master branch.

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 11:37 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

do i need to pull latest code?



On Sat, Nov 28, 2015 at 9:35 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
Patch is committed. Could you please try again?

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 9:17 AM

To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

thanks, I am waiting for the solution

On Sat, Nov 28, 2015 at 7:16 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
Thanks for reporting the issue Hafiz. This issue needs to be fixed. I have created https://issues.apache.org/jira/browse/RANGER-751

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:47 AM

To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

Added these lines and got following error

Traceback (most recent call last):
  File "update_property.py", line 40, in <module>
    write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
  File "update_property.py", line 21, in write_properties_to_xml
    if(os.path.isfile(xml_path)):
  File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
    st = os.stat(path)
TypeError: coercing to Unicode: need string or buffer, NoneType found
2015-11-28 18:46:39,743  [E] Update property failed for:


On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
In that case, these properties should have been already there. Not sure if you are using an old version of install.properties. Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:34 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

i am using apache ranger main branch code

On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
What version of ranger you are setting up?

Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:04 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on 'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact Administrator.


Any suggestion?

thanks



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Hafiz Mujadid <ha...@gmail.com>.
do i need to pull latest code?



On Sat, Nov 28, 2015 at 9:35 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:

> Patch is committed. Could you please try again?
>
> From: Hafiz Mujadid <ha...@gmail.com>
> Reply-To: "user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> Date: Saturday, November 28, 2015 at 9:17 AM
>
> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
> Subject: Re: ranger-admin setup failed
>
> thanks, I am waiting for the solution
>
> On Sat, Nov 28, 2015 at 7:16 PM, Velmurugan Periasamy <
> vperiasamy@hortonworks.com> wrote:
>
>> Thanks for reporting the issue Hafiz. This issue needs to be fixed. I
>> have created https://issues.apache.org/jira/browse/RANGER-751
>>
>> From: Hafiz Mujadid <ha...@gmail.com>
>> Reply-To: "user@ranger.incubator.apache.org" <
>> user@ranger.incubator.apache.org>
>> Date: Saturday, November 28, 2015 at 8:47 AM
>>
>> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
>> Subject: Re: ranger-admin setup failed
>>
>> Added these lines and got following error
>>
>> Traceback (most recent call last):
>>   File "update_property.py", line 40, in <module>
>>
>> write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
>>   File "update_property.py", line 21, in write_properties_to_xml
>>     if(os.path.isfile(xml_path)):
>>   File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
>>     st = os.stat(path)
>> TypeError: coercing to Unicode: need string or buffer, NoneType found
>> 2015-11-28 18:46:39,743  [E] Update property failed for:
>>
>>
>> On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <
>> vperiasamy@hortonworks.com> wrote:
>>
>>> In that case, these properties should have been already there. Not sure
>>> if you are using an old version of install.properties. Can you add the
>>> below lines in install.properties and try again?
>>>
>>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>>
>>> From: Hafiz Mujadid <ha...@gmail.com>
>>> Reply-To: "user@ranger.incubator.apache.org" <
>>> user@ranger.incubator.apache.org>
>>> Date: Saturday, November 28, 2015 at 8:34 AM
>>> To: "user@ranger.incubator.apache.org" <user@ranger.incubator.apache.org
>>> >
>>> Subject: Re: ranger-admin setup failed
>>>
>>> i am using apache ranger main branch code
>>>
>>> On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <
>>> vperiasamy@hortonworks.com> wrote:
>>>
>>>> What version of ranger you are setting up?
>>>>
>>>> Can you add the below lines in install.properties and try again?
>>>>
>>>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>>>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>>>
>>>> From: Hafiz Mujadid <ha...@gmail.com>
>>>> Reply-To: "user@ranger.incubator.apache.org" <
>>>> user@ranger.incubator.apache.org>
>>>> Date: Saturday, November 28, 2015 at 8:04 AM
>>>> To: "user@ranger.incubator.apache.org" <
>>>> user@ranger.incubator.apache.org>
>>>> Subject: ranger-admin setup failed
>>>>
>>>> Hi!
>>>>
>>>> I am running ./setup.sh script for ranger-admin but it is failing with
>>>> following exception
>>>>
>>>> 2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
>>>> 'ranger_audit'
>>>> 2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and
>>>> User Creation Process Completed..  ----------
>>>> 2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
>>>> Traceback (most recent call last):
>>>>   File "db_setup.py", line 1725, in <module>
>>>>     main(sys.argv)
>>>>   File "db_setup.py", line 1587, in main
>>>>     sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
>>>> KeyError: 'sqlanywhere_core_file'
>>>> 2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
>>>> Administrator.
>>>>
>>>>
>>>> Any suggestion?
>>>>
>>>> thanks
>>>>
>>>
>>>
>>>
>>> --
>>> Regards: HAFIZ MUJADID
>>>
>>
>>
>>
>> --
>> Regards: HAFIZ MUJADID
>>
>
>
>
> --
> Regards: HAFIZ MUJADID
>



-- 
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
Patch is committed. Could you please try again?

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 9:17 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

thanks, I am waiting for the solution

On Sat, Nov 28, 2015 at 7:16 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
Thanks for reporting the issue Hafiz. This issue needs to be fixed. I have created https://issues.apache.org/jira/browse/RANGER-751

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:47 AM

To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

Added these lines and got following error

Traceback (most recent call last):
  File "update_property.py", line 40, in <module>
    write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
  File "update_property.py", line 21, in write_properties_to_xml
    if(os.path.isfile(xml_path)):
  File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
    st = os.stat(path)
TypeError: coercing to Unicode: need string or buffer, NoneType found
2015-11-28 18:46:39,743  [E] Update property failed for:


On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
In that case, these properties should have been already there. Not sure if you are using an old version of install.properties. Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:34 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

i am using apache ranger main branch code

On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
What version of ranger you are setting up?

Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:04 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on 'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact Administrator.


Any suggestion?

thanks



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Hafiz Mujadid <ha...@gmail.com>.
thanks, I am waiting for the solution

On Sat, Nov 28, 2015 at 7:16 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:

> Thanks for reporting the issue Hafiz. This issue needs to be fixed. I have
> created https://issues.apache.org/jira/browse/RANGER-751
>
> From: Hafiz Mujadid <ha...@gmail.com>
> Reply-To: "user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> Date: Saturday, November 28, 2015 at 8:47 AM
>
> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
> Subject: Re: ranger-admin setup failed
>
> Added these lines and got following error
>
> Traceback (most recent call last):
>   File "update_property.py", line 40, in <module>
>
> write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
>   File "update_property.py", line 21, in write_properties_to_xml
>     if(os.path.isfile(xml_path)):
>   File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
>     st = os.stat(path)
> TypeError: coercing to Unicode: need string or buffer, NoneType found
> 2015-11-28 18:46:39,743  [E] Update property failed for:
>
>
> On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <
> vperiasamy@hortonworks.com> wrote:
>
>> In that case, these properties should have been already there. Not sure
>> if you are using an old version of install.properties. Can you add the
>> below lines in install.properties and try again?
>>
>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>
>> From: Hafiz Mujadid <ha...@gmail.com>
>> Reply-To: "user@ranger.incubator.apache.org" <
>> user@ranger.incubator.apache.org>
>> Date: Saturday, November 28, 2015 at 8:34 AM
>> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
>> Subject: Re: ranger-admin setup failed
>>
>> i am using apache ranger main branch code
>>
>> On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <
>> vperiasamy@hortonworks.com> wrote:
>>
>>> What version of ranger you are setting up?
>>>
>>> Can you add the below lines in install.properties and try again?
>>>
>>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>>
>>> From: Hafiz Mujadid <ha...@gmail.com>
>>> Reply-To: "user@ranger.incubator.apache.org" <
>>> user@ranger.incubator.apache.org>
>>> Date: Saturday, November 28, 2015 at 8:04 AM
>>> To: "user@ranger.incubator.apache.org" <user@ranger.incubator.apache.org
>>> >
>>> Subject: ranger-admin setup failed
>>>
>>> Hi!
>>>
>>> I am running ./setup.sh script for ranger-admin but it is failing with
>>> following exception
>>>
>>> 2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
>>> 'ranger_audit'
>>> 2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and
>>> User Creation Process Completed..  ----------
>>> 2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
>>> Traceback (most recent call last):
>>>   File "db_setup.py", line 1725, in <module>
>>>     main(sys.argv)
>>>   File "db_setup.py", line 1587, in main
>>>     sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
>>> KeyError: 'sqlanywhere_core_file'
>>> 2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
>>> Administrator.
>>>
>>>
>>> Any suggestion?
>>>
>>> thanks
>>>
>>
>>
>>
>> --
>> Regards: HAFIZ MUJADID
>>
>
>
>
> --
> Regards: HAFIZ MUJADID
>



-- 
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
Thanks for reporting the issue Hafiz. This issue needs to be fixed. I have created https://issues.apache.org/jira/browse/RANGER-751

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:47 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

Added these lines and got following error

Traceback (most recent call last):
  File "update_property.py", line 40, in <module>
    write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
  File "update_property.py", line 21, in write_properties_to_xml
    if(os.path.isfile(xml_path)):
  File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
    st = os.stat(path)
TypeError: coercing to Unicode: need string or buffer, NoneType found
2015-11-28 18:46:39,743  [E] Update property failed for:


On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
In that case, these properties should have been already there. Not sure if you are using an old version of install.properties. Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:34 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

i am using apache ranger main branch code

On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
What version of ranger you are setting up?

Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:04 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on 'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact Administrator.


Any suggestion?

thanks



--
Regards: HAFIZ MUJADID



--
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Hafiz Mujadid <ha...@gmail.com>.
Added these lines and got following error

Traceback (most recent call last):
  File "update_property.py", line 40, in <module>

write_properties_to_xml(ranger_admin_site_xml_path,parameter_name,parameter_value)
  File "update_property.py", line 21, in write_properties_to_xml
    if(os.path.isfile(xml_path)):
  File "/usr/lib/python2.7/genericpath.py", line 29, in isfile
    st = os.stat(path)
TypeError: coercing to Unicode: need string or buffer, NoneType found
2015-11-28 18:46:39,743  [E] Update property failed for:


On Sat, Nov 28, 2015 at 6:36 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:

> In that case, these properties should have been already there. Not sure if
> you are using an old version of install.properties. Can you add the below
> lines in install.properties and try again?
>
> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>
> From: Hafiz Mujadid <ha...@gmail.com>
> Reply-To: "user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> Date: Saturday, November 28, 2015 at 8:34 AM
> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
> Subject: Re: ranger-admin setup failed
>
> i am using apache ranger main branch code
>
> On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <
> vperiasamy@hortonworks.com> wrote:
>
>> What version of ranger you are setting up?
>>
>> Can you add the below lines in install.properties and try again?
>>
>> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
>> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>>
>> From: Hafiz Mujadid <ha...@gmail.com>
>> Reply-To: "user@ranger.incubator.apache.org" <
>> user@ranger.incubator.apache.org>
>> Date: Saturday, November 28, 2015 at 8:04 AM
>> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
>> Subject: ranger-admin setup failed
>>
>> Hi!
>>
>> I am running ./setup.sh script for ranger-admin but it is failing with
>> following exception
>>
>> 2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
>> 'ranger_audit'
>> 2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User
>> Creation Process Completed..  ----------
>> 2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
>> Traceback (most recent call last):
>>   File "db_setup.py", line 1725, in <module>
>>     main(sys.argv)
>>   File "db_setup.py", line 1587, in main
>>     sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
>> KeyError: 'sqlanywhere_core_file'
>> 2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
>> Administrator.
>>
>>
>> Any suggestion?
>>
>> thanks
>>
>
>
>
> --
> Regards: HAFIZ MUJADID
>



-- 
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
In that case, these properties should have been already there. Not sure if you are using an old version of install.properties. Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:34 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: Re: ranger-admin setup failed

i am using apache ranger main branch code

On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <vp...@hortonworks.com>> wrote:
What version of ranger you are setting up?

Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:04 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on 'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact Administrator.


Any suggestion?

thanks



--
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Hafiz Mujadid <ha...@gmail.com>.
i am using apache ranger main branch code

On Sat, Nov 28, 2015 at 6:33 PM, Velmurugan Periasamy <
vperiasamy@hortonworks.com> wrote:

> What version of ranger you are setting up?
>
> Can you add the below lines in install.properties and try again?
>
> *sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql*
> *sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql*
>
> From: Hafiz Mujadid <ha...@gmail.com>
> Reply-To: "user@ranger.incubator.apache.org" <
> user@ranger.incubator.apache.org>
> Date: Saturday, November 28, 2015 at 8:04 AM
> To: "user@ranger.incubator.apache.org" <us...@ranger.incubator.apache.org>
> Subject: ranger-admin setup failed
>
> Hi!
>
> I am running ./setup.sh script for ranger-admin but it is failing with
> following exception
>
> 2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on
> 'ranger_audit'
> 2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User
> Creation Process Completed..  ----------
> 2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
> Traceback (most recent call last):
>   File "db_setup.py", line 1725, in <module>
>     main(sys.argv)
>   File "db_setup.py", line 1587, in main
>     sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
> KeyError: 'sqlanywhere_core_file'
> 2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact
> Administrator.
>
>
> Any suggestion?
>
> thanks
>



-- 
Regards: HAFIZ MUJADID

Re: ranger-admin setup failed

Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
What version of ranger you are setting up?

Can you add the below lines in install.properties and try again?

sqlanywhere_core_file=db/sqlanywhere/xa_core_db_sqlanywhere.sql
sqlanywhere_audit_file=db/sqlanywhere/xa_audit_db_sqlanywhere.sql

From: Hafiz Mujadid <ha...@gmail.com>>
Reply-To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Date: Saturday, November 28, 2015 at 8:04 AM
To: "user@ranger.incubator.apache.org<ma...@ranger.incubator.apache.org>" <us...@ranger.incubator.apache.org>>
Subject: ranger-admin setup failed

Hi!

I am running ./setup.sh script for ranger-admin but it is failing with following exception

2015-11-28 17:59:53,880  [I] Privileges granted to 'rangeradmin' on 'ranger_audit'
2015-11-28 17:59:53,880  [I] ---------- Ranger Policy Manager DB and User Creation Process Completed..  ----------
2015-11-28 17:59:53,920  [I] DB FLAVOR :MYSQL
Traceback (most recent call last):
  File "db_setup.py", line 1725, in <module>
    main(sys.argv)
  File "db_setup.py", line 1587, in main
    sqlanywhere_core_file = globalDict['sqlanywhere_core_file']
KeyError: 'sqlanywhere_core_file'
2015-11-28 17:59:53,925  [E] DB schema setup failed! Please contact Administrator.


Any suggestion?

thanks