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

    • How to configure the NGINX status page for monitoring NGINX performance

      The NGINX plugin uses the NGINX status page to pull the performance metrics of the NGINX server. You may encounter the following errors while installing the NGINX plugin integration: Error_code : HTTP Error 404: This error usually indicates that the ...

    • Monitor and validate DNS IP changes using regex

      DNS administrators often monitor their DNS servers to detect changes in domain resolution and ensure IP mappings remain secure and accurate. Problem When your organization adds or modifies an IP address for your domain name, it’s critical to: Be ...

    • Monitor database issues for OpenCart or Joomla websites

      Database issues for websites developed using OpenCart or Joomla can be identified by enabling a Content Match. Configure your website response such that a particular text is always present during all success responses and absent during all error ...