export KEYCLOAK_DB_HOST=test.mysql.db.host
export KEYCLOAK_DB_PORT=3306
export KEYCLOAK_DB_NAME=keycloak
export KEYCLOAK_DB_USER=keycloak
export KEYCLOAK_DB_PASS=keycloak
He will generate the contents of mysql-related configuration files:
<datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://test.mysql.db.host:13306/keycloak?useSSL=false</connection-url>
<driver>mysql</driver>
<pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>1000</max-pool-size>
<prefill>false</prefill>
<flush-strategy>IdleConnections</flush-strategy>
</pool>
<security>
<user-name>keycloak</user-name>
<password>keycloak</password>
</security>
<validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<background-validation>false</background-validation>
<background-validation-millis>60000</background-validation-millis>
</validation>
<timeout>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
</datasource>
I can see that the useSSL in the mysql url is always false, how do I set it so that it becomes true?