[Maria-discuss] Can't connect to local MySQL server through socket
-----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-----
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@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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi On 24/06/2015 14:13, Guillaume Lefranc wrote:
Hello Sylvain,
the last lines of the error log of nodes 2 and 3 would be more helpful.
Here are the last 20 lines of error log on node #2: http://pastebin.com/XQduzP18 and node #3: http://pastebin.com/x8dshEph
Also how do you start your cluster? Do you bootstrap the first node correctly then start the two other nodes?
I start the cluster on node #1 with: /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf - --wsrep-new-cluster on node #2 with: /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf - --wsrep-cluster-address=gcomm://192.168.1.77 and on node #3 with: /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf - --wsrep-cluster-address=gcomm://192.168.1.77,192.168.1.80 192.168.1.77 and 192.168.1.80 are the IP addresses of nodes #1 and #2. Maybe the thing I'm missing is bootstrapping the first node because I'm not sure what it means. I'm on my way to look it up. Thanks, Sylvain
Thanks Guillaume
2015-06-24 14:04 GMT+02:00 Sylvain Raybaud <sylvain.raybaud@green-communications.fr <mailto:sylvain.raybaud@green-communications.fr>>:
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,
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
- -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJViqNoAAoJEEkkwl4JtJ9ytekP/0rWfUfvtT2MIT0kmLLGA2lM w9D7IRsve8/K/JzeKrKMkP+XyE9K+Aq/bl+5SQi2pV9s+i7GkHFRzpLBcrhujQ/U BBfJKCJhqXSaLjPmxmRLaVH5QPC/BJCunDEdkQNZWXi8dsVXCKmVuqh8mNVtTCYy 8pdApgTZkUWQHU3lkZnsXPSQ6z59sxmu5TtGmNfKEtzo3S5oJFnbnvMcFErA7DYG nAjs+dRWPvYFhVfLyITWhKjfLkWYxAQ6ZzZElZUF2FqqBmaWpJaTKCM6KihLhAcb urDjv7H+uIozsjsrgn4YtFo9Ps4sq746WnmU6WRLvvU7JNZiDzTLD1+S5UmqdpZw 4MMu72kyA+x4mdi2fhQ5Pzvo096yzHfrEZrg6iqpXdJBvorTugHWqaQfh7Qki/jV J+JCOPFdC0KAGgau3gpmyPDDRlnzhid02ZUEqed4iH59tutjh6+M+6lUYd2gDVxS zXfSh8es4E0s/qOF0vWtoQe2dU647rmZRQc7Mws0n9J47oe4WO4gcF2qPjoGzUfy pND5k8RAnpmuW2KItmkT8TJF3VQkuim2GpM7RBWaTCFKluesqCZLJy1oplZWtkeH 62B16bsGw6AZmRv5SuttUCeGOjd8bZsOQch02mJzbUKhIH3JC+boum7vehIDWpQh 6g9gGNtyo3SgMCO9ottT =Rbks -----END PGP SIGNATURE-----
participants (2)
-
Guillaume Lefranc -
Sylvain Raybaud