We are unable to backup VNA. We are getting the following error:
[[email protected] ~]$ /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)
Release : 20.2
Component : Virtual Network Assurance For CA Performance Management
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.
The solution this error is to grant global read/write privileges to the directory:
chmod 755 /opt/CA/MySql/data