Skip to main content

Jama Connect User Guide

Upgrade and configure MySQL

MySQL is the recommended database server. Follow these steps to upgrade and configure it.

If you want to install MySQL for the first time, see Install and configure MySQL.

Important

Before upgrading Jama Connect 8.62.x, you must create two additional database schemas for the installation/upgrade to succeed. To create the database schemas, run these SQL commands on the MySQL database server:

CREATE DATABASE saml;
CREATE DATABASE oauth;
CREATE USER 'oauthuser'@'%' IDENTIFIED BY 'password';
CREATE USER 'samluser'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON oauth.* TO ‘oauthuser’@‘%’;
GRANT ALL PRIVILEGES ON saml.* TO ‘samluser’@‘%’;
  1. Make sure that the InnoDB engine is enabled.

  2. Download and install a supported version of MySQL. To find out which version of MySQL you need, see Supported software, environments, and system requirements and click the link for your version of Jama Connect.

  3. Create an empty Jama Connect schema / database that uses UTF8.

    create database jama character set utf8;
  4. Use the following commands to create a user called "jamauser" with the ability to access, create, and update tables within the database.

    CREATE USER 'jamauser'@'%' IDENTIFIED BY 'password'; 
    GRANT ALL PRIVILEGES ON jama.* TO 'jamauser'@'%'.
  5. Restart the database server.

    The following recommended settings require 8 GB of memory allocated to MySQL Server for a typical installation and 16 GB for an enterprise installation.

    Depending on your database server's operating system, this can be added to your my.cnf file (Linux) or my.ini file (Windows). You can also make these changes directly to the database.

    Property

    Typical Installation

    Enterprise Installaton

    max_allowed_packet

    1 GB

    1 GB

    tmp_table_size

    2 GB

    2 GB

    max_heap_table_size

    2 GB

    2 GB

    table_open_cache

    512

    512

    innodb_buffer_pool_size

    2 GB

    12 GB

    innodb_log_file_size

    256 MB

    256 MB

    innodb_log_buffer_size

    12 MB

    12 MB

    innodb_thread_concurrency

    16

    16

    max_connections

    151

    351

    wait_timeout

    259200

    259200

    Here is a sample text config file at an enterprise level. You must add the following values for your environment:

    bind-address=0.0.0.0
    key_buffer_size=16M
    max_allowed_packet=1G
    thread_stack=192K
    thread_cache_size=8
    tmp_table_size=2G
    max_heap_table_size=2G
    table_open_cache=512
    innodb_buffer_pool_size=12G
    innodb_log_file_size=256M
    innodb_log_buffer_size=12M
    innodb_thread_concurrency=16
    max_connections=351wait_timeout=259200