MySQL error upgrading the DX Netops Portal to 21.2.8

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Error upgrading the Netops Portal similar to:

============================================

Unable to Check for Unsupported MySQL Schemas

The installation was unable to determine whether the existing MySQL instance has one or more schemas which are not managed by this product.

MySQL Error: /<TEMPDIRECTORY>/1234567.tmp/executeScriptTmpO: line 2: <characters>: command not found

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'netqos'@'localhost' (using password: YES)

Correct the above problem and restart the installation. PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK):

==================================================

The MySQL database password has special (non-alphanumeric characters).

Environment

Release : 21.2.8 only

Component : DX Netops Portal

Cause

Defect: DE529160 

Special characters in the mysql password are interfering with the check for additional schemas in the MySQL database.

Resolution

This issue has been corrected in DX Netops Performance Management 21.2.9 and later:

Symptom: In an environment with an external NetOps Portal database that has not been upgraded, the NetOps Portal console upgrade is allowed to proceed.
Resolution: With this fix, the NetOps Portal installer has been updated to do a database-version check even when database connection succeeds.
(21.2.9, DE529160, 33038674)

 

Additional Information

See the following for additional 21.2.8 MySQL upgrade Tips

WORKAROUND IF FOR SOME REASON YOU ARE UPGRADING TO 21.2.8 (It is recommended to go to the latest release):

The following workaround will allow the upgrade to proceed.

1) Verify there are no additional schemas in the database by running:

mysql -uroot -p -e "SELECT lower(SCHEMA_NAME) as schema_name FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mysql','information_schema','performance_schema','sys','netqosportal','em');"

If this returns output DO NOT PROCEED, please contact support , this indicates there are additional schemas found in the database.

2) If no output is returned run:

mkdir /var/lock/pm
touch /var/lock/pm/mysql.override

3) Re-run the upgrade as normal.

4) After the upgrade remove the override files:

rm -rf /var/lock/pm