topic Re: How to connect to MySQL using SSL? in Alfresco Forum

How to connect to MySQL using SSL?

fabrice7 — Thu, 20 Aug 2020 07:56:30 GMT

Hello,

I am using Alfresco Repository CE with a MariaDB server. I am building my own Docker image based on:

https://hub.docker.com/r/alfresco/alfresco-content-repository-community

mostly by adding the MySQL connector available here:

https://downloads.mariadb.com/Connectors/java/connector-java-2.2.5/mariadb-java-client-2.2.5.jar

I noticed Alfresco can connect to the MariaDB server using an unencrypted connection, but if I require the MariaDB user to use SSL, Alfresco can't connect to MariaDB anymore.

Is it possible to configure Alfresco/MariaDB connector to use SSL to connect to the MariaDB server?

Many thanks for any help!

Re: How to connect to MySQL using SSL?

fabrice7 — Thu, 20 Aug 2020 08:48:47 GMT

OK, I found the answer to my own question. You need to add `useSSL=true` to the connection string.

Example:

JAVA_OPTS="... -Ddb.url=\"jdbc:mariadb://$host:$port/$dbname?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useSSL=true\" ..."

Re: How to connect to MySQL using SSL?

EddieMay — Mon, 24 Aug 2020 10:11:41 GMT

Hi @fabrice7

Great that you found the solution & thanks for updating us on how you did it - really useful to other users.

Thanks,