Confluence

How to install Jira Confluence on Ubuntu 20.04 With PostgreSQL

Confluence is a team workspace where knowledge and collaboration meet. Dynamic pages give your team a place to create, capture, and collaborate on any project or idea. [Compared to Jira, Jira is a project management platform used by over 65,000 companies that can help with everything from software development to managing your wine collection, and Confluence is a wiki-based content management tool that makes organizing written information easy.]

Install Confluence in your local Environment -

Step 1- Setup PostgreSQL

Confluence needs a database to store user information and other data. It supports MySQL, Postgresql, Oracle and SQL Server. My choice is Postgresql, as it saves you the trouble of finding the JDBC driver you’ll need if you use MySQL, and money you’ll have to pay if you choose Oracle/SQL Server.

$ sudo apt install postgresql

After PostgreSQL installation, Check service status.

$ sudo systemctl status postgresql

postgreSQL service up and running

Step 2- Create user and database for Confluence

Start Postgresql

$ sudo -u postgres psql postgres=# create user confluenceuser with encrypted password 'test@123'; postgres=# create database confluence; postgres=# grant ALL ON DATABASE confluence to confluenceuser; postgres=# \q

Step 3 - Allow postgres user access Modify postgres config file to allow access for postgres user. $ sudo vi /etc/postgresql/12/main/pg_hba.conf

Modify the following line. your config file should be like below.

Save and Exit from the file. To restart postgresql service- $ sudo systemctl restart postgresql

Step 4- Download & install Confluence using the installer Download the latest Confluence installer. https://downloads.atlassian.com/software/confluence/downloads/atlassian-confluence-7.12.3-x64.bin

Once the download is complete, we can start the installation. Make the installer executable. $ sudo chmod a+x atlassian-confluence-7.12.3-x64.bin Run Installer file to start JIRA installation. $ sudo ./atlassian-confluence-7.12.3-x64.bin press enter key when prompt

At next screen choose- Custom Install (recommended for advanced users) [2, Enter] Choose JIRA installation directory - Enter to choose default path - [/opt/atlassian/confluence] Press Enter (Default location for Confluence data) Type 1 and press enter key to choose default port (HTTP: 8090, Control: 8000) Type y and hit enter (To Install Confluence as Service) Press y and hit enter (Start Confluence now?)

Confluence installation done successfully. Let's access Confluence instance - http://localhost:8090

Step 5 - Setup initial setting after installation - If you are installing on a remote server, replace localhost with server ip. Select “Production Installation”, click “Next”.

Enter your license if you have one, if not click “Get an evaluation license” to get a 30 day trial license.

Choose your deployment type

Setup Database & click Next

On this page, if you have a backup, you can restore. If you need a fresh install for production use, select “Empty Site”. Also you can follow up with recommended “Example Site”.

You will be asked how to manage users, select confluence manage users, you can change it later at any time.

Next you will be asked to create an admin user.

Now you can start Confluence.