You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by GitBox <gi...@apache.org> on 2022/08/17 00:59:28 UTC
[GitHub] [nifi] exceptionfactory opened a new pull request, #6306: NIFI-10358 Update CaptureChangeMySQL to use SSL JDBC properties
exceptionfactory opened a new pull request, #6306:
URL: https://github.com/apache/nifi/pull/6306
# Summary
[NIFI-10358](https://issues.apache.org/jira/browse/NIFI-10358) Updates the `CaptureChangeMySQL` Processor apply `SSL Mode` and `SSL Context Service` configuration settings to the enrichment JDBC connection.
In addition to the primary binary log connection, the `CaptureChangeMySQL` Processor maintains a secondary JDBC connection to the MySQL server when configured with a `Distributed Map Cache Client` to provide schema information.
Recent versions of the MySQL Connector for Java attempt to negotiate a TLS connection in the default configuration, based on MySQL server support for TLS. MySQL JDBC Driver versions prior to 8.0.28 have TLS 1.0 and TLS 1.1 enabled, which can result in connection attempts throwing an `SSLException` when running Apache NiFi on versions of Java that disable those deprecated TLS protocol versions.
In addition to TLS protocol negotiation issues, the `CaptureChangeMySQL` Processor does not support the option to configure JDBC connection properties. Updating the Processor to set MySQL JDBC connection properties based on the `SSL Mode` selected provides a more intuitive configuration and improves support for TLS negotiation using certificates issued by private certificate authorities.
The implementation leverages several [MySQL Connector Security Properties](https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-connp-props-security.html) that have been deprecated, but remain supported. This approach enables compatibility with a wide range of MySQL JDBC Driver versions.
# Tracking
Please complete the following tracking steps prior to pull request creation.
### Issue Tracking
- [X] [Apache NiFi Jira](https://issues.apache.org/jira/browse/NIFI) issue created
### Pull Request Tracking
- [X] Pull Request title starts with Apache NiFi Jira issue number, such as `NIFI-00000`
- [X] Pull Request commit message starts with Apache NiFi Jira issue number, as such `NIFI-00000`
### Pull Request Formatting
- [X] Pull Request based on current revision of the `main` branch
- [X] Pull Request refers to a feature branch with one commit containing changes
# Verification
Please indicate the verification steps performed prior to pull request creation.
### Build
- [X] Build completed using `mvn clean install -P contrib-check`
- [X] JDK 8
- [X] JDK 11
- [X] JDK 17
### Licensing
- [ ] New dependencies are compatible with the [Apache License 2.0](https://apache.org/licenses/LICENSE-2.0) according to the [License Policy](https://www.apache.org/legal/resolved.html)
- [ ] New dependencies are documented in applicable `LICENSE` and `NOTICE` files
### Documentation
- [ ] Documentation formatting appears as expected in rendered files
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@nifi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [nifi] mattyb149 closed pull request #6306: NIFI-10358 Update CaptureChangeMySQL to use SSL JDBC properties
Posted by GitBox <gi...@apache.org>.
mattyb149 closed pull request #6306: NIFI-10358 Update CaptureChangeMySQL to use SSL JDBC properties
URL: https://github.com/apache/nifi/pull/6306
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@nifi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [nifi] mattyb149 commented on pull request #6306: NIFI-10358 Update CaptureChangeMySQL to use SSL JDBC properties
Posted by GitBox <gi...@apache.org>.
mattyb149 commented on PR #6306:
URL: https://github.com/apache/nifi/pull/6306#issuecomment-1218230875
+1 LGTM, thanks for the improvement! Merging to main
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@nifi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org