When doing a new Management Console 4 installation using an "external database" (SQL, MySQL, PostgreSQL, etc.), it is important to remember that the software requires an empty database. The empty database needs to be created before the Management Console 4 installation is started. If an existing old database is used, MC 4 will not be able to update it properly or connect to it at all. This will result in a blank white browser page when trying to access the MC 4 login page.
The following requirements must be met for the new database:
- An empty database, with a user who has owner rights or similar (read-, write-, delete- and create rights) to the tables. Tables are automatically created by the BMC.
- This requirement doesn’t concern the embedded database as it is created and used by the BMC.
- Database must have COLLATION and ENCODING set to UTF-8.
- Make sure that the password does not expire for the database user or the owner. For example with MS SQL 2012: Make sure the Enforce Password Policy option is deselected so the passwords of the database user/owner will not expire.
This all also applies to MC 4 re-installation (i.e. the old MC 4 is uninstalled or deleted). A new database must be created! Updating the MC 4 however does not require any kind of database changes, if it is done by using the update feature.
Read more details about the MC 3 installation's database configuration and database creation from the MC 4 user manual (Chapter: INSTALLATION & CONFIGURATION).