Install Otrs
前言
Otrs 是一个开源的工单系统
OTRS is one of the most flexible web-based ticketing systems used for Customer Service, Help Desk, IT Service Management. With a fast implementation and easy customization to your needs it helps you reducing costs and increasing the efficiency and transparency of your business communication.
使用工单来对接请求服务，跟踪问题，管理事务，协调人力是一种高效的组织方式
这里分享一下 Otrs 的安装方法
参考 Otrs安装文档
Tip: 当前版本 OTRS 6 Patch Level 4
操作
系统环境
[root@much otrs]# hostnamectl
Static hostname: much
Icon name: computer-vm
Chassis: vm
Machine ID: 33dc28f7e76c4903ad9b603b77e29a7c
Boot ID: 7b4bb229c627449d8860c83a818b2416
Virtualization: kvm
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-514.21.1.el7.x86_64
Architecture: x86-64
[root@much otrs]# ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:27:0b:e9:0b brd ff:ff:ff:ff:ff:ff
inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic enp0s3
valid_lft 84089sec preferred_lft 84089sec
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:27:36:8b:0c brd ff:ff:ff:ff:ff:ff
inet 192.168.56.209/24 brd 192.168.56.255 scope global enp0s8
valid_lft forever preferred_lft forever
4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN qlen 1000
link/ether 52:54:00:16:5e:11 brd ff:ff:ff:ff:ff:ff
inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0
valid_lft forever preferred_lft forever
5: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN qlen 1000
link/ether 52:54:00:16:5e:11 brd ff:ff:ff:ff:ff:ff
[root@much otrs]#下载相关软件包
[root@much otrs]# pwd
/root/otrs
[root@much otrs]# ls
mysql57-community-release-el7-11.noarch.rpm otrs-6.0.4-03.noarch.rpm
[root@much otrs]# md5sum otrs-6.0.4-03.noarch.rpm
fd11a980d5ca7b09681f10ef7091890e otrs-6.0.4-03.noarch.rpm
[root@much otrs]#禁用 SELinux
[root@much otrs]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=disabled
# SELINUXTYPE= can take one of three two values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
[root@much otrs]# getenforce
Disabled
[root@much otrs]#安装 mysql
安装 mysql 仓库
[root@much otrs]# ls
mysql57-community-release-el7-11.noarch.rpm otrs-6.0.4-03.noarch.rpm
[root@much otrs]# rpm -ivh mysql57-community-release-el7-11.noarch.rpm
warning: mysql57-community-release-el7-11.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql57-community-release-el7-11 ################################# [100%]
[root@much otrs]# ll /etc/yum.repos.d/
total 48
-rw-r--r-- 1 root root 170 1月 22 21:10 cassandra.repo
-rw-r--r--. 1 root root 1664 11月 30 2016 CentOS-Base.repo
-rw-r--r--. 1 root root 1309 11月 30 2016 CentOS-CR.repo
-rw-r--r--. 1 root root 649 11月 30 2016 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root 314 11月 30 2016 CentOS-fasttrack.repo
-rw-r--r--. 1 root root 630 6月 16 2017 CentOS-Media.repo
-rw-r--r--. 1 root root 1331 11月 30 2016 CentOS-Sources.repo
-rw-r--r--. 1 root root 2893 11月 30 2016 CentOS-Vault.repo
-rw-r--r--. 1 root root 957 12月 28 2016 epel.repo
-rw-r--r--. 1 root root 1056 12月 28 2016 epel-testing.repo
-rw-r--r-- 1 root root 1838 4月 27 2017 mysql-community.repo
-rw-r--r-- 1 root root 1885 4月 27 2017 mysql-community-source.repo
[root@much otrs]#软件列表
[root@much otrs]# yum list all | grep mysql57
mysql57-community-release.noarch el7-11 installed
mysql-community-client.i686 5.7.21-1.el7 mysql57-community
mysql-community-client.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-common.i686 5.7.21-1.el7 mysql57-community
mysql-community-common.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-devel.i686 5.7.21-1.el7 mysql57-community
mysql-community-devel.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-embedded.i686 5.7.21-1.el7 mysql57-community
mysql-community-embedded.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-embedded-compat.i686 5.7.21-1.el7 mysql57-community
mysql-community-embedded-compat.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-embedded-devel.i686 5.7.21-1.el7 mysql57-community
mysql-community-embedded-devel.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-libs.i686 5.7.21-1.el7 mysql57-community
mysql-community-libs.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-libs-compat.i686 5.7.21-1.el7 mysql57-community
mysql-community-libs-compat.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-release.noarch el7-7 mysql57-community
mysql-community-server.x86_64 5.7.21-1.el7 mysql57-community
mysql-community-test.x86_64 5.7.21-1.el7 mysql57-community
1-20170320 mysql57-community
mysql-ref-manual-5.5-en-pdf.noarch 1-20170320 mysql57-community
1-20171228 mysql57-community
mysql-ref-manual-5.7-en-pdf.noarch 1-20171228 mysql57-community
[root@much otrs]#安装 mysql
[root@much otrs]# yum install mysql-community-server.x86_64
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.pregi.net
* c7-media:
* epel: mirror.pregi.net
* extras: mirror.pregi.net
* updates: mirror.pregi.net
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.21-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.21-1.el7 for package: mysql-community-server-5.7.21-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.21-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.21-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.21-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.21-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.52-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.21-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.21-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================
Installing:
mysql-community-libs x86_64 5.7.21-1.el7 mysql57-community 2.1 M
replacing mariadb-libs.x86_64 1:5.5.52-1.el7
mysql-community-libs-compat x86_64 5.7.21-1.el7 mysql57-community 2.0 M
replacing mariadb-libs.x86_64 1:5.5.52-1.el7
mysql-community-server x86_64 5.7.21-1.el7 mysql57-community 164 M
Installing for dependencies:
mysql-community-client x86_64 5.7.21-1.el7 mysql57-community 24 M
mysql-community-common x86_64 5.7.21-1.el7 mysql57-community 272 k
Transaction Summary
=====================================================================================================================================================
Install 3 Packages (+2 Dependent packages)
Total download size: 192 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.7.21-1.el7.x86_64.rpm is not installed
(1/5): mysql-community-common-5.7.21-1.el7.x86_64.rpm | 272 kB 00:00:01
(2/5): mysql-community-libs-5.7.21-1.el7.x86_64.rpm | 2.1 MB 00:00:13
(3/5): mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm | 2.0 MB 00:00:10
(4/5): mysql-community-client-5.7.21-1.el7.x86_64.rpm | 24 MB 00:02:18
(5/5): mysql-community-server-5.7.21-1.el7.x86_64.rpm | 164 MB 00:08:59
-----------------------------------------------------------------------------------------------------------------------------------------------------
Total 348 kB/s | 192 MB 00:09:25
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql57-community-release-el7-11.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows:
ipa-client-4.4.0-14.el7.centos.7.x86_64 has installed conflicts freeipa-client: ipa-client-4.4.0-14.el7.centos.7.x86_64
ipa-client-common-4.4.0-14.el7.centos.7.noarch has installed conflicts freeipa-client-common: ipa-client-common-4.4.0-14.el7.centos.7.noarch
ipa-common-4.4.0-14.el7.centos.7.noarch has installed conflicts freeipa-common: ipa-common-4.4.0-14.el7.centos.7.noarch
Installing : mysql-community-common-5.7.21-1.el7.x86_64 1/6
Installing : mysql-community-libs-5.7.21-1.el7.x86_64 2/6
Installing : mysql-community-client-5.7.21-1.el7.x86_64 3/6
Installing : mysql-community-server-5.7.21-1.el7.x86_64 4/6
Installing : mysql-community-libs-compat-5.7.21-1.el7.x86_64 5/6
Erasing : 1:mariadb-libs-5.5.52-1.el7.x86_64 6/6
Verifying : mysql-community-client-5.7.21-1.el7.x86_64 1/6
Verifying : mysql-community-libs-compat-5.7.21-1.el7.x86_64 2/6
Verifying : mysql-community-libs-5.7.21-1.el7.x86_64 3/6
Verifying : mysql-community-server-5.7.21-1.el7.x86_64 4/6
Verifying : mysql-community-common-5.7.21-1.el7.x86_64 5/6
Verifying : 1:mariadb-libs-5.5.52-1.el7.x86_64 6/6
Installed:
mysql-community-libs.x86_64 0:5.7.21-1.el7 mysql-community-libs-compat.x86_64 0:5.7.21-1.el7 mysql-community-server.x86_64 0:5.7.21-1.el7
Dependency Installed:
mysql-community-client.x86_64 0:5.7.21-1.el7 mysql-community-common.x86_64 0:5.7.21-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.52-1.el7
Complete!
[root@much otrs]#启动 mysql
[root@much otrs]# systemctl start mysqld
[root@much otrs]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 一 2018-01-29 23:40:24 CST; 6s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 3040 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 2960 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 3043 (mysqld)
CGroup: /system.slice/mysqld.service
└─3043 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
1月 29 23:40:19 much systemd[1]: Starting MySQL Server...
1月 29 23:40:24 much systemd[1]: Started MySQL Server.
[root@much otrs]#获取密码
[root@much mysql]# grep password /var/log/mysqld.log
2018-01-29T15:40:21.149869Z 1 [Note] A temporary password is generated for root@localhost: gis77wkd<pkL
[root@much mysql]#修改密码
[root@much mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.21
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user 'root'@'localhost' IDENTIFIED BY 'x1iAOA8A0ub2tWX_2L3s';
Query OK, 0 rows affected (0.00 sec)
mysql>安装 otrs
[root@much ~]# cd
[root@much ~]# cd otrs/
[root@much otrs]# ls
mysql57-community-release-el7-11.noarch.rpm otrs-6.0.4-03.noarch.rpm
[root@much otrs]# yum install otrs-6.0.4-03.noarch.rpm
Loaded plugins: fastestmirror, langpacks
Complete!
[root@much otrs]#启动 apache 服务
[root@much ~]# systemctl restart httpd本文系转载，前往查看
如有侵权，请联系 cloudcommunity@tencent.com 删除。
本文系转载，前往查看
如有侵权，请联系 cloudcommunity@tencent.com 删除。
评论
登录后参与评论
推荐阅读
目录
相关产品与服务
云数据库 SQL Server
腾讯云数据库 SQL Server （TencentDB for SQL Server）是业界最常用的商用数据库之一，对基于 Windows 架构的应用程序具有完美的支持。TencentDB for SQL Server 拥有微软正版授权，可持续为用户提供最新的功能，避免未授权使用软件的风险。具有即开即用、稳定可靠、安全运行、弹性扩缩等特点。