For troubleshooting questions, please post in the following format:
Summary
I am having an error where mattermost_test is not existing.
Steps to reproduce
I am using a fedora37 workstation that I am trying to install mattermost on. I have created an postgresql account for mmuser so that mmost can log in and have followed the directions such that the config .json matches with the Driver name and data source. The only thing that I can think is that I am not putting in the right SiteUrl. Would I just use the fully qualified domain name of the computer or something else?
Expected behavior
The test should run as defined in the mattermost documentation
Observed behavior
Here is what I have gotten:
{“timestamp”:“2023-03-15 19:25:25.872 -06:00”,“level”:“error”,“msg”:“Failed to ping DB”,“caller”:“sqlstore/store.go:250”,“error”:“pq: database "mattermost_test" does not exist”,“retrying in seconds”:10}
Hi @minute828 and welcome to the Mattermost forums!
Can you please show the line DataSource of your config.json? Make sure to mask the password, but please leave everything else as it is.
The line should look similar to this:
The values for “dbuser”, “dbpass” and “dbname” are relevant and according to the error message it seems as if your username and password are correct because it’s able to connect to the database server to find out that the database “mattermost_test” does not exist, so if I’d have to guess, the only thing you need to do now is to create an empty database.
To do that, switch to your postgres user again and run the following command:
su - postgres
createdb mattermost_test -O dbuser
Make sure to replace “dbuser” with your username.
Try again afterwards.