#!/bin/bash # add 2018-12-07 by Pascal Withopf, released under ASL 2.0 . ${srcdir:=.}/diag.sh init export NUMMESSAGES=1000 generate_conf add_conf ' module(load="../plugins/omclickhouse/.libs/omclickhouse") template(name="outfmt" option.stdsql="on" type="string" string="INSERT INTO rsyslog.load (id, ipaddress, message) VALUES (%msg:F,58:2%, ' add_conf "'%fromhost-ip%', '%msg:F,58:2%')" add_conf '") :syslogtag, contains, "tag" action(type="omclickhouse" server="localhost" usehttps="off" user="default" pwd="" template="outfmt" bulkmode="off") ' clickhouse-client --query="CREATE TABLE IF NOT EXISTS rsyslog.load ( id Int32, ipaddress String, message String ) ENGINE = MergeTree() PARTITION BY ipaddress Order By id" startup injectmsg shutdown_when_empty wait_shutdown clickhouse-client --query="SELECT message FROM rsyslog.load ORDER BY id" > $RSYSLOG_OUT_LOG clickhouse-client --query="DROP TABLE rsyslog.load" seq_check 0 $(( NUMMESSAGES - 1 )) exit_test