MySQL Forums
Forum List  »  NDB clusters

Can't connect to local MySQL server
Posted by: Tom Dauwen
Date: February 28, 2006 08:10AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't connect to local MySQL server
4697
February 28, 2006 08:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.