Database Requirements

You cannot log into CloudBees Flow until a database is configured. During the CloudBees Flow server installation, you can select the built-in (default) CloudBees Flow database (MariaDB) or an alternate database.

If you are using two different CloudBees Flow servers in a non-HA configuration, they cannot point to the same database.

Built-In Database

CloudBees Flow ships with a demo license, which limits the software to two concurrent job steps and the CloudBees Flow-provided built-in database. Running CloudBees Flow on a single machine with the demo license is not recommended for a production environment. Also, the built-in database is not supported in a clustered CloudBees Flow configuration.

In a production configuration, connect CloudBees Flow to a database. If CloudBees Flow is installed with the built-in database, you can reconfigure it to use an external database at any time. For a list of alternate databases supported by CloudBees Flow, see Supported Alternate Databases. For more information and configuration instructions, see External Database Configuration.

Using an external database requires a CloudBees Flow enterprise license. You must configure an external database at the same time as you install your enterprise license to prevent error messages about an unsupported configuration or a license requirement.

Supported Databases

CloudBees Flow supports the following external databases in a production environment:

  • MySQL 5.5.12, 5.6, 5.7 or later

  • Clean installations of the CloudBees Flow server require the MySQL JDBC driver. See Installing the MySQL JDBC Driver .

  • For upgrades, additions to my.cnf/my.ini are required. See Installing the MySQL JDBC Driver .

  • MS SQL Server 2012 (2012 R4 is recommended), 2014, 2016, and 2017

    As of version 9.2, CloudBees Flow has ended support for HTTPS connection types older than TLS 1.2. If you are using MS SQL Server 2012 or 2014, you must update it to support TLS1.2. For details, see the Microsoft TLS 1.2 support for Microsoft SQL Server web page.

  • Oracle 12c, 18c, and 19c

Database Requirements

Configuring UTF-8 Encoding

Databases must be configured to use UTF-8 encoding.

Setting the Open Connections Allowance

Databases must be configured to allow up to 200 open connections.

Setting the Oracle Database Open Cursors Parameter

In an Oracle database, set the OPEN_CURSORS parameter to at least 1000 to prevent CloudBees Flow from running out of open cursors. But depending on your CloudBees Flow server usage, the OPEN_CURSORS value of 1000 might not be sufficient, and you might see java.sql.SQLException: ORA-01000: maximum open cursors exceeded " in the <DATA_DIR>/logs/commander.log file. In this case, you must increase the value of OPEN_CURSORS to one that is optimal depending on your usage.

Disabling SQL Server Database Audit for the First-Time Database Connection

When using Microsoft SQL Server as the alternate database, turn off SQL Server Database Audit before CloudBees Flow connects to the database for the first time to create the user schema. Failing to do so can cause the server startup to be stuck in the “Making any necessary pre-schema-creation database setting changes” step while the CloudBees Flow server attempts to enable snapshot isolation to create the schema. This is a know issue with SQL Server as documented in https://support.microsoft.com/en-us/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation .

After CloudBees Flow finishes creating the schema and you have verified that you can log in to CloudBees Flow, turn on the SQL Server Database Audit as per your company policy.

Copyright © 2010-2020 CloudBees, Inc.Online version published by CloudBees, Inc. under the Creative Commons Attribution-ShareAlike 4.0 license.CloudBees and CloudBees DevOptics are registered trademarks and CloudBees Core, CloudBees Flow, CloudBees Flow Deploy, CloudBees Flow DevOps Insight, CloudBees Flow DevOps Foresight, CloudBees Flow Release, CloudBees Accelerator, CloudBees Accelerator ElectricInsight, CloudBees Accelerator Electric Make, CloudBees CodeShip, CloudBees Jenkins Enterprise, CloudBees Jenkins Platform, CloudBees Jenkins Operations Center, and DEV@cloud are trademarks of CloudBees, Inc. Most CloudBees products are commonly referred to by their short names — Accelerator, Automation Platform, Flow, Deploy, Foresight, Release, Insight, and eMake — throughout various types of CloudBees product-specific documentation. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Jenkins is a registered trademark of the non-profit Software in the Public Interest organization. Used with permission. See here for more info about the Jenkins project. The registered trademark Jenkins® is used pursuant to a sublicense from the Jenkins project and Software in the Public Interest, Inc. Read more at www.cloudbees.com/jenkins/about. Apache, Apache Ant, Apache Maven, Ant and Maven are trademarks of The Apache Software Foundation. Used with permission. No endorsement by The Apache Software Foundation is implied by the use of these marks.Other names may be trademarks of their respective owners. Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this content, and CloudBees was aware of a trademark claim, the designations have been printed in caps or initial caps. While every precaution has been taken in the preparation of this content, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.