Hey Gautam, Can you also attach a server side oozie.log snippet after running an Oozie job that seems to fail with the error you've sent?
I do not think your issue is related to MySQL at this point, but server logs will help determine. Thanks! On Thu, Jul 19, 2012 at 1:09 AM, Gautam Singaraju < [email protected]> wrote: > Hi Oozie community: > > > I am working on getting Oozie working with MySQL; and I have followed > the instructions in a previous post: > > http://mail-archives.apache.org/mod_mbox/incubator-oozie-users/201110.mbox/%3CCAC8XGpEFCTEnHZjdbPQoKgWm-jiK0gzY=a_9wdjgzuzpjef...@mail.gmail.com%3E > (I have copied some part of the suggestions at the end of the email.) > > I am using Oozie 3.2 and mysql 5.1. > > Exceptions: > 1. I have installed oozie as linux user: hadoop. > 2. also started it with webconsole. > 3. I am running on AWS. > > When I start oozie, and submit a job, I am getting the following error: > > WARN AuthenticationFilter:381 - Authentication exception: > AuthenticationToken expired > org.apache.hadoop.security.authentication.client.AuthenticationException: > AuthenticationToken expired > > Any suggestions would be greatly appreciated. Additionally, Apache > Oozie can benefit from a writeup on how to get oozie and mysql > working. > > Thanks in advance! > <--------------snip> > > 1. Get a jdbc connector jar from here: > http://dev.mysql.com/downloads/connector/j/ > 2. Run the following command (as user oozie): > sudo -u oozie <path-to-oozie-installation/oozie-setup.sh > -jars <path-to-connector-jar> > 3. Create the following DB in your MySQL and grant privs on it: > # mysql -u root -p > create database oozie; > grant all privileges on oozie.* to 'oozie'@'localhost' > identified by 'oozie'; > 4. Replace the following properties in your oozie-site.xml with the > values give below: > > <property> > <name>oozie.service.StoreService.jdbc.driver</name> > <value>com.mysql.jdbc.Driver</value> > <description> > JDBC driver class. > </description> > </property> > > <property> > <name>oozie.service.StoreService.jdbc.url</name> > <value>jdbc:mysql://localhost:3306/oozie</value> > <description> > JDBC URL. > </description> > </property> > > <property> > <name>oozie.service.StoreService.jdbc.username</name> > <value>oozie</value> > <description> > DB user name. > </description> > </property> > > <property> > <name>oozie.service.StoreService.jdbc.password</name> > <value>oozie</value> > <description> > DB user password. > > IMPORTANT: if password is emtpy leave a 1 space string, the > service > trims the value, > if empty Configuration assumes it is NULL. > > IMPORTANT: if the StoreServicePasswordService is active, > it will reset > this value with the value given in > the console. > </description> > </property> > > <-----------------end snip> > > > --- > Gautam > -- Harsh J
