Tech note - legacy key algorithm constraints

If you're running Matillion ETL on version 1.69 or later and have encountered issues with algorithm constraints when using a legacy key to connect to an SQL server, we advise the following workaround.

1. SSH into your Matillion ETL instance and locate the file etc/sysconfig/tomcat.

2. Locate the JAVA_OPTS and add the following line:

   -Djava.security.disableSystemPropertiesFile=true -Djdk.certpath.disabledAlgorithms=\"MD2, MD5, DSA, RSA keySize < 1024\"
   

3. Save and close the file.

4. Restart Tomcat:

   systemctl restart tomcat