Summary
Installed via Omnibus
As root I’ve tried:
psql --host=127.0.0.1 --dbname=mattermost_test --username=mmuser --password
with the default “mostest” as the password and I get:
psql: error: connection to server at “127.0.0.1”, port 5432 failed: FATAL: password authentication failed for user “mmuser”
connection to server at “127.0.0.1”, port 5432 failed: FATAL: password authentication failed for user “mmuser”
I’ve tried as su -u mattermost as well.
The config.json in /opt/mattermost/config/config,json shows:
"SqlSettings": {
"DriverName": "postgres",
"DataSource": "postgres://mmuser:mostest@localhost/mattermost_test?sslmode=disable\u0026connect_timeout=10",
"DataSourceReplicas": [],
"DataSourceSearchReplicas": [],
"MaxIdleConns": 20,
"ConnMaxLifetimeMilliseconds": 3600000,
"ConnMaxIdleTimeMilliseconds": 300000,
"MaxOpenConns": 300,
"Trace": false,
"AtRestEncryptKey": "###",
"QueryTimeout": 30,
"DisableDatabaseSearch": false,
"MigrationsStatementTimeoutSeconds": 100000,
"ReplicaLagSettings": []
mattermost export bulk bulk_data.json gives me:
Server is initializing...
Pinging SQL","caller":"sqlstore/store.go:218","database":"master"}
Failed to ping DB","caller":"sqlstore/store.go:228","error":"pq: password authentication failed for user \"mmuser\"","retrying in seconds":10}
mmctl config get SqlSettings returns
Error: cannot read user credentials, maybe you need to use login first: stat /root/.config/mmctl/config: no such file or directory
Literally no clue how the application is even connecting to the database when I can’t even connect…
— EDIT:
Found in docs that Mattermost Omnibus stores config in /etc/mattermost/mmomni.yml