You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@oozie.apache.org by tousif <to...@moonraft.com> on 2011/11/23 08:22:10 UTC
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
Re: oozie 3.1.0 not taking up database change
Posted by Alejandro Abdelnur <tu...@cloudera.com>.
Tousif,
It seems you are using Oozie 2.x DB configuration properties
(StoreService), you should use Oozie 3.x ones (JPAService).
Thanks.
Alejandro
On Wed, Nov 23, 2011 at 12:27 AM, tousif <to...@moonraft.com> wrote:
> 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 <mi...@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 <to...@moonraft.com>
> > To: oozie-users <oo...@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
>
Re: oozie 3.1.0 not taking up database change
Posted by tousif <to...@moonraft.com>.
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 <mi...@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 <to...@moonraft.com>
> To: oozie-users <oo...@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
Re: oozie 3.1.0 not taking up database change
Posted by Mohammad Islam <mi...@yahoo.com>.
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 <to...@moonraft.com>
To: oozie-users <oo...@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