第3步:创建JIRA数据库

登录MariaDB: 密码是上面创建的

sudo mysql -u root -p

然后创建一个数据库 jira

CREATE DATABASE jira CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

创建一个带密码的数据库用户 jirauser

CREATE USER 'jirauser'@'localhost' IDENTIFIED BY 'new_password_here';

然后授予用户完全访问权限 jira数据库。

GRANT ALL ON jira.* TO 'jirauser'@'localhost' WITH GRANT OPTION;

最后,保存更改并退出。

FLUSH PRIVILEGES;
EXIT;

打开MariaDB配置文件。

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

复制并粘贴下面内容:

# this is only for the mysqld standalone daemon
[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
default-storage-engine= INNODB
character_set_server = utf8mb4
innodb_default_row_format = DYNAMIC
innodb_large_prefix = ON
innodb_file_format = Barracuda
innodb_log_file_size = 2G
sql_mode = NO_AUTO_VALUE_ON_ZERO

保存文件并退出。

完成后,重新启动MariaDB。

sudo systemctl restart mariadb.service
如何在Ubuntu 18.04上安装JIRA项目管理软件

Jira是一款项目管理软件,允许错误跟踪和敏捷项目管理。

第1步:更新Ubuntu

准备Ubuntu并更新已安装的软件包。

sudo apt update
sudo apt dist-upgrade

第4步:下载并安装JIRA

JIRA下载页面:

https://www.atlassian.com/software/jira/download.

使用下面的命令提取下载的文件:

cd /tmp
wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-8.7.1-x64.bin
chmod a+x atlassian-jira-software-8.7.1-x64.bin

运行以下命令,开始安装。

sudo ./atlassian-jira-software-8.7.1-x64.bin

我们可以选择在任何目录中安装Jira。

Unpacking JRE . 
Starting Installer . 
This will install Jira Software 8.7.1 on your computer.
OK [o, Enter], Cancel [c]
o
Click Next to continue, or Cancel to exit Setup.
Choose the appropriate installation or upgrade option.
Please choose one of the following:
Express Install (use default settings) [1], Custom Install (recommended for advanced users) [2, Enter], Upgrade an existing Jira installation [3]
2
Select the folder where you would like Jira Software to be installed.
Where should Jira Software be installed?
[/opt/atlassian/jira]
Enter
Default location for Jira Software data
[/var/atlassian/application-data/jira]
Enter
Configure which ports Jira Software will use.
Jira requires two TCP ports that are not being used by any other
applications on this machine. The HTTP port is where you will access Jira
through your browser. The Control port is used to startup and shutdown Jira.
Use default ports (HTTP: 8080, Control: 8005) - Recommended [1, Enter], Set custom value for HTTP and Control ports [2]
1
Jira can be run in the background.
You may choose to run Jira as a service, which means it will start
automatically whenever the computer restarts.
Install Jira as Service?
Yes [y, Enter], No [n]
y
Details on where Jira Software will be installed and the settings that will be used.
Installation Directory: /opt/atlassian/jira 
Home Directory: /var/atlassian/application-data/jira 
HTTP Port: 8080 
RMI Port: 8005 
Install as service: Yes 
Install [i, Enter], Exit [e]
i
Extracting files .                                                                           
Please wait a few moments while Jira Software is configured.
Installation of Jira Software 8.7.1 is complete
Start Jira Software 8.7.1 now?
Yes [y, Enter], No [n]
y
Please wait a few moments while Jira Software starts up.
Launching Jira Software . 
Installation of Jira Software 8.7.1 is complete
Your installation of Jira Software 8.7.1 is now ready and can be accessed
via your browser.
Jira Software 8.7.1 can be accessed at http://localhost:8080
Finishing installation .

在为Web门户访问配置JIRA之前,请务必下载MySQL JDBC驱动程序。

运行以下命令下载它:

cd /tmp
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.18.zip
unzip mysql-connector-java-8.0.18.zip
sudo cp mysql-connector-java-8.0.18/mysql-connector-java-8.0.18.jar /opt/atlassian/jira/lib

重启JIRA服务

sudo /etc/init.d/jira stop
sudo /etc/init.d/jira start

访问JIRA门户:
http://localhost:8080

在下一个窗口中,单击自己的数据库,然后单击“数据库类型”值,单击并选择MySQL 5.7+。

设置应用程序属性并继续。

接下来,我们将需要输入JIRA的许可证密钥。

我们需要一个许可证密钥来设置Jira。
输入许可证密钥或者在下面生成新的许可证键。
我们需要在Myatlassian的帐户来生成许可证密钥。

创建一个帐户,如果我们还没有;登录并为应用程序生成试用许可证密钥。

然后粘贴在框中的许可证密钥并继续。

创建管理员帐户并继续。

继续并完成安装向导。

第2步:安装MariaDB数据库服务器

JIRA还需要一个数据库服务器来存储其内容。

要安装MariaDB运行下面的命令。

sudo apt install mariadb-server mariadb-client

安装MariaDB后,下面的命令可用于停止,启动和启用MariaDB服务

sudo systemctl stop mariadb.service
sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service

之后,运行以下命令,通过创建root密码并禁止远程根访问来保护MariaDB服务器。

sudo mysql_secure_installation

出现提示时,通过遵循教程,回答以下问题。

  • 输入root的当前密码(输入无):只需按Enter键
  • 设置root密码? [Y/N]:Y
  • 新密码:输入密码
  • 重新输入新密码:重复密码
  • 删除匿名用户? [Y/N]:Y
  • 远程禁止root登录? [Y/N]:Y
  • 删除测试数据库并访问它? [Y/N]:Y
  • 现在重新加载权限表? [Y/N]:Y

要测试是否安装了MariaDB,请在下面键入命令以登录MariaDB服务器

sudo systemctl status mariadb.service

输出示例:

mariadb.service - MariaDB 10.1.44 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2016-03-05 12:14:17 CST; 1min 15s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 16048 (mysqld)
   Status: "Taking your SQL requests now. "
    Tasks: 27 (limit: 4666)
   CGroup: /system.slice/mariadb.service
           └─16048 /usr/sbin/mysqld
Mar 05 12:14:17 ubuntu1804 /etc/mysql/debian-start[16081]: information_schema
Mar 05 12:14:17 ubuntu1804 /etc/mysql/debian-start[16081]: mysql
Mar 05 12:14:17 ubuntu1804 /etc/mysql/debian-start[16081]: performance_schema
日期:2020-07-07 20:55:56 来源:oir作者:oir