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 documentation:

Error handling for plugins

Troubleshooting installation errors for a Linux plugin

Troubleshooting installation errors for a Windows plugin

• 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 Error 404, Error 111, and "no host given" error when installing the Apache plugin

  When installing the Apache monitoring plugin, you may encounter the following errors: Error_code : URL Error no host given: The "no host given" error message typically indicates an issue with a URL or request that lacks a hostname. If you encounter ...

• Troubleshoot "[Errno 111] Connection refused" error when installing Tomcat plugins

  When installing Tomcat plugins, you may encounter the following error: We failed to reach a server. Reason: [Errno 111] Connection refused: This error indicates that your client is unable to establish a connection to the Tomcat Manager URL, but the ...

• 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 the "[Errno 111] Connection refused" error when installing the Elasticsearch plugins

  When installing the Elasticsearch monitoring plugins, you may encounter the following error: URL Error [Errno 111] Connection refused: This error usually indicates that the Elasticsearch client is unable to establish a connection to the Elasticsearch ...