Installing Trendz Analytics on CentOS/RHEL

This guide explains how to install Trendz Analytics on RHEL/CentOS 7, 8, or 9.

Hardware: Minimum 4 GB of RAM and 2 CPU cores. In small and medium deployments, Trendz can be installed on the same server as ThingsBoard.

Software:

• ThingsBoard 4.3.0 or newer. For older versions see Connecting to ThingsBoard 4.2 and Older.
• Active Trendz Analytics add-on. See the Self-Managed Activation guide.

• Docker CE and Docker Compose (required for the Python Executor)

CentOS 7 only — install wget, nano, and the EPEL repository before proceeding:

sudo yum install -y nano wget
sudo yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

sudo dnf install java-17-openjdk-headless

sudo yum install java-17-openjdk-headless

Set Java 17 as the default version:

sudo update-alternatives --config java

Verify the installation:

java -version

Expected output:

openjdk version "17.x.xx"
OpenJDK Runtime Environment (...)
OpenJDK 64-Bit Server VM (build ...)

Download the installation package:

wget https://dist.thingsboard.io/trendz-1.15.1.rpm

Install Trendz Analytics as a service:

sudo rpm -Uvh trendz-1.15.1.rpm

Trendz uses PostgreSQL. You can install it on the same server or use a managed PostgreSQL service.

Install PostgreSQL 16:

sudo dnf update
sudo dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf -y install postgresql16 postgresql16-server postgresql16-contrib

sudo dnf update
sudo dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf -y install postgresql16 postgresql16-server postgresql16-contrib

sudo yum update
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum -y install postgresql16 postgresql16-server postgresql16-contrib

sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl start postgresql-16
sudo systemctl enable --now postgresql-16

Set a password for the postgres user:

sudo -u postgres psql -c "\password"

Enter and confirm the password when prompted.

Configure MD5 authentication:

Edit pg_hba.conf:

sudo nano /var/lib/pgsql/16/data/pg_hba.conf

Locate the IPv4 local connections line and replace ident with md5:

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

Restart PostgreSQL to apply the change:

sudo systemctl restart postgresql-16.service

Create the Trendz database:

psql -U postgres -d postgres -h 127.0.0.1 -W

CREATE DATABASE trendz;

Press Ctrl+D to exit.

Configure the database connection:

sudo nano /etc/trendz/conf/trendz.conf

Add the following lines. Replace PUT_YOUR_POSTGRESQL_PASSWORD_HERE with your actual password:

# DB Configuration
export SPRING_DATASOURCE_URL=jdbc:postgresql://localhost:5432/trendz
export SPRING_DATASOURCE_USERNAME=postgres
export SPRING_DATASOURCE_PASSWORD=PUT_YOUR_POSTGRESQL_PASSWORD_HERE

sudo /usr/share/trendz/bin/install/install.sh

sudo service trendz start

Log in to ThingsBoard as a Sysadmin and open the Trendz Settings page.

If you see “Synchronization completed successfully”, no further action is needed.

Log in to ThingsBoard as a Sysadmin. Open the Trendz Settings page. If you see "Synchronization completed successfully", no further action is required.

If you see an error message:

1. Make sure Trendz is running.
2. Enter the correct Trendz internal URL (must be reachable from ThingsBoard).
3. Enter the correct ThingsBoard internal URL (must be reachable from Trendz).
4. Click Save configuration.
5. Click Retry discovery.

If you see an error message, follow these steps. Enter the correct Trendz internal URL and ThingsBoard internal URL. Click Save configuration. Click Retry discovery. Once "Synchronization completed successfully" appears, the synchronization is complete.

To use Python Calculation Fields and Prediction Models, install the Trendz Python Executor.

See the Python Executor Setup guide for instructions.

Access Trendz UI at http://localhost:8888.

Trendz uses ThingsBoard as its authentication provider — log in with your Tenant Administrator credentials from ThingsBoard.

After the first login, discover the topology so Trendz can learn about your assets, devices, profiles, and relations:

Click the Discover Topology button to start the topology discovery process. Click the Finish button to close the topology discovery page and unlock the main Trendz functionality.

See Business Entities for more on how Trendz uses this topology.

You can configure HTTPS access using HAProxy when Trendz is hosted in the cloud with a valid DNS name.

If HAProxy and Let’s Encrypt are already set up for ThingsBoard, open the HAProxy configuration file:

sudo nano /etc/haproxy/haproxy.cfg

In the frontend https_in section, add an ACL rule and backend reference:

acl trendz_http hdr(host) -i new-trendz-domain.com
use_backend tb-trendz if trendz_http

Register the Trendz backend:

backend tb-trendz
  balance leastconn
  option tcp-check
  option log-health-checks
  server tbTrendz1 127.0.0.1:8888 check inter 5s
  http-request set-header X-Forwarded-Port %[dst_port]

Generate an SSL certificate:

sudo certbot-certonly --domain new-trendz-domain.com --email [email protected]

Reload HAProxy:

sudo haproxy-refresh

Trendz is now available at https://new-trendz-domain.com.

See the HAProxy on Ubuntu guide to install HAProxy and generate an SSL certificate using Let’s Encrypt.

ThingsBoard and Trendz can share a single domain — ThingsBoard at https://{my-domain}/ and Trendz at https://{my-domain}/trendz/.

In the frontend https_in section, add:

acl trendz_acl path_beg /trendz/ path_beg /apiTrendz/
use_backend tb-trendz if trendz_acl

See the Upgrade Instructions for detailed steps.

Trendz logs are stored in /var/log/trendz. Check for errors with:

cat /var/log/trendz/trendz.log | grep ERROR