maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

It is just a simpler way to do authentication:
https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/

Unless you use it intentionally, I don't think it can break anything. I'd just comment the line and then, for consistency, I'd uninstall that plugin in other nodes in case it is installed.

Federico



--------------------------------------------
Lun 3/7/17, Jonathan Gazeley <Jonathan.Gazeley@xxxxxxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] Can't open shared library	'/usr/lib64/mysql/plugin/auth_socket.so'
 A: maria-discuss@xxxxxxxxxxxxxxxxxxx
 Data: Lunedì 3 luglio 2017, 14:13
 
 Hi folks,
 
 I did a routine reboot on one of my
 database nodes and it was unable to 
 start up wsrep afterwards. I'm running
 MariaDB 10.1.24 with Galera 
 25.3.20 on CentOS 7.3.1611 (latest).
 
 Jul 03 09:53:07 db2.example.com
 sh[14400]: WSREP: Failed to start mysqld 
 for wsrep recovery: '2017-07-03 
 9:50:49 139825954236672 [ERROR] Can't 
 open shared library
 '/usr/lib64/mysql/plugin/auth_socket.so' (errno: 0, 
 cannot open shared object file: No such
 file or directory)
 Jul 03 09:53:07 db2.example.com
 sh[14400]: 2017-07-03  9:50:49 
 139825954236672 [ERROR] Couldn't load
 plugins from 'auth_socket.so'.
 
 It fails to find auth_socket.so, but
 when I check in yum what provides 
 that file, only MariaDB 5.5 from the
 CentOS repo has it, but not MariaDB 
 10.1 from the MariaDB repo. I read in
 the notes that auth_socket is 
 deprecated and going in 10.2. My config
 file specifies 
 'loose-plugin-load=auth_socket'. If I
 just remove this line, will it 
 work? Will it break wsrep?
 
 Can someone explain this to me? Right
 now I am nervous because if the 
 other nodes also can't start up wsrep
 after rebooting then I will lose 
 my cluster. I'm looking for ways to
 resolve the problem and get the node 
 back online. I'm happy to upgrade to
 10.2 if necessary.
 
 Thanks,
 Jonathan
 
 
 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp