Configuring a MySQL or MariaDB database for the UrbanCode Deploy server#
To use a MySQL or MariaDB database with the server, before you install the server, install the database, and provide the JDBC JAR file for the server installation process.MySQL and MariaDB are similar databases. Which one you use depends on your operating system and version.
Before you install the UrbanCode™ Deploy server, install MySQL or MariaDB, depending on your operating system and version. If you are evaluating UrbanCode Deploy, you can install the database on the same system as the UrbanCode Deploy server.
For example, the command to install MariaDB on a system that runs Red Hat Enterprise Linux™ version 7 resembles the following example:
yum install -y mariadb mariadb-server
To set the database to run automatically and start the MariaDB database on a Linux system that uses
systemctl, run the following command:
systemctl enable mariadb; systemctl start mariadb
When you install UrbanCode Deploy, you need the database connection information, and a user account with table-creation privileges.
Note: It is recommended that the database be encoded in UTF-8. Changing the database to a case-sensitive collation is also recommended.
Follow these steps to set the database encoding:
- On the system that hosts the database, open MySQL or MariaDB configuration file. The location of the file depends on the operating system. On Linux, the file is named my.cnf, and many distributions put the file in the folder /etc or /etc/mysql. On Windows, the file is named my.ini.
[mysqld]section of the configuration file, add the following lines:
Restart the database. For example, to restart MariaDB on Linux, use this command:
systemctl restart mariadb
Open a command-line window and log in to the database.
The command might look like the following example:
mysql -u username -ppassword
username, specify the user name for the database. The default user name is
password, specify the password for that user name. The default account has no password; in this case, omit the
-pflag and the password.
Note: Do not insert a space between the
-pflag and the password.
Create a database. Specify case-sensitive collation.
The following commands are an example of how you might create this database:
CREATE USER 'ibm_ucd'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE ibm_ucd character set utf8 collate utf8_bin;
GRANT ALL ON ibm_ucd.* TO 'ibm_ucd'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Log out of the database command line.
Obtain the database JDBC driver.
The JDBC JAR file is included among the database installation files. The driver is unique to the database edition you are using.
When multiple drivers are available, you might need to consult with the database provider to determine which driver to use. The JDBC driver version that you must use might depend on the version of the database and the version of Java™ used by the UrbanCode Deploy server.
Copy the JDBC JAR file to installer_directory\lib\ext.
Begin server installation. See Installing the server. When you are prompted for the database type, enter mysql.
Provide the JDBC driver class UrbanCode Deploy uses to connect to the database.
The default value is
Next, provide the JDBC connection string.
Typically, it is similar to the following code:
For example, the connection string to database that is on the same computer as the UrbanCode Deploy server and that uses the default port resembles the following code:
Finish by entering the database user name and password.
Parent topic: Installing the server database