[jira] [Created] (AMBARI-6664) Oozie service can not be started on Ambari server with external Postgres

["Vitaly Brodetskyi (JIRA)" <ji...@apache.org>]

Vitaly Brodetskyi created AMBARI-6664:
-----------------------------------------

             Summary: Oozie service can not be started on Ambari server with external Postgres
                 Key: AMBARI-6664
                 URL: https://issues.apache.org/jira/browse/AMBARI-6664
             Project: Ambari
          Issue Type: Bug
          Components: agent
    Affects Versions: 1.7.0
            Reporter: Vitaly Brodetskyi
            Assignee: Vitaly Brodetskyi
            Priority: Blocker
             Fix For: 1.7.0


*STR:*
- Install single node cluster with Postgres 9 server as Ambari and Oozie DB (Stack - 2.0). Postgres server should be on dedicated host;
- Start all services.

*Actual result:* Oozie server will not start.

Error message for Oozie:
{noformat}
2014-07-23 08:42:57,947 - Error while executing command 'start':
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 111, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_server.py", line 43, in start
    oozie_service(action='start')
  File "/var/lib/ambari-agent/cache/stacks/HDP/2.0.6/services/OOZIE/package/scripts/oozie_service.py", line 43, in oozie_service
    Execute( db_connection_check_command, tries=5, try_sleep=10)
  File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 148, in __init__
    self.env.run()
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 149, in run
    self.run_action(resource, action)
  File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 115, in run_action
    provider_action()
  File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 239, in action_run
    raise ex
Fail: Execution of '/usr/jdk64/jdk1.7.0_45/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/lib/oozie/libserver/postgresql-9.0-801.jdbc4.jar org.apache.ambari.server.DBConnectionVerification jdbc:postgresql://<host>:5432/ooziedb oozieuser [PROTECTED] org.postgresql.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
java.lang.ClassNotFoundException: org.postgresql.Driver
{noformat}




--
This message was sent by Atlassian JIRA
(v6.2#6252)