CHANGELOG.rst

Community MySQL Collection Release Notes

Topics

v1.5.1

Release Summary

Final maintenance release of community.mysql major version 1.

Major Changes

• The community.mysql 1.x.y release stream is now effectively End of Life. No more releases will be made. This follows the decision to support each major release for two years. This decision stems from this discussion (#537)

v1.5.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 connector_name and connector_version to returned values (#497).

v1.4.8

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.7.

Bugfixes

• Include simplified_bsd.txt license file for various module utils.

v1.4.7

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.6.

Bugfixes

• mysql_query - fix false change reports when IF EXISTS/IF NOT EXISTS clause is used (#268).
• mysql_user - fix logic when update_password is set to on_create for users using plugin* arguments (#334). The on_create sets password to None for old mysql_native_authentication but not for authentiation methods which uses the plugin* arguments. This PR changes this so on_create also exchange plugin, plugin_hash_string, plugin_auth_string to None in the list of arguments to change

v1.4.6

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.5.

Bugfixes

• Include PSF-license.txt file for plugins/module_utils/_version.py.

v1.4.5

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.4.

Major Changes

• The community.mysql collection no longer supports Ansible 2.9 and ansible-base 2.10. While we take no active measures to prevent usage and there are no plans to introduce incompatible code to the modules, we will stop testing against Ansible 2.9 and ansible-base 2.10. Both will very soon be End of Life and if you are still using them, you should consider upgrading to the latest Ansible / ansible-core 2.11 or later as soon as possible (#343).

Bugfixes

• mysql_user - fix missing dynamic privileges after revoke and grant privileges to user (#120).
• mysql_user - fix parsing privs when a user has roles assigned (#231).
• mysql_user - fix the possibility for a race condition that breaks certain (circular) replication configurations when DROP USER is executed on multiple nodes in the replica set. Adding IF EXISTS avoids the need to use sql_log_bin: no making the statement always replication safe (#287).

v1.4.4

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.3.

Bugfixes

• Collection core functions - use vendored version of distutils.version instead of the deprecated Python standard library distutils (#269).

v1.4.3

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.2.

Bugfixes

• mysql_info - fix TypeError failure when there are databases that do not contain tables (#204).

v1.4.2

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.1.

Minor Changes

• mysql_query - correctly reflect changed status in replace statements (#193).

v1.4.1

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.4.0.

Bugfixes

• mysql - revert changes of connector arguments made in pull request 116 causing the invalid keyword argument error (#116).

v1.4.0

Release Summary

This is the minor release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.3.0.'

Major Changes

• mysql_user - the REQUIRESSL is an alias for the ssl key in the tls_requires option in community.mysql 2.0.0 and support will be dropped altogether in community.mysql 3.0.0 (#121).

Minor Changes

• mysql module utils - change deprecated connection parameters passwd and db to password and database (#116).
• mysql_collection - introduce codebabse split to handle divergences between MySQL and MariaDB (#103).
• mysql_info - add version.full and version.suffix return values (#114).
• mysql_user - deprecate the REQUIRESSL privilege (#101).

Bugfixes

• mysql_user - add support for REPLICA MONITOR privilege (#105).

v1.3.0

Release Summary

This is the minor release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.2.0.

Major Changes

• mysql_replication - the mode options values getslave, startslave, stopslave, resetslave, resetslaveall` and the master_use_gtid optionslave_posare deprecated (see the alternative values) and will be removed incommunity.mysql`` 3.0.0 (#97).
• mysql_replication - the word SLAVE in messages returned by the module will be changed to REPLICA in community.mysql 2.0.0 (#98).

Minor Changes

• mysql_replication - deprecate offending terminology, add alternative choices to the mode option (#78).

Bugfixes

• mysql_user - fix handling of INSERT, UPDATE, REFERENCES on columns (#106).
• mysql_user - the module is not idempotent when SELECT on columns granted (#99).

v1.2.0

Release Summary

This is the minor release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.1.2.

Minor Changes

• mysql_user - refactor to reduce cursor.execute() calls in preparation for adding query logging (#76).

Bugfixes

• mysql_user - add SHOW_ROUTINE privilege support (#86).
• mysql_user - fixed creating user with encrypted password in MySQL 8.0 (#79).

v1.1.2

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.1.1.

Minor Changes

• mysql_query - simple refactoring of query type check (#58).
• mysql_user - simple refactoring of priv type check (#58).

Bugfixes

• mysql_db - fix false warning related to unsafe_login_password option (#33).
• mysql_replication - fix crashes of mariadb >= 10.5.1 and mysql >= 8.0.22 caused by using deprecated terminology (#70).
• mysql_user - fixed change detection when using append_privs (#72).

v1.1.1

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.1.0.

Bugfixes

• mysql_query - fix failing when single-row query contains commas (#51).

v1.1.0

Release Summary

This is the minor release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.0.2.

Minor Changes

• mysql modules - add the check_hostname option (#28).
• mysql modules - patch the Connection class to add a destructor that ensures connections to the server are explicitly closed (#44).

Bugfixes

• mysql modules - fix crash when !includedir option is in config file (#46).

v1.0.2

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.0.1.

Bugfixes

• mysql_user - fix module's crash when modifying a user with host_all (#39).

v1.0.1

Release Summary

This is the patch release of the community.mysql collection. This changelog contains all changes to the modules in this collection that have been added after the release of community.mysql 1.0.0.

Bugfixes

• mysql_db - fix false warning related to unsafe_login_password option (#33).
• mysql_user - added tests to verify that TLS requirements are removed with an empty tls_requires option (#20).
• mysql_user - correct procedure to check existing TLS requirements (#26).
• mysql_user - minor syntax fixes (#26).

v1.0.0

Release Summary

This is the first proper release of the community.mysql collection. This changelog contains all changes to the modules in this collection that were added after the release of Ansible 2.9.0.

Minor Changes

• mysql_db - add master_data parameter (ansible/ansible#66048).
• mysql_db - add skip_lock_tables option (ansible/ansible#66688).
• mysql_db - add the check_implicit_admin parameter (ansible/ansible#24418).
• mysql_db - add the dump_extra_args parameter (ansible/ansible#67747).
• mysql_db - add the executed_commands returned value (ansible/ansible#65498).
• mysql_db - add the force parameter (ansible/ansible#65547).
• mysql_db - add the restrict_config_file parameter (ansible/ansible#34488).
• mysql_db - add the unsafe_login_password parameter (ansible/ansible#63955).
• mysql_db - add the use_shell parameter (ansible/ansible#20196).
• mysql_info - add exclude_fields parameter (ansible/ansible#63319).
• mysql_info - add global_status filter parameter option and return (ansible/ansible#63189).
• mysql_info - add return_empty_dbs parameter to list empty databases (ansible/ansible#65727).
• mysql_replication - add channel parameter (ansible/ansible#29311).
• mysql_replication - add connection_name parameter (ansible/ansible#46243).
• mysql_replication - add fail_on_error parameter (ansible/ansible#66252).
• mysql_replication - add master_delay parameter (ansible/ansible#51326).
• mysql_replication - add master_use_gtid parameter (ansible/ansible#62648).
• mysql_replication - add queries return value (ansible/ansible#63036).
• mysql_replication - add support of resetmaster choice to mode parameter (ansible/ansible#42870).
• mysql_user - priv parameter can be string or dictionary (ansible/ansible#57533).
• mysql_user - add TLS REQUIRES parameters (#9).
• mysql_user - add plugin_auth_string parameter (ansible/ansible#44267).
• mysql_user - add plugin_hash_string parameter (ansible/ansible#44267).
• mysql_user - add plugin parameter (ansible/ansible#44267).
• mysql_user - add the resource_limits parameter (ansible-collections/community.general#133).
• mysql_variables - add mode parameter (ansible/ansible#60119).

Bugfixes

• mysql - dont mask mysql_connect function errors from modules (ansible/ansible#64560).
• mysql_db - fix Broken pipe error appearance when state is import and the target file is compressed (ansible/ansible#20196).
• mysql_db - fix bug in the db_import function introduced by ansible/ansible#56721 (ansible/ansible#65351).
• mysql_info - add parameter for __collect to get only what are wanted (ansible-collections/community.general#136).
• mysql_replication - allow to pass empty values to parameters (ansible/ansible#23976).
• mysql_user - Fix idempotence when long grant lists are used (ansible/ansible#68044)
• mysql_user - Remove false positive no_log warning for update_password option
• mysql_user - add INVOKE LAMBDA privilege support (ansible-collections/community.general#283).
• mysql_user - add missed privileges to support (ansible-collections/community.general#617).
• mysql_user - fix host_all arguments conversion string formatting error (ansible/ansible#29644).
• mysql_user - fix overriding password to the same (ansible-collections/community.general#543).
• mysql_user - fix support privileges with underscore (ansible/ansible#66974).
• mysql_user - fix the error No database selected (ansible/ansible#68070).
• mysql_user - make sure current_pass_hash is a string before using it in comparison (ansible/ansible#60567).
• mysql_variable - fix the module doesn't support variables name with dot (ansible/ansible#54239).