DB Storage plugin failing to load

74 views

Skip to first unread message

Jack Thomas

unread,

Nov 29, 2014, 4:08:04 PM11/29/14

to rundeck...@googlegroups.com

I'm trying to get the db storage plugin working to store SSH keys. Once I have changed my config file to include:

dataSource.dbCreate = update

dataSource.url=jdbc:postgresql://localhost:5432/rundeck

dataSource.driverClassName=org.postgresql.Driver

dataSource.dialect=org.hibernate.dialect.PostgreSQLDialect

dataSource.username=rundeck

dataSource.password=password

rundeck.storage.provider.1.type=db

rundeck.storage.provider.1.path=/

The postgres database works fine for the other elements.

I get the following errors in the startup logs, and I can't upload keys:

2014-11-29 20:41:47,797 [qtp128889965-33] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: relation "storage" does not exist

Position: 29

2014-11-29 20:41:47,857 [qtp128889965-33] ERROR org.codehaus.groovy.grails.web.errors.GrailsExceptionResolver - PSQLException occurred when pr

ocessing request: [GET] /storage/access/keys

ERROR: relation "storage" does not exist

Position: 29. Stacktrace follows:

org.postgresql.util.PSQLException: ERROR: relation "storage" does not exist

Position: 29

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)

at grails.orm.HibernateCriteriaBuilder.invokeMethod(HibernateCriteriaBuilder.java:1622)

at rundeck.services.DbStorageService.hasPath(DbStorageService.groovy:64)

at com.dtolabs.rundeck.core.storage.ResolvedExtTree.hasPath(ResolvedExtTree.java:32)

at org.rundeck.storage.impl.DelegateTree.hasPath(DelegateTree.java:20)

at com.dtolabs.rundeck.core.storage.AuthRundeckStorageTree.hasPath(AuthRundeckStorageTree.java:96)

at rundeck.services.StorageService.hasPath(StorageService.groovy:17)

at rundeck.controllers.StorageController.getResource(StorageController.groovy:588)

at rundeck.controllers.StorageController.keyStorageAccess(StorageController.groovy:212)

at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:539)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:288)

at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)

at com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:486)

at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)

at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)

at org.eclipse.jetty.server.Server.handle(Server.java:349)

at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449)

at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910)

at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)

at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)

at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)

at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)

at java.lang.Thread.run(Thread.java:745)

I'm using build 2.3.2-1

Any ideas?

Reply all

Reply to author

Forward

0 new messages