MySQL-Max 4.1.14 refuses to join cluster as storage node

[Tim Pearson]

Hello all,

I have a problem with MySQL-Max not joining the cluster as a storage node. I am running Fedora Core 4 on two servers, and ndb_mgmd on an OpenWRT box (http://pcos.dyndns.org).

One of the Fedora Core servers works perfectly with the cluster, the other one does not, giving me this error message:

051013 17:04:36 mysqld ended

051013 17:04:37 mysqld started
051013 17:04:37 InnoDB: Started; log sequence number 0 44440
Configuration error: This node type mysqld(API) and config node type ndbd(NDB) don't match for nodeid 2
051013 17:04:38 [ERROR] Can't init databases
051013 17:04:38 [ERROR] Aborting

051013 17:04:38 InnoDB: Starting shutdown...
051013 17:04:40 InnoDB: Shutdown completed; log sequence number 0 44440
051013 17:04:40 [Note] /usr/sbin/mysqld-max: Shutdown complete

051013 17:04:40 mysqld ended


Contents of my.cnf for both servers is:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
ndbcluster
ndb-connectstring=nodeid=2,192.168.0.12

[mysql_cluster]
ndb-connectstring=nodeid=2,192.168.0.12

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

A check of the cluster via ndb_mgm shows that this server is started and active!?!?!

Yes, I am running ndbd first :-)

Can anyone help me with this problem? I have been through 4 re-installs and several reboots (of a production server :-P) with no success.

Thanks,

Tim