OpenProj is an open-source desktop project management application similar to Microsoft Project. OpenProj has a familiar user interface and even opens existing MS Project files. OpenProj is interoperable with Project, Gantt Charts and PERT charts.

(Last Updated On: November 11, 2018) Hello good folks! This short guide will take you through the steps to Install OpenProject Community Edition on Ubuntu 18.04 / 16.04 LTS. OpenProject is a powerful project management and support tool for small to large teams that help you throughout the entire project management lifecycle. Outstanding features of OpenProject • Project planning and scheduling • Product roadmap and release planning • Task management and team collaboration • Agile and Scrum • Time tracking, cost reporting, and budgeting • Bug tracking • Wikis • Forums • Meeting agendas and meeting minutes Step 1: Install transport-https & memcached Kick off the installation by ensuring your apt package list is updated and installing the transport-httpspackage. Sudo apt update sudo apt -y install apt-transport-https memcached Step 2: Enable universe and add OpenProject Repository Import the PGP key used to sign OpenProject packages: wget -qO- sudo apt-key add - Enable universe on your Ubuntu 18.04 and add OpenProject repository by running the commands: sudo add-apt-repository universe sudo wget -O /etc/apt/sources.list.d/openproject-ce.list Step 3: Install MySQL Database server OpenProject requires a database server to function.

It is recommended to use the latest MySQL version (>= 5.7) as it supports special characters such as emojis (emoticons) out of the box. Sudo apt -y install mysql-server libmysqlclient-dev mysql-client Once the database has been installed and service running, create a database and user for OpenProject. Login to the mysql console as root user $ mysql -uroot -p Then create a database and user CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'StrongPassword'; CREATE DATABASE openproject CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; GRANT ALL PRIVILEGES ON openproject.* TO 'openproject'@'localhost'; FLUSH PRIVILEGES; QUIT Step 4: Install the OpenProject Community Edition package After adding the OpenProject repository and configuring a database for OpenProject, install OpenProject Community Edition package on your Ubuntu 18.04 LTS. Sudo apt update sudo apt -y install openproject Step 5: Configure OpenProject on Ubuntu 18.04 / 16.04 LTS The OpenProject installation wizard supports the automatic setup for MySQL databases. The OpenProject package is configured through ENV parameters that are passed to the openproject user. Read current ENV parameters by running: $ openproject run env To write/read individual parameters, use openproject config:set PARAMETER=VALUE and openproject config:get PARAMETER.

Run the package configuration wizard with the following command: openproject configure 1. On database setup wizard, select “ Use an existing database” and click 2. Use MySQL IP 127.0.0.1 3. Use MySQL port 3306 4. Provide database username for OpenProject 5. Provide the password used by the openprojectuser to connect to the MySQL server: 6. Provide database name 7. Provide server FQDN 8. Set whether to enable SSL for MySQL database connection 9. Agree to install and configure Apache web server 10. Set Apache application domain name 11.Optionally set Server Path prefix to load OpenProject from, e.g /openproject 12. Set to enable SSL for Apache Web server URL Configure other settings or skip them for later configuration and install Memcache when prompted. On a successful installation, systemd symbolic links for services will be set for autostart.

Created symlink /etc/systemd/system/multi-user.target.wants/openproject.service -> /etc/systemd/system/openproject.service. Created symlink /etc/systemd/system/openproject.service.wants/openproject-web.service -> /etc/systemd/system/openproject-web.service. Created symlink /etc/systemd/system/openproject-web.service.wants/openproject-web-1.service -> /etc/systemd/system/openproject-web-1.service. Created symlink /etc/systemd/system/openproject.service.wants/openproject-worker.service -> /etc/systemd/system/openproject-worker.service. Created symlink /etc/systemd/system/openproject-worker.service.wants/openproject-worker-1.service -> /etc/systemd/system/openproject-worker-1.service. Install pythonmagick windows 7. Apache configuration file will be created automatically for you.