Troubleshoot the pymysql module not found error when installing the MySQL plugin

Troubleshoot the "pymysql module not found" error when installing the MySQL plugin

If you're encountering the pymysql module not found error, it likely means that the pymysql Python library is not installed on the server. pymysql is a Python package that provides a way to interact with MySQL databases using Python code and is used by the MySQL monitoring plugin.

Here are some ways to troubleshoot the error:
  1. Ensure that you have downloaded the pymysql zipped folder from our GitHub repository and placed it in the respective plugin folder.
    Note: The pymysql module is bundled with the MySQL monitoring plugin, so you don't need to install it separately.

    For Linux, copy and execute the below command within the mysql_monitoring folder to download the pymysql module from our GitHub repository.
    wget https://github.com/site24x7/plugins/raw/master/mysql_monitoring/pymysql/pymysql.zip && unzip pymysql.zip && rm pymysql.zip

    For Windows, download the pymysql zipped folder and place it in the mysql_monitoring folder.

  2. Ensure that you have downloaded the latest MySQL plugin files from our GitHub repository:
    wget https://raw.githubusercontent.com/site24x7/plugins/master/mysql_monitoring/mysql_monitoring.py
    wget https://raw.githubusercontent.com/site24x7/plugins/master/mysql_monitoring/mysql_monitoring.cfg
Follow the steps in this README file to install the MySQL monitoring plugin.
If the issue persists, reach out to support@site24x7.com with the name of the plugin and the error.

    • Related Articles

    • Troubleshoot connection errors in the MySQL plugin

      When configuring the MySQL plugin, you may encounter the following errors: Error : Connection Error - This error typically indicates that there is a problem establishing a connection to the database. Sometimes, this message is supplemented with an ...
    • Troubleshoot the "ORA-12514" error when installing Oracle plugins

      When installing the Oracle database monitoring plugins, you may encounter the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor: This error typically occurs during attempts to establish a ...
    • Troubleshoot "[Errno 111] Connection refused" error for RabbitMQ plugins

      When installing the RabbitMQ plugin, you may encounter the following error: urlopen error [Errno 111] Connection refused: This error usually occurs when the plugin tries to connect with the RabbitMQ server but is unable to establish a connection. ...
    • Troubleshoot the Unauthorized user (Error 401) when installing Tomcat plugins

      When installing Tomcat plugins, you may encounter the following error: Unauthorized user. Does not have permissions. HTTP Error 401: This error usually occurs when the user accessing the Tomcat Manager application does not have the necessary ...
    • Troubleshoot the Error 404 and Error 99 for RabbitMQ

      When installing the RabbitMQ plugin, you may encounter the following errors: HTTP Error 404: Not Found: This error usually occurs when Site24x7's RabbitMQ monitoring plugin attempts to access the /api/overview page of RabbitMQ, but the resource ...