{"id":324,"date":"2019-06-04T11:55:27","date_gmt":"2019-06-04T06:25:27","guid":{"rendered":"http:\/\/www.bhuvankrishna.in\/blog\/?p=324"},"modified":"2019-06-04T11:55:27","modified_gmt":"2019-06-04T06:25:27","slug":"reset-password-in-matrix-synapse","status":"publish","type":"post","link":"https:\/\/www.bhuvankrishna.in\/blog\/2019\/06\/04\/reset-password-in-matrix-synapse\/","title":{"rendered":"Reset password in matrix synapse"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To reset the password of matrix user in debian<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After login as root. Change the user to postgres<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#su postgres<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">At the postgres prompt connect to synapse database and update users table with new hash. generate the hash with hash_password command<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$hash_password\nPassword: &lt;hidden>\nConfirm password: &lt;hidden>\n$2b$12$eGgHG99FQ1O9Q8jSnwOJ2e88tND7nznMctJcASV.Is655Hnr7ZFtG &lt;example output>\n$psql\npostgres=# \\c synapsedb;\nsynapsedb=# select name from users where name = '@&lt;username>:&lt;domain>';\n[This will show if the user exists]\nsynapsedb=# UPDATE users SET password_hash = '$2b$12$eGgHG99FQ1O9Q8jSnwOJ2e88tND7nznMctJcASV.Is655Hnr7ZFtG WHERE name='@&lt;username>:&lt;domain>';'<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>To reset the password of matrix user in debian After login as root. Change the user to postgres At the postgres prompt connect to synapse database and update users table with new hash. generate the hash with hash_password command<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-324","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/posts\/324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/comments?post=324"}],"version-history":[{"count":1,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"predecessor-version":[{"id":325,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/posts\/324\/revisions\/325"}],"wp:attachment":[{"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bhuvankrishna.in\/blog\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}