How to fix "Communication link failure The last packet sent successfully to the server"?

How to fix "Communication link failure The last packet sent successfully to the server"?

Issue: Communication link failure error message will trigger based on many reasons.
Solution:

Communication link failure error message is shown due to various reasons. Follow any of the steps mentioned below to resolve the issue:

  1. Insufficient user privileges:

    • Ensure that the user has sufficient privileges to access the MySQL database from the host where Applications Manager is running. Follow the steps mentioned in this link to resolve the issue.

  2. Bind address mapping issues:

    • If you want to allow remote access to the MySQL server, implement the following change in my.ini or my.cnf file:

bind-address=*

    • If you choose to specify a list of selected IP addresses, make sure that the IP address of the Applications Manager machine is also present in the list.

      3. MySQL port is blocked by firewall/VPN:

    • Perform a telnet operation from the machine where the Applications Manager is installed. If any VPN or proxy is set to that machine, then make sure that the relevant IP (i.e. new IP after applying VPN) is also present in the bind-address list of IPs.

      4. Use latest driver:

                   To Monitor MySQL server version greater than 5.6 and later download the latest driver and place under the below location and restart the Applications Manager 
    1. AppMangager Home/working/mysql/MMMySQLDriver

                    New to ADSelfService Plus?

                      • Related Articles

                      • How to fix " Communications link failure" error thrown by MySQL server?

                        Error Message : Communications link failure The last packet successfully received from the server was 16 milliseconds ago. The last packet sent successfully to the server was 16 milliseconds ago. 1. Ensure MySQL is running on the target server. ...
                      • How can I upgrade the MySQL connector.jar?

                        For all the following issues mentioned below, the solution is same. Invalid authorization specification message from server. Unknown character set index for field '255' received from server. Communication link failure: javax.net.ssl.SSLException. ...
                      • How to view data under Session & Performance tab in MySQL monitor?

                        Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
                      • WMI/DCOM Communication and Network Resolution Errors

                        Applicable WMI Error Codes 0x80070776 — The object exporter specified was not found. Overview This error occurs when AppManager is unable to establish WMI/DCOM communication with the target Windows server during monitor addition or data collection. ...
                      • WMI/RPC Communication Errors

                        Applicable WMI Error Codes 0x800706BE – The remote procedure call failed 0x80010002 – Call was canceled by the message filter Overview These errors occur when Applications Manager is unable to establish or maintain WMI/RPC communication with the ...