I have reached instruction 9, but on running the command
sudo -u mattermost ./bin/mattermost
I get the following:
{“level”:“info”,“ts”:1613060636.7064807,“caller”:“app/server.go:225”,“msg”:“Server is initializing…”}
{“level”:“info”,“ts”:1613060636.7065976,“caller”:“app/web_hub.go:83”,“msg”:“Starting websocket hubs”,“number_of_hubs”:12}
{“level”:“info”,“ts”:1613060636.7084298,“caller”:“utils/i18n.go:90”,“msg”:“Loaded system translations”,“for locale”:“en”,“from locale”:“/opt/mattermost/i18n/en.json”}
{“level”:“info”,“ts”:1613060636.7175372,“caller”:“sqlstore/supplier.go:246”,“msg”:“Pinging SQL”,“database”:“master”}
{“level”:“warn”,“ts”:1613060636.7308486,“caller”:“sqlstore/upgrade.go:137”,“msg”:“The database schema version and model versions do not match”,“schema_version”:“5.31.0”,“model_version”:“5.30.0”}
{“level”:“error”,“ts”:1613060636.7499022,“caller”:“sqlstore/supplier.go:981”,“msg”:“Failed to create index”,“table”:“Channels”,“index_name”:“idx_channel_search_txt”,“error”:“Error 1214: The used table type doesn’t support FULLTEXT indexes”}
I understand that this error in the final line is to do with the setup of the SQL table, but I’m not sure how to proceed.
I’m not a Linux expert but I know enough to do basic commands (and understand what I’m doing) so be gentle.
The error that we are seeing here is most likely related to the storage engine tied to the Channels table. Can you please run the following command and share what you result are you getting?
SELECT table_name,engine FROM information_schema.tables WHERE table_schema = 'mattermost';
We are expected to see something that looks like this:
It looks like you are using MariaDB, which we haven’t done a lot of testing with. But it should work nevertheless.
The current issue seems to be that the table type does not support FULLTEXT indexes, and from the documentation, it seems like FULLTEXT index support for InnoDB tables was added in 10.0.5. What is the MariaDB version that you are using?
Thanks for all the help so far. Mattermost is completely installed. Now the next problems.
The VPS I want to use MM on is running Plesk and using Lets Encrypt for SSL/TSL certificates. How exactly do I setup Mattermost to run with this? I seem to be going around in circles with using https or http, either with the raw IP address or on a domain.
I want me 10 yo son to be able to use this server to chat to his friends. He doesn’t have a phone, so using the client on his iPad would allow him to safely chat to his friends.
If you already have an existing domain, you would need to create a new one that will handle only Mattermost traffic, and edit the nginx config appropriately to handle traffic from that domain.
There are lots of example on the internet that will show you how to setup nginx to handle multiple domain names.
What you would want to do here is use a virtualhost, which allows you to host multiple domains/subdomains from a single IP address, listening on the same port. You can do this by following the guide that @ahmaddanial provided in the previous reply in this thread. The virtual host is defined in the line (copied from the example) server_name mattermost.example.com; where mattermost.example.com is the name of your domain.