Return-Path: X-Original-To: apmail-incubator-ambari-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-ambari-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 46F21E06E for ; Wed, 29 May 2013 19:54:22 +0000 (UTC) Received: (qmail 76073 invoked by uid 500); 29 May 2013 19:54:22 -0000 Delivered-To: apmail-incubator-ambari-dev-archive@incubator.apache.org Received: (qmail 76049 invoked by uid 500); 29 May 2013 19:54:22 -0000 Mailing-List: contact ambari-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ambari-dev@incubator.apache.org Delivered-To: mailing list ambari-dev@incubator.apache.org Received: (qmail 76039 invoked by uid 99); 29 May 2013 19:54:22 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 May 2013 19:54:22 +0000 Date: Wed, 29 May 2013 19:54:22 +0000 (UTC) From: "Sumit Mohanty (JIRA)" To: ambari-dev@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (AMBARI-2223) Using an external MySQL / Oracle database for Oozie does not work MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AMBARI-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13669635#comment-13669635 ] Sumit Mohanty commented on AMBARI-2223: --------------------------------------- +1 for commit. > Using an external MySQL / Oracle database for Oozie does not work > ----------------------------------------------------------------- > > Key: AMBARI-2223 > URL: https://issues.apache.org/jira/browse/AMBARI-2223 > Project: Ambari > Issue Type: Bug > Components: agent > Affects Versions: 1.2.4 > Reporter: Siddharth Wagle > Assignee: Siddharth Wagle > Fix For: 1.2.4 > > Attachments: AMBARI-2223.patch > > > When setting up Oozie with an external database, the following commands are run: > {code} > cd /var/tmp/oozie && /usr/lib/oozie/bin/oozie-setup.sh -hadoop 0.20.200 /usr/lib/hadoop/ -extjs /usr/share/HDP-oozie/ext.zip -jars /usr/lib/hadoop/lib/hadoop-lzo-0.5.0.jar:/usr/share/java/mysql-connector-java.jar > {code} > The above command succeeds. > However, the next command fails: > {code} > cd /var/tmp/oozie && /usr/lib/oozie/bin/ooziedb.sh create -sqlfile oozie.sql -run > setting OOZIE_CONFIG=${OOZIE_CONFIG:-/etc/oozie/conf} > setting OOZIE_DATA=${OOZIE_DATA:-/var/lib/oozie} > setting OOZIE_LOG=${OOZIE_LOG:-/var/log/oozie} > setting CATALINA_BASE=${CATALINA_BASE:-/var/lib/oozie/oozie-server} > setting CATALINA_TMPDIR=${CATALINA_TMPDIR:-/var/tmp/oozie} > setting CATALINA_PID=${CATALINA_PID:-/var/run/oozie/oozie.pid} > setting JAVA_HOME=/usr/jdk/jdk1.6.0_31 > setting OOZIE_LOG=/var/log/oozie/ > setting CATALINA_PID=/var/run/oozie/oozie.pid > setting OOZIE_DATA=/grid/0/hadoop/oozie/data/ > setting JAVA_LIBRARY_PATH=/usr/lib/hadoop/lib/native/Linux-amd64-64 > Validate DB Connection > Error: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver > Stack trace for the error was (for debug purposes): > -------------------------------------- > java.lang.Exception: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver > at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:358) > at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:168) > at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:112) > at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:63) > Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver > at java.net.URLClassLoader$1.run(URLClassLoader.java:202) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:190) > at java.lang.ClassLoader.loadClass(ClassLoader.java:306) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) > at java.lang.ClassLoader.loadClass(ClassLoader.java:247) > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:169) > at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:347) > at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:354) > ... 3 more > -------------------------------------- > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira