Page MenuHomePhabricator

Clean up unix_socket flag in my.cnf
Closed, ResolvedPublic

Description

The unix_socket plugin no longer requires specific entries on my.cnf as since 10.4.3 it is enabled by default and only needs to show up on my.cnf to be specifically disabled.
https://mariadb.com/kb/en/authentication-plugin-unix-socket/

In MariaDB 10.4.3 and later, the unix_socket authentication plugin is installed by default, so if you do not want it to be available by default on those versions, then you will need to disable it.

Let's do a quick test and if it is all fine, clean it up.

Event Timeline

Marostegui moved this task from Triage to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2022-12-14T12:55:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1119 T325154', diff saved to https://phabricator.wikimedia.org/P42692 and previous config saved to /var/cache/conftool/dbconfig/20221214-125544-marostegui.json

On the test cluster (10.6) this flag isn't on my.cnf and the hosts do have the plugin enabled.

Mentioned in SAL (#wikimedia-operations) [2022-12-14T12:59:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1099:3318 T325154', diff saved to https://phabricator.wikimedia.org/P42694 and previous config saved to /var/cache/conftool/dbconfig/20221214-125950-marostegui.json

Change 868079 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] db_inventory.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868079

Change 868079 merged by Marostegui:

[operations/puppet@production] db_inventory.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868079

Change 868083 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] sanitarium_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868083

Change 868083 merged by Marostegui:

[operations/puppet@production] sanitarium_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868083

Change 868213 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] phabricator.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868213

Change 868213 merged by Marostegui:

[operations/puppet@production] phabricator.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868213

Change 868225 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] parsercache.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868225

Change 868225 merged by Marostegui:

[operations/puppet@production] parsercache.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868225

Change 868511 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] misc.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868511

Change 868511 merged by Marostegui:

[operations/puppet@production] misc.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868511

Change 868512 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] wikireplicas.my.cnf: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868512

Change 868512 merged by Marostegui:

[operations/puppet@production] wikireplicas.my.cnf: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868512

Change 868513 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] core_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868513

Change 868513 merged by Marostegui:

[operations/puppet@production] core_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/868513

Change 869179 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] wikitech.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869179

Change 869179 merged by Marostegui:

[operations/puppet@production] wikitech.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869179

Change 869352 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] misc_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869352

Change 869352 merged by Marostegui:

[operations/puppet@production] misc_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869352

Change 869579 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] dbstore_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869579

Change 869579 merged by Marostegui:

[operations/puppet@production] dbstore_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869579

Change 869867 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] analytics_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869867

Change 869867 merged by Marostegui:

[operations/puppet@production] analytics_multiinstance.my.cnf.erb: Remove unix_socket mention

https://gerrit.wikimedia.org/r/869867

Change 870744 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] analytics-meta.my.cnf.erb: : Remove unix_socket mention

https://gerrit.wikimedia.org/r/870744

Change 870744 merged by Marostegui:

[operations/puppet@production] analytics-meta.my.cnf.erb: : Remove unix_socket mention

https://gerrit.wikimedia.org/r/870744

Change 870751 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] mariadb: Clarify unix_socket entries

https://gerrit.wikimedia.org/r/870751

Change 870751 merged by Marostegui:

[operations/puppet@production] mariadb: Clarify unix_socket entries

https://gerrit.wikimedia.org/r/870751