如何配置PostgreSQL数据库以在tomcat 8上部署露天？ [英] How to configure PostgreSQL database for deploying alfresco on tomcat 8?

问题描述

我在ubuntu 16.04上从源代码构建了alfresco（版本5.2）。我想在tomcat 8上部署alfresco。部署成功，但是未按要求配置PostgreSQL数据库。我已按照 http://docs.alfresco.com/中给出的步骤进行操作5.1 / tasks / postgresql-config.html

我观察首页为在图片中显示alfresco_page

我在这里遗漏了一些未配置PostgreSQL数据库的信息。还有其他我需要错过的配置吗？

UPDATE

alfresco.log给了我

  2017-08-01 05：53：54,406警告[org.alfresco。 web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1]似乎未为Tomcat设置clientAuth。 X509身份验证
的clientAuth必须设置为'want'2017-08-01 05：53：54,416 WARN [org.alfresco.web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1]尝试设置clientAuth =想要通过JMX ... 
 2017-08-01 05：53：54,427 WARN [org.alfresco.web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1]无法设置clientAuth =想要通过JMX 。 
 2017-08-01 05：53：55,139错误[org.apache.solr.core.CoreContainer] [coreLoadExecutor-5-thread-1]创建核心[collection1]时出错：无法为核心collection1加载conf：从solr / collection1 / conf / solrconfig.xml 
 org.apache.solr.common.SolrException加载solr配置时出错：无法为核心集合加载conf1：从solr / collection1 / conf / solrconfig.xml加载solr配置时出错
在org.apache.solr.core.ConfigSetService.getConfig（ConfigSetService.java:66）
在org.apache.solr.core.CoreContainer.create（CoreContainer.java:489）
在org.apache.solr.core.CoreContainer $ 1.call（CoreContainer.java:255）
在org.apache.solr.core.CoreContainer $ 1.call（CoreContainer.java:249）
在java .util.concurrent.FutureTask.run（FutureTask.java:266）
 at java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1149）
 at java.util.concurrent.ThreadPoolExecutor $ Worker .run（ThreadPoolExecutor.java:624） 
在java.lang.Thread.run（Thread.java:748）
由以下原因引起：org.apache.solr.common.SolrException：从solr / collection1 / conf / solrconfig.xml加载solr配置时出错org.apache.solr.core.SolrConfig.readFromResourceLoader（SolrConfig.java:154）的
 org.apache.solr.core.ConfigSetService.createSolrConfig（ConfigSetService.java:80）的
在org.apache.solr.core.ConfigSetService.getConfig（ConfigSetService.java:61）
 ...另外7个
原因：java.io.IOException：找不到资源'solrconfig.xml在classpath或'/ root / tomcat85 / output / build / webapps / solr / collection1 / conf'中的
在org.apache.solr.core.SolrResourceLoader.openResource（SolrResourceLoader.java:362）
在org.apache.solr.core.Config。org.apache.solr.core.SolrResourceLoader.openConfig（SolrResourceLoader.java:308）
.org（org.apache.solr.core.Config.config.java:117）
 .apache.solr.core.Config。< init>（Config.java:87）
在org.apache.so lr.core.SolrConfig。< init>（SolrConfig.java:167）
在org.apache.solr.core.SolrConfig.readFromResourceLoader（SolrConfig.java:145）
 ...另外9个
 2017-08-01 05：54：09,634警告[org.hibernate.cfg.SettingsFactory] ​​[localhost-startStop-1]无法获取连接元数据
 org.apache.commons.dbcp.SQLNestedException：无法创建PoolableConnectionFactory（连接被拒绝。检查主机名和端口是否正确以及邮局主管正在接受TCP / IP连接。）
在org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory（BasicDataSource.java:1549）
在组织。 apache.commons.dbcp.BasicDataSource.createDataSource（BasicDataSource.java:1388）
在org.apache.commons.dbcp.BasicDataSource.getConnection（BasicDataSource.java:1044）
在org.springframework.orm。 hibernate3.LocalDataSourceConnectionProvider.getConnection（LocalDataSourceConnectionProvider.java:83）
在org.hibernate.cfg.SettingsFactory.buildSettings（SettingsFactory.java:84）
在org.hibernate.cfg.Configuration.buildSettings（Configuration。 java：2079）org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1304）
 org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory（LocalSessionFactoryBean.java:863）
