SUSE-RU-2023:3956-1

Dashboard / Vulnerabilities / SUSE-RU-2023:3956-1

SUSE-RU-2023:3956-1

Summary: Recommended update for mariadb104

Details: This update for mariadb104 fixes the following issues: - Implement version 10.4 of MariaDB (jsc#PED-2455): * It is possible to use more than one authentication plugin for each user account. * The root user account is being created with the ability to use two authentication plugins. * All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table. * Is being supported for User Password Expiry, which is not active by default. * Faster privilege checks for MariaDB setups with many user accounts or many database grants. - Update mysql-systemd-helper to be aware of custom group (bsc#1200105) - MariaDB is now support lz4 compression for 'INNODB'. (bsc#1186031) - Add 'mysql-user.conf' file to enable systemd generating mysql user in containers. (bsc#1173028) - Fixes an issue when MariaDB is ignoring the value of the parameter 'open_files_limit' in the global variables. (bsc#1180014)

References: https://www.suse.com/support/update/announcement/-2023-3956/suse-ru-20233956-1/, https://bugzilla.suse.com/1001367, https://bugzilla.suse.com/1005555, https://bugzilla.suse.com/1005558, https://bugzilla.suse.com/1005562, https://bugzilla.suse.com/1005564, https://bugzilla.suse.com/1005566, https://bugzilla.suse.com/1005569, https://bugzilla.suse.com/1005581, https://bugzilla.suse.com/1005582, https://bugzilla.suse.com/1006539, https://bugzilla.suse.com/1008253, https://bugzilla.suse.com/1012075, https://bugzilla.suse.com/1013882, https://bugzilla.suse.com/1019948, https://bugzilla.suse.com/1020873, https://bugzilla.suse.com/1020875, https://bugzilla.suse.com/1020877, https://bugzilla.suse.com/1020878, https://bugzilla.suse.com/1020882, https://bugzilla.suse.com/1020884, https://bugzilla.suse.com/1020885, https://bugzilla.suse.com/1020890, https://bugzilla.suse.com/1020891, https://bugzilla.suse.com/1020894, https://bugzilla.suse.com/1020896, https://bugzilla.suse.com/1020976, https://bugzilla.suse.com/1022428, https://bugzilla.suse.com/1038740, https://bugzilla.suse.com/1039034, https://bugzilla.suse.com/1041525, https://bugzilla.suse.com/1041891, https://bugzilla.suse.com/1042632, https://bugzilla.suse.com/1043328, https://bugzilla.suse.com/1047218, https://bugzilla.suse.com/1055165, https://bugzilla.suse.com/1055268, https://bugzilla.suse.com/1058374, https://bugzilla.suse.com/1058729, https://bugzilla.suse.com/1060110, https://bugzilla.suse.com/1062583, https://bugzilla.suse.com/1067443, https://bugzilla.suse.com/1068906, https://bugzilla.suse.com/1069401, https://bugzilla.suse.com/1080891, https://bugzilla.suse.com/1083087, https://bugzilla.suse.com/1088681, https://bugzilla.suse.com/1092544, https://bugzilla.suse.com/1098683, https://bugzilla.suse.com/1101676, https://bugzilla.suse.com/1101677, https://bugzilla.suse.com/1101678, https://bugzilla.suse.com/1103342, https://bugzilla.suse.com/1111858, https://bugzilla.suse.com/1111859, https://bugzilla.suse.com/1112368, https://bugzilla.suse.com/1112377, https://bugzilla.suse.com/1112384, https://bugzilla.suse.com/1112386, https://bugzilla.suse.com/1112391, https://bugzilla.suse.com/1112397, https://bugzilla.suse.com/1112404, https://bugzilla.suse.com/1112415, https://bugzilla.suse.com/1112417, https://bugzilla.suse.com/1112421, https://bugzilla.suse.com/1112432, https://bugzilla.suse.com/1112767, https://bugzilla.suse.com/1116686, https://bugzilla.suse.com/1118754, https://bugzilla.suse.com/1120041, https://bugzilla.suse.com/1122198, https://bugzilla.suse.com/1122475, https://bugzilla.suse.com/1127027, https://bugzilla.suse.com/1132666, https://bugzilla.suse.com/1136035, https://bugzilla.suse.com/1142909, https://bugzilla.suse.com/1143215, https://bugzilla.suse.com/1144314, https://bugzilla.suse.com/1156669, https://bugzilla.suse.com/1160285, https://bugzilla.suse.com/1160868, https://bugzilla.suse.com/1160878, https://bugzilla.suse.com/1160883, https://bugzilla.suse.com/1160895, https://bugzilla.suse.com/1160912, https://bugzilla.suse.com/1166781, https://bugzilla.suse.com/1168380, https://bugzilla.suse.com/1170204, https://bugzilla.suse.com/1173028, https://bugzilla.suse.com/1173516, https://bugzilla.suse.com/1174559, https://bugzilla.suse.com/1175596, https://bugzilla.suse.com/1177472, https://bugzilla.suse.com/1178428, https://bugzilla.suse.com/1180014, https://bugzilla.suse.com/1182218, https://bugzilla.suse.com/1182255, https://bugzilla.suse.com/1182739, https://bugzilla.suse.com/1183770, https://bugzilla.suse.com/1185870, https://bugzilla.suse.com/1185872, https://bugzilla.suse.com/1186031, https://bugzilla.suse.com/1189320, https://bugzilla.suse.com/1192497, https://bugzilla.suse.com/1195325, https://bugzilla.suse.com/1195334, https://bugzilla.suse.com/1195339, https://bugzilla.suse.com/1196016, https://bugzilla.suse.com/1197459, https://bugzilla.suse.com/1198603, https://bugzilla.suse.com/1198604, https://bugzilla.suse.com/1198605, https://bugzilla.suse.com/1198606, https://bugzilla.suse.com/1198607, https://bugzilla.suse.com/1198609, https://bugzilla.suse.com/1198610, https://bugzilla.suse.com/1198611, https://bugzilla.suse.com/1198612, https://bugzilla.suse.com/1198613, https://bugzilla.suse.com/1198628, https://bugzilla.suse.com/1198629, https://bugzilla.suse.com/1198630, https://bugzilla.suse.com/1198631, https://bugzilla.suse.com/1198632, https://bugzilla.suse.com/1198633, https://bugzilla.suse.com/1198634, https://bugzilla.suse.com/1198635, https://bugzilla.suse.com/1198636, https://bugzilla.suse.com/1198637, https://bugzilla.suse.com/1198638, https://bugzilla.suse.com/1198639, https://bugzilla.suse.com/1198640, https://bugzilla.suse.com/1199928, https://bugzilla.suse.com/1200105, https://bugzilla.suse.com/1201161, https://bugzilla.suse.com/1201163, https://bugzilla.suse.com/1201164, https://bugzilla.suse.com/1201165, https://bugzilla.suse.com/1201166, https://bugzilla.suse.com/1201167, https://bugzilla.suse.com/1201168, https://bugzilla.suse.com/1201169, https://bugzilla.suse.com/1201170, https://bugzilla.suse.com/1202863, https://bugzilla.suse.com/332530, https://bugzilla.suse.com/353120, https://bugzilla.suse.com/357634, https://bugzilla.suse.com/359522, https://bugzilla.suse.com/366820, https://bugzilla.suse.com/371000, https://bugzilla.suse.com/387746, https://bugzilla.suse.com/420313, https://bugzilla.suse.com/425079, https://bugzilla.suse.com/427384, https://bugzilla.suse.com/429618, https://bugzilla.suse.com/435519, https://bugzilla.suse.com/437293, https://bugzilla.suse.com/463586, https://bugzilla.suse.com/520876, https://bugzilla.suse.com/525065, https://bugzilla.suse.com/525325, https://bugzilla.suse.com/539243, https://bugzilla.suse.com/539249, https://bugzilla.suse.com/557669, https://bugzilla.suse.com/635645, https://bugzilla.suse.com/747811, https://bugzilla.suse.com/763150, https://bugzilla.suse.com/779476, https://bugzilla.suse.com/789263, https://bugzilla.suse.com/792444, https://bugzilla.suse.com/796164, https://bugzilla.suse.com/829430, https://bugzilla.suse.com/841709, https://bugzilla.suse.com/859345, https://bugzilla.suse.com/889126, https://bugzilla.suse.com/894479, https://bugzilla.suse.com/902396, https://bugzilla.suse.com/914370, https://bugzilla.suse.com/921955, https://bugzilla.suse.com/934789, https://bugzilla.suse.com/937754, https://bugzilla.suse.com/937767, https://bugzilla.suse.com/937787, https://bugzilla.suse.com/942908, https://bugzilla.suse.com/943096, https://bugzilla.suse.com/957174, https://bugzilla.suse.com/963810, https://bugzilla.suse.com/971456, https://bugzilla.suse.com/979524, https://bugzilla.suse.com/983938, https://bugzilla.suse.com/984858, https://bugzilla.suse.com/986251, https://bugzilla.suse.com/989913, https://bugzilla.suse.com/989919, https://bugzilla.suse.com/989922, https://bugzilla.suse.com/989926, https://bugzilla.suse.com/990890, https://bugzilla.suse.com/998309, https://www.suse.com/security/cve/CVE-2006-0903, https://www.suse.com/security/cve/CVE-2006-4226, https://www.suse.com/security/cve/CVE-2006-4227, https://www.suse.com/security/cve/CVE-2007-5969, https://www.suse.com/security/cve/CVE-2007-5970, https://www.suse.com/security/cve/CVE-2007-6303, https://www.suse.com/security/cve/CVE-2007-6304, https://www.suse.com/security/cve/CVE-2008-2079, https://www.suse.com/security/cve/CVE-2008-7247, https://www.suse.com/security/cve/CVE-2009-4019, https://www.suse.com/security/cve/CVE-2009-4028, https://www.suse.com/security/cve/CVE-2009-4030, https://www.suse.com/security/cve/CVE-2012-4414, https://www.suse.com/security/cve/CVE-2012-5611, https://www.suse.com/security/cve/CVE-2012-5612, https://www.suse.com/security/cve/CVE-2012-5615, https://www.suse.com/security/cve/CVE-2012-5627, https://www.suse.com/security/cve/CVE-2013-1976, https://www.suse.com/security/cve/CVE-2015-4792, https://www.suse.com/security/cve/CVE-2015-4802, https://www.suse.com/security/cve/CVE-2015-4807, https://www.suse.com/security/cve/CVE-2015-4815, https://www.suse.com/security/cve/CVE-2015-4816, https://www.suse.com/security/cve/CVE-2015-4819, https://www.suse.com/security/cve/CVE-2015-4826, https://www.suse.com/security/cve/CVE-2015-4830, https://www.suse.com/security/cve/CVE-2015-4836, https://www.suse.com/security/cve/CVE-2015-4858, https://www.suse.com/security/cve/CVE-2015-4861, https://www.suse.com/security/cve/CVE-2015-4864, https://www.suse.com/security/cve/CVE-2015-4866, https://www.suse.com/security/cve/CVE-2015-4870, https://www.suse.com/security/cve/CVE-2015-4879, https://www.suse.com/security/cve/CVE-2015-4895, https://www.suse.com/security/cve/CVE-2015-4913, https://www.suse.com/security/cve/CVE-2015-5969, https://www.suse.com/security/cve/CVE-2015-7744, https://www.suse.com/security/cve/CVE-2016-0505, https://www.suse.com/security/cve/CVE-2016-0546, https://www.suse.com/security/cve/CVE-2016-0596, https://www.suse.com/security/cve/CVE-2016-0597, https://www.suse.com/security/cve/CVE-2016-0598, https://www.suse.com/security/cve/CVE-2016-0600, https://www.suse.com/security/cve/CVE-2016-0606, https://www.suse.com/security/cve/CVE-2016-0608, https://www.suse.com/security/cve/CVE-2016-0609, https://www.suse.com/security/cve/CVE-2016-0610, https://www.suse.com/security/cve/CVE-2016-0616, https://www.suse.com/security/cve/CVE-2016-0640, https://www.suse.com/security/cve/CVE-2016-0641, https://www.suse.com/security/cve/CVE-2016-0642, https://www.suse.com/security/cve/CVE-2016-0644, https://www.suse.com/security/cve/CVE-2016-0646, https://www.suse.com/security/cve/CVE-2016-0649, https://www.suse.com/security/cve/CVE-2016-0650, https://www.suse.com/security/cve/CVE-2016-0651, https://www.suse.com/security/cve/CVE-2016-0668, https://www.suse.com/security/cve/CVE-2016-2047, https://www.suse.com/security/cve/CVE-2016-3477, https://www.suse.com/security/cve/CVE-2016-3492, https://www.suse.com/security/cve/CVE-2016-3521, https://www.suse.com/security/cve/CVE-2016-3615, https://www.suse.com/security/cve/CVE-2016-5440, https://www.suse.com/security/cve/CVE-2016-5584, https://www.suse.com/security/cve/CVE-2016-5616, https://www.suse.com/security/cve/CVE-2016-5624, https://www.suse.com/security/cve/CVE-2016-5626, https://www.suse.com/security/cve/CVE-2016-5629, https://www.suse.com/security/cve/CVE-2016-6662, https://www.suse.com/security/cve/CVE-2016-6663, https://www.suse.com/security/cve/CVE-2016-6664, https://www.suse.com/security/cve/CVE-2016-7440, https://www.suse.com/security/cve/CVE-2016-8283, https://www.suse.com/security/cve/CVE-2016-9843, https://www.suse.com/security/cve/CVE-2017-10268, https://www.suse.com/security/cve/CVE-2017-10286, https://www.suse.com/security/cve/CVE-2017-10320, https://www.suse.com/security/cve/CVE-2017-10365, https://www.suse.com/security/cve/CVE-2017-10378, https://www.suse.com/security/cve/CVE-2017-10379, https://www.suse.com/security/cve/CVE-2017-10384, https://www.suse.com/security/cve/CVE-2017-15365, https://www.suse.com/security/cve/CVE-2017-3238, https://www.suse.com/security/cve/CVE-2017-3243, https://www.suse.com/security/cve/CVE-2017-3244, https://www.suse.com/security/cve/CVE-2017-3257, https://www.suse.com/security/cve/CVE-2017-3258, https://www.suse.com/security/cve/CVE-2017-3265, https://www.suse.com/security/cve/CVE-2017-3291, https://www.suse.com/security/cve/CVE-2017-3302, https://www.suse.com/security/cve/CVE-2017-3308, https://www.suse.com/security/cve/CVE-2017-3309, https://www.suse.com/security/cve/CVE-2017-3312, https://www.suse.com/security/cve/CVE-2017-3313, https://www.suse.com/security/cve/CVE-2017-3317, https://www.suse.com/security/cve/CVE-2017-3318, https://www.suse.com/security/cve/CVE-2017-3453, https://www.suse.com/security/cve/CVE-2017-3456, https://www.suse.com/security/cve/CVE-2017-3464, https://www.suse.com/security/cve/CVE-2017-3636, https://www.suse.com/security/cve/CVE-2017-3641, https://www.suse.com/security/cve/CVE-2017-3653, https://www.suse.com/security/cve/CVE-2018-25032, https://www.suse.com/security/cve/CVE-2018-2562, https://www.suse.com/security/cve/CVE-2018-2612, https://www.suse.com/security/cve/CVE-2018-2622, https://www.suse.com/security/cve/CVE-2018-2640, https://www.suse.com/security/cve/CVE-2018-2665, https://www.suse.com/security/cve/CVE-2018-2668, https://www.suse.com/security/cve/CVE-2018-2755, https://www.suse.com/security/cve/CVE-2018-2759, https://www.suse.com/security/cve/CVE-2018-2761, https://www.suse.com/security/cve/CVE-2018-2766, https://www.suse.com/security/cve/CVE-2018-2767, https://www.suse.com/security/cve/CVE-2018-2771, https://www.suse.com/security/cve/CVE-2018-2777, https://www.suse.com/security/cve/CVE-2018-2781, https://www.suse.com/security/cve/CVE-2018-2782, https://www.suse.com/security/cve/CVE-2018-2784, https://www.suse.com/security/cve/CVE-2018-2786, https://www.suse.com/security/cve/CVE-2018-2787, https://www.suse.com/security/cve/CVE-2018-2810, https://www.suse.com/security/cve/CVE-2018-2813, https://www.suse.com/security/cve/CVE-2018-2817, https://www.suse.com/security/cve/CVE-2018-2819, https://www.suse.com/security/cve/CVE-2018-3058, https://www.suse.com/security/cve/CVE-2018-3060, https://www.suse.com/security/cve/CVE-2018-3063, https://www.suse.com/security/cve/CVE-2018-3064, https://www.suse.com/security/cve/CVE-2018-3066, https://www.suse.com/security/cve/CVE-2018-3143, https://www.suse.com/security/cve/CVE-2018-3156, https://www.suse.com/security/cve/CVE-2018-3162, https://www.suse.com/security/cve/CVE-2018-3173, https://www.suse.com/security/cve/CVE-2018-3174, https://www.suse.com/security/cve/CVE-2018-3185, https://www.suse.com/security/cve/CVE-2018-3200, https://www.suse.com/security/cve/CVE-2018-3251, https://www.suse.com/security/cve/CVE-2018-3277, https://www.suse.com/security/cve/CVE-2018-3282, https://www.suse.com/security/cve/CVE-2018-3284, https://www.suse.com/security/cve/CVE-2019-18901, https://www.suse.com/security/cve/CVE-2019-2510, https://www.suse.com/security/cve/CVE-2019-2537, https://www.suse.com/security/cve/CVE-2019-2614, https://www.suse.com/security/cve/CVE-2019-2627, https://www.suse.com/security/cve/CVE-2019-2628, https://www.suse.com/security/cve/CVE-2019-2737, https://www.suse.com/security/cve/CVE-2019-2739, https://www.suse.com/security/cve/CVE-2019-2740, https://www.suse.com/security/cve/CVE-2019-2758, https://www.suse.com/security/cve/CVE-2019-2805, https://www.suse.com/security/cve/CVE-2019-2938, https://www.suse.com/security/cve/CVE-2019-2974, https://www.suse.com/security/cve/CVE-2020-13249, https://www.suse.com/security/cve/CVE-2020-14765, https://www.suse.com/security/cve/CVE-2020-14776, https://www.suse.com/security/cve/CVE-2020-14789, https://www.suse.com/security/cve/CVE-2020-14812, https://www.suse.com/security/cve/CVE-2020-15180, https://www.suse.com/security/cve/CVE-2020-2574, https://www.suse.com/security/cve/CVE-2020-2752, https://www.suse.com/security/cve/CVE-2020-2760, https://www.suse.com/security/cve/CVE-2020-2812, https://www.suse.com/security/cve/CVE-2020-2814, https://www.suse.com/security/cve/CVE-2020-7221, https://www.suse.com/security/cve/CVE-2021-2154, https://www.suse.com/security/cve/CVE-2021-2166, https://www.suse.com/security/cve/CVE-2021-2372, https://www.suse.com/security/cve/CVE-2021-2389, https://www.suse.com/security/cve/CVE-2021-27928, https://www.suse.com/security/cve/CVE-2021-35604, https://www.suse.com/security/cve/CVE-2021-46657, https://www.suse.com/security/cve/CVE-2021-46658, https://www.suse.com/security/cve/CVE-2021-46659, https://www.suse.com/security/cve/CVE-2021-46661, https://www.suse.com/security/cve/CVE-2021-46663, https://www.suse.com/security/cve/CVE-2021-46664, https://www.suse.com/security/cve/CVE-2021-46665, https://www.suse.com/security/cve/CVE-2021-46668, https://www.suse.com/security/cve/CVE-2021-46669, https://www.suse.com/security/cve/CVE-2022-21427, https://www.suse.com/security/cve/CVE-2022-21595, https://www.suse.com/security/cve/CVE-2022-24048, https://www.suse.com/security/cve/CVE-2022-24050, https://www.suse.com/security/cve/CVE-2022-24051, https://www.suse.com/security/cve/CVE-2022-24052, https://www.suse.com/security/cve/CVE-2022-27376, https://www.suse.com/security/cve/CVE-2022-27377, https://www.suse.com/security/cve/CVE-2022-27378, https://www.suse.com/security/cve/CVE-2022-27379, https://www.suse.com/security/cve/CVE-2022-27380, https://www.suse.com/security/cve/CVE-2022-27381, https://www.suse.com/security/cve/CVE-2022-27382, https://www.suse.com/security/cve/CVE-2022-27383, https://www.suse.com/security/cve/CVE-2022-27384, https://www.suse.com/security/cve/CVE-2022-27386, https://www.suse.com/security/cve/CVE-2022-27387, https://www.suse.com/security/cve/CVE-2022-27444, https://www.suse.com/security/cve/CVE-2022-27445, https://www.suse.com/security/cve/CVE-2022-27446, https://www.suse.com/security/cve/CVE-2022-27447, https://www.suse.com/security/cve/CVE-2022-27448, https://www.suse.com/security/cve/CVE-2022-27449, https://www.suse.com/security/cve/CVE-2022-27451, https://www.suse.com/security/cve/CVE-2022-27452, https://www.suse.com/security/cve/CVE-2022-27455, https://www.suse.com/security/cve/CVE-2022-27456, https://www.suse.com/security/cve/CVE-2022-27457, https://www.suse.com/security/cve/CVE-2022-27458, https://www.suse.com/security/cve/CVE-2022-32081, https://www.suse.com/security/cve/CVE-2022-32083, https://www.suse.com/security/cve/CVE-2022-32084, https://www.suse.com/security/cve/CVE-2022-32085, https://www.suse.com/security/cve/CVE-2022-32086, https://www.suse.com/security/cve/CVE-2022-32087, https://www.suse.com/security/cve/CVE-2022-32088, https://www.suse.com/security/cve/CVE-2022-32089, https://www.suse.com/security/cve/CVE-2022-32091, https://www.suse.com/security/cve/CVE-2022-38791, https://www.suse.com/security/cve/CVE-2022-47015