#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0

    Please help error : Mixing of localhost (default for [NDBD]HostName) ...


    Hi all
    please help me slove error when i tried to install MySQL cluster , Error is : Mixing of localhost (default for [NDBD]HostName) with other hostname(192.168.5.192) is illegal

    config.ini :
    [ndb_mgmd]
    hostname=0.0.0.0
    datadir=c:\mysql\data
    NodeId=1

    [ndbd default]
    hostname=localhost
    noofreplicas=2
    datadir=c:\mysql\data

    [ndbd]
    hostname=127.0.0.1
    NodeId=3

    [ndbd]
    hostname=192.168.5.192
    NodeId=4

    [mysqld]
    hostname=127.0.0.1
    NodeId=50

    When i changed "192.168.5.192" to localhost , it is ok but ndbd is error : 2012-12-27 23:08:53 [ndbd] ERROR -- Failed to allocate nodeid, error: 'Error:
    Could not alloc node id at 192.168.5.206 port 1186: Connection done from wrong
    host ip 192.168.5.192.'

    Please help me . Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    2
    Rep Power
    0

    Cluster error : Mixing of localhost (default for [NDBD]HostName) ...


    Hi all
    please help me slove error when i tried to install MySQL cluster , Error is : Mixing of localhost (default for [NDBD]HostName) with other hostname(192.168.5.192) is illegal

    config.ini :
    [ndb_mgmd]
    hostname=0.0.0.0
    datadir=c:\mysql\data
    NodeId=1

    [ndbd default]
    hostname=localhost
    noofreplicas=2
    datadir=c:\mysql\data

    [ndbd]
    hostname=127.0.0.1
    NodeId=3

    [ndbd]
    hostname=192.168.5.192
    NodeId=4

    [mysqld]
    hostname=127.0.0.1
    NodeId=50

    When i changed "192.168.5.192" to localhost , it is ok but ndbd is error : 2012-12-27 23:08:53 [ndbd] ERROR -- Failed to allocate nodeid, error: 'Error:
    Could not alloc node id at 192.168.5.206 port 1186: Connection done from wrong
    host ip 192.168.5.192.'

    Please help me . Thanks

IMN logo majestic logo threadwatch logo seochat tools logo