WARN: Establishing SSL connection without server's identity verification is not recommended

[Антон_Воробьв]

In the default instalation jira-core I see in log catalina.out next:

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

In which configuration file to register the option "useSSL= alse"?

[kevin]

These answers are all about how to modify dbconfig.xml

But my question was thrown when I initialized the page.

At this time, the dbconfig.xml file has not been generated. 

I tried to create the dbconfig.xml file manually.

Still can't pass the verification of initialization page.

[王林林]

After adding useSSL, it does not take effect. Is there an updated processing method

[Michael Aglas]

except that warning is there any degredation of the tool? a functionality not working or so?

[Richard Cross]

If you get that warning during the setup phase, it won't proceed to configure the database, which is a pretty severe degradation of functionality.   ;-)

[Антон_Воробьв]

edit config - /var/atlassian/application-data/jira/dbconfig.xml

in line 

<url>jdbc:mysql://localhost:3306/jiradb?useUnicode=true&amp;useSSL=false&amp;characterEncoding=UTF8&amp;sessionVariables=default_storage_engine=InnoDB</url>

add useSSL=false&amp;

[Nirmani K]

@Антон_Воробьв add Where?

[Omar Malavé]

Hi @Nirmani K add it at the end of the url

[warm qing]

<url> jdbc：mysql：// address =（protocol = tcp）（host = 127.0.0.1）（port = 3306）/ jira？sessionVariables = default_storage_engine = InnoDB useSSL = false＆amp </ url>

Is it here ?

[Richard Cross]

But what if you're getting this error while attempting to set up Jira and connect it to a database for the first time?

[Benmway]

@Richard Cross I have the same issue when starting jira 8.10 with mysql 5.7. Where you able to fix this?

[Richard Cross]

Only by ditching MySQL 5.7 and using PostgreSQL instead.  :-)

[Varma Gadiraju]

You need to add "useSSL=false&amp;" this parameters in the dbconfig file.

Example: <url>jdbc:mysql://localhost:3003/jiradatabase?useUnicode=true&amp;"---ADD HERE---"characterEncoding=UTF8&amp;sessionVariables=default_storage_engine=InnoDB</url>

[Derek Mart]

MySQL - 5.7.31 / mysql-connector-java-5.1.48

Added (useSSL=false) in the connector url:

<url>jdbc:mysql://address=(useSSL=false)(protocol=tcp)...