VNA installation fails with Error: "Error updating MySQL database"

Products

• Network Observability
• Virtual Network Assurance

Issue/Introduction

Fresh install of Virtual Network Assurance (VNA) fails with error:

Error updating MySQL database

When testing mysql

cd /opt/CA/MySql/bin
./mysql -uroot -p

An error is returned:

./mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

Environment

DX Netops Virtual Network Assurance all supported releases

Cause

Missing prerequisite package:

• RHEL/CentOS Linux 8.x:
  
      ncurses-compat-libs
  
  
• RHEL/CentOS Linux 7.x
  
      ncurses-libs

Resolution

1. Make sure to install all required packages
   
   
2. Clean up the VNA install (assuming fresh install where deleting would not result in data loss ):
   
   Stop mysql if it is running:
   
       systemctl stop mysql
   
   

   Clean up the install files

      rm -rf /opt/CA/VNA
      rm -rf /opt/CA/MySql
      rm -f /etc/my.cnf /etc/VNA.cfg

   The non /etc file paths may vary if you did not install in the default location

3. Clean up the installer files
   
   rm -rf CA_VNA_Install_bak
   rm -f install.sh
   
   
4. Re-run the installation