Database installation

  Administration > System administration > Server > Install, Upgrade, and Migrate Jama > Install Jama >

Database installation

Previous pageNext page Print this topic! Mail us feedback on this topic!

Production Installations

Jama can use MySQL or SQL Server as its database. For a list of supported database versions, visit supported software. The database must run on a dedicated server.

Note: Database sizing is based on your usage and platform. Consult with your database administrator when determining the best settings.

 

MySQL Installation

MySQL is Jama's recommended database server.

1.Download and install a supported version of MySQL.

Note: Jama requires the InnoDB engine to be enabled.This should be enabled by default.

2.Create an empty Jama schema / database that uses UTF8.

create database contour character set utf8;

Note: Step 2 is optional, as long as the user has sufficient access to create a schema within the database, this can be done as part of the installation of Jama.

3.Be sure to have a user such as "root" or "jamauser" with the ability to access, create and update tables within the database. That user information will be needed to configure Jama.

 

Recommended settings for MySQL

The following settings require 2.5G memory allocated to MySQL Server. Depending on your database server's operating system, this can be added to your my.cnf (Linux) or my.ini (Windows) file. Alternatively, you can make these changes directly to the database.

 

 

Property

Typical Installation

Enterprise Installation

max_allowed_packet

128M

128M

query_cache_type

1

1

query_cache_size

256M

256M

tmp_table_size

64M

64M

table_open_cache

512

512

innodb_buffer_pool_size

2G

12G

innodb_additional_mem_pool_size

24M

24M

innodb_log_file_size

256M

256M

innodb_log_buffer_size

12M

12M

innodb_thread_concurrency

16

16

max_connections

151

351

 

 

 

Microsoft SQL Server

1.Download and install a supported version of SQL Server.
2.Configure SQL Server to operate in mixed mode for authentication; the option is referred to as SQL Server and Windows Authentication. Microsoft has created a document about how to change server authentication mode.
3.Enable TCP/IP for SQL Server. It is important to know what port is configured as it will be necessary when connecting Jama to the database. The default port is 1433.
4.Create a new login with SQL Server authentication, such as "jamauser."
5.Create a new database named "contour." Ensure that the user created has db_owner permissions.
6.Some processes can cause the database to lock users while they are trying to work or log into Jama. Execute the following queries to unlock tables permanently:
Run the following query (as a user with db_owner role for the database). It will roll back other transactions immediately if there are any.

ALTER DATABASE contour SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;

 

Check to make sure the flag was successfully turned on. If the returned value is 1, it is on.

SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name='contour';

 

Note: Steps 5 and 6 are optional, as long as the user has sufficient access to create a schema within the database. This can be done as part of installation of Jama.