iptables and OSI PI Integration

Input and output integration overview

The iptables plugin for Telegraf collects metrics on packet and byte counts for specified iptables rules, providing insights into firewall activity and performance.

This setup converts Telegraf into a lightweight PI Web API publisher, letting you push any Telegraf metric into the OSI PI System with a simple HTTP POST.

Integration details

iptables

The iptables plugin gathers packets and bytes counters for rules within a set of table and chain from the Linux iptables firewall. The plugin monitors rules identified by associated comments, as rules without comments are ignored. This approach ensures a unique identification for the monitored rules, which is particularly important since the rule number can change dynamically as rules are modified. To use this plugin effectively, users must name their rules with unique comments. The plugin also requires elevated permissions (CAP_NET_ADMIN and CAP_NET_RAW) to run, which can be configured either by running Telegraf as root (discouraged), using systemd capabilities, or by configuring sudo appropriately. Additionally, defining multiple instances of the plugin might lead to conflicts; thus, using locking mechanisms in the configuration is recommended to avoid errors during concurrent accesses.

OSI PI

OSI PI is an data management and analytics platform used in energy, manufacturing, and critical infrastructure. The PI Web API is its REST interface, exposing endpoints such as /piwebapi/streams/{WebId}/value that accept JSON payloads containing a Timestamp and Value. By pairing Telegraf’s flexible HTTP output with this endpoint, any metric Telegraf collects—SNMP counters, Modbus readings, Kubernetes stats—can be written directly into PI without installing proprietary interfaces. The configuration above authenticates with Basic or Kerberos, serializes each batch to JSON, and renders a minimal body template that aligns with PI Web API’s single-value write contract. Because Telegraf already supports batching, TLS, proxies, and custom headers, this approach scales from edge gateways to cloud VMs, allowing organizations to back-fill historical data, stream live telemetry, or mirror non-PI sources (e.g., Prometheus) into the PI data archive. It also sidesteps older SDK dependencies and enables hybrid architectures where PI remains on-prem while Telegraf agents run in containers or IIoT devices.

Configuration

iptables

[[inputs.iptables]]
  ## iptables require root access on most systems.
  ## Setting 'use_sudo' to true will make use of sudo to run iptables.
  ## Users must configure sudo to allow telegraf user to run iptables with
  ## no password.
  ## iptables can be restricted to only list command "iptables -nvL".
  use_sudo = false
  ## Setting 'use_lock' to true runs iptables with the "-w" option.
  ## Adjust your sudo settings appropriately if using this option
  ## ("iptables -w 5 -nvl")
  use_lock = false
  ## Define an alternate executable, such as "ip6tables". Default is "iptables".
  # binary = "ip6tables"
  ## defines the table to monitor:
  table = "filter"
  ## defines the chains to monitor.
  ## NOTE: iptables rules without a comment will not be monitored.
  ## Read the plugin documentation for more information.
  chains = [ "INPUT" ]

OSI PI

[[outputs.http]]
  ## PI Web API endpoint for writing a single value to a PI Point by Web ID
  url = "https://${PI_HOST}/piwebapi/streams/${WEB_ID}/value"

  ## Use POST for each batch
  method       = "POST"
  content_type = "application/json"

  ## Basic-auth header (base64-encoded "DOMAIN\\user:password")
  headers = { Authorization = "Basic ${BASIC_AUTH}" }

  ## Serialize Telegraf metrics as JSON
  data_format           = "json"
  json_timestamp_units  = "1ms"

  ## Render the JSON body that PI Web API expects
  body_template = """
  {{ range .Metrics -}}
  { "Timestamp": "{{ .timestamp | formatDate \"2006-01-02T15:04:05Z07:00\" }}", "Value": {{ index .fields 0 }} }
  {{ end -}}
  """

  ## Tune networking / batching if needed
  # timeout     = "10s"
  # batch_size  = 1

Input and output integration examples

iptables

1. Monitoring Firewall Performance: Monitor the performance and efficiency of your firewall rules in real time. By tracking packet and byte counters, network administrators can identify which rules are most active and may require optimization. This enables proactive management of firewall configurations to enhance security and performance, especially in environments where dynamic adjustments are frequently made.

2. Understanding Traffic Patterns: Analyze incoming and outgoing traffic patterns based on specific rules. By leveraging the metrics gathered by this plugin, system admins can gain insights into which services are receiving the most traffic, effectively identifying popular services and potential security threats from unusual traffic spikes.

3. Automated Alerting on Traffic Anomalies: Integrate the iptables plugin with an alerting system to notify administrators of unusual activity detected by the firewall. By setting thresholds on the collected metrics, such as sudden increases in packets dropped or unexpected protocol use, teams can automate responses to potential security incidents, enabling swift remediation of threats to the network.

4. Comparative Analysis of Firewall Rules: Conduct comparative analyses of different firewall rules over time. By collecting historical packet and byte metrics, organizations can evaluate the effectiveness of various rules, making data-driven decisions on which rules to modify, reinforce, or remove altogether, thus streamlining their firewall configurations.

OSI PI

1. Remote Pump Stations Telemetry Bridge: Install Telegraf on edge gateways at oil-field pump stations, gather flow-meter and vibration readings over Modbus, and POST them to the PI Web API. Operations teams view real-time data in PI Vision without deploying heavyweight PI interfaces, while bandwidth-friendly batching keeps satellite links economical.

2. Green-Energy Micro-Grid Dashboard: Export inverter, battery, and weather metrics from MQTT into Telegraf, which relays them to PI. PI AF analytics can calculate real-time power balance and feed a campus dashboard; historical deltas inform sustainability reports.

3. Brownfield SCADA Modernization: Legacy PLCs logged to CSV are ingested by Telegraf’s tail input; each row is parsed and immediately sent to PI via HTTP, creating a live data stream that co-exists with archival files while the SCADA upgrade proceeds incrementally.

4. Synthetic Data Generator for Training: Telegraf’s exec input can run a script that emits simulated sensor patterns. Posting those metrics to a non-production PI server through the Web API supplies realistic datasets for PI Vision training sessions without risking production tags.

Feedback

Thank you for being part of our community! If you have any general feedback or found any bugs on these pages, we welcome and encourage your input. Please submit your feedback in the InfluxDB community Slack.