Install OpenProject Project Management Platform on Ubuntu 16.04 | 18.04 | 18.10
OpenProject is a powerful web-based project management platform that allows users to collaborate on projects using features such as WYSIWYG text editor, intelligent workflows, conditional formatting, a new design, and much more…
If you’re looking for a project management suite that manages an entire project life cycle, from initiation to closure, you may want to look at OpenProject…
It is designed for ease of use to allow enterprises and business owners to collaborate and automate engaging experiences with users across multiple devices, including mobileā¦
This brief tutorial is going to show students and new users how to install OpenProject on Ubuntu 16.04 | 18.04 | 18.10To get started with installing OpenProject, follow the steps below:
Step 1: Install Apache2 HTTP Server
OpenProject requires a web server and Apache2 HTTP server is the most popular open source web server available today… To install Apache2 server, run the commands below:
sudo apt update sudo apt install apache2
After installing Apache2, the commands below can be used to stop, start and enable Apache2 service to always start up with the server boots…
sudo systemctl stop apache2.service sudo systemctl start apache2.service sudo systemctl enable apache2.service
Now that Apache2 is installed…. to test whether the web server is working, open your browser and browse to the URL below…

If you see the page above, then Apache2 is successfully installed…
Step 2: Install MySQL Database Server
OpenProject also requires a database server to store its content… If you’re looking for a truly open source database server, then MySQL is a great place to start… To install MySQL run the commands below:
sudo apt install mysql-server mysql-client libmysqlclient-dev
After installing MariaDB, the commands below can be used to stop, start and enable MariaDB service to always start up when the server boots…
sudo systemctl stop mysql.service sudo systemctl start mysql.service sudo systemctl enable mysql.service
Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation…
sudo mysql_secure_installation
When prompted, answer the questions below by following the guide.
- Enter current password for root (enter for none): Just press the Enter
- Set root password? [Y/n]: Y
- New password: Enter password
- Re-enter new password: Repeat password
- Remove anonymous users? [Y/n]: Y
- Disallow root login remotely? [Y/n]: Y
- Remove test database and access to it? [Y/n]: Y
- Reload privilege tables now? [Y/n]: Y
Now that MariaDB is installed, to test whether the database server was successfully installed, run the commands below…
sudo mysql -u root -p
type the root password when prompted…

If you see a similar screen as shown above, then the server was successfully installed…
Step 3: Create OpenProject Database
Now that you’ve installed all the packages that are required for OpenProject to function, continue below to start configuring the servers. First run the commands below to create a blank OpenProject database.
To logon to MariaDB database server, run the commands below.
sudo mysql -u root -p
Then create a database called openproject
CREATE DATABASE openproject CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Create a database user called openprojectuser with a new password
CREATE USER 'openprojectuser'@'localhost' IDENTIFIED BY 'new_password_here';
Then grant the user full access to the database.
GRANT ALL ON openproject.* TO 'openprojectuser'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;
Finally, save your changes and exit.
FLUSH PRIVILEGES; EXIT;
After that, continue below to install OpenProject…
Step 4: Install OpenProject
After installing MariaDB database server and after creating OpenProject database, run the commands below to add OpenProject repository and key…
sudo apt update sudo apt install apt-transport-https
Add the key and repository by running the commands below
wget -qO- https://dl.packager.io/srv/opf/openproject-ce/key | sudo apt-key add - sudo wget -O /etc/apt/sources.list.d/openproject-ce.list https://dl.packager.io/srv/opf/openproject-ce/stable/8/installer/ubuntu/18.04.repo
After that, run the commands below to install OpenProject.
sudo apt update sudo apt install openproject memcached
When the installation is complete, you should see similar message below to configure the platform..
The openproject package provides an installer. Please run the following command to finish the installation:
sudo openproject configure
Run the commands below to begin configuring OpenProject…
sudo openproject configure
Follow the steps below to complete the setup.. First when prompted, choose to use existing database…

Then type localhost for the database server and continue…

Next, accept the default port 3306 and continue

Next, type in the database username you created above and continue…

Type database user password

Then the database name

After that, select to install and continue apache2 server.. this will configure the existing apache2 server to function…

Next, type your domain name to use to connect to the server…

And the folder after your domain…

Follow the steps, install Memcached and avoid SSL connections… until you’re done with the setup… After a brief moment, your server should be installed and ready to use…
After installing, open your browser and browse to the server hostname or IP address followed by /openproject/login
You should be prompted to sign in… use the username and password below:
Username: admin
Password: admin

Enjoy!

If you ever want to reconfigure these server, run the commands below:
sudo openproject reconfigure
You may also like the post below:
I have instaled the nextcloud using: “https://websiteforstudents.com/setup-nextcloud-on-ubuntu-18-04-lts-beta-with-apache2-mariadb-and-php-7-1-support/” and it works fine. But when i try to install the OpenProject using this tuturial he can’t connect to DB openproject that i create for him and the nextcloud stop to work.
When i instal the openproject i start in the step: “Step 3: Create OpenProject Database” because i already have the Apache and the Mysql.
Everyting work’s fine durin the “Step 4: Install OpenProject” but when i execute “sudo openproject configure” he can’t connect to db and the nextcloud stop working. Because is a virtual machine i can roll back.
Can you help me?