puppetlabs/puppetlabs-mysql

Providers broken with MariaDB 11

jantman opened this issue ยท 12 comments

Describe the Bug

MariaDB 11 is out, and has deprecated the mysql (and mysqldump and mysqladmin) commands in favor of mariadb commands. The mysql commands now issue a deprecation message when used, which breaks the provider. e.g.:

Error: Could not prefetch mysql_database provider 'mysql': Execution of '/usr/bin/mysql -NBe show variables like '%_database' /usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead' returned 1: /usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 1102 (42000): Incorrect database name '/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/ma...'

And if we just run mysql directly on the command line:

# mysql
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3927
Server version: 11.0.2-MariaDB Arch Linux

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Expected Behavior

The provider will work, without throwing errors because of the deprecation message. Ideally, the provider will detect the presence of mariadb (etc.) commands and prefer those over mysql commands (at least if the engine that's running is MariaDB). Or, failing that, the provider won't error out on the deprecation message.

Steps to Reproduce

  1. Install MariaDB 11.0.2 client.
  2. Use any of the features in this module which call out to the mysql binary.

Environment

  • Version: 15.0.0 (latest)
  • Platform: Arch Linux, Puppet 7.24.0

Possible quickfix could imho be in lib/puppet/provider/mysql.rb to adjust mysql_caller. There add a version-compare if mariadb newer than 11.0.0 is used. Then use mariadb_raw instead of mysql_raw (copy those lines). And define a command mariadb_raw of course. Maybe there is a cleaner solution, but for the moment it worked for me.

The mysql command with MariaDB 11 is a symlink to the mariadb command. So probably a cleaner check will be to check if the mysql_caller is a symlink to mariadb and then use it, or just use the target of the link.
Or just ignore the stderr that shows the deprecation message.

The mysql command with MariaDB 11 is a symlink to the mariadb command. So probably a cleaner check will be to check if the mysql_caller is a symlink to mariadb and then use it, or just use the target of the link.

@ajdelgado : As explained in the warning: "It will be removed in a future release". Your proposal is working for now but will be obsolete when MariaDB will remove this symlink.

true, closing this PR

As explained in the warning: "It will be removed in a future release". Your proposal is working for now but will be obsolete when MariaDB will remove this symlink.

@Marc-DRI I don't see why this message would make the fix obsolete.

We do not know when MariaDB will remove these symlinks, and until that happens all MariaDB 11 installations are effectively broken. I still get this error on 11.4

Instead of relying on hypothetical unknowns, I would prefer if we find a practical solution to support MariaDB 11.

Edit: nvm, just saw that there is #1645

On the current LTS Version of MariaDB the symlinks are removed. And the module only works, changing all mysql calls to mariadb calls.

On the current LTS Version of MariaDB the symlinks are removed. And the module only works, changing all mysql calls to mariadb calls.

MariaDB Enterprise have just released 11.4 as the stable LTS release which is EOL May 2029 - so those symlinks are not going away in a hurry :)

@viscountstyx 11.4 of the OpenSource version don't have it.

