====== Mattermost ======


===== Installing PostgreSQL Database. =====

=== With Unix socket. ===

A SlackBuild for building and installing PostgreSQL can be found at SlackBuilds.org; follow the instructions there, and install PostgreSQL. After installing PostgreSQL perform the following steps:
  - Initialize the PostgreSQL database: <code>su postgres -c "initdb -D /var/lib/pgsql/10.2/data --locale=en_US.UTF-8 -A md5 -W"</code>
  - Start the PostgreSQL database: <code>/etc/rc.d/rc.postgresql start</code>
  - Switch to the postgres Linux user account that was created during the installation.<code>su -l postgres</code>
  - Start the PostgreSQL interactive terminal. <code>psql</code>
  - Create the Mattermost database.<code>CREATE DATABASE mattermostdb;</code>
  - Create mattermost user and give it the rights on the database:<code>CREATE USER mattermost;</code><code>GRANT ALL PRIVILEGES ON DATABASE mattermostdb to mattermost;</code>
  - Exit out of psql with \q.
  - Setup the Unix socket by editing file: /var/lib/pgsql/10.2/data/pg_hba.conf, replace<code># "local" is for Unix domain socket connections only</code><code>local all all md5</code> with<code>local mattermostdb mattermost peer</code>
  - Add the following to "/var/lib/pgsql/10.2/data/pg_ident.conf" <code>echo "mattermap mattermostdb mattermost" >> /var/lib/pgsql/10.2/data/pg_ident.conf</code>
  - Restart PostgreSQL <code>exit</code><code>/etc/rc.d/rc.postgresql restart</code>
  - Add the mattermost system user: <code>useradd --system --user-group mattermost</code>
  - Verify things are working thus far <code>sudo -u mattermost psql --dbname=mattermostdb --username=mattermost</code>

====== Sources ======
<!-- If you are copying information from another source, then specify that source -->
<!-- * Original source: [[http://some.website.org/some/page.html]] -->
<!-- Authors are allowed to give credit to themselves! -->
<!-- * Originally written by [[wiki:user:xxx | User X]] -->
<!-- * Contributions by [[wiki:user:yyy | User Y]] -->

<!-- Please do not modify anything below, except adding new tags.-->
<!-- You must remove the tag-word "template" below before saving your new page -->
{{tag>howtos template}}