perfsonar-user - [perfsonar-user] perfsonar-ui-web fails to start - unable to access database

Subject: perfSONAR User Q&A and Other Discussion

List archive

[perfsonar-user] perfsonar-ui-web fails to start - unable to access database

From: Trey Dockendorf <>
To: perfsonar-user <>
Subject: [perfsonar-user] perfsonar-ui-web fails to start - unable to access database
Date: Mon, 10 Aug 2015 10:31:48 -0500

I've installed perfsonar-ui-web-1.5.1 and noticed it's failing to start. The /var/log/tomcat6/catalina.out shows "java.sql.SQLException: Database '/var/lib/perfsonar-ui/database' not found." before the exception [1]. I also noticed a permission denied message to "derby.log" but unsure where that log is trying to write.

/var/lib/perfsonar-ui/ is owned by tomcat and I noticed persistence.xml has the /var/lib/perfsonar-ui/database path with "create=true", but seems the database is never created.

This install is on my perfsonar bandwidth host just to test out the perfsonar-ui interface. Tomcat installed is 6.0.24-90.el6.

Steps taken before the error:

wget http://downloads.perfsonar.eu/repositories/rpm/perfsonar-stable-x86_64.repo
mv perfsonar-stable-x86_64.repo /etc/yum.repos.d/

yum install perfsonar-ui-web

I tried restarting the tomcat6 service but the error is the same.

Thanks,

- Trey

[1]:

INFO [10-Aug 10:19:41 OiosamlProcessingFilterEntryPoint.java] The parameter oiosaml-j.home which is set in web.xml to: /home/tomcat/.oiosaml is not set to an (existing) directory, or the directory is empty - OIOSAML-J is not configured.

INFO [10-Aug 10:19:41 DefaultSecurityFilterChain.java] Creating filter chain: org.springframework.security.web.util.AnyRequestMatcher@1, [org.springframework.security.web.context.SecurityContextPersistenceFilter@ef1347f, org.springframework.security.web.authentication.logout.LogoutFilter@7dad8582, net.geant.security.oiosaml.OiosamlProcessingFilter@b185a44, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@6bce2c0c, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2cadff1f, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@53486323, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3564b98c, org.springframework.security.web.session.SessionManagementFilter@67d1b1b6, org.springframework.security.web.access.ExceptionTranslationFilter@77ea58f9, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@3a7780f0]

Mon Aug 10 10:19:41 CDT 2015 Thread[main,5,main] java.io.FileNotFoundException: derby.log (Permission denied)

55 psUI INFO [main] openjpa.Runtime - Starting OpenJPA 2.4.0

134 psUI INFO [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary".

Aug 10, 2015 10:19:41 AM org.apache.catalina.core.StandardContext start

SEVERE: Error listenerStart

Aug 10, 2015 10:19:41 AM org.apache.catalina.core.StandardContext start

SEVERE: Context [/perfsonar-ui] startup failed due to previous errors

Mon Aug 10 10:19:41 CDT 2015 Thread[main,5,main] Cleanup action starting

java.sql.SQLException: Database '/var/lib/perfsonar-ui/database' not found.

at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)

at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)

at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:233)

at org.perfsonar.ui.listener.PerfsonarInitListener.contextDestroyed(PerfsonarInitListener.java:23)

at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4249)

at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4890)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4754)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:516)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

at org.apache.catalina.startup.Catalina.start(Catalina.java:593)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: ERROR XJ004: Database '/var/lib/perfsonar-ui/database' not found.

at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)

... 39 more

============= begin nested exception, level (1) ===========

ERROR XJ004: Database '/var/lib/perfsonar-ui/database' not found.