330 commits

This branch

This branch

All branches

Author	SHA1	Message	Date
Andrew Klychkov	725aebf284	feat: Add Dependabot for GitHub Actions (#765)	2025-12-01 09:24:19 +01:00
Laurent Indermühle	131ba9dce3	Update releases EOL (#762)	2025-11-04 14:06:36 +01:00
Laurent Indermühle	0063735b93	[CI] Replace 11.4 with 11.8 (#758) ... This is the new latest LTS.	2025-11-04 11:58:43 +01:00
Laurent Indermühle	bf31d37d23	Add new GPG key for apt repository of MySQL (#759) ... * Add new GPG key for apt repository of MySQL * Fix Oracle pubkey with an extra V at the start and missing newline after the header. * Cut package for unsupported python connector mysqlclient * Update cache to refresh installed GPG keys	2025-11-03 15:18:59 +01:00
Andrew Klychkov	8ce302093b	ci: add stable-2.20 to matrix (#755) ... * ci: add stable-2.20 to matrix * Ensure unit tests - Python compatibility	2025-10-22 07:09:11 +02:00
Andrew Klychkov	3e090f977e	Release 4.0.1 commit (#754) 4.0.1	2025-10-16 11:15:29 +02:00
Andrew Klychkov	5217af0c2e	issue-744: add integration tests (#751)	2025-10-16 10:03:51 +02:00
george2asenov	1cb9f369d0	fix: case when grant options is set with no other user permissions in… (#744) ... * fix: case when grant options is set with no other user permissions in mariadb * Create changelog fragment * fix: wrong file name ext * Update changelogs/fragments/fix_user_perms_revoke_grant_option.yml Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru> --------- Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru>	2025-10-16 09:26:35 +02:00
Luca Keidel	fad6bc7564	mysql_info: Add support for source terminology for slave_status filter (#747) ... * mysql_info: Add support for source terminology for slave_status filter * Update changelogs/fragments/mysql_info_fix_slave_status_for_source_terminology.yaml --------- Co-authored-by: Luca Keidel <luca.keidel@check24.de> Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2025-10-08 10:29:18 +02:00
Stu-ops	f6cec49238	New Contributors Name ADDED (#745)	2025-10-01 15:10:27 +02:00
Andrew Klychkov	c431c70c47	Release 4.0.0 commit (#741) 4.0.0	2025-09-16 14:00:32 +02:00
Andrew Klychkov	7ff58997de	mysql_info: remove plugin_auth_string field from output (#739)	2025-09-16 13:53:00 +02:00
Andrew Klychkov	04b663b3b7	Remove testing against mysqlclient (#736) ... * Remove testing against mysqlclient * Fix * Update TESTING.md	2025-09-16 09:56:04 +02:00
Andrew Klychkov	fed5f30203	mysql_user: column_case_sensitive default is set to true (#737) ... * mysql_user: column_case_sensitive default is set to true * Update plugins/modules/mysql_user.py Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> --------- Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2025-09-16 07:56:19 +02:00
Andrew Klychkov	cafbb9100d	mysql_role: column_case_sensitive default is set to true (#738) ... * mysql_role: column_case_sensitive default is set to true * Update plugins/modules/mysql_role.py Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> --------- Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2025-09-16 07:55:45 +02:00
Andrew Klychkov	7a4f77fea2	Announce dropping Python 2 support (#735) ... * Announce dropping Python 2 support * major -> breaking in changelog	2025-09-16 07:55:08 +02:00
Andrew Klychkov	451f7e617d	mysql_db: change pipefail default as true (#734) ... * mysql_db: change pipefail default as true * Fix CI * major -> breaking in changelog	2025-09-16 07:54:35 +02:00
Andrew Klychkov	96828579ac	Fix CI (#733)	2025-09-15 13:41:41 +02:00
Laurent Indermühle	08257cd4d4	Release 3.16.0 commit (#731) 3.16.0	2025-09-12 17:55:58 +02:00
Richard Burnison	2e0c44f616	Add session_vars to mysql_query. (#729) ... This commit adds a `session_vars` dict to the `mysql_query` plugin, similar to that done in #489. While this could also be done by using a list of queries, having a dictionary allows for a cleaner query, reusability (via merge key), and a more consistent experience when using different plugins (like `mysql_user`, which supports `session_vars`).	2025-09-12 09:05:30 +02:00
Andrew Klychkov	1f9b1a29dd	Release 3.15.0 commit (#725) 3.15.0	2025-07-24 13:38:20 +02:00
Simon Pahl	539e940ab3	Fix python2 compatibility of execution_time_ms (#720) ... Co-authored-by: Simon Pahl <simon.pahl@etops.com>	2025-07-24 13:33:02 +02:00
Yves Heitz	83ad0e81e2	mysql_db: Add support for sql_log_bin option (#723)	2025-07-14 08:38:51 +02:00
Andrew Klychkov	105f9fd1ce	CI: update matrix; copy ignore-2.19.txt to ignore-2.20.txt (#724) ... * CI: update matrix; copy ignore-2.19.txt to ignore-2.20.txt * Update .github/workflows/ansible-test-plugins.yml --------- Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2025-07-14 07:52:16 +02:00
TimKruth02	6f0c0be929	Fix user module for default roles (#718) ... * mysql_user: fix crash when default role is set * tests: add DEFAULT role to user to force the module to fail * Add changelog fragment --------- Co-authored-by: “tkr” <“tim.kruth@wiit.cloud”>	2025-07-08 10:41:38 +02:00
Laurent Indermuehle	67f1460070	Add next expected version	2025-05-23 11:38:52 +02:00
Laurent Indermühle	fa3c72b2c0	Release 3.14.0 commit (#717) 3.14.0	2025-05-23 11:33:43 +02:00
Laurent Indermühle	49be739e89	Fix ssl verification always enabled for replication even if set to false (#707) ... * Fix ssl verification always enabled for replication even if set to false * add changelog fragment * fix test when multiple replication channels are present * test: add check for changereplication * fix mismatch default value We use "None" as a default to know if the user provide this option or not. But a bool can't have a default of "None" for the sanity tests. So we must erase the line. * doc: add var name used by MySQL and MariaDB * Revert the change of default value * style * fix indentation * Revert "Revert the change of default value" This reverts commit db047fda90. * add changelog about changed default value * add link to issue and PR in changelog * doc: explain false had no effect prior to 3.14.0	2025-05-09 11:00:29 +02:00
Joakim Soderlund	7307a51f20	Add action group containing all modules (#704) ... Helpful for setting module defaults. For example, when using the same credentials across multiple tasks while only declaring them once. This change creates the group `community.mysql.all` for that purpose.	2025-05-07 14:32:55 +02:00
Laurent Indermühle	06e23c8ac3	Add query to find command between python and python3 (#715) ... * Add query to find command between python and python3 * Cut extra $	2025-05-06 09:05:41 +02:00
Laurent Indermühle	74ea0438ce	fix mysql_info crash if PUBLIC role is used on MariaDB 10.11+ (#712) ... * tests: grant a privilege to the PUBLIC role to force the module to fail * skip the PUBLIC role from the users migration example * Cut the 3rd matching group as it fails to match roles without quotes The group purpose was to match the closing quotes. We don't need the value after the TO. So we can ignore this entirely. * add MariaDB role detection * Add changelog fragment * doc: add notes that users_info doesn't support MariaDB roles.	2025-04-28 14:45:33 +02:00
Laurent Indermühle	d44f8f2039	CI: fix string templating for ansible devel (core 2.19, 12 beta) in tests (#713) ... * fix string templating for ansible devel (core 2.19, 12 beta) * fix order to prevent [ERROR]: Task failed: Module failed: 'Server_id' * cut jinja templates from conditionals * fix 'item' already in use	2025-04-28 13:52:40 +02:00
Laurent Indermühle	da2dc9ab5d	Doc: locked returned in users info (#706) ... * doc: users_info returns a new field "locked" * doc: fix hash syntax Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru> --------- Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru>	2025-04-24 13:44:50 +02:00
Andrew Klychkov	b26235b7d7	Release 3.13.0 commit (#705) 3.13.0	2025-03-21 07:02:43 +01:00
Keeper-of-the-Keys	45a29408ad	User locking (#702) ... * function to check if a user is locked already Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add the location and logic of where I think user locking would happen. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Fix missing parameters for execute() Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add the locked attribute Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Initial user locking integration tests Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add attribute documentation Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * More descriptive names in the integration tests Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * - Changes requested/suggested by @Andersson007 - Example usage - Changelog fragment Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Fix user_is_locked and remove host_all option. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Fix host of user (was % should have been localhost after deleting `host:` earlier) Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Switch locked to named instead of positional. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add check_mode support. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add check_mode: true test cases Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Fix names that included `check_mode: true` Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add idempotence checks Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Switch calls to user_mod with sequences of None positional arguments to full named arguments Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * locked check should not run for roles. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * check_mode is set at the task level and not the module level Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add user locking to info module and test. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Handle DictCursor Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add check_mode feedback Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add another builtin account to the exclusion list Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Initial switch to default=None for locked, will need to add a test for it. Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> * Add check that missing locked argument does not unlock a user Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com> --------- Signed-off-by: E.S. Rosenberg a.k.a. Keeper of the Keys <es.rosenberg+github@gmail.com>	2025-03-19 14:40:59 +01:00
Laurent Indermühle	dd7e297d50	Add support for MariaDB 11.4 (#703) ... * fix missing symlink to mysql binaries for MariaDB 11+ * update tested version of MariaDB 11.4 instead of 10.5 * add changelog fragment * [CI] add way to trigger workflow manually Useful in the case we don't modifiy any files in the paths: sections of the push event. * add version check for mariadb < 10.4.6 without mariadb* binaries * Use same concatenation method between functions to avoid future confusion I didn't notice that db_dump and db_import were different, thus I introduced a bug with the initialization of the variable cmd. This commit fixes that.	2025-03-10 18:55:42 +01:00
Andrew Klychkov	e9845b0a1c	Release 3.12.0 commit (#698) 3.12.0	2025-01-17 10:11:27 +01:00
Andrew Klychkov	960ac32adf	mysql_query: returns execution_time_ms list containing execution time per query (#697) ... * mysql_query: returns execution_time_ms list containing execution time per query * Update changelogs/fragments/0-mysql_query-returns-exec-time-ms.yml Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2025-01-16 15:49:53 +01:00
Sergio	a45a0d006d	mysql_db: added zstd support (#696)	2025-01-16 09:35:04 +01:00
Andrew Klychkov	022ed60906	Fix linting issues (#693)	2024-12-13 09:21:06 +01:00
Laurent Indermuehle	3d3f115574	Add next expected version	2024-11-19 10:56:37 +01:00
Laurent Indermühle	e437d562c1	Release 3.11.0 commit (#692) 3.11.0	2024-11-19 10:51:58 +01:00
Laurent Indermühle	9057637844	mysql_info - add table count to the databases returned values (#691) ... * Add tables count per database * Add integrations tests * Deduplicate tests between main and new task file	2024-11-19 08:51:03 +01:00
Laurent Indermühle	d613fa1993	Fix wrong documentation assertion (#690)	2024-11-18 15:44:39 +01:00
Laurent Indermühle	7d787eb238	Add contributors from last 10 PR pages (#688) ... I've applied a sort on the whole file. This Patch is hard to read, sorry. I've remove nobody! Only move!	2024-11-07 10:37:10 +01:00
Soledad208	ebb37ae7a3	sql_mode can be set in session, therefore we should look for ANSI_QUOTES in session variable instead of global variable (#677) ... * issue-671: get ASNI_QUOTES from session sql_mode instead of GLOBAL sql_mode	2024-11-07 09:56:31 +01:00
Andrew Klychkov	90bd0b0a75	Update contributor's email (#684)	2024-10-24 10:57:36 +02:00
JS	93cd1850d9	Update mysql_user.py - table/privilege spacing update (#687) ... * Update mysql_user.py - table/privilege spacing update Add note for no spacing between the table and the privilege as this will make the task not idempotent in check mode but still make it idempotent when in normal mode. * Update plugins/modules/mysql_user.py Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru> --------- Co-authored-by: Andrew Klychkov <aaklychkov@mail.ru>	2024-10-23 10:31:40 +02:00
Andrew Klychkov	a5afa1a375	CI: add stable-2.18, fix README (#681) ... * CI: add stable-2.18, fix README * Update .github/workflows/ansible-test-plugins.yml Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> * Update .github/workflows/ansible-test-plugins.yml Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> * Update .github/workflows/ansible-test-plugins.yml Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> * Update README.md Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me> --------- Co-authored-by: Laurent Indermühle <laurent.indermuehle@pm.me>	2024-09-26 14:31:08 +02:00
Maxwell G	28bf7093be	changelogs: categorize deprecations under deprecated_features (#679) ... These should be put under deprecated_features so they show up properly in the generated changelog.	2024-09-11 14:35:02 +02:00