Confluence Can't reach database server or port

Zhi Tian Liao

Hello

When I set confluence to connect mysql, it shows me this below error:

 

both Mysql and confluence are installed by docker in a same server, and set mysql with port 3307(docker run -p 3307:3306)

I have create DB confluence with "grant all" user confluence1 and pw 54321.

and set wait_timeout = 600 in my.cnf but still no use

 

Does anyone have ideas about it?

Thank you.

 

 

Manisha Kharga _Appfire_

Hi @Zhi Tian Liao 

The communication link between the driver and the data source to which the driver was attempting to connect failed before the function completed processing. So usually its a network error.

Can you please try to create the database connection using the Connection string option.

Follow the below details and replace the value based on your instance.

Connection string: jdbc:mysql://[Host IP or DNS]:[PORT]/[Database Name]?sessionVariables=tx_isolation='READ-COMMITTED'

Driver class: com.mysql.jdbc.Driver

Driver JAR location: atlassian-confluence/lib/mysql-connector-java-5.1.48.jar

Username:XXX

Password:XXX

 

Thanks,
Manisha