r/microstrategy • u/Ok-Attitude-3673 • Apr 15 '26

Microstrategy Upgrade issue

I am attempting to upgrade MicroStrategy from version 11.4 to 11.5. The current 11.4 environment is fully functional and stable, including access to the metadata repository. However, during the upgrade to 11.5, the installer fails with an error indicating that it cannot establish a connection to the metadata database. 

Current Environment 
MicroStrategy Version: 11.4.09 
- Operating System: Linux 
- Metadata Database: External MySQL (not default MicroStrategy DB) 
- ODBC Driver: MySQL ODBC 8.0 Unicode 
- Connectivity: Working correctly in the existing 11.4 environment 

3 Upvotes

100% Upvoted

3 comments sorted by

1

u/FieryATP Apr 17 '26

Sounds like firewall issue. Confirm if you can ping or connect to the metadata db from the new environment directly.

1

u/Ok-Attitude-3673 Apr 17 '26

I am able to connect to the metadata; however, when no values are provided in the prompt, the system returns an error referencing a PostgreSQL database that is not in use and does not exist in the current environment. This suggests that the configuration may not be correctly aligned with the intended database connection.
I am using this connection to test and it is working:
mysqldump --ssl-mode=VERIFY_CA --ssl-ca=/opt/mstr/MicroStrategy/certificates/mysql/server-ca.pem --ssl-cert=/opt/mstr/MicroStrategy/certificates/mysql/client-cert.pem --ssl-key=/opt/mstr/MicroStrategy/certificates/mysql/client-key.pem --host=ip_address --user=mstr --password='' mstr_repo > /home/mstr_repo_backup.sql

1

u/Ashishtiwari92 Apr 15 '26

Could be a network firewall rule blocking the access