cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Saradhi.Potharaju
AppDynamics Team (Retired)

Symptoms

While taking a metadata backup of the Controller using the ControllerMetadataBackup.sh script (as outlined in the

Controller Data Backup and Restore documentation) it fails with error message:

 

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect 

 

Diagnosis

For mysqldump (used in the ControllerMetadataBackup.sh script):

 

  • If host is set to localhost, then a socket or pipe is used.
  • If host is set to 127.0.0.1, then the client is forced to use TCP/IP.

No host is set in the script by default, therefore on some servers, the script might fail while trying to use socket to connect to MySQL.

 

Solution

Add -h with the Controller hostname to the mysqldump options in the ControllerMetadataBackup.sh script. This forces mysqldump to use TCP/IP.

 

Change from:

 

$appd_install_dir/db/bin/mysqldump -u root -p[password] -P [port_number] controller 

 

To:

 
$appd_install_dir/db/bin/mysqldump -u root -p[password] -h [controller_host_name] -P [port_number] controller 

 

Version history
Last update:
‎09-14-2018 10:53 AM
Updated by:
June 26 Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here