Unable to install Virtual Network Assurance (VNA) with MySQL Error : "Failed to find valid data directory"

Products

• DX NetOps
• CA Virtual Network Assurance

Issue/Introduction

When attempting to install VNA using the CA_VNA-<VERSION>-Linux.txe installer, an error occurs:

Please enter the existing password for root@localhost account in MySQL>

Please re-enter the existing password for root@localhost account in MySQL>

Extracting MySQL

Comparing existing MySQL version with new MySQL version

MySQL upgrade required, starting MySQL upgrade process

Stopping MySQL Service

 ERROR! MySQL server PID file could not be found!

Configuring MySQL startup

MySQL Config Updated

Starting MySQL Service

Starting MySQL. ERROR! The server quit without updating PID file (/opt/CA/MySql/data/9LD0004AP095.pid).

Failed to start MySQL; aborting the upgrade procedure

Failed to upgrade MySQL

A problem occurred during installation (install directory not deleted). Backing up to /root/NetOps/CA_VNA_Install_bak

Checking in the specified error file shows a message indicating that MySQL is improperly installed and cannot see its data directory:

# cat /opt/CA/Mysql/data/9LD0004AP095.err

2022-01-21T05:54:48.939699Z 0 [System] [MY-010116] [Server] /opt/CA/MySql/bin/mysqld (mysqld 8.0.12-commercial) starting as process 108972

2022-01-21T05:54:48.964284Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.

2022-01-21T05:54:48.964708Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2022-01-21T05:54:48.964727Z 0 [ERROR] [MY-010119] [Server] Aborting

 

Environment

DX NetOps 21.2.x Virtual Network Assurance (VNA)

Resolution

MySQL is improperly installed so cannot stat it's own directory. In this case, uninstall VNA completely:

/opt/CA/VNA/tools/bin/uninstall_vna.sh

Then reboot the server, after which, re-install. If some of the parameters being used are causing problems, try again using no-prompt defaults:

./CA_VNA-21.2.6-Linux.txe --no-prompt -U username