← Back to team overview

maria-discuss team mailing list archive

Re: Can't connect to local MySQL server through socket

 

Hello Sylvain,

the last lines of the error log of nodes 2 and 3 would be more helpful.
Also how do you start your cluster? Do you bootstrap the first node
correctly then start the two other nodes?

Thanks
Guillaume

2015-06-24 14:04 GMT+02:00 Sylvain Raybaud <
sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi
>
> I'm setting up a 3 nodes cluster of mariadb+galera. The cluster seems
> to be created properly:
>
> mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM
> INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"'
> Enter password:
> +--------------+
> | cluster size |
> +--------------+
> | 3            |
> +--------------+
>
>
> Problem is, I can only connect to mysql on the first node I create. On
> the other nodes it gives me:
>
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (111 "Connection refused")
>
> /tmp/mysql.sock does exist and has correct permissions. However it
> does not seem to be in listening state since it is not shown by
> netstat -l.
>
> I feel this must be some simple configuration problem but I'm quite stuck.
>
> My configuration can be found at: http://pastebin.com/gVie8uKp
>
> Note that since I'm compiling and running mariadb in buildroot I do
> not have /etc/mysql/debian.cnf.
>
> Any idea?
>
> Thanks,
>
>
> - --
> Sylvain Raybaud
> www.green-communications.fr
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iQIcBAEBAgAGBQJVipzlAAoJEEkkwl4JtJ9yn8MP/A3Ld0XxNmkO8DCh2znYud6u
> E3Wiuw35v+wD0EZx05H4nFT2eI/4G8tMCtWy1B0hJx0qiuyjMItXKMqL6yOIrZfx
> cA4WAikesCwrLCXZgmL5xj0/Ow+8hzNLctCxMNAmJvYUPcW4YyJkinA3C1ch65aa
> arrfg1/Z8B40VyapjeOc1T7jr97S1465+YMmB6G5aD/3aFBORYWEjqhMSutRKhfJ
> K7J6KIFQQwrL0gRqtiPwsMxsD2QW/bc8hQQvMz0Nuy7iriY3YZCCvPqtFA+r8cnp
> 6P4GB0Bp5YL7HY7SO5YuAKiUYmtb5koBoD1oMtuFBVNIFLTP5X8yWErZr2pZXRbx
> 97oCBWisp3VqQjPCJJBYLrmP4qx5aYU6+C/vcc51Kr+OEFOLeyszVFM85bPx5+ZL
> d8W5iuOUSBpguQ3P3dQV1PnBWGqe0FcotSHnDSQMD6lxFfQ/s09er3okqob/Wo1k
> cqKkqPfjMNUaXcE4yf6/UN/ytNMOnPyHVPQNaIsQmiS+TYoIEtf6T2nItMjfoCAz
> OJ1PaACOzXrvx3rClT/ay6w/TAjILM0O9GiIYsHhdJRrapgu59r57olZouTbmooo
> VpU7fKq9LnF3dgZOMFW1VBnegfseXWuyCmzXEXx7fiNpvzEukmDrhFpPAuNYdJ9Y
> Md+Mm44tp+FpWhFfrU6u
> =ybAn
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> 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
>

Follow ups

References