ansible-collections/community.mysql (community.mysql)
### [`v3.10.0`](https://togithub.com/ansible-collections/community.mysql/blob/HEAD/CHANGELOG.rst#v3100)
[Compare Source](https://togithub.com/ansible-collections/community.mysql/compare/3.9.0...3.10.0)
\=======
## Release Summary
This is a minor release of the `community.mysql` collection.
This changelog contains all changes to the modules and plugins in this
collection that have been made after the previous release.
## Minor Changes
- mysql_info - Add `tls_requires` returned value for the `users_info` filter ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)).
- mysql_info - return a database server engine used ([https://github.com/ansible-collections/community.mysql/issues/644](https://togithub.com/ansible-collections/community.mysql/issues/644)).
- mysql_replication - Adds support for `CHANGE REPLICATION SOURCE TO` statement ([https://github.com/ansible-collections/community.mysql/issues/635](https://togithub.com/ansible-collections/community.mysql/issues/635)).
- mysql_replication - Adds support for `SHOW BINARY LOG STATUS` and `SHOW BINLOG STATUS` on getprimary mode.
- mysql_replication - Improve detection of IsReplica and IsPrimary by inspecting the dictionary returned from the SQL query instead of relying on variable types. This ensures compatibility with changes in the connector or the output of SHOW REPLICA STATUS and SHOW MASTER STATUS, allowing for easier maintenance if these change in the future.
- mysql_user - Add salt parameter to generate static hash for `caching_sha2_password` and `sha256_password` plugins.
## Breaking Changes / Porting Guide
- collection - support of mysqlclient connector is deprecated - use PyMySQL connector instead! We will stop testing against it in collection version 4.0.0 and remove the related code in 5.0.0 ([https://github.com/ansible-collections/community.mysql/issues/654](https://togithub.com/ansible-collections/community.mysql/issues/654)).
- mysql_info - The `users_info` filter returned variable `plugin_auth_string` contains the hashed password and it's misleading, it will be removed from community.mysql 4.0.0. Use the `plugin_hash_string` return value instead ([https://github.com/ansible-collections/community.mysql/pull/629](https://togithub.com/ansible-collections/community.mysql/pull/629)).
## Bugfixes
- mysql_info - Add `plugin_hash_string` to `users_info` filter's output. The existing `plugin_auth_string` contained the hashed password and thus is missleading, it will be removed from community.mysql 4.0.0. ([https://github.com/ansible-collections/community.mysql/pull/629](https://togithub.com/ansible-collections/community.mysql/pull/629)).
- mysql_user - Added a warning to update_password's on_new_username option if multiple accounts with the same username but different passwords exist ([https://github.com/ansible-collections/community.mysql/pull/642](https://togithub.com/ansible-collections/community.mysql/pull/642)).
- mysql_user - Fix `tls_requires` not removing `SSL` and `X509` when sets as empty ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)).
- mysql_user - Fix idempotence when using variables from the `users_info` filter of `mysql_info` as an input ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)).
- mysql_user - Fixed an IndexError in the update_password functionality introduced in PR [https://github.com/ansible-collections/community.mysql/pull/580](https://togithub.com/ansible-collections/community.mysql/pull/580) and released in community.mysql 3.8.0. If you used this functionality, please avoid versions 3.8.0 to 3.9.0 ([https://github.com/ansible-collections/community.mysql/pull/642](https://togithub.com/ansible-collections/community.mysql/pull/642)).
- mysql_user - add correct `ed25519` auth plugin handling ([https://github.com/ansible-collections/community.mysql/issues/6](https://togithub.com/ansible-collections/community.mysql/issues/6)).
- mysql_variables - fix the module always changes on boolean values ([https://github.com/ansible-collections/community.mysql/issues/652](https://togithub.com/ansible-collections/community.mysql/issues/652)).
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR contains the following updates:
3.9.0->3.10.0Release Notes
ansible-collections/community.mysql (community.mysql)
### [`v3.10.0`](https://togithub.com/ansible-collections/community.mysql/blob/HEAD/CHANGELOG.rst#v3100) [Compare Source](https://togithub.com/ansible-collections/community.mysql/compare/3.9.0...3.10.0) \======= ## Release Summary This is a minor release of the `community.mysql` collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release. ## Minor Changes - mysql_info - Add `tls_requires` returned value for the `users_info` filter ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)). - mysql_info - return a database server engine used ([https://github.com/ansible-collections/community.mysql/issues/644](https://togithub.com/ansible-collections/community.mysql/issues/644)). - mysql_replication - Adds support for `CHANGE REPLICATION SOURCE TO` statement ([https://github.com/ansible-collections/community.mysql/issues/635](https://togithub.com/ansible-collections/community.mysql/issues/635)). - mysql_replication - Adds support for `SHOW BINARY LOG STATUS` and `SHOW BINLOG STATUS` on getprimary mode. - mysql_replication - Improve detection of IsReplica and IsPrimary by inspecting the dictionary returned from the SQL query instead of relying on variable types. This ensures compatibility with changes in the connector or the output of SHOW REPLICA STATUS and SHOW MASTER STATUS, allowing for easier maintenance if these change in the future. - mysql_user - Add salt parameter to generate static hash for `caching_sha2_password` and `sha256_password` plugins. ## Breaking Changes / Porting Guide - collection - support of mysqlclient connector is deprecated - use PyMySQL connector instead! We will stop testing against it in collection version 4.0.0 and remove the related code in 5.0.0 ([https://github.com/ansible-collections/community.mysql/issues/654](https://togithub.com/ansible-collections/community.mysql/issues/654)). - mysql_info - The `users_info` filter returned variable `plugin_auth_string` contains the hashed password and it's misleading, it will be removed from community.mysql 4.0.0. Use the `plugin_hash_string` return value instead ([https://github.com/ansible-collections/community.mysql/pull/629](https://togithub.com/ansible-collections/community.mysql/pull/629)). ## Bugfixes - mysql_info - Add `plugin_hash_string` to `users_info` filter's output. The existing `plugin_auth_string` contained the hashed password and thus is missleading, it will be removed from community.mysql 4.0.0. ([https://github.com/ansible-collections/community.mysql/pull/629](https://togithub.com/ansible-collections/community.mysql/pull/629)). - mysql_user - Added a warning to update_password's on_new_username option if multiple accounts with the same username but different passwords exist ([https://github.com/ansible-collections/community.mysql/pull/642](https://togithub.com/ansible-collections/community.mysql/pull/642)). - mysql_user - Fix `tls_requires` not removing `SSL` and `X509` when sets as empty ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)). - mysql_user - Fix idempotence when using variables from the `users_info` filter of `mysql_info` as an input ([https://github.com/ansible-collections/community.mysql/pull/628](https://togithub.com/ansible-collections/community.mysql/pull/628)). - mysql_user - Fixed an IndexError in the update_password functionality introduced in PR [https://github.com/ansible-collections/community.mysql/pull/580](https://togithub.com/ansible-collections/community.mysql/pull/580) and released in community.mysql 3.8.0. If you used this functionality, please avoid versions 3.8.0 to 3.9.0 ([https://github.com/ansible-collections/community.mysql/pull/642](https://togithub.com/ansible-collections/community.mysql/pull/642)). - mysql_user - add correct `ed25519` auth plugin handling ([https://github.com/ansible-collections/community.mysql/issues/6](https://togithub.com/ansible-collections/community.mysql/issues/6)). - mysql_variables - fix the module always changes on boolean values ([https://github.com/ansible-collections/community.mysql/issues/652](https://togithub.com/ansible-collections/community.mysql/issues/652)).Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR was generated by Mend Renovate. View the repository job log.