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 <[email protected]> wrote: > <anbari server> is just the host name. Not the url that you gave. > > > On Thursday, February 5, 2015, Hadoop Solutions <[email protected]> > 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 <[email protected]> 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 < >>> [email protected]> wrote: >>> >>>> Attached Screenshot.... >>>> >>>> [image: Inline images 2] >>>> >>>> On 5 February 2015 at 12:42, Hadoop Solutions <[email protected]> >>>> 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 >>>>> >>>> >>>> >>> >>
