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:
- 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. - 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 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 "[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. ...