Matrix/Riot

NCKNE

@stantropics already askes this question in the closed matrix thread:

First of all, thanks to everyone who has been working on the matrix app. I'm very happy to be able to run it on cloudron!

Making a user an administrator.
Referring to the documentation (https://github.com/matrix-org/synapse/wiki) one command needs to be executed to make a user an admin - it manipulates the data in the postgresdb:
UPDATE users SET admin = 1 WHERE name = '@foo:bar.com'
What is the recommended way to perform this on Cloudron?

Thanks a lot in advance.
Stay healthy everyone!

Is there any recommended way to set a user as an admin in the app store released version of matrix?

Thanks!

girish

@NCKNE The sql command is probably the way to go for the app store version as well. I will put it in the docs. That said, I am yet to figure what an admin can do that a normal user cannot. Do special controls appear in the riot ui for admins?

girish

OK, I found https://github.com/vector-im/riot-web/issues/4125 which is an open issue for implementing admin functions in Riot. I also found https://github.com/Awesome-Technologies/synapse-admin which can probably be run locally.

will

@girish Getting an error on verifying:

$ curl https://example.com/.well-known/matrix/server
curl: (6) Could not resolve host: example.com (I used my own domain)

I chowned the matrix folder and server file to be owned by yellowtent. I had to use sudo to get the mkdir command to work.
I set permissions of 0600 on the server file.
There is no app at example.com.
Matrix is installed at matrix.example.com.
Do I need to manually add a DNS entry for example.com?

girish

@will You need to have an app installed at example.com. You can even set it to redirect to some other existing app i.e go to existing app -> Location -> Add redirection.

timbo

Hey! Works very very well. Runs smooth and does its job. But no LDAP would be a great feature for future

msbt

@will you can just enable registration in homeserver.yaml and you're good to go

timbo

well you can enable it yes, but users who registered were not able to login (?). I guess this is because it only accepts login from LDAP?

msbt

worked fine before when I tested it, did you also set

password_config:
  enabled: true
  localdb_enabled: true

and maybe restarted matrix?

will

@girish added a redirect for matrix, and it works! Is this only needed if an app lives at rimmer.cloud or do I need it regardless?

girish

@will Only requirement is that it should be used by some app on Cloudron. You don't need to redirect it to matrix specifically. example.com can either be any app or it can redirect to any app. (At a technical level, all this means is that the Cloudron's reverse proxy is prepared & ready to answer requests for that domain).

will

@girish Will this requirement be patched in a future release?

girish

@will there is no way around this requirement. the matrix protocol requires the apex domain to serve up those documents. is your concern that the domain example.com can be used to host a site somewhere else? If so, all you have to do is to move the .well-known setup to that server/new location.

will

@girish My concern is having anything at example.com
It would be cleaner to just have cloudron handle that for me. Small gripe, not a big deal at all.

girish

@will said in Matrix/Riot:

It would be cleaner to just have cloudron handle that for me. Small gripe, not a big deal at all.

Ah, Cloudron side limitation can definitely be fixed I agree that having to ssh and put files manually in a cryptic location is kinda crude. This will be fixed soonish but we just wanted to get the apps out for testing sooner rather than later.

will

@girish Dont get me wrong, Im thankful! Its great. I'm just giving a little feedback on possible improvements. Sounds like you are on it already

yusf

@msbt said in Matrix/Riot:

I'm guessing it is because of new keys and everything, haven't tried to re-use any of the existing ones.

Might very well be, yes. I'm going to try and migrate the keys too. The migration is hard to dry run though

msbt

if you want to make sure this works, you could try with a test-instance, after that a clone and then the real thing good luck either way!

yusf

I'm transitioning my external reverse-proxy-and-well-known solution to the Cloudron solution. Is there any way I can configure Riot to have https://domain.tld as base_url while still having the Synapse server at https://matrix.domain.tld? This way I would be able keep Riot user sessions across migration.

girish

@yusf That should not be a problem. Riot can be installed on the main domain as well. Just make sure the .well-known is setup on the server.

yusf

@girish Sorry, I meant doing so while keeping Riot at a subdomain too. I guess not?

girish

@yusf Yeah, I think not

jegillikin

FWIW, I just installed all of this and tested it. Works great, instructions are clear. The yaml edits referenced by @msbt were quite helpful on the external-registration side.

Look forward to the eventual Jitsi package.

yusf

@girish What if I edited the Cloudron reverse proxy settings directly?

girish

@yusf reverse proxy configs will get overwritten during updates. I think https://cloudron.io/documentation/apps/#well-known-uris should help setup well knowns the way you want them, no?

yusf

@girish Well-known is in place for Synapse already, but it seems that well-known configurations aren't enough to enable entering domain.tld as homeserver in Riot sign-in when the server is at matrix.domain.tld.

What seems to be needed is the ability to forward the whole /_matrix path at domain.tld to Synapse.

In nginx terms I belive that would look something like this:

server {
  listen         443;
  server_name    domain.tld;

 location /_matrix {
    proxy_pass https://matrix.domain.tld;
 }
}

ApplegateR

@girish I really hope this is possible add this in Wishlist for Matrix User and room manageable so spamming prevent and keep my chat server clean

girish

@ApplegateR said in Matrix/Riot:

@girish I really hope this is possible add this in Wishlist for Matrix User and room manageable so spamming prevent and keep my chat server clean

What are you referring to ? Did you maybe reply in the wrong thread?

ApplegateR

@girish have a admin access from web. So that way I can manage user or room.

msbt

@ApplegateR you can just grab the synapse admin package from here and put it inside a Surfer/LAMP app, it's just static files. You can login with your admin user and manage users and channels.

humptydumpty

@ApplegateR I just tried what @msbt mentioned and it works great. One error I ran into was that after uploading the files to a root surfer app and trying to log in, it spit out a "session expired" error. It turned out the account I was using wasn't an admin. To make a user an admin, refer to the doc here.

Basically, in Cloudron --> app settings page --> web terminal, and enter this code.

PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} -c "UPDATE users SET admin=1 WHERE name='@user:example.com'"

The only part you need to edit is the one at the end to match your desired Matrix user:

@user:example.com

Then, you can log in and manage the Matrix server.

ApplegateR

@humptydumpty and @msbt thank you guy for Huge help and why this wasn't on docs if anyone really interesting to have one for matrix management

ApplegateR

@ApplegateR confirm it is work and thank you and I will just use surfer it better than nothing! much appericate of creator done this

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

Matrix/Riot