Command reference

Check if the database exists

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

Drop database schema

All data will be deleted!

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

Create or update database schema

fastor-db-scheme

Restart receivers and configuration

fastor-restart

Stop receivers

fastor-stop

Restart database

fastor-db-restart

Stop database

fastor-db-stop

Manage receivers individually

Restart receivers

If you need to restart receivers individually, you can do it via service restart commands, for example:

For CentOS 7

systemctl restart qoestor_fullflow_0.service
systemctl restart qoestor_clickstream_0.service

For CentOS 6

service qoestor_fullflow_0 stop
service qoestor_clickstream_0 stop
service qoestor_fullflow_0 start
service qoestor_clickstream_0 start

Stop receivers

For CentOS 7

systemctl stop qoestor_fullflow_0.service
systemctl stop qoestor_clickstream_0.service

For CentOS 6

service qoestor_clickstream_0 stop
service qoestor_fullflow_0 stop

Check if the database is running

ps aux | grep clickhouse

Check if receivers are running

ps aux | grep ipfix

Check if receivers are listening on ports and have active connections

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

Check if data exists 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"