I didn’t fully read the instructions in https://docs.mattermost.com/deploy/server/deploy-linux.html and didn’t notice the sentence about arm64. So I downloaded the amd64 rather than the arm64 tarball! I’ve now removed mattermost and followed the instructions again with the arm64 tarball. Now getting a problem with Postgres when sserver.
manager@raspberrypi:~$ sudo systemctl start mattermost
[sudo] password for manager:
Job for mattermost.service failed because the control process exited with error code.
See “systemctl status mattermost.service” and “journalctl -xeu mattermost.service” for details.
manager@raspberrypi:~$ journalctl -xeu mattermost | tail -n 50 | tee -a ~/20250731_mattermost_troubleshooting.txt
Aug 01 06:53:15 raspberrypi mattermost[10357]: {“timestamp”:“2025-08-01 06:53:15.738 +01:00”,“level”:“info”,“msg”:“Pinging SQL”,“caller”:“sql/sql_utils.go:68”,“database”:“master”,“dataSource”:“postgres://:@192.168.2.10:5432/mattermost?connect_timeout=10&sslmode=disable”,“attempt”:3}
Aug 01 06:53:15 raspberrypi mattermost[10357]: {“timestamp”:“2025-08-01 06:53:15.779 +01:00”,“level”:“error”,“msg”:“Failed to ping DB”,“caller”:“sql/sql_utils.go:77”,“database”:“master”,“dataSource”:“postgres://:@192.168.2.10:5432/mattermost?connect_timeout=10&sslmode=disable”,“retrying in seconds”:2,“error”:“pq: password authentication failed for user “mmuser””}
Aug 01 06:53:17 raspberrypi mattermost[10357]: {“timestamp”:“2025-08-01 06:53:17.780 +01:00”,“level”:“info”,“msg”:“Pinging SQL”,“caller”:“sql/sql_utils.go:68”,“database”:“master”,“dataSource”:“postgres://:@192.168.2.10:5432/mattermost?connect_timeout=10&sslmode=disable”,“attempt”:4}
Aug 01 06:53:17 raspberrypi mattermost[10357]: {“timestamp”:“2025-08-01 06:53:17.814 +01:00”,“level”:“error”,“msg”:“Failed to ping DB”,“caller”:“sql/sql_utils.go:77”,“database”:“master”,“dataSource”:“postgres://:@192.168.2.10:5432/mattermost?connect_timeout=10&sslmode=disable”,“retrying in seconds”:2,“error”:“pq: password authentication failed for user “mmuser””}
Aug 01 06:53:19 raspberrypi mattermost[10357]: {“timestamp”:“2025-08-01 06:53:19.815 +01:00”,“level”:“info”,“msg”:“Pinging SQL”,“caller”:“sql/sql_utils.go:68”,“database”:“master”,“dataSource”:“postgres://:@192.168.2.10:5432/mattermost?connect_timeout=10&sslmode=disable”,“attempt”:5}
Aug 01 06:53:19 raspberrypi mattermost[10357]: Error: failed to initialize platform: cannot create store: error setting up connections: pq: password authentication failed for user “mmuser”
Aug 01 06:53:19 raspberrypi mattermost[10357]: Usage:
Aug 01 06:53:19 raspberrypi mattermost[10357]: mattermost [flags]
Aug 01 06:53:19 raspberrypi mattermost[10357]: mattermost [command]
Aug 01 06:53:19 raspberrypi mattermost[10357]: Available Commands:
Aug 01 06:53:19 raspberrypi mattermost[10357]: completion Generate the autocompletion script for the specified shell
Aug 01 06:53:19 raspberrypi mattermost[10357]: db Commands related to the database
Aug 01 06:53:19 raspberrypi mattermost[10357]: export Export data from Mattermost
Aug 01 06:53:19 raspberrypi mattermost[10357]: help Help about any command
Aug 01 06:53:19 raspberrypi mattermost[10357]: import Import data.
Aug 01 06:53:19 raspberrypi mattermost[10357]: jobserver Start the Mattermost job server
Aug 01 06:53:19 raspberrypi mattermost[10357]: server Run the Mattermost server
Aug 01 06:53:19 raspberrypi mattermost[10357]: version Display version information
Aug 01 06:53:19 raspberrypi mattermost[10357]: Flags:
Aug 01 06:53:19 raspberrypi mattermost[10357]: -c, --config string Configuration file to use.
Aug 01 06:53:19 raspberrypi mattermost[10357]: -h, --help help for mattermost
Aug 01 06:53:19 raspberrypi mattermost[10357]: Use “mattermost [command] --help” for more information about a command.
Aug 01 06:53:19 raspberrypi systemd[1]: mattermost.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ An ExecStart= process belonging to unit mattermost.service has exited.
░░
░░ The process’ exit code is ‘exited’ and its exit status is 1.
Aug 01 06:53:19 raspberrypi systemd[1]: mattermost.service: Failed with result ‘exit-code’.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ The unit mattermost.service has entered the ‘failed’ state with result ‘exit-code’.
Aug 01 06:53:19 raspberrypi systemd[1]: Failed to start mattermost.service - Mattermost.
░░ Subject: A start job for unit mattermost.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A start job for unit mattermost.service has finished with a failure.
░░
░░ The job identifier is 4116 and the job result is failed.
Aug 01 06:53:19 raspberrypi systemd[1]: mattermost.service: Consumed 1.362s CPU time.
░░ Subject: Resources consumed by unit runtime
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ The unit mattermost.service completed and consumed the indicated resources.
Could this be due to my router having my server as the DMZ but not yet having iptables set to accept the numerous ports for mattermost?
PS I use TalkTalk which doesn’t allow my own website https://johnrose.mywire.org to be accessed by my internet browser on my home network. Could that be a problem?