rpm -ql MariaDB-server-11.4.4-1.el9.x86_64
/etc/logrotate.d/mariadb
/etc/my.cnf.d
/etc/my.cnf.d/enable_encryption.preset
/etc/my.cnf.d/server.cnf
/etc/my.cnf.d/spider.cnf
/etc/security/user_map.conf
/lib64/security/pam_user_map.so
/usr/bin/aria_chk
/usr/bin/aria_dump_log
/usr/bin/aria_ftdump
/usr/bin/aria_pack
/usr/bin/aria_read_log
/usr/bin/galera_new_cluster
/usr/bin/galera_recovery
/usr/bin/innochecksum
/usr/bin/mariadb-fix-extensions
/usr/bin/mariadb-install-db
/usr/bin/mariadb-service-convert
/usr/bin/mariadb-upgrade
/usr/bin/mariadbd-multi
/usr/bin/mariadbd-safe
/usr/bin/mariadbd-safe-helper
/usr/bin/myisam_ftdump
/usr/bin/myisamchk
/usr/bin/myisamlog
/usr/bin/myisampack
/usr/bin/perror
/usr/bin/resolveip
/usr/bin/wsrep_sst_backup
/usr/bin/wsrep_sst_common
/usr/bin/wsrep_sst_mariabackup
/usr/bin/wsrep_sst_mysqldump
/usr/bin/wsrep_sst_rsync
/usr/bin/wsrep_sst_rsync_wan
/usr/lib/.build-id
/usr/lib/.build-id/0e
/usr/lib/.build-id/0e/f3096446bbef4aa62fa720a0621b41c64153f6
/usr/lib/.build-id/11
/usr/lib/.build-id/11/5bb7707cc1c96bc15e1de10ee1522b74fccc04
/usr/lib/.build-id/13
/usr/lib/.build-id/13/2a2080dbfe9d10d32af507551c55c7f8cfadef
/usr/lib/.build-id/15
/usr/lib/.build-id/15/0114117ecfc05c19942f856252533b166fee7f
/usr/lib/.build-id/15/6eb3da8e69795880a618cd3d377e82a990d014
/usr/lib/.build-id/16
/usr/lib/.build-id/16/328fe70f72cedbb97696ad5cfeb3ebb389fbc8
/usr/lib/.build-id/1e
/usr/lib/.build-id/1e/6f981fab91cd0e9e1246bc2b8bc3e0d8673865
/usr/lib/.build-id/21
/usr/lib/.build-id/21/4c36f94726eb0ff59bd01a891b64e4151ef459
/usr/lib/.build-id/22
/usr/lib/.build-id/22/adb64faa2066440a219ec96cd1c647531a5a68
/usr/lib/.build-id/29
/usr/lib/.build-id/29/efd63c7c8dbeacdaf8e7bb0c77f9a7fbc36d63
/usr/lib/.build-id/2b
/usr/lib/.build-id/2b/e9ba19c70105c4a1b79db13e6e712c382ae237
/usr/lib/.build-id/2c
/usr/lib/.build-id/2c/362f576f5a86d9d34aa1dcfd20767dd73c1fb8
/usr/lib/.build-id/3f
/usr/lib/.build-id/3f/ce83b7aa111d7a79847c92d69425c337461430
/usr/lib/.build-id/41
/usr/lib/.build-id/41/d4ed046ce6519d476262e25ce5b3f596849c7f
/usr/lib/.build-id/47
/usr/lib/.build-id/47/8c0d8be8eaddb1a7ebbc0b0fcf69ea1d8040eb
/usr/lib/.build-id/56
/usr/lib/.build-id/56/ee7c9d63083cbd14443d11c71316d822f82441
/usr/lib/.build-id/60
/usr/lib/.build-id/60/ec3317a5b2e47c0741110c107b4ba9abfae8b5
/usr/lib/.build-id/68
/usr/lib/.build-id/68/6d45b625796b49e461e6a77a43995c8405c527
/usr/lib/.build-id/6b
/usr/lib/.build-id/6b/ccd7372e1406b798d7de6ee4e5d9132e142718
/usr/lib/.build-id/77
/usr/lib/.build-id/77/e45c07633c380f0864a570735f2a8ba8c42fd7
/usr/lib/.build-id/7b
/usr/lib/.build-id/7b/00a913326499c1f21c708d1cd0cfb4cdc17b83
/usr/lib/.build-id/7d
/usr/lib/.build-id/7d/97847262f9c5a1840251df46ba12a73eacbfe9
/usr/lib/.build-id/82
/usr/lib/.build-id/82/9f99404a1a10ed0df9057313eea3b9e35fd4b7
/usr/lib/.build-id/90
/usr/lib/.build-id/90/8108e91ee1f8a5f68767a9408c6afe51eca25a
/usr/lib/.build-id/94
/usr/lib/.build-id/94/29e4a4765e4f6090e270df1da665061caf2db8
/usr/lib/.build-id/94/424d0ab11872ffad78b149c11fb9e7f4d2dc52
/usr/lib/.build-id/98
/usr/lib/.build-id/98/5cf1e664956365606391b8ac4adab0956c57bc
/usr/lib/.build-id/9a
/usr/lib/.build-id/9a/3d4ef1157c6801cd2d5b3445602fa259654891
/usr/lib/.build-id/9f
/usr/lib/.build-id/9f/13c2c71ed7ef4ed3a6bdc130fd60f35f7c43bc
/usr/lib/.build-id/a1
/usr/lib/.build-id/a1/f6bf205153004decbb548465b67df5a6a76d1b
/usr/lib/.build-id/a5
/usr/lib/.build-id/a5/db709ef374b749d0911ad35dadddebccba4dee
/usr/lib/.build-id/b2
/usr/lib/.build-id/b2/d4906a48aee4e67ac2e61f90232db14f65e4f5
/usr/lib/.build-id/b5
/usr/lib/.build-id/b5/1b1f453e85aabcaa62bbb5f0faf6e1bd778500
/usr/lib/.build-id/c5
/usr/lib/.build-id/c5/461a9ae438bd4bfd8fc2790578e9c2d1277d95
/usr/lib/.build-id/d0
/usr/lib/.build-id/d0/42dabc3ea8f05a6f51769e58a3bc3bf7a8036b
/usr/lib/.build-id/e3
/usr/lib/.build-id/e3/af6bf05eb0799ddc043dad7b1435b81c705551
/usr/lib/.build-id/f2
/usr/lib/.build-id/f2/b224836108083aa615873bdfb7bdf11593a330
/usr/lib/.build-id/f7
/usr/lib/.build-id/f7/ae79442ec86f76facfa32f0512bbb694b27b8c
/usr/lib/.build-id/fc
/usr/lib/.build-id/fc/65c99d7f8df97b854688778fa88a9afb25626c
/usr/lib/.build-id/ff
/usr/lib/.build-id/ff/124de728f05a0ff6ce3debf99ddc548d009699
/usr/lib/.build-id/ff/d12a9ef10cae6ccc757ee8aca09bc850f3c648
/usr/lib/systemd/system/mariadb-extra.socket
/usr/lib/systemd/system/mariadb-extra@.socket
/usr/lib/systemd/system/mariadb.service
/usr/lib/systemd/system/mariadb.socket
/usr/lib/systemd/system/mariadb@.service
/usr/lib/systemd/system/mariadb@.socket
/usr/lib/systemd/system/mariadb@bootstrap.service.d
/usr/lib/systemd/system/mariadb@bootstrap.service.d/use_galera_new_cluster.conf
/usr/lib/systemd/system/mysql.service
/usr/lib/systemd/system/mysqld.service
/usr/lib/sysusers.d/mariadb.conf
/usr/lib/tmpfiles.d/mariadb.conf
/usr/lib64/libmariadbd.so
/usr/lib64/libmariadbd.so.19
/usr/lib64/libmysqld.so
/usr/lib64/mysql
/usr/lib64/mysql/plugin
/usr/lib64/mysql/plugin/auth_ed25519.so
/usr/lib64/mysql/plugin/auth_pam.so
/usr/lib64/mysql/plugin/auth_pam_tool_dir
/usr/lib64/mysql/plugin/auth_pam_tool_dir/auth_pam_tool
/usr/lib64/mysql/plugin/auth_pam_v1.so
/usr/lib64/mysql/plugin/disks.so
/usr/lib64/mysql/plugin/file_key_management.so
/usr/lib64/mysql/plugin/ha_archive.so
/usr/lib64/mysql/plugin/ha_blackhole.so
/usr/lib64/mysql/plugin/ha_federated.so
/usr/lib64/mysql/plugin/ha_federatedx.so
/usr/lib64/mysql/plugin/ha_mroonga.so
/usr/lib64/mysql/plugin/ha_sphinx.so
/usr/lib64/mysql/plugin/ha_spider.so
/usr/lib64/mysql/plugin/handlersocket.so
/usr/lib64/mysql/plugin/locales.so
/usr/lib64/mysql/plugin/metadata_lock_info.so
/usr/lib64/mysql/plugin/password_reuse_check.so
/usr/lib64/mysql/plugin/query_cache_info.so
/usr/lib64/mysql/plugin/query_response_time.so
/usr/lib64/mysql/plugin/server_audit.so
/usr/lib64/mysql/plugin/simple_password_check.so
/usr/lib64/mysql/plugin/sql_errlog.so
/usr/lib64/mysql/plugin/type_mysql_json.so
/usr/lib64/mysql/plugin/wsrep_info.so
/usr/sbin/mariadbd
/usr/sbin/rcmysql
/usr/share/doc/MariaDB-server-11.4.4
/usr/share/doc/MariaDB-server-11.4.4/COPYING
/usr/share/doc/MariaDB-server-11.4.4/CREDITS
/usr/share/doc/MariaDB-server-11.4.4/INSTALL-BINARY
/usr/share/doc/MariaDB-server-11.4.4/README-wsrep
/usr/share/doc/MariaDB-server-11.4.4/README.md
/usr/share/doc/MariaDB-server-11.4.4/THIRDPARTY
/usr/share/man/man1/aria_chk.1.gz
/usr/share/man/man1/aria_dump_log.1.gz
/usr/share/man/man1/aria_ftdump.1.gz
/usr/share/man/man1/aria_pack.1.gz
/usr/share/man/man1/aria_read_log.1.gz
/usr/share/man/man1/galera_new_cluster.1.gz
/usr/share/man/man1/galera_recovery.1.gz
/usr/share/man/man1/innochecksum.1.gz
/usr/share/man/man1/mariadb-conv.1.gz
/usr/share/man/man1/mariadb-fix-extensions.1.gz
/usr/share/man/man1/mariadb-install-db.1.gz
/usr/share/man/man1/mariadb-service-convert.1.gz
/usr/share/man/man1/mariadb-upgrade.1.gz
/usr/share/man/man1/mariadbd-multi.1.gz
/usr/share/man/man1/mariadbd-safe-helper.1.gz
/usr/share/man/man1/mariadbd-safe.1.gz
/usr/share/man/man1/myisam_ftdump.1.gz
/usr/share/man/man1/myisamchk.1.gz
/usr/share/man/man1/myisamlog.1.gz
/usr/share/man/man1/myisampack.1.gz
/usr/share/man/man1/mysql.server.1.gz
/usr/share/man/man1/resolveip.1.gz
/usr/share/man/man1/wsrep_sst_backup.1.gz
/usr/share/man/man1/wsrep_sst_common.1.gz
/usr/share/man/man1/wsrep_sst_mariabackup.1.gz
/usr/share/man/man1/wsrep_sst_mysqldump.1.gz
/usr/share/man/man1/wsrep_sst_rsync.1.gz
/usr/share/man/man1/wsrep_sst_rsync_wan.1.gz
/usr/share/man/man8/mariadbd.8.gz
/usr/share/mariadb
/usr/share/mariadb/binary-configure
/usr/share/mariadb/bulgarian
/usr/share/mariadb/bulgarian/errmsg.sys
/usr/share/mariadb/chinese
/usr/share/mariadb/chinese/errmsg.sys
/usr/share/mariadb/czech
/usr/share/mariadb/czech/errmsg.sys
/usr/share/mariadb/danish
/usr/share/mariadb/danish/errmsg.sys
/usr/share/mariadb/dutch
/usr/share/mariadb/dutch/errmsg.sys
/usr/share/mariadb/english
/usr/share/mariadb/english/errmsg.sys
/usr/share/mariadb/estonian
/usr/share/mariadb/estonian/errmsg.sys
/usr/share/mariadb/fill_help_tables.sql
/usr/share/mariadb/french
/usr/share/mariadb/french/errmsg.sys
/usr/share/mariadb/georgian
/usr/share/mariadb/georgian/errmsg.sys
/usr/share/mariadb/german
/usr/share/mariadb/german/errmsg.sys
/usr/share/mariadb/greek
/usr/share/mariadb/greek/errmsg.sys
/usr/share/mariadb/hindi
/usr/share/mariadb/hindi/errmsg.sys
/usr/share/mariadb/hungarian
/usr/share/mariadb/hungarian/errmsg.sys
/usr/share/mariadb/italian
/usr/share/mariadb/italian/errmsg.sys
/usr/share/mariadb/japanese
/usr/share/mariadb/japanese/errmsg.sys
/usr/share/mariadb/korean
/usr/share/mariadb/korean/errmsg.sys
/usr/share/mariadb/magic
/usr/share/mariadb/maria_add_gis_sp.sql
/usr/share/mariadb/maria_add_gis_sp_bootstrap.sql
/usr/share/mariadb/mariadb.logrotate
/usr/share/mariadb/mariadb_performance_tables.sql
/usr/share/mariadb/mariadb_sys_schema.sql
/usr/share/mariadb/mariadb_system_tables.sql
/usr/share/mariadb/mariadb_system_tables_data.sql
/usr/share/mariadb/mariadb_test_data_timezone.sql
/usr/share/mariadb/mariadb_test_db.sql
/usr/share/mariadb/mini-benchmark
/usr/share/mariadb/mysql.server
/usr/share/mariadb/mysqld_multi.server
/usr/share/mariadb/norwegian
/usr/share/mariadb/norwegian-ny
/usr/share/mariadb/norwegian-ny/errmsg.sys
/usr/share/mariadb/norwegian/errmsg.sys
/usr/share/mariadb/policy
/usr/share/mariadb/policy/apparmor
/usr/share/mariadb/policy/apparmor/README
/usr/share/mariadb/policy/apparmor/usr.sbin.mysqld
/usr/share/mariadb/policy/apparmor/usr.sbin.mysqld.local
/usr/share/mariadb/policy/selinux
/usr/share/mariadb/policy/selinux/README
/usr/share/mariadb/policy/selinux/mariadb-server.fc
/usr/share/mariadb/policy/selinux/mariadb-server.te
/usr/share/mariadb/policy/selinux/mariadb.pp
/usr/share/mariadb/policy/selinux/mariadb.te
/usr/share/mariadb/polish
/usr/share/mariadb/polish/errmsg.sys
/usr/share/mariadb/portuguese
/usr/share/mariadb/portuguese/errmsg.sys
/usr/share/mariadb/romanian
/usr/share/mariadb/romanian/errmsg.sys
/usr/share/mariadb/russian
/usr/share/mariadb/russian/errmsg.sys
/usr/share/mariadb/serbian
/usr/share/mariadb/serbian/errmsg.sys
/usr/share/mariadb/slovak
/usr/share/mariadb/slovak/errmsg.sys
/usr/share/mariadb/spanish
/usr/share/mariadb/spanish/errmsg.sys
/usr/share/mariadb/swahili
/usr/share/mariadb/swahili/errmsg.sys
/usr/share/mariadb/swedish
/usr/share/mariadb/swedish/errmsg.sys
/usr/share/mariadb/systemd
/usr/share/mariadb/systemd/mariadb-extra@.socket
/usr/share/mariadb/systemd/mariadb.service
/usr/share/mariadb/systemd/mariadb@.service
/usr/share/mariadb/systemd/mariadb@.socket
/usr/share/mariadb/systemd/mysql.service
/usr/share/mariadb/systemd/mysqld.service
/usr/share/mariadb/systemd/use_galera_new_cluster.conf
/usr/share/mariadb/ukrainian
/usr/share/mariadb/ukrainian/errmsg.sys
/usr/share/mariadb/wsrep.cnf
/usr/share/mariadb/wsrep_notify
rpm -ql MariaDB-client-11.4.4-1.el9.x86_64
/etc/my.cnf.d
/etc/my.cnf.d/mysql-clients.cnf
/usr/bin/mariadb
/usr/bin/mariadb-access
/usr/bin/mariadb-admin
/usr/bin/mariadb-binlog
/usr/bin/mariadb-check
/usr/bin/mariadb-conv
/usr/bin/mariadb-convert-table-format
/usr/bin/mariadb-dump
/usr/bin/mariadb-dumpslow
/usr/bin/mariadb-embedded
/usr/bin/mariadb-find-rows
/usr/bin/mariadb-hotcopy
/usr/bin/mariadb-import
/usr/bin/mariadb-plugin
/usr/bin/mariadb-secure-installation
/usr/bin/mariadb-setpermission
/usr/bin/mariadb-show
/usr/bin/mariadb-slap
/usr/bin/mariadb-tzinfo-to-sql
/usr/bin/mariadb-waitpid
/usr/bin/msql2mysql
/usr/bin/my_print_defaults
/usr/bin/mytop
/usr/bin/replace
/usr/bin/resolve_stack_dump
/usr/lib/.build-id
/usr/lib/.build-id/03
/usr/lib/.build-id/03/34f2778cead31aa7763b5a17800c71da0ce103
/usr/lib/.build-id/15
/usr/lib/.build-id/15/12d8685ea9bd0ffa12ebe80e03f9841dc54f15
/usr/lib/.build-id/19
/usr/lib/.build-id/19/97e79f7bcd52e1b1b1305e889bdda5264485d3
/usr/lib/.build-id/1d
/usr/lib/.build-id/1d/75b1609306acb5fb789bc3366295882ff75a0c
/usr/lib/.build-id/35
/usr/lib/.build-id/35/a93ecfbce429e7d3461aa5a1ac607fe924e27e
/usr/lib/.build-id/47
/usr/lib/.build-id/47/0dae6826acefeb44eb77b8ea8e021b061ce1e2
/usr/lib/.build-id/4f
/usr/lib/.build-id/4f/9889e79cb237323cfa5d6351742e5f194eb483
/usr/lib/.build-id/5b
/usr/lib/.build-id/5b/a1f562b7e20237bcf845eb3d1fd97a69d15643
/usr/lib/.build-id/68
/usr/lib/.build-id/68/e67143ade5ec5c43235ffd03bf7410ec908d4e
/usr/lib/.build-id/86
/usr/lib/.build-id/86/0c337f922d1de64f1809dc3224a3ce24db903a
/usr/lib/.build-id/96
/usr/lib/.build-id/96/ac9e196f407ef1062955bd50788e1f60a54797
/usr/lib/.build-id/97
/usr/lib/.build-id/97/8c3c28f428baeb55e0becf53797fc71fc2c02c
/usr/lib/.build-id/b7
/usr/lib/.build-id/b7/a93106051c0882d8cde58cc6d001ffd490e34f
/usr/lib/.build-id/d5
/usr/lib/.build-id/d5/71afdf1589e0cc08149f898664dce7d5b0beaa
/usr/lib/.build-id/f2
/usr/lib/.build-id/f2/a6a5f21ddbc1b3129222181adafc3fae6d4fa8
/usr/lib/.build-id/f9
/usr/lib/.build-id/f9/17d7a292df0e06475d04c48862314b36645c66
/usr/share/man/man1/mariadb-access.1.gz
/usr/share/man/man1/mariadb-admin.1.gz
/usr/share/man/man1/mariadb-binlog.1.gz
/usr/share/man/man1/mariadb-check.1.gz
/usr/share/man/man1/mariadb-convert-table-format.1.gz
/usr/share/man/man1/mariadb-dump.1.gz
/usr/share/man/man1/mariadb-dumpslow.1.gz
/usr/share/man/man1/mariadb-embedded.1.gz
/usr/share/man/man1/mariadb-find-rows.1.gz
/usr/share/man/man1/mariadb-hotcopy.1.gz
/usr/share/man/man1/mariadb-import.1.gz
/usr/share/man/man1/mariadb-plugin.1.gz
/usr/share/man/man1/mariadb-secure-installation.1.gz
/usr/share/man/man1/mariadb-setpermission.1.gz
/usr/share/man/man1/mariadb-show.1.gz
/usr/share/man/man1/mariadb-slap.1.gz
/usr/share/man/man1/mariadb-tzinfo-to-sql.1.gz
/usr/share/man/man1/mariadb-waitpid.1.gz
/usr/share/man/man1/mariadb.1.gz
/usr/share/man/man1/msql2mysql.1.gz
/usr/share/man/man1/my_print_defaults.1.gz
/usr/share/man/man1/mytop.1.gz
/usr/share/man/man1/perror.1.gz
/usr/share/man/man1/replace.1.gz
/usr/share/man/man1/resolve_stack_dump.1.gz


