08-29-2020, 11:02 AM
#################################Installation ########################################
yum update -y
yum -y install mariadb-server
#Start and Enable Database Services
systemctl start mariadb.service
systemctl enable mariadb.service
systemctl status mariadb.service
#Create initial database
mysql_secure_installation
mysql -u root -p
:'
create database mattermost;
GRANT ALL ON mattermost.* TO mattermost@localhost IDENTIFIED BY 'Root@123';
'
useradd -U -M -d /opt/mattermost mattermost
wget https://releases.mattermost.com/5.4.0/ma...d64.tar.gz
tar zxf /tmp/mattermost.tar.gz -C /opt
mkdir /opt/mattermost/data ############ To store client files and attachments
chown -R mattermost: /opt/mattermost
vim /opt/mattermost/config/config.json
:'
"ServiceSettings": {
"SiteURL": "http://server.com/mattermost",
...
"SqlSettings": {
"DriverName": "mysql",
"DataSource": "mattermost:Root@123@tcp(localhost:3306)/mattermost?charset=utf8mb4,utf8&readTimeout=30s&writeTimeout=30s",
"DataSourceReplicas": [],
...
'
cd /opt/mattermost
sudo -u mattermost bin/mattermost ####### ctrls+c
vim /etc/systemd/system/mattermost.service
:'
[Unit]
Description=Mattermost
After=network.target nss-lookup.target mariadb.service
[Service]
Type=notify
WorkingDirectory=/opt/mattermost
User=mattermost
SyslogIdentifier=mattermost
ExecStart=/opt/mattermost/bin/mattermost
TimeoutStartSec=3600
LimitNOFILE=49152
[Install]
WantedBy=multi-user.target
'
systemctl daemon-reload
systemctl start mattermost
systemctl status mattermost
systemctl enable mattermost
yum install nginx
systemctl start nginx
systemctl enable nginx
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --reload
################################# Errors ########################################
#sudo -u mattermost bin/mattermost
#Error: The used table type doesn’t support FULLTEXT indexes
# 1 Solution: Update Table in Mysql
#mysql -u root -p;
#show databases;
#use mattermost;
#ALTER TABLE `PublicChannels` ENGINE = MyISAM;
#flush privileges;
#exit
# 2 Solution: Update the Mysql
#rpm -Uvh https://dl.fedoraproject.org/pub/epel/ep...noarch.rpm
#rpm -Uvh http://rpms.famillecollet.com/enterprise...ease-7.rpm
#yum -y update mysql*
#rpm -qa | grep mysql
#wget http://repo.mysql.com/mysql57-community-release-el7.rpm
#yum remove mysql-community-release
#rpm -ivh /tmp/mysql57-community-release-el7.rpm
#rpm -ivh mysql57-community-release-el7.rpm
#yum update mysql
#mysql_upgrade
#systemctl restart mysql
#sudo -u mattermost bin/mattermost
Failed to ping DB retrying in 10 seconds err=dial tcp: lookup dockerhost on 192.168.2.1:53: no such host
# 1 Solution : Do an entry of dockerhost
vim /etc/hosts
127.0.0.1 dockerhost
yum update -y
yum -y install mariadb-server
#Start and Enable Database Services
systemctl start mariadb.service
systemctl enable mariadb.service
systemctl status mariadb.service
#Create initial database
mysql_secure_installation
mysql -u root -p
:'
create database mattermost;
GRANT ALL ON mattermost.* TO mattermost@localhost IDENTIFIED BY 'Root@123';
'
useradd -U -M -d /opt/mattermost mattermost
wget https://releases.mattermost.com/5.4.0/ma...d64.tar.gz
tar zxf /tmp/mattermost.tar.gz -C /opt
mkdir /opt/mattermost/data ############ To store client files and attachments
chown -R mattermost: /opt/mattermost
vim /opt/mattermost/config/config.json
:'
"ServiceSettings": {
"SiteURL": "http://server.com/mattermost",
...
"SqlSettings": {
"DriverName": "mysql",
"DataSource": "mattermost:Root@123@tcp(localhost:3306)/mattermost?charset=utf8mb4,utf8&readTimeout=30s&writeTimeout=30s",
"DataSourceReplicas": [],
...
'
cd /opt/mattermost
sudo -u mattermost bin/mattermost ####### ctrls+c
vim /etc/systemd/system/mattermost.service
:'
[Unit]
Description=Mattermost
After=network.target nss-lookup.target mariadb.service
[Service]
Type=notify
WorkingDirectory=/opt/mattermost
User=mattermost
SyslogIdentifier=mattermost
ExecStart=/opt/mattermost/bin/mattermost
TimeoutStartSec=3600
LimitNOFILE=49152
[Install]
WantedBy=multi-user.target
'
systemctl daemon-reload
systemctl start mattermost
systemctl status mattermost
systemctl enable mattermost
yum install nginx
systemctl start nginx
systemctl enable nginx
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --reload
################################# Errors ########################################
#sudo -u mattermost bin/mattermost
#Error: The used table type doesn’t support FULLTEXT indexes
# 1 Solution: Update Table in Mysql
#mysql -u root -p;
#show databases;
#use mattermost;
#ALTER TABLE `PublicChannels` ENGINE = MyISAM;
#flush privileges;
#exit
# 2 Solution: Update the Mysql
#rpm -Uvh https://dl.fedoraproject.org/pub/epel/ep...noarch.rpm
#rpm -Uvh http://rpms.famillecollet.com/enterprise...ease-7.rpm
#yum -y update mysql*
#rpm -qa | grep mysql
#wget http://repo.mysql.com/mysql57-community-release-el7.rpm
#yum remove mysql-community-release
#rpm -ivh /tmp/mysql57-community-release-el7.rpm
#rpm -ivh mysql57-community-release-el7.rpm
#yum update mysql
#mysql_upgrade
#systemctl restart mysql
#sudo -u mattermost bin/mattermost
Failed to ping DB retrying in 10 seconds err=dial tcp: lookup dockerhost on 192.168.2.1:53: no such host
# 1 Solution : Do an entry of dockerhost
vim /etc/hosts
127.0.0.1 dockerhost