[Monitorix-general] Ubuntu 15.04 and Monitorix v3.7.0 / MySQL 5.6

[Anthony Stump]

I'm not sure if it's something I'm doing wrong or if there is a bug in
Monitorix, but I'm unable to get Monitorix to connect to MySQL.

Here are settings (and yes I included password, don't really care because
it's bound to localhost.)

# MYSQL graph
#
-----------------------------------------------------------------------------
<mysql>
conn_type = host
list = localhost
# list = /var/run/mysqld/mysqld.sock
<desc>
localhost = 3306, monitorix, m0n1t0r1x15
</desc>
rigid = 0, 2, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100
</mysql>

I tested the connection in MySQL - it's setup per instructions:

***@astump15:~$ mysql -u monitorix -pm0n1t0r1x15 -h localhost
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2361

But I'm getting this in the monitorix log:

Sun May 10 21:09:00 2015 - mysql::mysql_update: Cannot connect to MySQL
'/var/run/mysqld/mysqld.sock'.
Sun May 10 21:09:00 2015 - ERROR: while updating
/var/lib/monitorix/mysql.rrd: /var/lib/monitorix/mysql.rrd: expected
timestamp not found in data source from N

[Koko Wijatmoko]

On Sun, 10 May 2015 21:11:19 -0500

Post by Anthony Stump
Sun May 10 21:09:00 2015 - mysql::mysql_update: Cannot connect to
MySQL '/var/run/mysqld/mysqld.sock'.
Sun May 10 21:09:00 2015 - ERROR: while updating
/var/lib/monitorix/mysql.rrd: /var/lib/monitorix/mysql.rrd: expected
timestamp not found in data source from N

perhaps mysqld.sock permission issue?

[Jordi Sanfeliu]

Hello,

This could be caused by the extra configuration file that comes with the
Debian/Ubuntu package, located in '/etc/monitorix/conf.d/' directory.

Please, read the following excerpt from the installation HOWTO for
Debian/Ubuntu systems:

<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."

I hope that helped.
Regards.

Post by Anthony Stump
I'm not sure if it's something I'm doing wrong or if there is a bug in
Monitorix, but I'm unable to get Monitorix to connect to MySQL.
Here are settings (and yes I included password, don't really care
because it's bound to localhost.)
# MYSQL graph
#
-----------------------------------------------------------------------------
<mysql>
conn_type = host
list = localhost
# list = /var/run/mysqld/mysqld.sock
<desc>
localhost = 3306, monitorix, m0n1t0r1x15
</desc>
rigid = 0, 2, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100
</mysql>
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2361
Sun May 10 21:09:00 2015 - mysql::mysql_update: Cannot connect to MySQL
'/var/run/mysqld/mysqld.sock'.
Sun May 10 21:09:00 2015 - ERROR: while updating
/var/lib/monitorix/mysql.rrd: /var/lib/monitorix/mysql.rrd: expected
timestamp not found in data source from N
--
Thank you,
Anthony Stump

[Anthony Stump]

Yup. Forgot the debian config... :S

Post by Jordi Sanfeliu
Hello,
This could be caused by the extra configuration file that comes with the
Debian/Ubuntu package, located in '/etc/monitorix/conf.d/' directory.
Please, read the following excerpt from the installation HOWTO for
<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."
I hope that helped.
Regards.

Post by Anthony Stump
I'm not sure if it's something I'm doing wrong or if there is a bug in
Monitorix, but I'm unable to get Monitorix to connect to MySQL.
Here are settings (and yes I included password, don't really care
because it's bound to localhost.)
# MYSQL graph
#

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

Post by Anthony Stump
<mysql>
conn_type = host
list = localhost
# list = /var/run/mysqld/mysqld.sock
<desc>
localhost = 3306, monitorix, m0n1t0r1x15
</desc>
rigid = 0, 2, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100
</mysql>
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2361
Sun May 10 21:09:00 2015 - mysql::mysql_update: Cannot connect to MySQL
'/var/run/mysqld/mysqld.sock'.
Sun May 10 21:09:00 2015 - ERROR: while updating
/var/lib/monitorix/mysql.rrd: /var/lib/monitorix/mysql.rrd: expected
timestamp not found in data source from N
--
Thank you,
Anthony Stump

--
Jordi Sanfeliu
FIBRANET Network Services Provider
http://www.fibranet.cat
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Monitorix-general mailing list
https://lists.sourceforge.net/lists/listinfo/monitorix-general