influxdb-zabbix.conf

### Welcome to the influxdb-zabbix configuration file.

###
### Polling
### Controls polling interval
###
[polling]
  ## Default polling interval in seconds.
  ## Minimum is 15.
  interval=30
  #intervaliferror=60

###
### InfluxDB
### Controls InfluxDB api endpoint
###
[influxdb]
  url="http://localhost:8086"
  database="zabbix"

  ## Precision of writes, valid values are ms as formatted in the SQL queries
  precision= "ms"

  ## Connection timeout (in seconds). If not provided, will default to 0 (no timeout)
  # timeout=5

  ## Credentials
  # username="influxdb-zabbix"
  # password="zabbixmetrics"

###
### Zabbix DB
### Select one provider by commenting [zabbix.postgres] or [zabbix.mysql]
###
[zabbix]

  [zabbix.postgres]
  ## PostgreSQL:
  ##   postgres://[user[:password]]@localhost[/dbname]\
  ##       ?sslmode=[disable|verify-ca|verify-full]
  ##   or a simple string:
  ##        host=localhost user=... password=... sslmode=... dbname=zabbix application_name=influxdb-zabbix
  ##
  address="postgres://zabbix:zabbix123***@192.168.1.101/zabbix?sslmode=disable"

  ##[zabbix.mysql]
  ## MariaDB/MySQL
  ## specify servers via a url matching:
  ##  [username[:password]@][protocol[(address)]]/dbname[?tls=[true|false|skip-verify]]
  ##  see https://github.com/go-sql-driver/mysql#dsn-data-source-name
  ##  e.g.
  ##    db_user:passwd@tcp(127.0.0.1:3306)/zabbix'
  ##address="zabbix:zabbix@tcp(10.0.0.10:3306)/zabbix"

###
### Zabbix tables
### At least one table has to be active
###
### Controls tables for extracting data
###   name (string - mandatory) is the relation name in postgres.
###   active (boolean - mandatory) is to activate or not the data extraction.
###   startid (int - default 0) is the lower boundary (non-inclusive) to select syncid from the table.
###       -- startid is needed for the first load. After this, value stored in registry file prevails on this one.
###       -- example: 1345654 (next query will return records with syncid > 1345654)
###   inputrowsperbatch (int - default 100000) is the number of rows to extract from Zabbix backend
###   outputrowsperbatch (int - default 100000) is the number of rows to load into InfluxDB
###   interval in seconds (int - default 15) is time before each extraction poll.
###
[tables]
  [tables.history]
  name="history"
  active=true
  startid=0
  inputrowsperbatch=50000
  outputrowsperbatch=50000
  interval=15

  [tables.history_uint]
  name="history_uint"
  active=true
  startid=0
  inputrowsperbatch=50000
  outputrowsperbatch=50000
  interval=15

  [tables.trends]
  name="trends"
  active=true
  startid=0
  inputrowsperbatch=50000
  outputrowsperbatch=50000
  interval=15

  [tables.trends_uint]
  name="trends_uint"
  active=true
  startid=0
  inputrowsperbatch=50000
  outputrowsperbatch=50000
  interval=15

###
### Registry file
### Name of the registry file. Per default, it is put in the current working directory.
###
[registry]
# File name path
# Default: /var/lib/influxdb-zabbix/influxdb-zabbix.json
filename="influxdb-zabbix.json"

###
### Logging
### Controls Logging
###
[logging]
# File name path
# Default: /var/log/influxdb-zabbix/influxdb-zabbix.log
filename="influxdb-zabbix.log"

# Either "console", "file", default is "file"
# Use comma to separate multiple modes, e.g. "console, file"
modes="console"

# Buffer length of channel, keep it as it is if you don't know what it is.
bufferlen=10000

# Either "Trace", "Debug", "Info", "Warn", "Error", "Critical", default is "Trace"
levelconsole="Trace"

# Either "Trace", "Debug", "Info", "Warn", "Error", "Critical", default is "Warn"
levelfile="Warn"

# Set formatting to "false" to disable color formatting of console logs
formatting=true

# This enables automated log rotate(switch of following options), default is true
logrotate=true

# Max line number of single file, default is 1000000
maxlines=1000000

# Max size shift of single file, default is 28 means 1 << 28, 256MB
maxsizeshift=28

# Segment log daily, default is true
dailyrotate=true

# Expired days of log file(delete after max days), default is 7
maxdays=7

 ### End