Adding the blueprint design server database to the engine MariaDB database

If you have an installed Heat orchestration engine, you can reuse the engine database for the blueprint design server rather than installing a separate database.

Before you begin

Install an engine that is provided with IBM UrbanCode Deploy. See Installing an engine in interactive mode or Installing an engine in silent mode.

Procedure

Log in to the MariaDB database on the computer that hosts the engine. The default user name is root, and the default password is passw0rd, as in the following example:
```
mysql -u root -ppassw0rd
```

Create a user for the blueprint design server to use:

CREATE USER 'ibm_ucdp'@'localhost' IDENTIFIED BY 'password';

Create a database:
```
CREATE DATABASE ibm_ucdp;
```

Grant permissions for the user:

GRANT ALL ON ibm_ucdp.* TO 'ibm_ucdp'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Type quit to exit the MariaDB command-line console.
Obtain the MariaDB JDBC driver.
Either note the location of the JDBC JAR file or place the file in the installation_directory/ibm-ucd-patterns-install/web-install/media/server/opt/tomcat/lib folder.
Begin blueprint design server installation. See Installing the blueprint design server. When you are prompted for the database type, enter mariadb.
Provide the JDBC driver class that the blueprint design server uses to connect to the database. The default value is org.mariadb.jdbc.Driver.
Next, provide the JDBC connection string. Typically, it is similar to the following code:
```
jdbc:mariadb://DB_URL:DB_PORT/DB_NAME
```
For example, if database is on the same computer as the blueprint design server and uses the default port, the JDBC connection string resembles the following code:
```
jdbc:mariadb://localhost:3306/ibm_ucdp
```
Finish by entering the database user name and password.

What to do next

Install the blueprint design server. See Installing the blueprint design server.

Feedback