在org.springframework.orm.hiberna te3.LocalSessionFactoryBean.buildSessionFactory（LocalSessionFactoryBean.java:782）
在org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet（AbstractSessionFactoryBean.java:188）
在org.springframework.beans.factory.support。 AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1573）
在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1511）
  

解决方案

要检查的内容：

1. postgres是否正在运行（ps -ef | grep postgres）？


2. 可以使用psql通过在露天环境中配置的db.name，db.username和db.password连接到postgres吗？ -global.properties？


3. 您是否按照文档中有关编辑pg_hba.conf的步骤进行操作，以确保将postgres配置为允许基于密码的身份验证？





此外，除非您对低级类本身进行更改，否则从源代码构建Alfresco的情况极为罕见。




I have built alfresco(version 5.2) from source on ubuntu 16.04. I want to deploy alfresco on tomcat 8. The deployment is successful however the PostgreSQL database is not getting configured as required. I have followed the steps as given in http://docs.alfresco.com/5.1/tasks/postgresql-config.html

I observe the home page as given in image alfresco_page

Am I missing onto something here that the PostgreSQL database is not getting configured. Is there any other configuration that needs to be done that I have missed ?

UPDATE

The alfresco.log gave me this

2017-08-01 05:53:54,406 WARN  [org.alfresco.web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1] clientAuth does not appear to be set for Tomcat. clientAuth must be set to 'want' for X509 Authentication
2017-08-01 05:53:54,416 WARN  [org.alfresco.web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1] Attempting to set clientAuth=want through JMX...
2017-08-01 05:53:54,427 WARN  [org.alfresco.web.scripts.servlet.X509ServletFilterBase] [localhost-startStop-1] Unable to set clientAuth=want through JMX.
2017-08-01 05:53:55,139 ERROR [org.apache.solr.core.CoreContainer] [coreLoadExecutor-5-thread-1] Error creating core [collection1]: Could not load conf for core collection1: Error loading solr config from solr/collection1/conf/solrconfig.xml
org.apache.solr.common.SolrException: Could not load conf for core collection1: Error loading solr config from solr/collection1/conf/solrconfig.xml
        at org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:66)
        at org.apache.solr.core.CoreContainer.create(CoreContainer.java:489)
        at org.apache.solr.core.CoreContainer$1.call(CoreContainer.java:255)
        at org.apache.solr.core.CoreContainer$1.call(CoreContainer.java:249)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.solr.common.SolrException: Error loading solr config from solr/collection1/conf/solrconfig.xml
        at org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:154)
        at org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:80)
        at org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:61)
        ... 7 more
Caused by: java.io.IOException: Can't find resource 'solrconfig.xml' in classpath or '/root/tomcat85/output/build/webapps/solr/collection1/conf'
        at org.apache.solr.core.SolrResourceLoader.openResource(SolrResourceLoader.java:362)
        at org.apache.solr.core.SolrResourceLoader.openConfig(SolrResourceLoader.java:308)
        at org.apache.solr.core.Config.<init>(Config.java:117)
        at org.apache.solr.core.Config.<init>(Config.java:87)
        at org.apache.solr.core.SolrConfig.<init>(SolrConfig.java:167)
        at org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:145)
        ... 9 more
2017-08-01 05:54:09,634 WARN  [org.hibernate.cfg.SettingsFactory] [localhost-startStop-1] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
        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 org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:83)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:863)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:782)
        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:188)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)

解决方案

Things to check:

1. Is postgres running (ps -ef|grep postgres)?
2. Can you use psql to connect to postgres using the db.name, db.username, and db.password that are configured in alfresco-global.properties?
3. Did you follow the step in the docs about editing pg_hba.conf to make sure that postgres is configured to allow password based authentication?

Also, it is exceedingly rare to need to build Alfresco from source unless you are making changes to the low-level classes themselves, which is not recommended.

这篇关于如何配置PostgreSQL数据库以在tomcat 8上部署露天？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！