ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hadoop Solutions <munna.had...@gmail.com>
Subject Re: Oozie Database Change blocked in Ambari
Date Thu, 05 Feb 2015 08:28:28 GMT
Hi Ravi,

Thank you for your help!

Now, I can changed my derby DB to MySQL.

Thanks,
Shaik

On 5 February 2015 at 15:32, Ravi Mutyala <rmutyala@gmail.com> wrote:

> <anbari server> is just the host name. Not the url that you gave.
>
>
> On Thursday, February 5, 2015, Hadoop Solutions <munna.hadoop@gmail.com>
> wrote:
>
>> HI Ravi,
>>
>> Thank you for your reply.
>>
>> I am trying to execute above procedure, but, i am getting below error...
>>
>> Please help me to resolve this.
>>
>> [root@sv2lxbdp2mstd01 ~]#
>>  /var/lib/ambari-server/resources/scripts/configs.sh get
>> http://10.193.154.215:8080/ BDP2_DEV oozie-site oozie.conf
>> [ERROR] "oozie-site" not found in server response.
>> [ERROR] Output of `curl -k -s -u admin:admin "http://
>> http://10.193.154.215:8080/:8080/api/v1/clusters/BDP2_DEV?fields=Clusters/desired_configs"`
>> is:
>> [ERROR]
>>
>>
>> Thanks,
>> Shaik
>>
>> On 5 February 2015 at 14:02, Ravi Mutyala <rmutyala@gmail.com> wrote:
>>
>>> You have to go using configs.sh for this one (not through UI yet)
>>>
>>> 1. /var/lib/ambari-server/resources/scripts/configs.sh get <ambari
>>> server> <cluster name> oozie-site oozie.conf
>>> 2. modify the file (oozie.conf to oozie.conf.new) with you mysql DB.
>>> 3 ./var/lib/ambari-server/resources/scripts/configs.sh set <ambari
>>> server> <cluster name> oozie-site oozie.conf.new
>>>
>>> Example values for mysql.
>>> oozie.service.JPAService.create.db.schema  = true  <if you need it to
>>> create schema>
>>> oozie.service.JPAService.jdbc.driver = com.mysql.jdbc.Driver
>>> oozie.service.JPAService.jdbc.username = oozie
>>> oozie.service.JPAService.jdbc.password = <password>
>>> oozie.service.JPAService.jdbc.url =
>>> jdbc:mysql://mysql.server.host:3306/oozie
>>>
>>> Thanks
>>>
>>> On Wed, Feb 4, 2015 at 11:11 PM, Hadoop Solutions <
>>> munna.hadoop@gmail.com> wrote:
>>>
>>>> Attached Screenshot....
>>>>
>>>> [image: Inline images 2]
>>>>
>>>> On 5 February 2015 at 12:42, Hadoop Solutions <munna.hadoop@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> I am new to Ambari, while installing HDP2.2 through Ambari, by mistake
>>>>> i have selected wrong database for Oozie.
>>>>>
>>>>> After deploying, i am unable to change the DB from Ambari. All radio
>>>>> buttons are blocked in config page.
>>>>>
>>>>> Please let me know how to change Oozie DB Derby to MySQL.
>>>>>
>>>>> Regards,
>>>>> Shaik
>>>>>
>>>>
>>>>
>>>
>>

Mime
View raw message