Attention System Admins: Requirements for Jama Connect 8.62 self-hosted release

By Chloe posted 05-25-2021 07:36

  

Before you can install or upgrade to the Jama Connect 8.62 release, we recommend that you first create two new database schemas to support the new SAML and OAuth authentication options.

For the upgrade to complete, organizations using Microsoft SQL Server must enter database users in Replicated. Without these entries, the installation or upgrade will fail.

Organizations that do not create the new schema will successfully install/upgrade; however, the system will continue to attempt to connect to the databases and produce log failures. After you create the database schemas, you must restart Jama Connect.

To create the database schemas, use the script for your database and your upgrade or installation scenario.

 

For an upgrade installation with Microsoft SQL Server, use this script:  

USE master;

CREATE LOGIN samluser with password = 'password';

CREATE LOGIN oauthuser with password = 'password';

GO

 

USE jama;

EXEC ('CREATE SCHEMA oauth');

EXEC ('CREATE SCHEMA saml');

GO

 

USE jama;

CREATE USER samluser for LOGIN samluser with DEFAULT_SCHEMA=saml;

CREATE USER oauthuser for LOGIN oauthuser with DEFAULT_SCHEMA=oauth;

GO

 

EXEC sp_addrolemember N'db_owner', samluser;

EXEC sp_addrolemember N'db_owner', oauthuser;

GO

 

For a new installation with Microsoft SQL Server, use  this script:

USE master;

CREATE LOGIN jamauser with password = 'password';

CREATE LOGIN samluser with password = 'password';

CREATE LOGIN oauthuser with password = 'password';

GO

 

USE master;

CREATE DATABASE jama;

GO

ALTER DATABASE jama SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE

GO

 

USE jama;

EXEC ('CREATE SCHEMA oauth');

EXEC ('CREATE SCHEMA saml');

GO

 

USE jama;

CREATE USER jamauser for LOGIN jamauser;

CREATE USER samluser for LOGIN samluser with DEFAULT_SCHEMA=saml;

CREATE USER oauthuser for LOGIN oauthuser with DEFAULT_SCHEMA=oauth;

GO

 

EXEC sp_addrolemember N'db_owner', jamauser;

EXEC sp_addrolemember N'db_owner', samluser;

EXEC sp_addrolemember N'db_owner', oauthuser;

GO

 

For an upgrade installation with MySQL, use this script: 

CREATE DATABASE saml;

CREATE DATABASE oauth;

GRANT ALL PRIVILEGES ON oauth.* TO ‘jamauser’@‘%’;

GRANT ALL PRIVILEGES ON saml.* TO ‘jamauser’@‘%’;

GRANT SELECT ON mysql.user TO ‘jamauser’@‘%’;

 

For a new installation with MySQL, use this script:  

CREATE DATABASE jama character set utf8;

CREATE DATABASE saml;

CREATE DATABASE oauth;

CREATE USER 'jamauser'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON jama.* TO 'jamauser'@'%';

GRANT ALL PRIVILEGES ON oauth.* TO ‘jamauser’@‘%’;

GRANT ALL PRIVILEGES ON saml.* TO ‘jamauser’@‘%’;

GRANT SELECT ON mysql.user TO ‘jamauser’@‘%’;

 

 

0 comments
140 views