mysql-stats3: Switch from mysql.connector to PyMySQL

Linuxfabrik / monitoring-plugins

220+ check plugins for Icinga and other Nagios-compatible monitoring applications. Each plugin is a standalone command line tool (written in Python) that provides a specific type of check.

https://linuxfabrik.ch

The Unlicense

220 stars 51 forks source link

mysql-stats3: Switch from mysql.connector to PyMySQL #570

Closed 10RUPTiV closed 2 years ago

10RUPTiV commented 2 years ago

Hi,

Is it possible to have a new version of the plugin to use the new python module as mysql-connector is no more available in Debian repository.

Maybe you would need to switch to python3-pymysql - Pure-Python MySQL Driver - Python 3.x

markuslf commented 2 years ago

Thanks you for the hint.

markuslf commented 2 years ago

There are currently a bunch of new mysql checks on the way (which will replace mysql-stats3). We have to adapt them, too.

https://github.com/Linuxfabrik/monitoring-plugins/issues/66

markuslf commented 2 years ago

On RHEL 8+, this is python3-mysql
On RHEL 7, this is python36-mysql https://pypi.org/project/PyMySQL/

markuslf commented 2 years ago

mysql-stats is deprecated and will be removed. Instead, use the bunch of new mysql-* plugins in this repository.

Changed the db_mysql3.py library from using mysql.connector to pymysql. Have a look at https://github.com/Linuxfabrik/lib/commit/cbf7a6ad906d7711d448d3b80e622f8c7a0d93b3