OpenLDAP with MySQL Cluster - No free node Error

[Priyesh Potdar <priyesh.potdar@dimdim.com>]

Hi All,

I am new to use of ndb with openLDAP. I have established a MySQL Cluster
in my network and also compiled the openLDAP with --enable-ndb option.
Now when I start the openLDAP with command "slapd -d 5" (To see the
debug output), I get the following error:

Configuration error: Error : Could not alloc node id at 192.168.7.40
port 1186: No free node id found for mysqld(API).

My slapd.conf contains :

#######################################################################

database        ndb
suffix          "dc=example,dc=com"
rootdn          "cn=Manager,dc=example,dc=com"
# Cleartext passwords, especially for the rootdn, should
# be avoid.  See slappasswd(8) and slapd.conf(5) for details.
# Use of strong authentication encouraged.
rootpw          secret

dbconnect 192.168.7.40
## dbhost - mysql host, where you mysql server resides, used to create
schemas
dbhost 192.168.7.40
## dbname - mysql database
dbname testing
## dbuser - mysql user name
dbuser root
## dbpass - mysql user password (empty in this case)
dbpass ""
## dbconnections - how many connections slapd should make to Cluster
## (like ndb-cluster-connection-pool)
dbconnections 1
# should only be accessible by the slapd and slap tools.
# Mode 700 recommended.
directory       /usr/local/var/openldap-data
# Indices to maintain
#index  objectClass     eq


Output from the ndbd_mgm show command is as follows:

-- NDB Cluster -- Management Client --
ndb_mgm>     show
Connected to Management Server at: 192.168.7.40:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     3 node(s)
id=2    @192.168.7.30  (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0, Master)
id=3    @192.168.7.56  (mysql-5.1.44 ndb-7.1.3, Nodegroup: 1)
id=4 (not connected, accepting connect from 192.168.7.40)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.7.40  (mysql-5.1.44 ndb-7.1.3)

[mysqld(API)]   8 node(s)
id=5    @192.168.7.30  (mysql-5.1.44 ndb-7.1.3)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)

and Config.ini file contains the following data:

[NDBD DEFAULT]
NoOfReplicas=1
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Managment Server
[NDB_MGMD]
HostName=192.168.7.40
# Storage Engines
[NDBD]
HostName=192.168.7.30
[NDBD]
HostName=192.168.7.56
[NDBD]
HostName=192.168.7.40

[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]

[API]
[API]
[API]
[API]


Any help on the same is appreciated.

Thanks,
Priyesh Potdar