cmon start : Failed to get hostid

Asked by Fredouille91

Hello

I installed CMON with SeveralNines MySQL Cluster configurator.
My Cluster is working fine (every service is up), but when I start cmon, I have the following error :

------------------------------------------------------------------------------------
Oct 31 09:59:24 : (INFO) Registering managed cluster with cluster id=1

INSERT INTO cluster(id, type) VALUES(1,'mysqlcluster') ON DUPLICATE KEY UPDATE type='mysqlcluster'
Oct 31 09:59:24 : (INFO) Managed cluster has been registered - registered cluster id=1

skip=1 - INSERT INTO hosts(cid,hostname, ip, cmon_version) VALUES(1,'','','1.1.10') ON DUPLICATE KEY UPDATE cmon_version='1.1.10',hostname='',ip=''
Oct 31 09:59:24 : (ERROR) Failed to get hostid
Oct 31 09:59:24 : (ERROR) Critical error (mysql error code -1) occured - shutting down
------------------------------------------------------------------------------------

The cluster and host is written in the database host is empty :

------------------------------------------------------------------------------------
mysql> select * from hosts\G
*************************** 1. row ***************************
          id: 9
         cid: 1
    hostname:
 ping_status: 0
   ping_time: 0
          ip:
   report_ts: 2011-10-31 09:59:24
         msg:
cmon_version: 1.1.10
 cmon_status: 0000-00-00 00:00:00
1 row in set (0.00 sec)
------------------------------------------------------------------------------------

Here is my cluster informations :

------------------------------------------------------------------------------------
 ndb_mgm -e "SHOW"
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @10.10.10.102 (mysql-5.1.56 ndb-7.1.15, Nodegroup: 0, Master)
id=4 @10.10.10.103 (mysql-5.1.56 ndb-7.1.15, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @10.10.10.100 (mysql-5.1.56 ndb-7.1.15)
id=2 @10.10.10.101 (mysql-5.1.56 ndb-7.1.15)

[mysqld(API)] 15 node(s)
id=5 @10.10.10.102 (mysql-5.1.56 ndb-7.1.15)
id=6 @10.10.10.102 (mysql-5.1.56 ndb-7.1.15)
id=7 @10.10.10.102 (mysql-5.1.56 ndb-7.1.15)
id=8 @10.10.10.102 (mysql-5.1.56 ndb-7.1.15)
id=9 @10.10.10.103 (mysql-5.1.56 ndb-7.1.15)
id=10 @10.10.10.103 (mysql-5.1.56 ndb-7.1.15)
id=11 @10.10.10.103 (mysql-5.1.56 ndb-7.1.15)
id=12 @10.10.10.103 (mysql-5.1.56 ndb-7.1.15)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)
id=16 (not connected, accepting connect from any host)
id=17 (not connected, accepting connect from 10.10.10.100)
id=18 (not connected, accepting connect from 10.10.10.101)
id=19 (not connected, accepting connect from 10.10.10.105)
------------------------------------------------------------------------------------

Do you have any idea how I could correct this error ?

Thank you very much for your help,

Best regards,

Fred

Question information

Language:
English Edit question
Status:
Solved
For:
cmon Edit question
Assignee:
No assignee Edit question
Solved by:
Fredouille91
Solved:
Last query:
Last reply:
Revision history for this message
Fredouille91 (fred-prost) said :
#1

I finally managed to find a solution : I had to set skip_name_resolve=0 in /etc/cmon.cfg and define all hosts in y /etc/hosts for each host (including cmon host).