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)
VNA 3.x
Unknown
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
/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
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