oozie-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tousif <tou...@moonraft.com>
Subject Re: oozie 3.1.0 not taking up database change
Date Wed, 23 Nov 2011 08:27:57 GMT
Mysql version is  5.1.54. oozie is registering derby jdbc and postgre jdbc,
but nowhere i found mysql mentioned.

There are no errors as such. I wonder just by changing oozie-sitel jdbc
properties oozie takes up db change.
and one thing to add is even after commenting derby configuration in
oozie-site.xml ,oozie is starting derby.



On Wed, Nov 23, 2011 at 1:13 PM, Mohammad Islam <mislam77@yahoo.com> wrote:

> what is the error message in other catalina output files? Please check all
> the files for any  error/exception. Also which version of mysql you are
> using?
>
> Regards,
> Mohammad
>
>
> ________________________________
>  From: tousif <tousif@moonraft.com>
> To: oozie-users <oozie-users@incubator.apache.org>
> Sent: Tuesday, November 22, 2011 11:22 PM
> Subject: oozie 3.1.0 not taking up database change
>
> Hi,
>
> I want to change oozie database from apache derby to mysql.
>
> i followed following steps
>
> 1)  bin/oozie-setup.sh -hadoop 0.20.200 /home/tousif/BrandMoods/hadoop -jar
> /home/tousif/BrandMoods/oozie-3.1.0/mysql-connector-java-5.0.8-bin.jar
>
> 2) adding properties in oozie-site.xml
>   commenting derby configuration
>
> <property>
>         <name>oozie.service.StoreService.jdbc.driver</name>
>         <value>com.mysql.jdbc.Driver</value>
>     </property>
>     <property>
>         <name>oozie.service.StoreService.jdbc.url</name>
>         <value>jdbc:mysql://localhost:3306/oozie</value>
>     </property>
>     <property>
>         <name>oozie.service.StoreService.jdbc.username</name>
>         <value>root</value>
>     </property>
>     <property>
>         <name>oozie.service.StoreService.jdbc.password</name>
>         <value>oozie</value>
>     </property>
>
>
> 3) restart oozie.
>
> After doing all these steps oozie starts derby not mysql.  i have commented
> derby configuration
>
> oozie logs
>
> 2011-11-23 12:43:52,426  INFO ConfigurationService:539 - USER[-] GROUP[-]
> Oozie home dir  [/home/tousif/BrandMoods/oozie-3.1.0]
> 2011-11-23 12:43:52,427  INFO ConfigurationService:539 - USER[-] GROUP[-]
> Oozie conf dir  [/home/tousif/BrandMoods/oozie-3.1.0/conf]
> 2011-11-23 12:43:52,427  INFO ConfigurationService:539 - USER[-] GROUP[-]
> Oozie conf file [oozie-site.xml]
> 2011-11-23 12:43:52,536  INFO ConfigurationService:539 - USER[-] GROUP[-]
> Configuration change via System Property, [oozie.base.url]=[
> http://localhost:11000/oozie]
>
>
>
>    2011-11-23 12:43:52,847  INFO KerberosHadoopAccessorService:539 -
> USER[-] GROUP[-] Oozie Kerberos Authentication [disabled]
> 2011-11-23 12:43:59,001  INFO JPAService:539 - USER[-] GROUP[-] TOKEN[-]
> APP[-] JOB[-] ACTION[-] All entities initialized
> 2011-11-23 12:43:59,003  INFO JPAService:539 - USER[-] GROUP[-] TOKEN[-]
> APP[-] JOB[-] ACTION[-] JPA configuration:
>
> DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:/home/tousif/BrandMoods/oozie-3.1.0/data/oozie-db;create=true,Username=sa,Password=,MaxActive=10,TestOnBorrow=false,TestOnReturn=false,TestWhileIdle=false
> 2011-11-23 12:43:59,169  INFO Services:539 - Initialized
> 2011-11-23 12:43:59,174  INFO Services:539 - Running with JARs for Hadoop
> version [0.20.203.0]
>
>
>
>
>
>
>
> --
>
>
>
> Regards
> Tousif
>



-- 
Regards
Tousif

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message