From owner-freebsd-current@FreeBSD.ORG Thu Nov 29 14:43:33 2007 Return-Path: Delivered-To: current@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1295C16A479 for ; Thu, 29 Nov 2007 14:43:33 +0000 (UTC) (envelope-from bra@fsn.hu) Received: from people.fsn.hu (people.fsn.hu [195.228.252.137]) by mx1.freebsd.org (Postfix) with ESMTP id AD72013C44B for ; Thu, 29 Nov 2007 14:43:32 +0000 (UTC) (envelope-from bra@fsn.hu) Received: from japan.t-online.private (people [192.168.2.4]) by people.fsn.hu (Postfix) with ESMTP id 978D1100B28 for ; Thu, 29 Nov 2007 15:24:03 +0100 (CET) Message-ID: <474ECB7E.5090707@fsn.hu> Date: Thu, 29 Nov 2007 15:23:58 +0100 From: Attila Nagy User-Agent: Thunderbird 2.0.0.0 (X11/20070421) MIME-Version: 1.0 To: current@FreeBSD.org Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit Cc: Subject: MySQL cluster ndb_mgmd problems on FreeBSD 7.x X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 29 Nov 2007 14:43:33 -0000 Hello, I have four machines, each of them are in the same IP subnet and running FreeBSD 7.0-BETA2. On these machines I'm trying to set up a MySQL cluster (one management node, one SQL node and two data nodes). The problem is that on the management node I can't use the NDB management client (/usr/local/bin/ndb_mgm), even on localhost and also, the MySQL process on the SQL node can't connect to the management node. The strange thing is that if I install a 6-STABLE world into a directory, install the same MySQL from ports in that chroot, and run the NBD management daemon (ndb_mgmd) *outside* the chroot (so a 6.x binary in 7.x world), everything starts to work perfectly. I'm not sure where could I start. So: with an ndb_mgmd built on 6.x and ran on 7.x the whole stack works, with the same binary, but built and ran on 7.x it does not (the NDB management client is unusable and the MySQL daemon can't connect too). The config is very basic. NDB-related config: [ndbd default] NoOfReplicas=2 DataMemory=80M IndexMemory=18M [ndb_mgmd] hostname=172.16.1.2 datadir=/data/mysql-cluster [ndbd] hostname=172.16.1.8 datadir=/data/mysql [ndbd] hostname=172.16.1.9 datadir=/data/mysql [mysqld] hostname=172.16.1.4 my.cnf on the SQL node: [mysqld] ndbcluster ndb-connectstring = 172.16.1.2 datadir = /data/mysql socket = /tmp/mysql.sock [mysql_cluster] ndb-connectstring = 172.16.1.2 Any ideas? Anybody running MySQL cluster on 7.x? Thanks, -- Attila Nagy e-mail: Attila.Nagy@fsn.hu Free Software Network (FSN.HU) phone: +3630 306 6758 http://www.fsn.hu/