Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.
  • Supported databases:
    • Microsoft SQL Server 2012 (or newer)
    • MySQL 5.7.x (deprecated, for more details see: Blancco Management Console: limited support with MySQL)
      • Database must have COLLATION and ENCODING set to UTF-8.
    • PostgreSQL 9.4.x (or newer)
      • “pg_trgm” extension has to be enabled for the database schema, before the MC installation.
  • 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 Management Console 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 and database configuration and database creation from the MC 4 user admin manual (Chapter: INSTALLATION & CONFIGURATION).