Table of Contents

Commands reference

Check if the database has been created

clickhouse-client --query="show databases" | grep qoestor

Delete DB schema

All data will be deleted!

clickhouse-client --query="drop database qoestor"

Create / update database schema

fastor-db-scheme

Restarting receivers and configuration

fastor-restart

Stopping receivers

fastor-stop

Database restart

fastor-db-restart

Stop the DB

fastor-db-stop

Controlling receivers separately

Restarting receivers

If you need to restart the receivers separately, this can be done by restarting the services, for example

Stopping receivers

Check if the DB is working

ps aux | grep clickhouse

Check if receivers are running

ps aux | grep ipfix

Check if the receivers are listening to the ports and if there is a connection

netstat -nlpa | grep 1500
netstat -nlpa | grep 1501

Check if there is data in the database

clickhouse-client --query="select count(), min(flow_start_time), max(flow_start_time) from qoestor.fullflow"
clickhouse-client --query="select count(), min(time), max(time) from qoestor.clickstream"