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.rayb...@green-communications.fr>: > -----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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
