Home

Synapse wiki

For now, this is just a quick dumping ground of useful Synapse snippets which otherwise are going to get lost across scrollback, gists, scripts etc.

Note: Keep in mind to shut down (or restart) Synapse whenever these commands are executed. Synapse caches a lot of information. Do the same for clients.

Useful SQL queries

What servers are my server talking to?

SELECT * FROM destinations;

What servers are currently participating in this room?

SELECT DISTINCT split_part(state_key, ':', 2)
    FROM current_state_events AS c
    INNER JOIN room_memberships AS m USING (room_id, event_id)
    WHERE room_id = '!cURbafjkfsMDVwdRDQ:matrix.org' AND membership = 'join';

Manually resetting passwords:

scripts/hash_password
UPDATE users SET password_hash='$2a$12$CC5r6fEe......' where name='@user:domain.com';