How to Install Mattermost with MySQL on Ubuntu 14.04 & Debian 8

Install Mattermost with MySQL on Ubuntu 14.04 & Debian 8. Mattermost is a best alternative of Slack messaging application. It provides you option for all communications at one place with easy to use interface. You can easily share messages, files over desktops and mobile devices.

Step 1 – Setup MySQL Database Server

First you need to install MySQL database server on your system. Use following command to install default available version of mysql or read this tutorial.

$ sudo apt-get install mysql-server

Now create a database for mattermost installation and a mysql user for authentication.

$ mysql -u root -p

mysql> CREATE DATABASE mattermost;
mysql> GRANT ALL on mattermost.* to [email protected] IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;

Step 2 – Download Mattermost Archive

Now you can use root account or a separate account for your mattermost installation. Use below commands to create separate account.

$ sudo adduser mmuser
$ sudo passwd mmuser

Now switch to newly created account and download the mattermost compiled edition using below command. To find latest version visit here. Also extract the downloaded archive file.

$ sudo su - mmuser
$ wget https://releases.mattermost.com/2.2.0/mattermost-team-2.2.0-linux-amd64.tar.gz
$ tar xzf mattermost-team-2.2.0-linux-amd64.tar.gz

Step 3 – Configure Mattermost

Now edit mattermost configuration file config/config.json and update below details under SqlSettings section. Update DataSource values as per created records in step 1.

  "DriverName": "mysql",
  "DataSource": "mmuser:[email protected](localhost:3306)/mattermost?charset=utf8mb4,utf8",

Now create data directory for mattermost installation. This is the location where mattermost keeps data of teams like uploaded files etc.

$ mkdir ~/mattermost/data

Step 4 – Start Mattermost Server

You mattermost setup has been completed. Now use following commands to start mattermost service.

$ cd ~/mattermost/bin
$ ./platform

Default mattermost runs on port 8065, which can be changed in config/config.json file. Access your server on port 8065 (or customized port) through web browser.

 http://svr1.tecadmin.net:8065/

Now you may need to create your first team in mattermost. To create team enter email address for team administrator account and click Create Team.

Make sure administrator email is correct and click “Yes, this address is correct”.

Now enter name of you team in box and click Next.

You can customized your team url here. Input required team url and click Next.

Now choose a username for your administrator account and click Next.

Enter a secured password for you administrator account and click Finish.

You team has been successfully created and you will be redirected to you account.

Step 5 – Setup Mattermost with Upstart

Now create a mattermost startup script for Upstart daemon. Edit /etc/init/mattermost.conf file in text editor and add following content.

start on runlevel [2345]
stop on runlevel [016]
respawn
chdir /home/mmuser/mattermost
setuid mmuser
exec bin/platform

Now you can use following commands to start and stop mattermost .

$ sudo start mattermost
$ sudo stop mattermost