Rundeck setup with Oracle

460 views

Skip to first unread message

Vinayak

unread,

Dec 13, 2012, 9:43:43 AM12/13/12

to rundeck...@googlegroups.com

Hi,

I have installed rundeck 1.4.4 and I want setup oracle database with it.

Have copied ojdbc14.jar under server/lib

and have configured rundeck-config.properties file as below

=====================================================================

#loglevel.default is the default log level for jobs: ERR,WARN,INFO,VERBOSE,DEBUG

loglevel.default=INFO

#rss.enabled if set to true enables RSS feeds that are public (non-authenticated)

rss.enabled=true

grails.serverURL=http://********.local:4440

dataSource.dbCreate = update

dataSource.url = jdbc:oracle:thin:@localhost:1511/rndckdbd

dataSource.driverClassName = oracle.jdbc.driver.OracleDriver

dataSource.username = RNDCKDBD_OWNER

dataSource.password = ******

dataSource.dialect = org.hibernate.dialect.Oracle10gDialect

#note, make sure this is set to "true" if you are using Oracle or Mysql

rundeck.v14.rdbsupport=true

=====================================================================

But I am getting below error. Please suggest...

-bash-3.2$ java -jar rundeck-launcher-1.4.4.jar

WARNING: HTTPS is not enabled, specify -Drundeck.ssl.config=/ngs/app/merlind/ciAutomation/rundeck/server/config/ssl.properties to enable.

2012-12-13 13:58:39.922::INFO: Logging to STDERR via org.mortbay.log.StdErrLog

2012-12-13 13:58:39.974::INFO: jetty-6.1.21

2012-12-13 13:58:40.216::INFO: NO JSP Support for /, did not find org.apache.jasper.servlet.JspServlet

2012-12-13 13:58:45.279:/:INFO: Initializing Spring root WebApplicationContext

2012-12-13 13:58:50,220 ERROR ContextLoader - Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

at com.dtolabs.rundeck.RunServer.run(RunServer.java:101)

at com.dtolabs.rundeck.RunServer.main(RunServer.java:64)

at com.dtolabs.rundeck.ExpandRunServer.invokeMain(ExpandRunServer.java:690)

at com.dtolabs.rundeck.ExpandRunServer.execute(ExpandRunServer.java:647)

at com.dtolabs.rundeck.ExpandRunServer.run(ExpandRunServer.java:304)

at com.dtolabs.rundeck.ExpandRunServer.main(ExpandRunServer.java:113)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

... 6 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

... 6 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

... 6 more

Caused by: org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

... 6 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at $Proxy7.getMetaData(Unknown Source)

... 6 more

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

... 9 more

2012-12-13 13:58:50.222::WARN: Failed startup of context org.mortbay.jetty.webapp.WebAppContext@3e97db11{/,/ngs/app/merlind/ciAutomation/rundeck/server/exp/webapp}