Install Data Flow Service

Instructions

Starting with PortSIP PBX v22.3, PortSIP introduces a new component: the PortSIP Data Flow Service—a high-performance analytics engine built on ClickHouse.

The Data Flow service powers the following advanced capabilities:

• Call Detail Record (CDR) storage and analytics

• Comprehensive call reports

• Real-time data dashboards

• Queue wallboards for contact center operations

ClickHouse is optimized for large-scale analytical workloads, capable of handling billions of CDRs and real-time queue or agent activity data with extremely fast query performance. This makes it ideal for service providers and enterprise-grade deployments.

---

Deployment Guidelines

Because ClickHouse is resource-intensive and optimized for analytics workloads, the PortSIP Data Flow service must be installed on a separate server.

Deploying the Data Flow service on the same server as the PBX core may degrade overall system performance due to high CPU, memory, and disk I/O usage during data ingestion and analytics processing.

❗ Important Do not install the Data Flow service on the same server as the PortSIP PBX. Running both services on a single server may negatively impact call processing performance and overall system stability.

---

Hardware Requirements

The PortSIP Data Flow service can be deployed on either a physical server or a virtual machine.

For best performance, ensure your hardware meets or exceeds the specifications below. For additional reference, see the ClickHouse official best practices documentation.

Minimum Requirements

• vCPU: 4 cores

• Memory: 16 GB

• Disk: 128 GB SSD

---

Recommended Requirements

• vCPU: 8 cores

• Memory: 32 GB

• Disk: 256GB or larger (NVMe SSD preferred)

---

Hardware Sizing Formula (Large-Scale Deployments)

For large or high-volume environments, use the following guideline:

• vCPU: ≥ 8

• Memory: vCPU × 4 GB

• Disk: Based on expected CDR volume and data retention policy

---

Supported Operating Systems

The PortSIP Data Flow service supports 64-bit Linux only.

The following operating systems are officially supported:

• Ubuntu: 22.04, 24.04

• Debian: 12

---

Network Requirements

Static IP Address

You must configure a static private IP address for the Data Flow server.

• Example private IP: 192.168.1.35

If a static private IP is not available, the server must have a static public IP address and be able to communicate reliably with the PBX server.

---

Step 1: Generate the Data Flow Token

1. Log in to the PortSIP PBX Web Portal as a System Administrator.

2. Navigate to Servers > Data Flow.

3. Select the default Data Flow server.

4. Click Generate Token.

5. Copy and securely store the generated token.

---

Step 2: Configure the Firewall on the PBX Server

To allow the Data Flow server (192.168.1.35) to communicate with the PBX server (192.168.1.20), configure firewall rules on the PBX server.

Execute the following commands on the PBX server:

sudo firewall-cmd --permanent --zone=trusted --add-source=192.168.1.35
sudo firewall-cmd --reload

Verify the firewall rule by execute the command below:

sudo firewall-cmd --zone=trusted --list-all

Expected output:

[ubuntu@localhost ~]$ sudo firewall-cmd --zone=trusted --list-all
trusted (active)
  target: ACCEPT
  icmp-block-inversion: no
  interfaces: 
  sources: 192.168.1.35
  services: 
  ports: 
  protocols: 
  forward: yes
  masquerade: no
  forward-ports: 
  source-ports: 
  icmp-blocks: 
  rich rules:

(Optional) Allow the Entire LAN

If required, you may allow the entire LAN subnet:

sudo firewall-cmd --permanent --zone=trusted \
--add-source=192.168.1.0/24 && \
sudo firewall-cmd --reload

---

Step 3: Create and Run the Data Flow Docker Instance

All commands must be executed in the /opt/portsip directory on the Data Flow server.

Initialize the Environment

sudo mkdir -p /opt/portsip
cd /opt/portsip
sudo curl https://raw.githubusercontent.com/portsip/portsip-pbx-sh/master/v22.3/init.sh -o init.sh
sudo /bin/sh init.sh

---

Install Docker and Docker Compose

sudo /bin/sh install_docker.sh

If prompted with:

cloud.cfg (Y/I/N/O/D/Z) [default=N] ?

Enter Y and press Enter.

---

Create the Data Flow Service Docker Instance

Command parameters:

• -p : Path for storing Data Flow and ClickHouse data (required)

• -d : ClickHouse Docker image (portsip/clickhouse:25.8)

• -a : Private IP address of the Data Flow server

• -A : Public IP address (use if private IP is not available)

• -i : PortSIP PBX Docker image version (required)

• -x : PBX server IP address

  • If PBX is deployed in HA mode, use the Virtual IP (VIP)

Example command:

sudo /bin/sh dataflow_ctl.sh run \
-p /var/lib/portsip/ \
-a 192.168.1.35 \
-i portsip/pbx:22 \
-x 192.168.1.20 \
-d portsip/clickhouse:25.8

---

Notes and Operational Considerations

• If the PBX IP address changes, you must delete and recreate the existing Data Flow Docker instance.

• If a new authentication token is generated, the Data Flow Docker instance must be deleted and recreated.

• After upgrading the PBX to a new version, you must remove and recreate the Data Flow Docker instance to ensure compatibility.

The above operations do not affect or erase existing analytics data stored in ClickHouse.

---

Installation Complete

The Data Flow Service has now been successfully installed.

You can now proceed to Step 7: Reboot to Apply the Certificate in the Install PortSIP PBX guide.