HTTP and SQLite Integration

<pre><code class="language-toml">[[inputs.http]] ## One or more URLs from which to read formatted metrics. urls = [ "http://localhost/metrics", "http+unix:///run/user/420/podman/podman.sock:/d/v4.0.0/libpod/pods/json" ] ## HTTP method # method = "GET" ## Optional HTTP headers # headers = {"X-Special-Header" = "Special-Value"} ## HTTP entity-body to send with POST/PUT requests. # body = "" ## HTTP Content-Encoding for write request body, can be set to "gzip" to ## compress body or "identity" to apply no encoding. # content_encoding = "identity" ## Optional Bearer token settings to use for the API calls. ## Use either the token itself or the token file if you need a token. # token = "eyJhbGc...Qssw5c" # token_file = "/path/to/file" ## Optional HTTP Basic Auth Credentials # username = "username" # password = "pa$$word" ## OAuth2 Client Credentials. The options 'client_id', 'client_secret', and 'token_url' are required to use OAuth2. # client_id = "clientid" # client_secret = "secret" # token_url = "https://indentityprovider/oauth2/v1/token" # scopes = ["urn:opc:idm:__myscopes__"] ## HTTP Proxy support # use_system_proxy = false # http_proxy_url = "" ## Optional TLS Config ## Set to true/false to enforce TLS being enabled/disabled. If not set, ## enable TLS only if any of the other options are specified. # tls_enable = ## Trusted root certificates for server # tls_ca = "/path/to/cafile" ## Used for TLS client certificate authentication # tls_cert = "/path/to/certfile" ## Used for TLS client certificate authentication # tls_key = "/path/to/keyfile" ## Password for the key file if it is encrypted # tls_key_pwd = "" ## Send the specified TLS server name via SNI # tls_server_name = "kubernetes.example.com" ## Minimal TLS version to accept by the client # tls_min_version = "TLS12" ## List of ciphers to accept, by default all secure ciphers will be accepted ## See https://pkg.go.dev/crypto/tls#pkg-constants for supported values. ## Use "all", "secure" and "insecure" to add all support ciphers, secure ## suites or insecure suites respectively. # tls_cipher_suites = ["secure"] ## Renegotiation method, "never", "once" or "freely" # tls_renegotiation_method = "never" ## Use TLS but skip chain &amp; host verification # insecure_skip_verify = false ## Optional Cookie authentication # cookie_auth_url = "https://localhost/authMe" # cookie_auth_method = "POST" # cookie_auth_username = "username" # cookie_auth_password = "pa$$word" # cookie_auth_headers = { Content-Type = "application/json", X-MY-HEADER = "hello" } # cookie_auth_body = '{"username": "user", "password": "pa$$word", "authenticate": "me"}' ## cookie_auth_renewal not set or set to "0" will auth once and never renew the cookie # cookie_auth_renewal = "5m" ## Amount of time allowed to complete the HTTP request # timeout = "5s" ## List of success status codes # success_status_codes = [200] ## Data format to consume. ## Each data format has its own unique set of configuration options, read ## more about them here: ## https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md # data_format = "influx" </code></pre>

<pre><code class="language-toml">[[outputs.sql]] ## Database driver ## Valid options: mssql (Microsoft SQL Server), mysql (MySQL), pgx (Postgres), ## sqlite (SQLite3), snowflake (snowflake.com), clickhouse (ClickHouse) driver = "sqlite" ## Data source name ## For SQLite, the DSN is a filename or URL with the scheme "file:". ## Example: "file:/path/to/telegraf.db?cache=shared" data_source_name = "file:/path/to/telegraf.db?cache=shared" ## Timestamp column name timestamp_column = "timestamp" ## Table creation template ## Available template variables: ## {TABLE} - table name as a quoted identifier ## {TABLELITERAL} - table name as a quoted string literal ## {COLUMNS} - column definitions (list of quoted identifiers and types) table_template = "CREATE TABLE {TABLE} ({COLUMNS})" ## Table existence check template ## Available template variables: ## {TABLE} - table name as a quoted identifier table_exists_template = "SELECT 1 FROM {TABLE} LIMIT 1" ## Initialization SQL (optional) init_sql = "" ## Maximum amount of time a connection may be idle. "0s" means connections are never closed due to idle time. connection_max_idle_time = "0s" ## Maximum amount of time a connection may be reused. "0s" means connections are never closed due to age. connection_max_lifetime = "0s" ## Maximum number of connections in the idle connection pool. 0 means unlimited. connection_max_idle = 2 ## Maximum number of open connections to the database. 0 means unlimited. connection_max_open = 0 ## Metric type to SQL type conversion ## The values on the left are the data types Telegraf has and the values on the right are the SQL types used when writing to SQLite. #[outputs.sql.convert] # integer = "INT" # real = "DOUBLE" # text = "TEXT" # timestamp = "TIMESTAMP" # defaultvalue = "TEXT" # unsigned = "UNSIGNED" # bool = "BOOL" </code></pre>