MySql upgrade failed when updating VNA

Products

• Virtual Network Assurance

Issue/Introduction

When attempting to upgrade VNA it fails with the following error

Failed to upgrade the MySQL data; aborting the upgrade procedure
Failed to upgrade MySQL

 

When attempting to start mysql we get the following error:

service mysql start
/etc/init.d/mysql: line 239: my_print_defaults: command not found
/etc/init.d/mysql: line 259: cd: /usr/local/mysql: No such file or directory
Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)

Environment

VNA 3.x

Cause

Unknown 

Resolution

The /etc/my.cnf showed the following:

/etc/my.cnf showed the following
socket      = Y/MySql/data/mysql.sock
basedir     = Y/MySql
datadir     = Y/MySql/data
tmpdir      = Y/MySql/tmp
socket      = Y/MySql/data/mysql.sock

• In the my.cnf those entries where "Y" is seen should reference the valid path to MySql.  With a default install it should be /optCA

/etc/VNA.cfg showed the following:
ca.root=Y
vna_db_name=vna_xxxx
container_install=0
sdn_client_queue_size=1000
sdn_poll_timeout_minutes=30
mysql_host=localhost
mysql_port=3306

• ca.root should be set to /opt/CA

The issue was that the install failed before VNA was actually re-installed.  Basically the install of VNA lays down all new files every time.  Everything as far as configuration, etc. is stored in the DB.

In this case, VNA was never actually laid down after the upgrade because the DB portion failed.  To resolve that we just need to re-run the installation ( after fixing the files ) and it worked