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).
Release : 21.2.8 only
Component : DX Netops Portal
Special characters in the mysql password are interfering with the check for additional schemas in the MySQL database.
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:
3) Re-run the upgrade as normal.
4) After the upgrade remove the override files:
rm -rf /var/lock/pm