Mailing-List: contact oozie-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: oozie-users@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of tucu@cloudera.com designates
 209.85.212.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <E236CD55EC618B4884CA7273B31AA0780755C938@stlwexmbxprd04.na.ds.monsanto.com>
References: 
 <E236CD55EC618B4884CA7273B31AA0780755C938@stlwexmbxprd04.na.ds.monsanto.com>
From: Alejandro Abdelnur <tucu@cloudera.com>
Date: Mon, 3 Oct 2011 17:09:38 -0700
Message-ID: 
 <CAJs-t7M7X6JfR_kC7_PsNFcnr+d29mhADGG+pKuyXLtDfDw8eA@mail.gmail.com>
Subject: Re: Oozie setup issue
To: CDH Users <cdh-user@cloudera.org>
Content-Type: multipart/alternative; boundary=20cf307abeb90aaefc04ae6deab8

--20cf307abeb90aaefc04ae6deab8
Content-Type: text/plain; charset=ISO-8859-1

[moving this  thread to cdh-user@ alias as it is a CDH related issue,
oozie-users@ BCCed]

Matthew,

The Oozie binaries are owned by root, but the Oozie data directories
/var/lib/oozie, /var/log/oozie, /var/tmp/oozie are own by the 'oozie' unix
user.

If installing oozie from CDH RPM you don't need to run chown, nor need to
add OOZIE_CHECK_OWNER, nor need to add oozie to the sudoers.

You have to start/stop Oozie using the /sbin/service command 'sudo
/sbin/service oozie start' That will start Oozie with the correct user.

If you started Oozie with root unix user the first time, all the Oozie data
directories will have files owned by root thus will fail when trying to
start with the oozie unix user.

I'd suggest doing a clean install and starting Oozie with the 'sudo
/sbin/servce oozie start' command. That should would.

Thanks.

Alejandro

On Mon, Oct 3, 2011 at 3:27 PM, GOEKE, MATTHEW (AG/1000) <
matthew.goeke@monsanto.com> wrote:

> I am having issues setting up the version of oozie that comes with CDH3u1
> (pretty sure 2.2) from the included rpm. So far I have:
>
> *ran the rpm
> *chown'ed the oozie directories over to the oozie user / group (for some
> reason the rpm didn't do that)
> *changed JRE_HOME to point to our current Java version
> *added OOZIE_CHECK_OWNER=true to confirm ownership during startup
> *added the ability to -u oozie into the sudoers
> *added in the extjs dependency using the oozie-setup.sh
>
> I have debugged through several things but now I seem to be hitting a brick
> wall. For some reason I getting the below error in the oozie.log file found
> in /var/log/oozie/ and I am at a loss at this point for what I am missing. I
> know it is some minor oversight but I would love some help on this and I can
> include the full log if necessary. Thanks in advance :)
>
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: DDL is not
> permitted for a read-only connection, user or database.
>
> Matt
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> This e-mail message may contain privileged and/or confidential information,
> and is intended to be received only by persons entitled
> to receive such information. If you have received this e-mail in error,
> please notify the sender immediately. Please delete it and
> all attachments from any servers, hard drives or any other media. Other use
> of this e-mail by you is strictly prohibited.
>
> All e-mails and attachments sent and received are subject to monitoring,
> reading and archival by Monsanto, including its
> subsidiaries. The recipient of this e-mail is solely responsible for
> checking for the presence of "Viruses" or other "Malware".
> Monsanto, along with its subsidiaries, accepts no liability for any damage
> caused by any such code transmitted by or accompanying
> this e-mail or any attachment.
>
>
> The information contained in this email may be subject to the export
> control laws and regulations of the United States, potentially
> including but not limited to the Export Administration Regulations (EAR)
> and sanctions regulations issued by the U.S. Department of
> Treasury, Office of Foreign Asset Controls (OFAC).  As a recipient of this
> information you are obligated to comply with all
> applicable U.S. export laws and regulations.
>

--20cf307abeb90aaefc04ae6deab8--