Hi there, I am about to configure the telegraf helm chart with an postgresql output plugin, anyway I cannot find the reference “docs/all-config-values.yaml” which should also contain the information how exactly to configure the values.yaml in order to connect to postgesql. Any idea where this example file could be?
May be these files would help?
# Below is a full list of telegraf configuration values tested with this chart.
# The telegraf configuration file is in TOML format while Helm uses YAML. The template for
# the configmap iterates through this whole tree and produces valid telegraf configuration.
# To enable a plugin simply provide the configration. Plugins that aren't listed wont be
# enabled. To check the configration options for the individual plugins:
##
# Inputs: https://github.com/influxdata/telegraf/tree/master/plugins/inputs/{plugin}
# Outputs https://github.com/influxdata/telegraf/tree/master/plugins/outputs/{plugin}
##
# Alternatively if you have telegraf installed on your system you can check the telegraf
# sample configuration:
##
# Inputs:
# telegraf -sample-config \
# -input-filter {plugin} \
# -output-filter foo \
# -processor-filter foo \
# -aggregator-filter foo
# Outputs:
# telegraf -sample-config \
# -input-filter foo \
# -output-filter {plugin} \
# -processor-filter foo \
# -aggregator-filter foo
##
# The telegraf.conf generated by this file lives at `all-config-values.toml`
config:
global_tags:
dc: "us-east-1"
user: "$USER"
agent:
interval: "1s"
round_interval: true
metric_batch_size: 1000
metric_buffer_limit: 10000
collection_jitter: "0s"
flush_interval: "10s"
flush_jitter: "0s"
precision: ""
debug: false
quiet: false
logfile: ""
hostname: ""
omit_hostname: false
outputs:
influxdb:
urls:
- "http://influxdb.tick:8086"
database: "telegraf"
retention_policy: ""
write_consistency: "any"
timeout: "5s"
username: "telegraf"
password: "metricsmetricsmetricsmetrics"
user_agent: "telegraf"
udp_payload: 512
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
amqp:
url: "amqp://localhost:5672/influxdb"
exchange: "telegraf"
auth_method: "PLAIN"
routing_tag: "host"
retention_policy: "default"
database: "telegraf"
precision: "s"
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
data_format: "influx"
kafka:
brokers:
- "localhost:9092"
topic: "telegraf"
routing_tag: "host"
compression_codec: 0
required_acks: -1
max_retry: 3
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
data_format: "influx"
mqtt:
servers:
- "localhost:1883"
topic_prefix: "telegraf"
username: "telegraf"
password: "metricsmetricsmetricsmetrics"
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
data_format: "influx"
nats:
servers:
- "nats://localhost:4222"
username: ""
password: ""
subject: "telegraf"
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
data_format: "influx"
nsq:
server: "localhost:4150"
topic: "telegraf"
data_format: "influx"
inputs:
aerospike:
servers:
- "localhost:3000"
apache:
urls:
- "http://localhost/server-status?auto"
cassandra:
context: "/jolokia/read"
servers:
- "myuser:mypassword@10.10.10.1:8778"
- "10.10.10.2:8778"
- ":8778"
metrics :
- "/java.lang:type=Memory/HeapMemoryUsage"
- "/org.apache.cassandra.metrics:type=Table,keyspace=*,scope=*,name=ReadLatency"
cloudwatch:
region: "us-east-1"
access_key: ""
secret_key: ""
token: ""
role_arn: ""
profile: ""
shared_credential_file: ""
period: "5m"
delay: "5m"
interval: "5m"
cache_ttl: "10m"
namespace: "AWS/ELB"
ratelimit: 10
metrics:
names:
- "Latency"
- "RequestCount"
dimensions:
name: "LoadBalancerName"
value: "p-example"
consul:
address: "localhost"
scheme: "http"
token: ""
username: ""
password: ""
datacentre: ""
couchbase:
servers:
- "http://localhost:8091"
couchdb:
hosts:
- "http://localhost:8086/_stats"
disque:
servers:
- "localhost"
dns_query:
servers:
- "8.8.8.8"
domains:
- "."
record_type: "A"
port: 53
timeout: 2
dovecot:
servers:
- "localhost:24242"
type: "global"
filters:
- ""
elasticsearch:
servers:
- "http://localhost:9200"
http_timeout: "5s"
local: true
cluster_health: false
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
graylog:
servers:
- "http://[graylog-server-ip]:12900/system/metrics/multiple"
metrics:
- "jvm.cl.loaded"
- "jvm.memory.pools.Metaspace.committed"
username: ""
password: ""
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
haproxy:
servers:
- "http://myhaproxy.com:1936/haproxy?stats"
influxdb:
urls:
- "http://influxdb.tick:8086/debug/vars"
- "http://test-influxdb.influxdb:8086/debug/vars"
timeout: "5s"
lustre2:
ost_procfiles:
- "/proc/fs/lustre/obdfilter/*/stats"
- "/proc/fs/lustre/osd-ldiskfs/*/stats"
- "/proc/fs/lustre/obdfilter/*/job_stats"
mds_procfiles:
- "/proc/fs/lustre/mdt/*/md_stats"
- "/proc/fs/lustre/mdt/*/job_stats"
mailchimp:
api_key: ""
days_old: 0
campaign_id: ""
memcached:
servers:
- "localhost:11211"
unix_sockets:
- "/var/run/memcached.sock"
mesos:
timeout: 100
masters:
- "localhost:5050"
master_collections:
- "resources"
- "master"
- "system"
- "agents"
- "frameworks"
- "tasks"
- "messages"
- "evqueue"
- "registrar"
slaves:
-
slave_collections:
- "resources"
- "agent"
- "system"
- "executors"
- "tasks"
- "messages"
mongodb:
servers:
- "mongodb://user:password@127.0.0.1:27017"
gather_perdb_stats: false
mysql:
servers:
- "tcp(127.0.0.1:3306)?tls=false"
perf_events_statements_digest_text_limit : 120
perf_events_statements_limit: 250
perf_events_statements_time_limit : 86400
table_schema_databases: []
gather_table_schema: false
gather_process_list: true
gather_info_schema_auto_inc: true
gather_slave_status: true
gather_binary_logs: false
gather_table_io_waits: false
gather_table_lock_waits: false
gather_index_io_waits: false
gather_event_waits: false
gather_file_events_stats: false
gather_perf_events_statements: false
interval_slow: "30m"
net_response:
protocol: "tcp"
address: "github.com:80"
timeout: "1s"
send: "ssh"
expect: "ssh"
read_timeout: "1s"
nginx:
urls:
- "http://nginx.nginx-ingress/nginx_status"
nsq:
endpoints:
- "http://localhost:4151"
phpfpm:
urls:
- "http://localhost/status"
ping:
urls:
- "www.google.com"
count: 1
ping_interval: 1.0
timeout: 1.0
interface: ""
postgresql:
address: "postgres://user:password@localhost?sslmode=disable"
ignored_databases:
- "postgres"
databases:
- "app_production"
- "testing"
prometheus:
urls:
- "http://localhost:9100/metrics"
bearer_token: /path/to/bearer/token
ssl_ca: /path/to/cafile
ssl_cert: /path/to/certfile
ssl_key: /path/to/keyfile
insecure_skip_verify: false
rabbitmq:
url: "http://localhost:15672"
name: "rmq-server-1"
username: "guest"
password: "guest"
ssl_ca: "/etc/telegraf/ca.pem"
ssl_cert: "/etc/telegraf/cert.pem"
ssl_key: "/etc/telegraf/key.pem"
insecure_skip_verify: false
nodes:
- "rabbit@node1"
- "rabbit@node2"
raindrops:
urls:
- "http://localhost:8080/_raindrops"
redis:
servers:
- "tcp://localhost:6379"
rethinkdb:
servers:
- "127.0.0.1:28015"
riak:
servers:
- "http://localhost:8098"
sqlserver:
servers:
- "Server=192.168.1.10;Port=1433;User Id=<user>;Password=<pw>;app name=telegraf;log=1;"
twemproxy:
addr: "localhost:22222"
pools:
- "redis_pool"
- "mc_pool"
zookeeper:
servers:
- "localhost:2181"
http_listener:
service_address: ":8186"
read_timeout: "10s"
write_timeout: "10s"
max_body_size: 0
max_line_size: 0
statsd:
service_address: ":8125"
delete_gauges: false
delete_counters: false
delete_sets: false
delete_timings: true
percentiles:
- 90
metric_separator: "_"
parse_data_dog_tags: false
templates:
- "cpu.* measurement*"
allowed_pending_messages: 10000
percentile_limit: 1000
tcp_listener:
service_address: ":8094"
allowed_pending_messages: 10000
max_tcp_connections: 250
data_format: "influx"
udp_listener:
service_address: ":8092"
data_format: "influx"
allowed_pending_messages: 10000
webhooks:
service_address: ":1619"
filestack:
path: "/filestack"
github:
path: "/github"
mandrill:
path: "/mandrill"
rollbar:
path: "/rollbar"
Yes, thanks. I understand now how to build the values.yaml for helm.
