How to deploy Bold BI using Apache server on Oracle Linux

Published:

This article explains how to deploy the Bold BI application using Apache server on Oracle Linux, along with its prerequisites and the steps for installing the deployment prerequisites.

Hardware and Software Prerequisites

Hardware requirements

The following hardware requirements are necessary to run the Bold BI Enterprise edition:

Operating System: Oracle Linux 9.2
CPU: 4-core.
memory: 16 GB RAM.
Disk Space: 10 GB or more.

Software requirements

The following software requirements are necessary to run the Bold BI Enterprise edition:

Database: Microsoft SQL Server 2012+ | PostgreSQL | MySQL
Web Server: Nginx or Apache
Web Browser: Microsoft Edge, Mozilla Firefox, and Chrome.

Deployment Prerequisites

Install Apache.
Install zip.
```
 sudo dnf install zip
```
Install wget.
```
 sudo dnf install wget
```

Install the GDIPlus package using the following command.

sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm
sudo yum install epel-release
sudo yum install libgdiplus

Install python pip and following pip packages by running the below command.

 sudo yum -y install python3-pip && python3.9 -m pip install duckdb===0.9.2 dlt===0.4.2 pymysql pyodbc pg8000 poetry pandas===2.0.0 "dlt[parquet]" "dlt[filesystem]"

Note: Python 3.9 must be installed on that machine.

Install the pv tool by running the following command.
```
sudo dnf install pv
```
Add an openssl conf path in the environment if it does not exist.
```
export OPENSSL_CONF=/etc/ssl/
```

Deploying Bold BI Application

Register and copy the Bold BI Linux package link from here.
Download the Bold BI Linux package by running the following command.
```
sudo wget {Bold BI Linux package link}
```

Extract the zip file.

sudo unzip {Bold BI Linux package zip file}

Change the working directory to BoldBIEnterpriseEdition-Linux by running the following command.
```
cd BoldBIEnterpriseEdition-Linux
```
Execute the following command to deploy Bold BI on your Linux machine.

Command Syntax:
```
sudo bash install-boldbi.sh -i {new} -u {user} -h {host URL} -s apache 
```
Example command:
```
sudo bash install-boldbi.sh -i new -u root -h http://linux.example.com -s apache
```
Note:
* i: Installation type: Specifies whether it is a new or upgrade installation.
* u: Specifies the user or group that manages the service. Please ensure that this user exists on your Linux server.
* h: Domain or IP address of the machine with HTTP protocol.
* s: Setting this to Apache will automatically configure the Bold BI with the Apache front-end server.

Additional References

Was this article useful?

Dislike

Written by Sivanesan Saravanan

Updated

Comments (0)