[Monitorix-general] MySQL statistics show value: -nan

[czezz]

Hi,
I have a problem with configuring monitorix to monitor MySQL.
My MySQL is installed locally on this same machine as monitorix.
I have created user with passwd as stated in manual but I still cannot get any values on graphs.
All statistics for MySQL are like: -nan
This is my part of configuration for MySQL:
# MYSQL graph
# -----------------------------------------------------------------------------
<mysql>
        conn_type = host
        list = localhost
        <desc>
                localhost = 3306, monitorixuser, passwdmonitorix
        </desc>
        rigid = 0, 2, 0, 0, 0, 0
        limit = 100, 100, 100, 100, 100, 100
</mysql>
Can anyone advise what Im doing wrong ?
Cheers,
Czezz

[Jordi Sanfeliu]

Hi Czezz,

If you are using a Debian system (or a derivative), you should know that
there is a second configuration file in '/etc/monitorix/conf.d/' that is
probably overriding your settings.

As stated here: <http://www.monitorix.org/doc-debian.html>

"IMPORTANT NOTICE: The Debian package also comes with an extra
configuration file in /etc/monitorix/conf.d/00-debian.conf that includes
some options specially adapted for Debian systems. This file will be
loaded right after the main configuration file, hence some options in
the main configuration will be overwritten by this extra file."

Please, confirm this and if not, we can investigate it further.
Thanks.

Post by czezz
Hi,
I have a problem with configuring monitorix to monitor MySQL.
My MySQL is installed locally on this same machine as monitorix.
I have created user with passwd as stated in manual but I still cannot
get any values on graphs.
All statistics for MySQL are like: -nan
# MYSQL graph
#
-----------------------------------------------------------------------------
<mysql>
conn_type = host
list = localhost
<desc>
localhost = 3306, monitorixuser, passwdmonitorix
</desc>
rigid = 0, 2, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100
</mysql>
Can anyone advise what Im doing wrong ?
Cheers,
Czezz

[czezz]

Exactly! :)
Thanks for pointing that out. I have installed it on Ubuntu and that was of course the case.
BR,
Czezz
Dnia 16 października 2014 15:27 Jordi Sanfeliu &lt;***@fibranet.cat&gt; napisał(a):
Hi Czezz,
If you are using a Debian system (or a derivative), you should know that
there is a second configuration file in '/etc/monitorix/conf.d/' that is
probably overriding your settings.
As stated here: &lt;http://www.monitorix.org/doc-debian.html&gt;
"IMPORTANT NOTICE: The Debian package also comes with an extra
configuration file in /etc/monitorix/conf.d/00-debian.conf that includes
some options specially adapted for Debian systems. This file will be
loaded right after the main configuration file, hence some options in
the main configuration will be overwritten by this extra file."
Please, confirm this and if not, we can investigate it further.
Thanks.
On 10/16/2014 03:15 PM, czezz wrote:
&gt; Hi,
&gt; I have a problem with configuring monitorix to monitor MySQL.
&gt; My MySQL is installed locally on this same machine as monitorix.
&gt;
&gt; I have created user with passwd as stated in manual but I still cannot
&gt; get any values on graphs.
&gt; All statistics for MySQL are like: -nan
&gt;
&gt; This is my part of configuration for MySQL:
&gt;
&gt; # MYSQL graph
&gt; #
&gt; -----------------------------------------------------------------------------
&gt; &lt;mysql&gt;
&gt; conn_type = host
&gt; list = localhost
&gt; &lt;desc&gt;
&gt; localhost = 3306, monitorixuser, passwdmonitorix
&gt; &lt;/desc&gt;
&gt; rigid = 0, 2, 0, 0, 0, 0
&gt; limit = 100, 100, 100, 100, 100, 100
&gt; &lt;/mysql&gt;
&gt;
&gt; Can anyone advise what Im doing wrong ?
&gt;
&gt; Cheers,
&gt; Czezz
&gt;