We make increasing use of Perl modules, and do our best to limit
ourselves to core Perl modules to keep the requirements down. There
are just a few exceptions:
Test::More We require the minimum version to be 0.96, which
appeared in Perl 5.13.4, because that version was
the first to have all the features we're using.
This module is required for testing only! If you
don't plan on running the tests, you don't need to
bother with this one.
Text::Template This module is not part of the core Perl modules.
As a matter of fact, the core Perl modules do not
include any templating module to date.
This module is absolutely needed, configuration
depends on it.
The rule of thumb to use when you want something that "just works" for all recent versions of OpenSSL, including OpenSSL 1.0.2 and 1.1.0, is:
specify both --prefix and --openssldir
set --prefix and --openssldir to the same location
$ openssl version
openssl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory
$ export LD_LIBRARY_PATH="/path/to/dir/lib/:$LD_LIBRARY_PATH"
$ openssl version
OpenSSL 1.1.1d 10 Sep 2019
CREATE CONTINUOUS QUERY <cq_name> ON <database_name>
BEGIN
SELECT <function[s]>
INTO <destination_measurement>
FROM <measurement>
[WHERE <stuff>]
GROUP BY time(<interval>)[,<tag_key[s]>]
END
show continuous queryすると実行したクエリを表示できます。
time_tookについて5分間の平均をとって格納します。保存先に、"1day"という1日だけデータを保持するretention policyを設定しているので、
古くなったデータは順次消えていきます。
CREATE CONTINUOUS QUERY cq_downsampled_successed_5min_1day ON downsampled_dnsprobe
BEGIN
SELECT mean(time_took)
INTO downsampled_dnsprobe."1day".mes_cq_downsampled_successed_5min_1day
FROM dnsprobe.thirty_five_days.dnsprobe
WHERE got_response = 'True'
GROUP BY time(5m), prb_id, af, proto, dst_name, rrtype
END
> select percentile(measured, 20) from testdb group by proto
name: testdb
tags: proto=tcp
time percentile
---- ----------
1577766044022027112 6.350597491749054
name: testdb
tags: proto=udp
time percentile
---- ----------
1577766044050092539 9.58538941785223
> select percentile(measured, 50) from testdb group by proto
name: testdb
tags: proto=tcp
time percentile
---- ----------
1577766043809580444 49.02986276817023
name: testdb
tags: proto=udp
time percentile
---- ----------
1577766043931028528 13.858574248282208
In order to avoid logs being spammed into uselessness, it is
required that each chain is rooted in a known CA certificate.
3.1. Log Entries
Each submitted certificate MUST be accompanied by all
additional certificates required to verify the certificate chain up
to an accepted root certificate