Confluence mysql ssl连接异常

2022-12-30

confluence存储空间与内存空间满
清理后启动出现以下报错:

** BEGIN NESTED EXCEPTION **

javax.net.ssl.SSLException
MESSAGE: closing inbound before receiving peer's close_notify

STACKTRACE:

javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify
	at java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
	at java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
	at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
	at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
	at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.shutdownInput(Unknown Source)
	at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:2249)
	at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4221)
	at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1464)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:642)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:255)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:622)
	at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1114)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)^C


** END NESTED EXCEPTION **

mysql5.7默认开启了ssl认证,手动关闭即可。
临时修复,未深入研究

编辑 /var/atlassian/application-data/confluence/confluence.cfg.xml
jdbcurl后方添加参数?useSSL=false

修改前

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/confluence</property>

修改后

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