CMON community: missing table after setup Invalid query: Table 'cmon.cluster' doesn't exist

[Andrew Nurcahya]

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

[johan (johan-severalnines)]

Hi Andrew,

Which version did you download?
I will look into this asap.

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
>

[johan (johan-severalnines)]

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
>

[Andrew Nurcahya (andrew-datafeedfile)]

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: [phone]
fax: [phone]
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
>

[johan (johan-severalnines)]

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: [phone]
> fax: [phone]
> 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?
>>
>> Thank...

[Andrew Nurcahya (andrew-datafeedfile)]

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: [phone]
fax: [phone]
skype: da...

[johan (johan-severalnines)]

Hi Andrew,

I will reply to you in a private email about your inquiries.

Regarding the the mysqld's not being connected, yest that is because you
haven't GRANTed as you write.

Best regards,
Johan

On 2011-03-19 02.53, Andrew Nurcahya wrote:
> 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?
>

[Andrew Nurcahya (andrew-datafeedfile)]

Ok Thanks Johan, I will look forward to your private email. Thanks

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

<email address hidden>
phone: [phone]
fax: [phone]
skype: datafeedfile | twitter: anurcahya | linkedin: andrewnurcahya
http://www.DataFeedFile.com
http://www.PriceTime.com

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

On Mon, Mar 21, 2011 at 10:13 AM, johan <email address hidden> wrote:

> Hi Andrew,
>
> I will reply to you in a private email about your inquiries.
>
> Regarding the the mysqld's not being connected, yest that is because you
> haven't GRANTed as you write.
>
>
> Best regards,
> Johan
>
> On 2011-03-19 02.53, Andrew Nurcahya wrote:
> > 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?
> >
>
> --
> 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
>