Installation

Installation on Linux

Installation on RedHat and CentOS

• Download influxDB for RedHat Linux from InfluxData Downloads, e.g.: https://download.influxdata.com/influxdb/releases/influxdb-1.11.8.x86_64.rpm

• Copy file to server and Install influxdb: sudo rpm -ivh influxdb-1.11.8.x86_64.rpm

Installation on Docker

Dockerfile for all three services on the same container

# Use the official InfluxDB image
FROM influxdb:latest AS influxdb

# Use the official Telegraf image
FROM telegraf:latest AS telegraf

# Use the official Grafana image
FROM grafana/grafana:latest AS grafana

# Set up InfluxDB
FROM influxdb
COPY --from=influxdb /etc/influxdb/influxdb.conf /etc/influxdb/influxdb.conf
EXPOSE 8086

# Set up Telegraf
FROM telegraf
COPY --from=telegraf /etc/telegraf/telegraf.conf /etc/telegraf/telegraf.conf
EXPOSE 8125/udp

# Set up Grafana
FROM grafana
COPY --from=grafana /etc/grafana/grafana.ini /etc/grafana/grafana.ini
EXPOSE 3000

# Start all services
CMD ["sh", "-c", "influxd & telegraf & grafana-server --homepath=/usr/share/grafana"]

• If docker build shows error: file not found, try the following Dockerfile

# Use the latest InfluxDB image
FROM influxdb:latest as influxdb

# Use the latest Telegraf image
FROM telegraf:latest as telegraf

# Use the latest Grafana image
FROM grafana/grafana:latest as grafana
USER root
# Create directories if they don't exist
RUN mkdir -p /etc/influxdb /etc/telegraf /etc/grafana

# Copy configuration files
COPY influxdb/influxdb.conf /etc/influxdb/influxdb.conf
COPY telegraf/telegraf.conf /etc/telegraf/telegraf.conf

# Expose ports
EXPOSE 8086 3000 8125
USER grafana
# Start services
CMD service influxdb start && \
    service telegraf start && \
    service grafana-server start && \
    tail -f /dev/null

Configuration

influxdb.conf

[meta]
  dir = "/var/lib/influxdb/meta"

[data]
  dir = "/var/lib/influxdb/data"
  wal-dir = "/var/lib/influxdb/wal"

[http]
  bind-address = ":8086"
  auth-enabled = false

telegraf.conf

[[inputs.snmp]]
  agents = ["udp://<device_ip>:161"]
  version = 2
  community = "public"
  interval = "60s"

  [[inputs.snmp.field]]
    name = "hostname"
    oid = "RFC1213-MIB::sysName.0"
    is_tag = true

  [[inputs.snmp.table]]
    name = "interface"
    oid = "IF-MIB::ifTable"
    inherit_tags = ["hostname"]

[[outputs.influxdb]]
  urls = ["http://localhost:8086"]
  database = "snmp"

grafana.ini

[server]
http_port = 3000

[database]
type = sqlite3
path = grafana.db

[security]
admin_user = admin
admin_password = admin

Run docker

docker build -t monitoring .
docker run -d -p 3000:3000 -p 8086:8086 -p 8125:8125/udp --name monitoring monitoring

Docker compose for services in different containers

docker-compose.yml

version: '3.7'

services:
  influxdb:
    image: influxdb:latest
    container_name: influxdb
    ports:
      - "8086:8086"
    volumes:
      - influxdb-data:/var/lib/influxdb
    environment:
      - INFLUXDB_DB=snmp
      - INFLUXDB_HTTP_AUTH_ENABLED=true
      - INFLUXDB_ADMIN_USER=admin
      - INFLUXDB_ADMIN_PASSWORD=admin

  telegraf:
    image: telegraf:latest
    container_name: telegraf
    depends_on:
      - influxdb
    volumes:
      - ./telegraf.conf:/etc/telegraf/telegraf.conf:ro

  grafana:
    image: grafana/grafana:latest
    container_name: grafana
    ports:
      - "3000:3000"
    depends_on:
      - influxdb
    volumes:
      - grafana-data:/var/lib/grafana
    environment:
      - GF_SECURITY_ADMIN_USER=admin
      - GF_SECURITY_ADMIN_PASSWORD=admin

volumes:
  influxdb-data:
  grafana-data:

Configuration

telegraf.conf

[[inputs.snmp]]
  agents = ["udp://<device_ip>:161"]
  version = 2
  community = "public"
  interval = "60s"

  [[inputs.snmp.field]]
    name = "hostname"
    oid = "RFC1213-MIB::sysName.0"
    is_tag = true

  [[inputs.snmp.table]]
    name = "interface"
    oid = "IF-MIB::ifTable"
    inherit_tags = ["hostname"]

[[outputs.influxdb]]
  urls = ["http://influxdb:8086"]
  database = "snmp"
  username = "admin"
  password = "admin"

Run docker-compose

• docker-compose up -d

Docker-compose for 2 containers: 1 for grafana and another one for influxdb and telegraf

Dockerfile

# Use the official InfluxDB image as the base
FROM influxdb:latest

# Install Telegraf
RUN apt-get update && apt-get install -y telegraf

# Copy Telegraf configuration file
COPY telegraf.conf /etc/telegraf/telegraf.conf

# Expose InfluxDB and Telegraf ports
EXPOSE 8086 8125/udp

# Start both InfluxDB and Telegraf
CMD ["sh", "-c", "influxd & telegraf --config /etc/telegraf/telegraf.conf"]

Docker-compose

version: '3.7'

services:
  influxdb-telegraf:
    build: .
    container_name: influxdb-telegraf
    ports:
      - "8086:8086"
      - "8125:8125/udp"
    volumes:
      - influxdb-data:/var/lib/influxdb
      - ./telegraf.conf:/etc/telegraf/telegraf.conf:ro
    environment:
      - INFLUXDB_DB=snmp
      - INFLUXDB_HTTP_AUTH_ENABLED=true
      - INFLUXDB_ADMIN_USER=admin
      - INFLUXDB_ADMIN_PASSWORD=admin

  grafana:
    image: grafana/grafana:latest
    container_name: grafana
    ports:
      - "3000:3000"
    depends_on:
      - influxdb-telegraf
    volumes:
      - grafana-data:/var/lib/grafana
    environment:
      - GF_SECURITY_ADMIN_USER=admin
      - GF_SECURITY_ADMIN_PASSWORD=admin

volumes:
  influxdb-data:
  grafana-data:

Build and start services

docker-compose build
docker-compose up -d

API Commands

• curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=telegraf" --data-urlencode "q=SELECT last("session_state") FROM "Cisco-IOS-XE-bgp-oper:bgp-state-data/neighbors/neighbor""

• curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=telegraf" --data-urlencode "q=SELECT * FROM "Cisco-IOS-XE-bgp-oper:bgp-state-data/neighbors/neighbor""

• curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=telegraf" --data-urlencode "q=SELECT * FROM interface where time > now() - 1m and source='$sourcename'" | jq -r ".results[].series[] | .columns,.values[] @csv"

• curl -i XPOST "http://localhost:8086/write?db=telegraf" --data-binary 'cpu_load_short_host=serer01 value=0.64'

Access Database

influx
show
use $database
show measurements
select * from $table where time > now() -5m and source="$hostname"

• influx -database telegraf -execute "show measurements"

• influx -database telegraf -execute "select * from $table where time > now() -5m and host='$hostname'"

• influx -database telegraf -execute "select * from "$tablewithspecialcharacter" where time > now() -5m and host='$hostname'"