Zenoss ZenTech Community

When I add the MySQL Collector and configure parameters for MySQL for Zenoss Master Host, I receive an error:

2015-03-30 18:42:29,705 ERROR zen.PythonClient: Error modeling MySQL server for root:***:3306

I verified that I can log into MySQL from the MariaDB docker container and mysql connect to the database using root.

Please advise if I need to update anything else to ensure that the MySQL database monitoring works.

Subject:	Updated info ...
Author:	Ken Jenkins
Posted:	2015-03-30 21:48

When I check status of MySQL in the Control Center, the MariaDB database server shows as not answering, is this normal Zenoss Core 5 shows with a blue check.

Thanks,
Ken

Subject:	MariaDB is not listening on
Author:	Andrew Kirch
Posted:	2015-03-31 16:03

MariaDB is not listening on an external port. You could add a virtual host and monitor it that way if you wish. I don't know how much the MySQL ZP has been tested against MariaDB, but it shouldn't break anything.

Andrew Kirch

akirch@gvit.com

Need Zenoss support, consulting or custom development Look no further. Email or PM me!

Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard

Subject:	Added virtual host
Author:	Ken Jenkins
Posted:	2015-03-31 19:49

Added virtual host in Control Center to the MariaDB and updated the hosts file to reference the external IP like it was done with zenoss5.

Allowed MariaDB privs to the new virtual host too.

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'mariadb.zenoss01.##.##.##' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

Modeling failed ...

2015-04-01 00:38:22,689 INFO zen.ZenModeler: No portscan plugins found for mariadb.zenoss01##.##.##
2015-04-01 00:38:22,691 ERROR zen.PythonClient: Error modeling MySQL server for root:***:3306

I am looking for other ideas.

Thanks,
Ken

Subject:	could you please include the
Author:	Andrew Kirch
Posted:	2015-04-01 15:34

could you please include the output from a zenmodel run

Subject:	Output
Author:	Ken Jenkins
Posted:	2015-04-01 17:56

Please note that I am monitoring the MariaDB database instance using Device Class /Ping
I added the MySQL Collector plugin to the device
The Zenoss Master is monitored using Device Class /Devices/Servers/Linux
If there is a better way to monitor databases

2015-04-01 22:42:05,171 INFO zen.ZenModeler: Connecting to localhost:8789
2015-04-01 22:42:05,184 INFO zen.ZenModeler: Connected to ZenHub
2015-04-01 22:42:05,463 INFO zen.ZenModeler: Collecting for device mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,690 INFO zen.ZenModeler: skipping WMI-based collection, PySamba zenpack not installed
2015-04-01 22:42:05,766 INFO zen.ZenModeler: Python collection device mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,767 INFO zen.ZenModeler: plugins: MySQLCollector
2015-04-01 22:42:05,767 INFO zen.PythonClient: Collecting data for device mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,774 INFO zen.ZenModeler: No command plugins found for mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,780 INFO zen.ZenModeler: SNMP monitoring off for mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,783 INFO zen.ZenModeler: No portscan plugins found for mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,783 ERROR zen.PythonClient: Error modeling MySQL server for root:***:3306
2015-04-01 22:42:05,784 INFO zen.PythonClient: Python client finished collection for mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,784 INFO zen.ZenModeler: Modeler MySQLCollector processing data for device mariadb.zenoss01.###.###.com
2015-04-01 22:42:05,784 INFO zen.ZenModeler: No change in configuration detected
2015-04-01 22:42:05,784 INFO zen.ZenModeler: Scan time: 0.32 seconds
2015-04-01 22:42:05,785 INFO zen.ZenModeler: Daemon ZenModeler shutting down
2015-04-01 22:42:05,791 INFO zen.publisher: publishing failed: Connection was closed cleanly.

Subject:	It looks like it's just not
Author:	Andrew Kirch
Posted:	2015-04-07 09:35

It looks like it's just not connecting to MariaDB. I would suggest filing a documentation bug against the MySQL ZenPack.

Subject:	Zenoss Core 5 - MySQL Database Monitor ZenPack not monitoring Zenoss Master Host
Author:	Ken Jenkins
Posted:	2015-03-30 13:57

Zenoss Core 5 - MySQL Database Monitor ZenPack not monitoring Zenoss Master Host