/
Setup Scm Activity Database (Legacy)
Setup Scm Activity Database (Legacy)
Supported Databases
- Microsoft SQL Server
- PostgreSQL
- MySQL
- SQLite
Here for demo we will use MySQL Database commands for the steps 1 and 2. Note. for SQ Lite skip steps 1 and 2:
STEP-1
Create Scm Activity Database.
CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;
STEP-2
Create Database user credentials with permissions.
GRANT ALL PRIVILEGES ON scmactivity.* TO scmactivity@'localhost' IDENTIFIED BY 'secret'; FLUSH PRIVILEGES;
STEP-3
Configure SCM Activity JDBC Connection.
SQLITE
SQLite is very simple - You can keep Database file in Jira Home directory and that's it! :-)
jdbc:sqlite:C:/APPS/sqlitedb/SCMActivity.db org.sqlite.JDBC
(C:/APPS/sqlitedb/SCMActivity.db) is system database file path.
MYSQL
jdbc:mysql://localhost/scmactivity com.mysql.jdbc.Driver
MICROSOFT SQL SERVER
jdbc:jtds:sqlserver://localhost:1433/scmactivity net.sourceforge.jtds.jdbc.Driver
POSTGRESQL
jdbc:postgresql://localhost:5432/scmactivity org.postgresql.Driver
, multiple selections available,
Related content
Scm Activity For Jira
Scm Activity For Jira
Read with this
Scm Changesets for Jira (Cloud)
Scm Changesets for Jira (Cloud)
Read with this
Project Properties Data Center App
Project Properties Data Center App
More like this
Project Properties Cloud App
Project Properties Cloud App
More like this
Okta Connector Cloud App
Okta Connector Cloud App
More like this
Manage Inactive Users for Jira
Manage Inactive Users for Jira
More like this