Dear Johan:

I checked using show.sh (yes I did install using your core script).

root@dffimport:~/mysqlcluster-71/cluster/scripts# ./show.sh
Connected to Management Server at: 10.0.0.10:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=3 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10, Nodegroup: 0, Master)
id=4 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10, Nodegroup: 0)
id=5 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10, Nodegroup: 1)
id=6 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10, Nodegroup: 1)
[ndb_mgmd(MGM)] 2 node(s)
id=1 @10.0.0.10  (mysql-5.1.51 ndb-7.1.10)
id=2 @10.0.0.180  (mysql-5.1.51 ndb-7.1.10)
[mysqld(API)] 36 node(s)
id=7 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=8 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=9 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=10 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=11 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=12 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=13 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=14 @10.0.60.1  (mysql-5.1.51 ndb-7.1.10)
id=15 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=16 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=17 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=18 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=19 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=20 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=21 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=22 @10.0.60.2  (mysql-5.1.51 ndb-7.1.10)
id=23 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=24 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=25 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=26 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=27 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=28 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=29 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=30 @10.0.60.3  (mysql-5.1.51 ndb-7.1.10)
id=31 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=32 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=33 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=34 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=35 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=36 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=37 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=38 @10.0.60.4  (mysql-5.1.51 ndb-7.1.10)
id=39 (not connected, accepting connect from 10.0.0.10)
id=40 (not connected, accepting connect from 10.0.0.180)
id=41 (not connected, accepting connect from 10.0.0.10)
id=42 (not connected, accepting connect from 10.0.0.180)


So it looks like id 39 - 42 are there and waiting...

Then I re-read your email and re-read all the documentation, that is when I
noticed you wrote "it must match the hostname where you start cmon" which
means the empty slots are not listening to my cmon server at 10.0.60.254, so
I added the [MYSQLD] hostname=10.0.60.254, did a rolling re-start, and it
works now...

Thank you so much for your help. Our company have not decided to use MySQL
Cluster, but if we do we will probably buy the CMON enterprise, how much is
it?

Also, can you give me an idea how much it cost for your consultation for
MySQL questions by email or by chat?

I have 1 last question... all my mysqld nodes are showing connected but can
not be managed? why? because I have not granted cmon user for each mysqld
server?

Thanks again...

Hadi "Andrew" Nurcahya
http://www.DataFeedFile.com

<email address hidden>
phone: 281-808-3698
fax: 832-201-9364
skype: datafeedfile | twitter: anurcahya | linkedin: andrewnurcahya
http://www.DataFeedFile.com
http://www.PriceTime.com

------------------------------------------


On Fri, Mar 18, 2011 at 11:27 AM, johan <email address hidden> wrote:

> Hi Hadi,
>
> The problem is the following:
> Mar 18 10:30:12 : (INFO) Trying to connect to management servers...
> Mar 18 10:30:12 : (INFO) Could not connect to management server(s). -
> make sure you have an API slot free in config.ini (http://
> www.severalnines.com/cmon/doc/apislot.html ). cmon will continue to work
> but the aggregation of ndb statistics such as diskdata info will not
> work. Retrying in 10 seconds.
>
>
> I guess this has been a problem since startup and then tables will not
> be created (cmon creates the automatically).
> To fix this:
> 1) check that you have a free [mysqld] /[api] slot. Do this by:
> ./show.sh  (if you use the core scripts)
> ndb_mgm -e "show"   (if you don't use the core scripts)
>
> What should be printed out should look like:
>
> |... *id=6 (not connected, accepting connect from localhost)*|
>  or
> |... *id=6 (not connected, accepting connect from any host)*|
>
> IF you don't have this you must add a an api slot so that cmon can join
> the cluster.
>
> * Edit your config.ini and add
> [mysqld]
> at the end of the file
>
> Restart the management servers
> Restart the data nodes one by one.
>
> If you the core scripts you can do:
> ./rolling-restart.sh
>
> Let me know if this works for you.
>
> BR
> johan
>
>
> On 2011-03-18 16.30, Andrew Nurcahya wrote:
> > Dear Johan:
> >
> > Thanks for the quick reply.
> > Here is the /var/log/cmon.log
> >
> > Thanks
> >
> > Hadi "Andrew" Nurcahya
> > http://www.DataFeedFile.com
> >
> > <email address hidden>
> > phone: 281-808-3698
> > fax: 832-201-9364
> > skype: datafeedfile | twitter: anurcahya | linkedin: andrewnurcahya
> > http://www.DataFeedFile.com
> > http://www.PriceTime.com
> >
> > ------------------------------------------
> >
> >
> > On Fri, Mar 18, 2011 at 9:45 AM, johan<email address hidden>  wrote:
> >
> >> Hi again,
> >>
> >> pressed the send to quickly.
> >>
> >> Can you also send me the cmon.log file
> >>
> >> It is by default in /var/log/cmon.log.
> >>
> >> BR
> >> johan
> >>
> >>
> >> On 2011-03-18 15.19, Andrew Nurcahya wrote:
> >>> Public bug reported:
> >>>
> >>> Hello, I have tried to install CMON community 2 days ago and can not
> get
> >>> it to work. It never created tables in MySQL. I have already went
> >>> through the SETUP in the PHP website and it did not complain with any
> >>> error. But I do not see any table created and have this error:
> >>>
> >>> Invalid query: Table 'cmon.cluster' doesn't exist
> >>>
> >>> Please help, what should I do?
> >>>
> >>> Thanks
> >>>
> >>> --Andrew
> >>>
> >>> ** Affects: cmon
> >>>        Importance: Undecided
> >>>            Status: New
> >>>
> >> --
> >> You received this bug notification because you are a direct subscriber
> >> of the bug.
> >> https://bugs.launchpad.net/bugs/737580
> >>
> >> Title:
> >>   CMON community: missing table after setup Invalid query: Table
> >>   'cmon.cluster' doesn't exist
> >>
> >> Status in cmon  - MySQL Cluster monitoring:
> >>   New
> >>
> >> Bug description:
> >>   Hello, I have tried to install CMON community 2 days ago and can not
> >>   get it to work. It never created tables in MySQL. I have already went
> >>   through the SETUP in the PHP website and it did not complain with any
> >>   error. But I do not see any table created and have this error:
> >>
> >>   Invalid query: Table 'cmon.cluster' doesn't exist
> >>
> >>   Please help, what should I do?
> >>
> >>   Thanks
> >>
> >>   --Andrew
> >>
> >> To unsubscribe from this bug, go to:
> >> https://bugs.launchpad.net/cmon/+bug/737580/+subscribe
> >>
> >
> > ** Attachment added: "cmon.log"
> >
> https://bugs.launchpad.net/bugs/737580/+attachment/1917618/+files/cmon.log
> >
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/737580
>
> Title:
>  CMON community: missing table after setup Invalid query: Table
>  'cmon.cluster' doesn't exist
>
> Status in cmon  - MySQL Cluster monitoring:
>  New
>
> Bug description:
>  Hello, I have tried to install CMON community 2 days ago and can not
>  get it to work. It never created tables in MySQL. I have already went
>  through the SETUP in the PHP website and it did not complain with any
>  error. But I do not see any table created and have this error:
>
>  Invalid query: Table 'cmon.cluster' doesn't exist
>
>  Please help, what should I do?
>
>  Thanks
>
>  --Andrew
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/cmon/+bug/737580/+subscribe
>