@tuxmaster5000, @viscountstyx, @flokoe, @ajdelgado - I just upgrade MariaDB to 11.4 and I am experiencing the same issue @jantman described. Is there a fix I can implement or is there a workaround I can use? All my puppet agent runs fails with that error.

@tuxmaster5000, @viscountstyx, @flokoe, @ajdelgado - I just upgrade MariaDB to 11.4 and I am experiencing the same issue @jantman described. Is there a fix I can implement or is there a workaround I can use? All my puppet agent runs fails with that error.

I've had to clone https://github.com/DRI-Syloe/puppetlabs-mysql/tree/mariadb_11 which contains the fix as we're using MariaDB 11.4 Enterprise which provides the deprecation warning and breaks puppet runs - you may have to do the same.

@tuxmaster5000, @viscountstyx, @flokoe, @ajdelgado - I just upgrade MariaDB to 11.4 and I am experiencing the same issue @jantman described. Is there a fix I can implement or is there a workaround I can use? All my puppet agent runs fails with that error.

I've had to clone https://github.com/DRI-Syloe/puppetlabs-mysql/tree/mariadb_11 which contains the fix as we're using MariaDB 11.4 Enterprise which provides the deprecation warning and breaks puppet runs - you may have to do the same.

Obviously I'm rather keen to change back to the main module once #1645 is merged

As viscountstyx said, currently until this PR is officially merged, the only solution is to fork this repo and apply the patches from #1645 yourself.

And due to the Perforce changes and the overall velocity in official modules, I am afraid this probably won't happen any time soon. So don't get your hopes up. Alas, this issue is over 1.5 years old.