Deploy xwiki using Docker with an existing MySQL service

Help / Discuss
,
#1

Today, I tried to deploy xwiki by Docker,
And because I have an existing MySQL 8 Service already, So I did NOT follow https://github.com/xwiki/xwiki-docker#introduction to create an docker network and deploy a xwiki specified MySQL service by Docker first, just created a xwiki database and the xwiki user, then use the following command to create xwiki container.

docker run -d --name xwiki --restart always \
    -h xwiki \
    -p 30010:8080 \
    -e DB_USER=xwiki \
    -e DB_PASSWORD=mypassword \
    -e DB_DATABASE=xwiki \
    -e DB_HOST=192.168.1.2:30006 \
    -v /home/me/docker-data/xwiki:/usr/local/xwiki \
    -v /etc/localtime:/etc/localtime \
    xwiki:13.10.7

But, the error below showed as xwiki container init.

Caused by: java.sql.SQLException: Connections using insecure transport are prohibited while --require_secure_transport=ON.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)
	at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:106)
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)
	... 50 common frames omitted

Someone can tell me how can I create the xwiki container in this situation? Thanks.

P.S.
My existing MySQL 8 Service enabled two options below:

--require-secure-transport=ON
--default-authentication-plugin=mysql_native_password
#2

You’ll need to find how to configure Hibernate to establish a secure connection to your MySQL server (or turn the secure transport to OFF).

See:

Maybe the following is enough:

<property name="hibernate.connection.url">jdbc:mysql://blablaba:8443/dbname?useSSL=true</property>
<property name="hibernate.connection.verifyServerCertificate">false</property>
<property name="hibernate.connection.requireSSL">true</property>
#3

You can edit your hibernate.cfg.xml file in your permanent directory on your host (/home/me/docker-data/xwiki).