507
edits
m (Jtraulle moved page User:Jtraulle/DiscourseMigrationImplementation to User:Jtraulle/Discourse Migration/Implementation) |
No edit summary Tag: 2017 source edit |
||
| (23 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
=== Apache2 config === | |||
Forums are available on entry URL: https://www.dolibarr.org/forum, https://www.dolibarr.fr/forum, https://www.dolibarr.de/forum | |||
but behind, it is discourse. | |||
Enable '''proxy '''and '''proxy_http '''modules. | |||
Add | |||
<syntaxhighlight lang="apache"> | |||
# To allow the rewrite on rss that is not a redirect from browser | |||
SSLProxyEngine on | |||
SSLProxyVerify none | |||
SSLProxyCheckPeerCN off | |||
SSLProxyCheckPeerExpire off | |||
# Redirection pour compatibilite avec ancien forum kunena | |||
* | RewriteRule ^/forum/user/(\d+)-(.*) /forum/u/$2/summary [L,R=permanent] | ||
* | RewriteRule ^/forumold/.*/(\d+)-(.*)$ /forum/t/$2 [L,R=permanent] | ||
* | |||
# Redirection pour transfert apache - discourse | |||
<Location "/forum"> | |||
RequestHeader set "X-Forwarded-Proto" expr=%{REQUEST_SCHEME} | |||
RequestHeader set "X-Forwarded-SSL" expr=%{HTTPS} | |||
ProxyPreserveHost On | |||
ProxyPass "http://127.0.0.1:8800/forum" connectiontimeout=60 timeout=60 | |||
ProxyPassReverse "http://127.0.0.1:8800/forum" | |||
</Location> | |||
</syntaxhighlight> | |||
The apache proxy redirect HTTP including /forum/ in URL to the port the docker nginx server run. | |||
The Logs of the proxy are available into /home/dolibarr/logs/dolibarr_ssl_access_log file and are used by fail2ban rules. | |||
== Firewall == | |||
Les regles du firewall sont définies et activé par le script /home/dolibarr/tools/firewallvmprod1 | |||
TODO Utiliser ufw | |||
=== Backup === | |||
Backup of discourse instance is done into directories /mnt/sdb1/backup/discourses | |||
=== MySQL/MariaDB Databases === | === MySQL/MariaDB Databases === | ||
| Line 53: | Line 56: | ||
Installed following the Docker docs : https://docs.docker.com/install/linux/docker-ce/ubuntu/#install-docker-engine---community-1 | Installed following the Docker docs : https://docs.docker.com/install/linux/docker-ce/ubuntu/#install-docker-engine---community-1 | ||
== Tests for dolibarr.de migration == | |||
* Retrieve test VM backup | |||
* Update packages (apt) | |||
* Upgrade db to postgres12 (data container) | |||
* rebuild web_only container tu upgrade to same discourse version as prod | |||
== Upgrade the web container == | |||
From : https://meta.discourse.org/t/faster-rebuilds/40341/13 | |||
<syntaxhighlight lang="bash"> | |||
cd /var/discourse | |||
sudo git pull | |||
sudo ./launcher bootstrap web_only | |||
sudo ./launcher destroy web_only | |||
sudo ./launcher start web_only | |||
</syntaxhighlight> | |||
== Upgrade the data container == | |||
See | |||
* https://meta.discourse.org/t/postgresql-12-update/151236#data-container-install | |||
* https://meta.discourse.org/t/postgresql-15-update/349515#p-1698209-data-container-install-3 | |||
* https://meta.discourse.org/t/postgresql-18-update-for-self-hosters/406194 | |||
<syntaxhighlight lang="bash"> | |||
cd /var/discourse | |||
sudo ./launcher stop web_only | |||
sudo ./launcher stop data | |||
# twice is not a typo but on purpose | |||
sudo ./launcher rebuild data | |||
sudo ./launcher rebuild data | |||
sudo ./launcher rebuild web_only | |||
</syntaxhighlight> | |||
== Useful resources == | == Useful resources == | ||