When running setup-kolab you only have 2 options: new OR existing
- new: will reset the mysql root server password and changes the method to native_password
- existing: asks for a root given password
MariaDB 10.4+ (Debian Stretch and Buster) comes with unix_socket authentication enabled per default. Aka ... there's no default root password. If you select "new" it will automatically changes root@localhost from unix_socket to native_password which breaks other maintenance scripts.
It would be great if setup-kolab could/would support unix_socket authentication for creating kolab and roundcube user/database.
- add a 3rd option (new, existing, unix_socket). unix_socket would be similar to existing but without password. While this sounds nice in the first place, other setup parts (roundcube, syncrotron) don't know about it and will ask for rootpw
- When asking for the rootpw we could say: the string unix_socket triggers the unix_socket authentication instead of pw authentication.
I personally think that solution 2 is viable. We could support the new unix_socket auth plugin and don't have to change too many arguments or setup logic only for the one-time setup.