Created on 02-25-2016 10:45 AM - edited 09-16-2022 03:05 AM
When I try to install Oozie it give me this error:
2016-02-25 18:22:24,260 INFO org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Overriding configuration with system property. Key [oozie.http.port], Value [11000] 2016-02-25 18:22:24,268 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.ProxyUserService.proxyuser.hue.hosts] 2016-02-25 18:22:24,268 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.GroupsService.hadoop.security.group.mapping] 2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.service.ProxyUserService.proxyuser.hue.groups] 2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [hadoop.security.credential.provider.path] 2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.from.address] 2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.port] 2016-02-25 18:22:24,269 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.host] 2016-02-25 18:22:24,270 WARN org.apache.oozie.service.ConfigurationService: SERVER[cloudera1] Invalid configuration defined, [oozie.email.smtp.auth] 2016-02-25 18:22:24,274 WARN org.apache.oozie.service.Services: SERVER[cloudera1] System ID [oozie-oozi] exceeds maximum length [10], trimming 2016-02-25 18:22:24,275 INFO org.apache.oozie.service.Services: SERVER[cloudera1] Exiting null Entering NORMAL 2016-02-25 18:22:24,276 INFO oozieops: SERVER[cloudera1] Exiting null Entering NORMAL 2016-02-25 18:22:24,276 INFO org.apache.oozie.service.Services: SERVER[cloudera1] Initialized runtime directory [/tmp/oozie-oozi6638948414612903101.dir]
stdout
Thu Feb 25 18:22:22 UTC 2016 JAVA_HOME=/usr/lib/jvm/java-7-oracle-cloudera using 5 as CDH_VERSION Validate DB Connection
stderr
Error: Could not connect to the database: org.postgresql.util.PSQLException: The connection attempt failed. Stack trace for the error was (for debug purposes): -------------------------------------- java.lang.Exception: Could not connect to the database: org.postgresql.util.PSQLException: The connection attempt failed. at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:905) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:185) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:129) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:80) Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:393) at org.postgresql.Driver.connect(Driver.java:267) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:895) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:901) ... 3 more Caused by: java.net.UnknownHostException: : at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at java.net.Socket.connect(Socket.java:528) at java.net.Socket.<init>(Socket.java:425) at java.net.Socket.<init>(Socket.java:208) at org.postgresql.core.PGStream.<init>(PGStream.java:62) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76) ... 15 more --------------------------------------
It successfully creates Oozie database but fails creating oozie database tables.
I'm using the last version of CDH in Ubuntu 14.04.
Regards,
Created 03-02-2016 11:14 AM
Created 03-02-2016 11:14 AM