To verify the correct operation of the access log transmission from the Tempesta FW ring buffer, mapped to userspace, to a Clickhouse server via a user-space utility utils/tfw_logger. This test will ensure that access logs are correctly generated by Tempesta FW, and transmitted to the Clickhouse server without data loss or corruption.
Clickhouse has SQL-like query syntax.
Access log table creation:
CREATE TABLE IF NOT EXISTS access_log (timestamp UInt64, address IPv6, method UInt8, version UInt8, status UInt16, response_content_length UInt32, response_time UInt32, vhost String, uri String, referer String, user_agent String, PRIMARY KEY(timestamp))
For tests I used Clickhouse client/server downloaded as curl https://clickhouse.com/ | sh. But I think it would be better to install the server from distro repositories.
To verify the correct operation of the access log transmission from the Tempesta FW ring buffer, mapped to userspace, to a Clickhouse server via a user-space utility
utils/tfw_logger
. This test will ensure that access logs are correctly generated by Tempesta FW, and transmitted to the Clickhouse server without data loss or corruption.Clickhouse has SQL-like query syntax.
Access log table creation:
CREATE TABLE IF NOT EXISTS access_log (timestamp UInt64, address IPv6, method UInt8, version UInt8, status UInt16, response_content_length UInt32, response_time UInt32, vhost String, uri String, referer String, user_agent String, PRIMARY KEY(timestamp))
For tests I used Clickhouse client/server downloaded as
curl https://clickhouse.com/ | sh
. But I think it would be better to install the server from distro repositories.