Configuring a MariaDB database for the IBM UrbanCode Deploy blueprint design server

To use a MariaDB database with the blueprint design server, before you install the blueprint design server, install the MariaDB database and provide the Java™ Database Connectivity (JDBC) JAR file for the blueprint design server installation process.

Before you begin

Before you install the blueprint design server, install the MariaDB database. If you are evaluating IBM® UrbanCode™ Deploy, you can install the database on the same system as the blueprint design server.

Note: If you installed an engine instead of extending an existing engine and you install the engine and the blueprint design server on the same computer, use the database that the engine uses. See Adding the blueprint design server database to the engine MariaDB database.

For example, to install MariaDB on a Red Hat Enterprise Linux version 7 system, run the following command:

yum install -y mariadb-server

For example, to set the database to run automatically and start the MariaDB database on a Red Hat Enterprise Linux version 7 system, run the following command:

systemctl start mariadb.service ; systemctl enable mariadb.service

Note: The blueprint design server expects data from the database to be encoded in UTF-8.

Procedure

Log in to the database server as a user with table-creation privileges. For example, if you installed MariaDB as the root user, run this command from the command line:
```
mysql -u root
```
The command line shows a prompt that looks like this example:
```
MariaDB [(none)]>
```
Create a user for the blueprint design server to use and assign the user a password, as in the following example command. This example creates a user that is named ibm_ucdp with the password as ibm_ucdp.
```
CREATE USER 'ibm_ucdp'@'localhost' IDENTIFIED BY 'password';
```
Remember this user name and password because you must have them when you install the blueprint design server.
Create a database for the blueprint design server, as in the following example command:
```
CREATE DATABASE ibm_ucdp;
```

Grant permissions for the user to work with the database:

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

Type quit to exit the MariaDB command line.
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.

Feedback