Unable to Backup VNA - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/CA/MySql/data/mysql.sock' (13)

Products

• Virtual Network Assurance

Issue/Introduction

We are unable to backup VNA. We are getting the following error:

[wildfly@hostname ~]$ /app/CA/VNA/tools/bin/db_backup.sh -p PASSWORD /tmp/backup.sql     
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/CA/MySql/data/mysql.sock' (13)

Environment

Release : 20.2

Component : Virtual Network Assurance For CA Performance Management

Cause

If you are using a non-root user to run the backup, the error is due to permissions on the listed /opt/CA/MySql/data directory where mysql.sock resides.  When trying to reference the file, behind the scenes a permission denied error is occurring.

Resolution

The solution this error is to grant global read/write privileges to the directory:

chmod 755 /opt/CA/MySql/data