Database Setup
If you don't want to use the virtualized setup, you need to create different databases and users used by the various CoreMedia CMS components (see Section 3.2, “Prerequisites”). At the root level of the Blueprint workspace you will find SQL scripts for creating and dropping all database entities needed for the relational database. A default MongoDB installation requires no further configuration, because the CoreMedia components connect through the default port with no user credentials, by default. If required, see Section 4.5, “Collaborative Components” in CoreMedia Operations Basics for more MongoDB configuration.
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 DXP 8.
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 |
|---|---|---|---|
| cm7management | cm7management | cm7management | Database for the Content Management Server |
| cm7master | cm7master | cm7master | Database for the Master Live Server |
| cm7replication | cm7replication | cm7replication | Database for the Replication Live Server |
| cm7mcaefeeder | cm7mcaefeeder | cm7mcaefeeder | Database for the CAE Feeder connected to the Content Management Server |
| cm7caefeeder | cm7caefeeder | cm7caefeeder | Database for the CAE Feeder connected to the Master Live Server |
Table 3.3. Database Settings
Host Mappings
In order to run Blueprint locally, you have to add the following
mappings to the etc/hosts file:
127.0.0.1 studio-helios.localhost 127.0.0.1 preview-helios.localhost 127.0.0.1 helios.localhost 127.0.0.1 studio.corporate.localhost 127.0.0.1 preview.corporate.localhost 127.0.0.1 corporate.localhost 127.0.0.1 editor.localhost 127.0.0.1 shop-preview-helios.localhost 127.0.0.1 shop-helios.localhost 127.0.0.1 shop-preview-production-helios.localhost
 |  |  |
 |