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

  • On CentOS 7
    systemctl restart qoestor_fullflow_0.service
    systemctl restart qoestor_clickstream_0.service
  • On CentOS 6
    service qoestor_fullflow_0 stop
    service qoestor_clickstream_0 stop
    service qoestor_fullflow_0 start
    service qoestor_clickstream_0 start

Stopping receivers

  • On CentOS 7
    systemctl stop qoestor_fullflow_0.service
    systemctl stop qoestor_clickstream_0.service
  • On CentOS 6
    service qoestor_clickstream_0 stop
    service qoestor_fullflow_0 stop

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"