Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
centos:web_c7:mattermost [05.10.2017 18:49. ] – [Erstellen eines Systemd Init Daemon] djangocentos:web_c7:mattermost [22.07.2019 14:47. ] (aktuell) – [Links] django
Zeile 1: Zeile 1:
-====== Mattermost mit MariaDB und Apache unter CentOS 7.x installieren und betreiben ======+====== Mattermost v4 mit MariaDB und Apache unter CentOS 7.x installieren und betreiben ======
 {{:centos:web_c7:mattermost_logo.png?nolink&200 |Bild: Mattermost Logo}} **[[https://www.mattermost.org/|Mattermost]]** ist ein Werkzeug zum gemeinsamen Zusammenarbeiten in Teams, egal ob dies kleine schlagkräftige Gruppen sind, oder einzelne Bereiche bzw. Fachabteilungen in Firmen und Organisationen. Dabei ist es unerheblich, wo sich die einzelnen Teammitglieder befinden. egal ob vor Ort im Büro, im Homeoffice oder unterwegs. Neben der klassischen Funktion des Austausch von Informationen, Dokumenten, Programm- und Logdaten gibt es auch Möglichkeiten zum Anbinden und Einspeisen von Informationen aus verschiedenen Datenquellen, wie z.B. Datenbanken oder anderweitigen Systemen. {{:centos:web_c7:mattermost_logo.png?nolink&200 |Bild: Mattermost Logo}} **[[https://www.mattermost.org/|Mattermost]]** ist ein Werkzeug zum gemeinsamen Zusammenarbeiten in Teams, egal ob dies kleine schlagkräftige Gruppen sind, oder einzelne Bereiche bzw. Fachabteilungen in Firmen und Organisationen. Dabei ist es unerheblich, wo sich die einzelnen Teammitglieder befinden. egal ob vor Ort im Büro, im Homeoffice oder unterwegs. Neben der klassischen Funktion des Austausch von Informationen, Dokumenten, Programm- und Logdaten gibt es auch Möglichkeiten zum Anbinden und Einspeisen von Informationen aus verschiedenen Datenquellen, wie z.B. Datenbanken oder anderweitigen Systemen.
  
Zeile 489: Zeile 489:
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.ClusterDiscovery ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.ClusterDiscovery ENGINE = MyISAM;
 Query OK, 0 rows affected (0.05 sec)                Query OK, 0 rows affected (0.05 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.ChannelMembers ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Commands ENGINE = MyISAM;
 Query OK, 0 rows affected (0.05 sec)                Query OK, 0 rows affected (0.05 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Channels ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.CommandWebhooks ENGINE = MyISAM;
 Query OK, 0 rows affected (0.02 sec)                Query OK, 0 rows affected (0.02 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Commands ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Compliances ENGINE = MyISAM;
 Query OK, 0 rows affected (0.04 sec)                Query OK, 0 rows affected (0.04 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Compliances ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Emoji ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.04 sec)                Query OK, 0 rows affected (0.04 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Emoji ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.FileInfo ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.02 sec)                Query OK, 0 rows affected (0.02 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.IncomingWebhooks ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.IncomingWebhooks ENGINE = MyISAM;
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Licenses ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Jobs ENGINE = MyISAM;
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthAccessData ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Licenses ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthApps ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthAccessData ENGINE= MyISAM; 
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthAuthData ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthApps ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OutgoingWebhooks ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OAuthAuthData ENGINE = MyISAM;  
 +Query OK, 0 rows affected (0.03 sec)                
 +Records: 0  Duplicates: 0  Warnings: 0 
 + 
 +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.OutgoingWebhooks ENGINE = MyISAM;
 Query OK, 0 rows affected (0.05 sec)                Query OK, 0 rows affected (0.05 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.PasswordRecovery ENGINE=MyISAM;+ 
 +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Posts ENGINE = MyISAM;
 Query OK, 0 rows affected (0.05 sec)                Query OK, 0 rows affected (0.05 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Posts ENGINE=MyISAM;  +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Preferences ENGINE = MyISAM;  
-Query OK, 0 rows affected (0.07 sec)               +Query OK, 0 rows affected (0.63 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Preferences ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Reactions ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.63 sec)                Query OK, 0 rows affected (0.63 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Sessions ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Sessions ENGINE = MyISAM;
 Query OK, 0 rows affected (0.07 sec)                Query OK, 0 rows affected (0.07 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Status ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Status ENGINE = MyISAM;
 Query OK, 0 rows affected (0.35 sec)                Query OK, 0 rows affected (0.35 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Systems ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Systems ENGINE = MyISAM; 
 Query OK, 3 rows affected (0.06 sec)                Query OK, 3 rows affected (0.06 sec)               
 Records: 3  Duplicates: 0  Warnings: 0 Records: 3  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.TeamMembers ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.TeamMembers ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.18 sec)                Query OK, 0 rows affected (0.18 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Teams ENGINE=MyISAM; +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Teams ENGINE = MyISAM; 
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
  
-MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Users ENGINE=MyISAM;+MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Tokens ENGINE = MyISAM;  
 +Query OK, 0 rows affected (0.03 sec)                
 +Records: 0  Duplicates: 0  Warnings: 0 
 + 
 +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.UserAccessTokens ENGINE = MyISAM;  
 +Query OK, 0 rows affected (0.03 sec)                
 +Records: 0  Duplicates: 0  Warnings: 0 
 + 
 +MariaDB [mattermost_db]> ALTER TABLE mattermost_db.Users ENGINE = MyISAM;
 Query OK, 0 rows affected (0.03 sec)                Query OK, 0 rows affected (0.03 sec)               
 Records: 0  Duplicates: 0  Warnings: 0 Records: 0  Duplicates: 0  Warnings: 0
Zeile 700: Zeile 713:
  
 <file apache /etc/httpd/conf.d/mattermost.conf># <file apache /etc/httpd/conf.d/mattermost.conf>#
-# Django : 2016-09-26+# Django : 2017-10-05
 #          vHost mattermost.nausch.org #          vHost mattermost.nausch.org
 # #
  
-<VirtualHost 10.0.0.97:80>+<VirtualHost 10.0.0.107:80>
     ServerAdmin webmaster@nausch.org     ServerAdmin webmaster@nausch.org
     ServerName mattermost.nausch.org     ServerName mattermost.nausch.org
Zeile 716: Zeile 729:
     ErrorLog  logs/mattermost_error.log     ErrorLog  logs/mattermost_error.log
 </VirtualHost> </VirtualHost>
-<VirtualHost 10.0.0.97:443>+<VirtualHost 10.0.0.107:443>
     ServerAdmin webmaster@nausch.org     ServerAdmin webmaster@nausch.org
     ServerName mattermost.nausch.org     ServerName mattermost.nausch.org
Zeile 722: Zeile 735:
  
     # Welcher Inhalt soll angezeigt bzw. auf welchen Server sollen die HTTP-Requests weitergeleitet werden?     # Welcher Inhalt soll angezeigt bzw. auf welchen Server sollen die HTTP-Requests weitergeleitet werden?
-    RewriteEngine on +    <Proxy *> 
-    RewriteCond %{REQUEST_URI} ^/api/v1/websocket [NC,OR]+       Require all granted 
 +    </Proxy> 
 + 
 +    RewriteEngine On 
 +    RewriteCond %{REQUEST_URI} ^/api/v[0-9]+/(users/)?websocket [NC,OR]
     RewriteCond %{HTTP:UPGRADE} ^WebSocket$ [NC,OR]     RewriteCond %{HTTP:UPGRADE} ^WebSocket$ [NC,OR]
     RewriteCond %{HTTP:CONNECTION} ^Upgrade$ [NC]     RewriteCond %{HTTP:CONNECTION} ^Upgrade$ [NC]
Zeile 729: Zeile 746:
     RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f     RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f
     RewriteRule .* http://127.0.0.1:8065%{REQUEST_URI} [P,QSA,L]     RewriteRule .* http://127.0.0.1:8065%{REQUEST_URI} [P,QSA,L]
-    RequestHeader set X-Forwarded-Proto "https" + 
-    <Location /> +    <Location /api/v3/users/websocket
-        Require all granted +       Require all granted 
-        ProxyPassReverse http://127.0.0.1:8065 +       ProxyPass ws://127.0.0.1:8065/api/v3/users/websocket 
-        ProxyPassReverseCookieDomain 127.0.0.1 mattermost nausch.org+       ProxyPassReverse ws://127.0.0.1:8065/api/v3/users/websocket 
 +       ProxyPassReverseCookieDomain 127.0.0.1 mattermost.nausch.org
     </Location>     </Location>
-    <Location /api/v1/websocket+ 
-        Require all granted +    <Location /> 
-        ProxyPassReverse http://127.0.0.1:8065 +       Require all granted 
-        ProxyPassReverseCookieDomain 127.0.0.1 mattermost.nausch.org+       ProxyPass http://127.0.0.1:8065/ 
 +       ProxyPassReverse http://127.0.0.1:8065/ 
 +       ProxyPassReverseCookieDomain 127.0.0.1 mattermost.nausch.org
     </Location>     </Location>
  
Zeile 1018: Zeile 1038:
  
  
-~~DISCUSSION~~ 
  • centos/web_c7/mattermost.txt
  • Zuletzt geändert: 22.07.2019 14:47.
  • von django