Upgrading the Bold Reports Linux package to the Latest Version

This section explains how to upgrade the Bold Reports Linux package from any version to the latest version.

1. Register and download the latest Bold Reports Linux package from the getting started guide.

2. Install the python 3.9 or later by executing the following command:

   Ubuntu Version:22.04 :

      sudo apt-get install -y python3

   Ubuntu Version:20.04 :

      sudo apt update && sudo apt install wget software-properties-common && sudo add-apt-repository ppa:deadsnakes/ppa && sudo apt update && sudo apt install python3.9

3. Install pip dependency packages for ETL service by running the following command:

   sudo apt-get install python3-pip && sudo python3 -m pip install --upgrade pip && sudo pip install duckdb===1.1.2 dlt===0.4.12 pymysql pyodbc pg8000 poetry pandas===2.2.2 numpy===1.26.4 "dlt[parquet]" "dlt[filesystem]"

4. Download the latest Bold Reports Linux package by running the following command.

      sudo wget {Bold Reports Linux package link}

5. Extract the zip file.

      sudo unzip {Bold Reports Linux package zip file}

6. Change the directory to BoldReports_EnterpriseReporting-Linux by running the following command:

      cd BoldReports_EnterpriseReporting-Linux

7. Execute the following command to deploy Bold Reports on your Linux machine:

      sudo bash install-boldreports.sh -i {upgrade} -u {user} -h {host URL}

   • i: Installation type : Specifies whether it is a new or upgraded installation.

   • u: Specify the user or group that manages the service.

   • h: Domain or IP address of the machine with the HTTP protocol.

Example for upgrading the installation:

sudo bash install-boldreports.sh -i upgrade -u www-data -h http://linux.example.com

• Refer to the optional client libraries installation guide and install the optional client libraries after the installation is completed.

• Now, you can open the host URL in the browser and use the latest features of Bold Reports.

NOTE: The Bold Reports Linux package backup file will be available in the following location: /var/www/

Upgrade breaking changes v3.x to latest

The below breaking changes are applicable only for upgrading the Bold Reports application from version v3.x to latest version.

Automatic Nginx configuration:

• If you preferred automatic Nginx configuration during the initial installation, the below prompt message will be displayed, and you can proceed with the installation by choosing Yes.

• If you are choosing No, then please follow the below manual Nginx configuration step.

Manual Nginx configuration:

• If you have manually configured Nginx during the initial installation, the below message will be displayed.

• For manual Nginx configuration, modify the default Nginx configuration file in location/etc/nginx/sites-available. Open it in a text editor and add the following code, like the below image.

     location /reporting/viewer {
        proxy_pass         http://localhost:6554/reporting/viewer;
        proxy_http_version 1.1;
        proxy_set_header   Upgrade $http_upgrade;
        proxy_set_header   Connection keep-alive;
        proxy_set_header   Host $host;
        proxy_cache_bypass $http_upgrade;
        proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header   X-Forwarded-Proto $scheme;
     }
  
     location /etlservice/ {
       root               /var/www/bold-services/application/etl/etlservice/wwwroot;
       proxy_pass         http://localhost:6509/;
       proxy_http_version 1.1;
       proxy_set_header   Upgrade $http_upgrade;
       proxy_set_header   Connection "upgrade";
       proxy_set_header   Host $http_host;
       proxy_cache_bypass $http_upgrade;
       proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_set_header   X-Forwarded-Proto $scheme;
     }
     location /etlservice/_framework/blazor.server.js {
       root               /var/www/bold-services/application/etl/etlservice/wwwroot;
       proxy_pass         http://localhost:6509/_framework/blazor.server.js;
       proxy_http_version 1.1;
       proxy_set_header   Upgrade $http_upgrade;
       proxy_set_header   Connection "upgrade";
       proxy_set_header   Host $http_host;
       proxy_cache_bypass $http_upgrade;
       proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_set_header   X-Forwarded-Proto $scheme;
     }

Nginx configuration file code:

Once the Nginx configuration is updated, run sudo nginx -t to verify the syntax of the configuration files. If the configuration file test is successful, force Nginx to pick up the changes by running the sudo nginx -s reload.

Upgrade breaking changes v5.x to latest

The below breaking changes are applicable only for upgrading the Bold Reports application from version v5.x to the latest version.

Automatic Nginx configuration:

• If you preferred automatic Nginx configuration during the initial installation, the below prompt message will be displayed, and you can proceed with the installation by choosing Yes.

• If you choose No, please follow the manual Nginx configuration steps below.

Manual Nginx configuration:

• If you have manually configured Nginx during the initial installation, the following message will be displayed.

• For manual Nginx configuration, modify the default Nginx configuration file located at /etc/nginx/sites-available. Open it in a text editor and add the following code, as shown in the image below:

        location /etlservice/ {
        root               /var/www/bold-services/application/etl/etlservice/wwwroot;
        proxy_pass         http://localhost:6509/;
        proxy_http_version 1.1;
        proxy_set_header   Upgrade $http_upgrade;
        proxy_set_header   Connection "upgrade";
        proxy_set_header   Host $http_host;
        proxy_cache_bypass $http_upgrade;
        proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header   X-Forwarded-Proto $scheme;
        }
        location /etlservice/_framework/blazor.server.js {
        root               /var/www/bold-services/application/etl/etlservice/wwwroot;
        proxy_pass         http://localhost:6509/_framework/blazor.server.js;
        proxy_http_version 1.1;
        proxy_set_header   Upgrade $http_upgrade;
        proxy_set_header   Connection "upgrade";
        proxy_set_header   Host $http_host;
        proxy_cache_bypass $http_upgrade;
        proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header   X-Forwarded-Proto $scheme;
        }

Nginx configuration file code:

Once the Nginx configuration is updated, run sudo nginx -t to verify the syntax of the configuration files. If the configuration file test is successful, force Nginx to pick up the changes by running sudo nginx -s reload.