Blueprint Developer Manual / Version 2304
Table Of ContentsRelational Database Setup
You need to create different databases and users used by the various CoreMedia
CMS
components (seeSection 3.1, “Prerequisites”). In the
workspace-configuration/database
folder of the Blueprint workspace you will
find SQL scripts for creating and dropping all database entities needed for the relational
database.
The scripts are suitable for a local MySQL instance in a developer environment. You can easily
adapt them for other databases or remote users. There are also Bash scripts and Windows batch
files to apply the SQL scripts. If the MySQL server is running and the
mysql command line client is executable via the PATH
variable, you only need to execute the following in order to prepare the databases for
CoreMedia Content Cloud.
Windows:
> cd $CM_BLUEPRINT_HOME\workspace-configuration\database\mysql\ createDB.bat
Linux:
$ cd $CM_BLUEPRINT_HOME/workspace-configuration/database/mysql ./createDB.sh
The command was successful if the following databases have been created:
| Database | User | Password | Description |
|---|---|---|---|
| cm_management | cm_management | cm_management | Database for the Content Management Server |
| cm_master | cm_master | cm_master | Database for the Master Live Server |
| cm_replication | cm_replication | cm_replication | Database for the Replication Live Server |
| cm_mcaefeeder | cm_mcaefeeder | cm_mcaefeeder | Database for the CAE Feeder connected to the Content Management Server |
| cm_caefeeder | cm_caefeeder | cm_caefeeder | Database for the CAE Feeder connected to the Master Live Server |
| cm_editorial_comments | cm_editorial_comments | cm_editorial_comments | Database for the Studio Server that runs the editorial comments feature |
Table 4.4. Database Settings
MongoDB Database Setup
Several CoreMedia core features like CapLists, Notifications and Projects require MongoDB as a persistence layer. A default local MongoDB installation is sufficient, because the CoreMedia components connect through the default port with no user credentials, by default. If required, see Section 4.5, “Collaborative Components” in Operations Basics for more MongoDB configuration.
