Advertisement
Guest User

Unable to Connect to Database

a guest
May 10th, 2013
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. sudo -u oozie /usr/lib/oozie/bin/ooziedb.sh create -sqlfile ~/oozie-create.sql
  2. setting OOZIE_CONFIG=/etc/oozie/conf
  3. setting OOZIE_DATA=/var/lib/oozie
  4. setting OOZIE_LOG=/var/log/oozie
  5. setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat
  6. setting CATALINA_TMPDIR=/var/lib/oozie
  7. setting CATALINA_PID=/var/run/oozie/oozie.pid
  8. setting CATALINA_BASE=/usr/lib/oozie/oozie-server-0.20
  9. setting CATALINA_OPTS=-Xmx1024m
  10. setting OOZIE_HTTPS_PORT=11443
  11. setting OOZIE_HTTPS_KEYSTORE_PASS=password
  12. setting CATALINA_OPTS="$CATALINA_OPTS -Doozie.https.port=${OOZIE_HTTPS_PORT}"
  13. setting CATALINA_OPTS="$CATALINA_OPTS -Doozie.https.keystore.pass=${OOZIE_HTTPS_KEYSTORE_PASS}"
  14. setting OOZIE_CONFIG=/etc/oozie/conf
  15. setting OOZIE_DATA=/var/lib/oozie
  16. setting OOZIE_LOG=/var/log/oozie
  17. setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat
  18. setting CATALINA_TMPDIR=/var/lib/oozie
  19. setting CATALINA_PID=/var/run/oozie/oozie.pid
  20. setting CATALINA_BASE=/usr/lib/oozie/oozie-server-0.20
  21. setting CATALINA_OPTS=-Xmx1024m
  22. setting OOZIE_HTTPS_PORT=11443
  23. setting OOZIE_HTTPS_KEYSTORE_PASS=password
  24. setting CATALINA_OPTS="$CATALINA_OPTS -Doozie.https.port=${OOZIE_HTTPS_PORT}"
  25. setting CATALINA_OPTS="$CATALINA_OPTS -Doozie.https.keystore.pass=${OOZIE_HTTPS_KEYSTORE_PASS}"
  26.  
  27. Validate DB Connection
  28.  
  29. Error: Could not connect to the database: org.apache.oozie.service.ServiceException: E0001: Could not create runtime directory,
  30.  
  31. Stack trace for the error was (for debug purposes):
  32. --------------------------------------
  33. java.lang.Exception: Could not connect to the database: org.apache.oozie.service.ServiceException: E0001: Could not create runtime directory,
  34. at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:473)
  35. at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:179)
  36. at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:118)
  37. at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:64)
  38. Caused by: org.apache.oozie.service.ServiceException: E0001: Could not create runtime directory,
  39. at org.apache.oozie.service.Services.createRuntimeDir(Services.java:139)
  40. at org.apache.oozie.service.Services.<init>(Services.java:123)
  41. at org.apache.oozie.tools.OozieDBCLI.getJdbcConf(OozieDBCLI.java:161)
  42. at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:461)
  43. at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:469)
  44. ... 3 more
  45. Caused by: java.io.IOException: No such file or directory
  46. at java.io.UnixFileSystem.createFileExclusively(Native Method)
  47. at java.io.File.checkAndCreate(File.java:1705)
  48. at java.io.File.createTempFile0(File.java:1726)
  49. at java.io.File.createTempFile(File.java:1838)
  50. at org.apache.oozie.service.Services.createRuntimeDir(Services.java:128)
  51. ... 7 more
  52. --------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement