[ Mattermost ] [ 7.9.1 ] Self-hosted Slack-alternative

This is the best place for community developers to publish their genius work. Your Apps enrich the QNAP Turbo NAS.
Post Reply
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.33.2 ] Self-hosted Slack-alternative

Post by yanuk »

Manged to get anti virus working with Mattermost after I just noticed there's a Qclamav on qnapclub repository.

Here's how to enable it.
Install antivirus plugin from marketplace.
Install QClamAV
Edit clamd.conf in /opt/ClamAV
look for

Code: Select all

# TCP port address.
# Default: no
TCPSocket 3318
uncomment the last line TCPSocket and give it an unused port number I'm using 3318 as 3310 is used

Code: Select all

# TCP address.
# By default we bind to INADDR_ANY, probably not wise.
# Enable the following to provide some degree of protection
# from the outside world. This option can be specified multiple
# times if you want to listen on multiple IPs. IPv6 is now supported.
# Default: no
TCPAddr 127.0.0.1
uncomment the last line TCPAddr

Code: Select all

cd /opt/ClamAV
./ClamAV.sh restart
it should run now. verify by checking

Code: Select all

lsof -i -P -n | grep 3318
clamd     1231762    admin    4u  IPv4 79609266      0t0  TCP 127.0.0.1:3318 (LISTEN)
go back to Matermost console. look under antivirus setting.
Enable plugin and enter in "localhost:3318" for host and port.

Done!

Thank you Stephane for your consistent hard work updating the versions!
TS451
TS453
TVS-682
Silverow
New here
Posts: 7
Joined: Tue Nov 28, 2017 12:39 pm

Re: [ Mattermost ] [ 5.33.2 ] Self-hosted Slack-alternative

Post by Silverow »

Hello. If there is a "How to install and configure" that qpkg?
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.33.3 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

updated
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.33.2 ] Self-hosted Slack-alternative

Post by yanuk »

Silverow wrote: Fri Apr 09, 2021 8:04 pm Hello. If there is a "How to install and configure" that qpkg?
what do you want to know? or what issues are you having ?

it is pretty direct, install the qpkg, then edit the config file to point to the correct database setting and it's all done.
you need a little more advanced still on port forwarding if you want to use this service exposed to the internet.

I'm using this with Postgresql 10. All good so far for a few years now.
TS451
TS453
TVS-682
Silverow
New here
Posts: 7
Joined: Tue Nov 28, 2017 12:39 pm

Re: [ Mattermost ] [ 5.33.3 ] Self-hosted Slack-alternative

Post by Silverow »

Could you plz explain how to "edit the config file to point to the correct database setting"?
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.33.3 ] Self-hosted Slack-alternative

Post by yanuk »

Silverow wrote: Wed Apr 14, 2021 2:06 pm Could you plz explain how to "edit the config file to point to the correct database setting"?
I assume you know how to SSH into QNAP

Code: Select all

cd /opt/Mattermost/config
edit the config.json file, i use vim, you can use vi or anything editor

Code: Select all

vim config.json
I'm using postgresql on port 5432, using database name "mattermost" and example username of "mmuser", you can change it to any other user so the below setting is for postgres, if you're using MySQL you can enter your settings accordingly.
press "i" to edit the file

Code: Select all

    "SqlSettings": {
        "DriverName": "postgres",
        "DataSource": "postgres://mmuser:really_secure_password@localhost:5432/mattermost?sslmode=disable&connect_timeout=10", 
    },
Press 'esc' then ":wq" to save and quit
restart mattermost and it should connect to the database
for MySQL setting you can check it out here https://docs.mattermost.com/administrat ... abase.html
TS451
TS453
TVS-682
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.33.3 ] Self-hosted Slack-alternative

Post by yanuk »

additional info i think you would need would be setting up the database and user. here are the commands for Postgresql, You can google the equivalent for MySQL/MariaDB
I'm using PostgresSQL10 qpkg by Stephane on qnapclub repo so adapt accordingly

Code: Select all

cd /opt/QPostgres/bin
./su postgres
./psql
from here the prompt will convert to "postgres=#"

Code: Select all

create database mattermost;
create user mmuser with encrypted password 'really_secure_password';
grant all privileges on database mydb to mmuser;
\q
you should have created a database called mattermost, with user id mmuser and password really_secure_password

Code: Select all

exit
to exit user as postgres and back to QNAP admin user. This step is important
TS451
TS453
TVS-682
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.35.0 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

updated to 5.35 core
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.36.0 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

updated to 5.36
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.36.1 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

bump to 5.36.1
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.37.0 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

bump to 5.37
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Mattermost ] [ 5.38.1 ] Self-hosted Slack-alternative

Post by QNAP_Stephane »

bump to 5.38.1
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
cabaseira
Starting out
Posts: 10
Joined: Sat Feb 29, 2020 4:19 am

Re: [ Mattermost ] [ 5.33.3 ] Self-hosted Slack-alternative

Post by cabaseira »

I can't make it work.
I'm using QMariadb. I created a user named "mattermost" and a database with the same name.
In config file I changed this:

Code: Select all

    "SqlSettings": {
        "DriverName": "mysql",
        "DataSource": "mysql://mattermost:mattermost@tcp(192.168.0.2:3308)/mattermost?charset=utf8mb4,utf8&writeTimeout=30s", 
    },
I tried too with the user "mmuser" and "mattermost" database.

Code: Select all

    "SqlSettings": {
        "DriverName": "mysql",
        "DataSource": "mysql://mmuser:mattermost@tcp(192.168.0.2:3308)/mattermost?charset=utf8mb4,utf8&writeTimeout=30s", 
    },
When I enter in:
http://192.168.0.2:8456/mattermost

I get this message:

Code: Select all

Not Found

The requested URL was not found on this server.
Can anybody help me?
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.38.1 ] Self-hosted Slack-alternative

Post by yanuk »

ah. I don't use the app icon in qnap to load mattermost. Try looking at the config.json setting

Code: Select all

 "ListenAddress": ":8123", 
that's the port number. then you'll just enter the IP address of your NAS followed by the port number
Example: HTTP://192.168.0.2:8123
TS451
TS453
TVS-682
yanuk
Know my way around
Posts: 164
Joined: Mon Feb 08, 2016 9:45 am

Re: [ Mattermost ] [ 5.38.1 ] Self-hosted Slack-alternative

Post by yanuk »

QNAP_Stephane wrote: Sun Aug 22, 2021 11:26 pm bump to 5.38.1
Time to bump up to 6.4? :D

Thank you Stephane!
TS451
TS453
TVS-682
Post Reply

Return to “Community Apps”