confluence8.5.8部署踩坑记录

1.数据库连接报错

 checkStorageEngineType Your database Storage Engine could not be determined: Communications link failure\n\nThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:172)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at com.atlassian.confluence.impl.util.db.SingleConnectionDatabaseHelper.getConnection(SingleConnectionDatabaseHelper.java:49)
        at com.atlassian.confluence.setup.dbcheck.MySQLChecker.checkStorageEngineType(MySQLChecker.java:81)
        at com.atlassian.confluence.setup.dbcheck.MySQLChecker.verifyDatabaseSetup(MySQLChecker.java:44)
        at com.atlassian.confluence.setup.DefaultBootstrapManager.checkConfigurationOnStartup(DefaultBootstrapManager.java:759)
        at com.atlassian.confluence.impl.setup.DelegatingBootstrapConfigurer.checkConfigurationOnStartup(DelegatingBootstrapConfigurer.java:47)
        at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.checkConfigurationOnStartup(BootstrapApplicationStartupListener.java:23)
        at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.onApplicationEvent(BootstrapApplicationStartupListener.java:18)
        at com.atlassian.confluence.setup.BootstrapApplicationStartupListener.onApplicationEvent(BootstrapApplicationStartupListener.java:13)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:178)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:171)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:145)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:429)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:435)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:386)
        at com.atlassian.spring.container.SpringContainerContext.contextReloaded(SpringContainerContext.java:164)
        at com.atlassian.spring.container.ContainerContextLoaderListener.contextInitialized(ContainerContextLoaderListener.java:40)
        at com.atlassian.confluence.setup.ConfluenceBootstrappedContextLoaderListener.contextInitialized(ConfluenceBootstrappedContextLoaderListener.java:40)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4460)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4914)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1332)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1322)
        at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.base/java.lang.Thread.run(Unknown Source)

1.确认mysql配置文件中关闭ssl,配置文件一般在/etc/my.cnf
[mysqld]
ssl=0

2.如果数据库和confluence部署在同一台服务器上,确认confluence.cfg.xml配置文件中的connection.url
初始化的时候填的外网ip没有报错,第二天一看莫名其妙confluence服务炸了,查看日志数据库连接超时,
最后折腾了半天把url中的ip地址改成127.0.0.1之后重启confluence服务, 启动成功。

  <property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/confluence?useSSL=false</property>

2.缺少索引配置

lucene.index.dir property has not been defined

确认confluence.cfg.xml中是否有如下配置

   <property name="lucene.index.dir">${localHome}/index</property>

没有的话加上后重启confluence服务, 再进入网页重新配置数据库。