Hello,
I tryed to set up a MySQL cluster for the first time on Debian.
I think the ndb is running correct. But I can't login to the database.
this is what I get:
node2:/etc/mysql# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
on the management node everything seems to be working:
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.201 (Version: 5.0.18, Nodegroup: 0, Master)
id=3 @192.168.0.202 (Version: 5.0.18, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.203 (Version: 5.0.18)
[mysqld(API)] 2 node(s)
id=4 @192.168.0.202 (Version: 5.0.18)
id=5 (not connected, accepting connect from any host)
the mysql deamon seems to be running:
node2:/etc/mysql# ps -ax | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See
http://procps.sf.net/faq.html
1014 ? Ss 0:00 /usr/local/mysql/bin/ndbd --initial
1015 ? R 0:21 /usr/local/mysql/bin/ndbd --initial
1016 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1017 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1018 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1019 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1020 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1021 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1022 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1023 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1024 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1025 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1026 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1027 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1028 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1029 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1030 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1031 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1032 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1033 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1034 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1035 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1036 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1037 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1038 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1039 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1040 ? S 0:02 /usr/local/mysql/bin/ndbd --initial
1041 ? S 0:02 /usr/local/mysql/bin/ndbd --initial
1042 ? S 0:02 /usr/local/mysql/bin/ndbd --initial
1043 ? S 0:02 /usr/local/mysql/bin/ndbd --initial
1044 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1045 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1046 ? S 0:00 /usr/local/mysql/bin/ndbd --initial
1365 pts/1 S 0:00 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/node2.pid
1386 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1387 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1388 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1389 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1390 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1391 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1393 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1394 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1395 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1396 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1397 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1398 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1399 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1400 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1405 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1406 pts/1 S 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/node2.pid --skip-locking
1409 pts/1 R+ 0:00 grep mysql
my /etc/my.conf file on the cluster nodes:
[mysqld]
ndbcluster
# the IP of the MANAGMENT (THIRD) SERVER
ndb-connectstring=192.168.0.203
[mysql_cluster]
# the IP of the MANAGMENT (THIRD) SERVER
ndb-connectstring=192.168.0.203
I'm thinking it had something to do with the my.conf file. but I can't figure it out.
can someone help me out?
Thanks in advance