@girish Do you want the comments here? All I can say is that this section:
Riot is pre-configured to use matrix subdomain as the homeserver location.
ought to be more evident. Like at the start of a paragraph. It's the sort of essential info that real coders like yourself just know but tinkerers like me don't.
Another line that could use some clarifying is:
SSH into the server and add the record like this
My own impression from using Cloudron is that there is no need to ssh into the server and that using the built-in Terminal is the place to get things done if needed. I followed it literally, but I also think someone could read it and think "they must mean through the Console of the app...but which one, the Matrix server or the RIOT app?" and proceed to get confused because they can't navigate to
Finally, in Step 3, after the line:
If you installed synapse at matrix.example.com, the client should be already able to connect
maybe you could add something like "check Step 1" as a reminder because someone will prob skip it and then get here wondering what's going on.
Finally, thank you again.
@stantropics In the terminal you should be able run the psql command to update a user to admin.
To get the password type:
psql --host=$CLOUDRON_POSTGRESQL_HOST port=$CLOUDRON_POSTGRESQL_PORT $CLOUDRON_POSTGRESQL_DATABASE $CLOUDRON_POSTGRESQL_USERNAME
[right-click-Copy and ctrl-v paste in the password]
UPDATE users SET admin = 1 WHERE name = '@foo:bar.com';
BUT: I am getting: psql: FATAL: password authentication failed for user ...
Can anyone see what I am doing wrong? @girish ?
@jimscarver In the Terminal, there is a Postgres button on the top. Just clicking it will paste the command to connect to postgres. Just paste enter after that.
(That aside, I think the mistake in your cli is possibly that the database name is not set)