====== CentOS7 安裝 Leantime 專案管理系統 ======
  * 安裝環境 : 
    * PVE 6.0.12 底下的 CT
    * CentOS Linux release 7.7.1908 (Core) 

===== 安裝相關系統環境 =====
  * EPEL 與其他工具套件<code sh>
yum install -y epel-release yum-utils wget unzip
</code>
  * PHP 7.2 and up <code sh>
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
yum-config-manager --disable remi-php54
yum-config-manager --enable remi-php73
yum install -y php php-mysqlnd php-mbstring
</code>
  * Apache with mod_rewrite<code sh>
yum install -y httpd mod_ssl
</code>
  * MySQL 5.6 -> MariaDB 10.3<code h /etc/yum.repos.d/MariaDB.repo>
# MariaDB 10.3 CentOS repository list - created 2019-01-25 13:04 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
</code><code sh>
yum install -y MariaDB-server 
</code>
  * 基本參數環境設定
    * <code h /etc/php.ini>
:
[Date]
:
date.timezone = Asia/Taipei
:
</code>
    * <code h /etc/httpd/conf/httpd.conf>
:
<Directory "/var/www/html">
:
    AllowOverride All
:
</code>
  * 系統初始化設定 <code sh>
systemctl start httpd
systemctl enable httpd
systemctl start mariadb
systemctl enable mariadb 
mysql_secure_installation
mysql -u root -p
</code>

===== 安裝與設定 Leantime =====
  * Download latest release package
  * Upload entire directory to your server
  * Point your domain to the public/ directory
  * Rename config/configuration.sample.php to config/configuration.php
    * <code sh>
su - root
cd /var/www/
wget https://leantime.io/download/?wpdmdl=6881 -O leantime.zip
unzip leantime.zip
rmdir html
mv public html
cp config/configuration.sample.php config/configuration.php
chown apache:apache /var/www/userfiles/
</code>
  * Create an empty MySQL database<code sh>
mysql -u root -p
create database leadtime;
create user 'leadtime'@'localhost' identified by '**Password**';
grant all on leadtime.* to 'leadtime'@'localhost';
flush privileges;
quit
</code><cli>
[root@ct-leantime www]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 10.3.20-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database leadtime;
Query OK, 1 row affected (0.000 sec)

MariaDB [(none)]> create user 'leadtime'@'localhost' identified by '**Password**';
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> grant all on leadtime.* to 'leadtime'@'localhost';
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> quit
Bye
[root@ct-leantime www]# 
</cli>
  * Fill in your database credentials (username, password, host, dbname) in config/configuration.php
    * <code h /var/www/config/configuration.php>
:
    /* Database */
    public $dbHost="localhost"; //Database host
        public $dbUser="leadtime"; //Database username
        public $dbPassword="**Password**"; //Database password
        public $dbDatabase="leadtime"; //Database name

        /* Fileupload */
:
</code>
  * Navigate to <yourdomain.com>/install
  * Follow instructions to install database and set up first user account
  * {{:tech:2019112301.png}}
  * {{:tech:2019112302.png}}


===== 參考網址 =====
  * https://help.leantime.io/article/show/97353-system-requirements
  * https://help.leantime.io/article/show/97350-installing-leantime
  * https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/

{{tag>project}}