keycloak 4.3 version How to connect to database using SSL protocol when using mysql database?

70 views
Skip to first unread message

Eric Jones

unread,
Dec 14, 2023, 8:53:04 AM12/14/23
to Keycloak User
Hi,
   This is my current environment variable configuration:
    export KEYCLOAK_INSTALL_MODE=standalone
    export KEYCLOAK_DB_VENDOR=mysql

    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?


Reply all
Reply to author
Forward
0 new messages