Unable to connect with connect string: nodeid 10,172.17.3.66:1186

There's a comma between 10 and 172 instead of a period.



-----Original Message-----
From: Aastha [mailto:aastha3@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node

Helo,

I am receiving error when trying to start the data node. The configuration seems ok. Kindly help.

*C:\mysql\bin>ndbd*
*Unable to connect with connect string: nodeid 10,172.17.3.66:1186* *Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1,
failed.*
*2012-08-07 18:19:20 [ndbd] ERROR -- Could not connect to management
server, e**rror: ''*

*Config.ini on management node :*

[ndbd default]

# Options affecting ndbd processes on all data nodes:

NoOfReplicas 1 # Number of replicas

DataDir C:/mysql/bin/cluster-data # Directory for each data node's data
files

# Forward slashes used in directory path,

# rather than backslashes. This is correct;

# see Important note in text

DataMemory 80M # Memory allocated to data storage

IndexMemory 18M # Memory allocated to index storage

# For DataMemory and IndexMemory, we have used the

# default values. Since the "world" database takes up

# only about 500KB, this should be more than enough for

# this example Cluster setup.


[ndb_mgmd]

# Management process options:

HostName 172.17.3.66 # Hostname or IP address of management
node

DataDir C:/mysql/bin/cluster-logs # Directory for management node log
files

NodeId 1

[ndbd]

# Options for data node "A":

HostName 172.17.3.69 # Hostname or IP address

NodeId 10

MaxNoOfOrderedIndexes 1024

MaxNoOfAttributes 3000 # added 2012.7.20

[mysqld]

# SQL node A options:

HostName 172.17.3.68 # Hostname or IP address

NodeId 60

[mysqld]

# SQL node B options:

HostName 172.17.3.67 # Hostname or IP address

NodeId 61



*my.ini on management server*

[mysql_cluster]

# Options for management node process

config-file c:/mysql/bin/config.ini

configdir c:/mysql/bin/cluster-cache/


*my.ini on data node *

[mysql_cluster]

# Options for data nod process:

ndb-connectstring 172.17.3.66 # location of the management server

ndb-nodeid 10

Kindly help. I have looked at the configuration and things fine to me


Regards,

Aastha Gupta

________________________________

Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql

I just realized I shouldn't be reading these first thing in the morning before my first cup of coffee...... That says node id 10, then the IP. Sorry about that.


-----Original Message-----
From: Stillman, Benjamin [mailto:BStillman@limitedbrands.com]
Sent: Wednesday, August 08, 2012 8:56 AM
To: 'Aastha'; mysql@lists.mysql.com
Subject: RE: Error starting data node

Unable to connect with connect string: nodeid 10,172.17.3.66:1186

There's a comma between 10 and 172 instead of a period.



-----Original Message-----
From: Aastha [mailto:aastha3@gmail.com]
Sent: Tuesday, August 07, 2012 6:20 PM
To: mysql@lists.mysql.com
Subject: Error starting data node

Helo,

I am receiving error when trying to start the data node. The configuration seems ok. Kindly help.

*C:\mysql\bin>ndbd*
*Unable to connect with connect string: nodeid 10,172.17.3.66:1186* *Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1,
failed.*
*2012-08-07 18:19:20 [ndbd] ERROR -- Could not connect to management
server, e**rror: ''*

*Config.ini on management node :*

[ndbd default]

# Options affecting ndbd processes on all data nodes:

NoOfReplicas 1 # Number of replicas

DataDir C:/mysql/bin/cluster-data # Directory for each data node's data
files

# Forward slashes used in directory path,

# rather than backslashes. This is correct;

# see Important note in text

DataMemory 80M # Memory allocated to data storage

IndexMemory 18M # Memory allocated to index storage

# For DataMemory and IndexMemory, we have used the

# default values. Since the "world" database takes up

# only about 500KB, this should be more than enough for

# this example Cluster setup.


[ndb_mgmd]

# Management process options:

HostName 172.17.3.66 # Hostname or IP address of management
node

DataDir C:/mysql/bin/cluster-logs # Directory for management node log
files

NodeId 1

[ndbd]

# Options for data node "A":

HostName 172.17.3.69 # Hostname or IP address

NodeId 10

MaxNoOfOrderedIndexes 1024

MaxNoOfAttributes 3000 # added 2012.7.20

[mysqld]

# SQL node A options:

HostName 172.17.3.68 # Hostname or IP address

NodeId 60

[mysqld]

# SQL node B options:

HostName 172.17.3.67 # Hostname or IP address

NodeId 61



*my.ini on management server*

[mysql_cluster]

# Options for management node process

config-file c:/mysql/bin/config.ini

configdir c:/mysql/bin/cluster-cache/


*my.ini on data node *

[mysql_cluster]

# Options for data nod process:

ndb-connectstring 172.17.3.66 # location of the management server

ndb-nodeid 10

Kindly help. I have looked at the configuration and things fine to me


Regards,

Aastha Gupta

________________________________

Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql