Troubleshooting for MySQL plugin

Why is my MySQL plugin not getting added to Site24x7?

Agent Requirements:
  1. The Site24x7 Linux monitoring agent version is above 15.0.0
  2. The Site24x7 Linux server monitoring agent should be installed in the network or on the specific host where the MySQL instance is running.
  3. If you are running the plugin in Windows, refer this article to know how to run python scripts in Windows servers.
  4. While adding a plugin, the name of the plugin file and its folder should be identical.
  5. Execute the plugin using the command
    python  mysql.py 
    If you get a valid output, try re-registering the plugin from the Site24x7 web client.
Dependency Module:
  1. For Linux: The dependency module 'pymysql' should be correctly installed.
  2. For Windows: Python 3 and python Mysql connecter should be installed in the server where you plan to run the plugin. Know how to add Python to Windows PATH.
Credentials:
  1. Ensure correct login credentials are given. For example, make sure the MySQL database is probably listed on the localhost address or access is given to login via localhost.
Connection Errors:
  1. Test if you are able to connect the MySQL with the specified user. If you are using a password for that user, then edit the password section in the plugin script.
  2. Ensure netstat command is installed to get the socket path. Execute the below command and get the socket path:
    mysqladmin variables | grep socket
    Generally, it would be /var/run/mysqld/mysqld.sock
    Configure this value for the key : 'MYSQL_SOCKET' in the mysql.py python script and check if you are able to connect.

If the issue still persists, execute the plugin using the command python  mysql.py and share the output as a screenshot with support@site24x7.com. 

    • Related Articles

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

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

    • Response time in Website monitoring

      In website monitoring, response time is calculated as the total time taken to resolve the DNS, complete the TCP hand-shake, negotiate an SSL handshake (for HTTPS) and download the full HTML output from the server. However, it does not include getting ...

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