Eugene, postgresql is refusing the connection. Check your pg_hba.conf. Regards
Diego El dom., 8 mar. 2020 02:15, Eugene Jose Espinoza <[email protected]> escribió: > Hi all! We're getting white screen in our DSpace installation. This DSpace > installation has been working since December 2019. Just this week, we're > getting white screen. What I can remember last time I was configuring it > was I was trying to access the Postgresql database through pgadmin 4, so I > returned the previous settings for pg_hba.conf and postgresql.conf. Not > quite sure if this was related to why we're getting the white screen error. > > Below is the snippet of the dspace.log: > > [1]+ Stopped tail -f dspace.log.2020-03-08 > root@s192-169-196-113:/dspace/log# clear > root@s192-169-196-113:/dspace/log# tail -f dspace.log.2020-03-08 > Caused by: java.net.ConnectException: Connection refused (Connection > refused) > at java.net.PlainSocketImpl.socketConnect(Native Method) > at > java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) > at > java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > at java.net.Socket.connect(Socket.java:607) > at org.postgresql.core.PGStream.<init>(PGStream.java:69) > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:158) > ... 101 more > 2020-03-08 16:07:31,960 WARN > org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: > 08001 > 2020-03-08 16:07:31,960 ERROR > org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Connection to > localhost:5432 refused. Check that the hostname and port are correct and > that the postmaster is accepting TCP/IP connections. > 2020-03-08 16:07:31,963 WARN > org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: > 08001 > 2020-03-08 16:07:31,963 ERROR > org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Connection to > localhost:5432 refused. Check that the hostname and port are correct and > that the postmaster is accepting TCP/IP connections. > 2020-03-08 16:07:31,964 ERROR > org.dspace.app.xmlui.cocoon.DSpaceCocoonServletFilter @ Serious Error > Occurred Processing Request! > javax.servlet.ServletException: org.apache.cocoon.ProcessingException: > Sitemap: error invoking action > at <map:act type="locale"> - > file:///dspace/webapps/xmlui/sitemap.xmap:767:64 > at > org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:230) > at > org.apache.cocoon.sitemap.SitemapServlet.service(SitemapServlet.java:84) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:468) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:443) > at > org.apache.cocoon.servletservice.spring.ServletFactoryBean$ServiceInterceptor.invoke(ServletFactoryBean.java:264) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > at com.sun.proxy.$Proxy127.service(Unknown Source) > at org.dspace.springmvc.CocoonView.render(CocoonView.java:113) > at > org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1216) > at > org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1001) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951) > at > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.dspace.app.xmlui.cocoon.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.dspace.app.xmlui.cocoon.DSpaceCocoonServletFilter.doFilter(DSpaceCocoonServletFilter.java:160) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.dspace.app.xmlui.cocoon.servlet.multipart.DSpaceMultipartFilter.doFilter(DSpaceMultipartFilter.java:119) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) > at > org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:868) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.apache.cocoon.ProcessingException: Sitemap: error invoking > action > at <map:act type="locale"> - > file:///dspace/webapps/xmlui/sitemap.xmap:767:64 > at > org.apache.cocoon.ProcessingException.throwLocated(ProcessingException.java:111) > at > org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:141) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.SwitchSelectNode.invoke(SwitchSelectNode.java:88) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.HandleErrorsNode.invoke(HandleErrorsNode.java:78) > at > org.apache.cocoon.components.treeprocessor.sitemap.ErrorHandlerHelper.prepareErrorHandler(ErrorHandlerHelper.java:157) > at > org.apache.cocoon.components.treeprocessor.sitemap.ErrorHandlerHelper.prepareErrorHandler(ErrorHandlerHelper.java:124) > at > org.apache.cocoon.components.treeprocessor.sitemap.ErrorHandlerHelper.invokeErrorHandler(ErrorHandlerHelper.java:94) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:89) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:239) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171) > at > org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:247) > at > org.apache.cocoon.servlet.RequestProcessor.process(RequestProcessor.java:351) > at > org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:169) > ... 51 more > Caused by: org.hibernate.exception.JDBCConnectionException: Could not open > connection > at > org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132) > at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) > at > org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221) > at > org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) > at > org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) > at > org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) > at > org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1387) > at sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352) > at com.sun.proxy.$Proxy77.beginTransaction(Unknown Source) > at > org.dspace.core.HibernateDBConnection.getSession(HibernateDBConnection.java:43) > at > org.dspace.core.HibernateDBConnection.configureDatabaseMode(HibernateDBConnection.java:154) > at > org.dspace.core.HibernateDBConnection.setConnectionMode(HibernateDBConnection.java:140) > at org.dspace.core.Context.setMode(Context.java:701) > at org.dspace.core.Context.init(Context.java:183) > at org.dspace.core.Context.<init>(Context.java:126) > at > org.dspace.app.xmlui.utils.ContextUtil.obtainContext(ContextUtil.java:95) > at > org.dspace.app.xmlui.utils.ContextUtil.obtainContext(ContextUtil.java:59) > at > org.dspace.app.xmlui.cocoon.DSpaceLocaleAction.act(DSpaceLocaleAction.java:109) > at > org.apache.cocoon.sitemap.impl.DefaultExecutor.invokeAction(DefaultExecutor.java:55) > at > org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:105) > ... 64 more > Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 > refused. Check that the hostname and port are correct and that the > postmaster is accepting TCP/IP connections. > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:247) > at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) > at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) > at org.postgresql.Driver.makeConnection(Driver.java:452) > at org.postgresql.Driver.connect(Driver.java:254) > at > org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) > at > org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256) > at > org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:868) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363) > at > org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) > at > org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) > at > org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) > at > org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:301) > at > org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214) > ... 84 more > Caused by: java.net.ConnectException: Connection refused (Connection > refused) > at java.net.PlainSocketImpl.socketConnect(Native Method) > at > java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) > at > java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > at java.net.Socket.connect(Socket.java:607) > at org.postgresql.core.PGStream.<init>(PGStream.java:69) > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:158) > ... 98 more > > Any help will be appreciated to lead me what to look at. Thanks, cheers > and have a nice day! > > -- > All messages to this mailing list should adhere to the DuraSpace Code of > Conduct: https://duraspace.org/about/policies/code-of-conduct/ > --- > You received this message because you are subscribed to the Google Groups > "DSpace Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-community/828a70be-600f-4ac6-b11e-c74be72db756%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-community/828a70be-600f-4ac6-b11e-c74be72db756%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/CAHJt4A56h59Tu5v%3DDmbvMpN4zO-SUrmNOSpsw5qH_JxPHsmNgA%40mail.gmail.com.
