Poddery - Diaspora, Matrix and XMPP: Difference between revisions
Update with MySQL specific instructions |
|||
| Line 101: | Line 101: | ||
# Follow steps 1 to 6 from https://wiki.debian.org/Diaspora/XMPP | # Follow steps 1 to 6 from https://wiki.debian.org/Diaspora/XMPP | ||
sudo mysql -u root -p # Enter password from the access repo | sudo mysql -u root -p # Enter password from the access repo | ||
CREATE USER 'prosody'@'localhost' IDENTIFIED BY '<passwd_in_repo>'; | CREATE USER 'prosody'@'localhost' IDENTIFIED BY '<passwd_in_repo>'; | ||
GRANT ALL PRIVILEGES ON diaspora_production.* TO 'prosody'@'localhost'; | GRANT ALL PRIVILEGES ON diaspora_production.* TO 'prosody'@'localhost'; | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
sudo chown -R root:ssl-cert /etc/letsencrypt | sudo chown -R root:ssl-cert /etc/letsencrypt | ||
sudo chmod g+r -R /etc/letsencrypt | sudo chmod g+r -R /etc/letsencrypt | ||
sudo chmod g+x /etc/letsencrypt/{archive,live} | sudo chmod g+x /etc/letsencrypt/{archive,live} | ||
sudo systemctl restart prosody | sudo systemctl restart prosody | ||
* We have enabled all XEPs conversations expect. We use sslh to multiplex Diaspora and Prosody on port 443. | * We have enabled all XEPs conversations expect. We use sslh to multiplex Diaspora and Prosody on port 443. | ||