meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
linux:sw:openproject:package_to_docker [2026/06/29 16:40] – niziaklinux:sw:openproject:package_to_docker [2026/06/30 11:46] (current) – niziak
Line 2: Line 2:
  
 Migrate packaged installation to docker compose. Migrate packaged installation to docker compose.
 +
 +WHY: 
 +  * it will be only official supported method in future (until current distros reaches EOL)
 +  * it can be scaled easily (i.e. docker swarm)
 +  * easier migration to another machine
  
 References: References:
Line 8: Line 13:
   * [[https://www.openproject.org/docs/installation-and-operations/operation/restoring/#changing-the-database-schema-from-cloud-to-on-premises|Restoring an OpenProject backup]]   * [[https://www.openproject.org/docs/installation-and-operations/operation/restoring/#changing-the-database-schema-from-cloud-to-on-premises|Restoring an OpenProject backup]]
   * [[https://www.openproject.org/docs/installation-and-operations/installation/docker/#openproject-on-docker-all-in-one-container|OpenProject on Docker all-in-one container]]   * [[https://www.openproject.org/docs/installation-and-operations/installation/docker/#openproject-on-docker-all-in-one-container|OpenProject on Docker all-in-one container]]
 +  * [[https://medium.com/@jaydeepawar4912/deploying-openproject-on-kubernetes-a-step-by-step-guide-with-aws-ses-email-integration-d2b625750102|Deploying OpenProject on Kubernetes: A Step-by-Step Guide with AWS SES Email Integration]]
 +  * [[https://gitlab.opencode.de/bmi/opendesk/deployment/opendesk/-/blob/00fafb6a1bc9efb91d5fa3f7a0815ce61701a3d8/helmfile/apps/openproject/values.yaml]]
 + 
  
 ===== setup docker compose ===== ===== setup docker compose =====
Line 15: Line 23:
 ===== database migration ===== ===== database migration =====
  
-Packaged installation creates binary ''.pgdumps'' which cannot be restored directly on target container due to owner mismatch.+Packaged installation creates binary ''.pgdump'' which cannot be restored directly on target container due to owner mismatch.
  
 Packaged installation: Packaged installation:
Line 45: Line 53:
 </code> </code>
  
 +Restore ''.sql'' dump:
 +
 +<code bash>
 +zstd -d -c openproject.sql.zst | docker compose exec -T  -u postgres db psql -d openproject
 +</code>
 +
 +Convert schema openproject to public
 +<code bash>
 +docker compose exec -it -u postgres db psql -d openproject -c "DROP SCHEM A public CASCADE;"
 +docker compose exec -it -u postgres db psql -d openproject -c "ALTER SCHEMA openproject RENAME TO public;"
 +</code>
 +
 +Verify that there are tables and OP users:
 +<code bash>
 +docker compose exec -it -u postgres db psql -d openproject -c "\dt"
 +docker compose exec -it -u postgres db psql -d openproject -c "SELECT count(*) FROM users;"
 +</code>
 +
 +Startup everything:
 +<code bash>
 +docker compose up -d
 +</code>
 +
 +====== Restore attachments ======
 +
 +<code bash>
 +tar -C /var/openproject/assets/files/ -xf attachments-latest.tar.gz
 +chown -R 1000:1000 /var/openproject/assets
 +</code>
 +
 +====== Inbound emails ======
 +
 +[[https://www.openproject.org/docs/installation-and-operations/configuration/incoming-emails/|Configuring inbound emails]]
 +
 +====== Outbound mails ======
 +
 +References:
 +  * [[https://www.openproject.org/docs/installation-and-operations/configuration/outbound-emails/]]
 +
 +References to do:
 +  * [[https://dev.to/eddited17/how-to-fix-openproject-email-with-microsoft-365-the-easy-way-aa8|How to Fix OpenProject Email with Microsoft 365 (The Easy Way)]]
 +  * [[https://medium.com/@jaydeepawar4912/deploying-openproject-on-kubernetes-a-step-by-step-guide-with-aws-ses-email-integration-d2b625750102]]
 +
 +
 +Verify what final docker compose envs looks like with command:
 +<code bash>
 +docker compose config
 +</code>
  
 +There are issues with passing SMTP related env to OP:
  
 +  * [[https://github.com/opf/openproject-docker-compose/issues/155|Docker Compose SMTP configuration behavior does not match documentation #155]]
 +  * 
  
 +Using postfix relay on local host.