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

[Jordi S. <jo...@fi...>]

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.



On 10/16/2014 03:15 PM, czezz wrote:
> 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
FIBRANET Network Services Provider
http://www.fibranet.cat