Commands reference

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

All data will be deleted!

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

fastor-db-scheme

fastor-restart

fastor-stop

fastor-db-restart

fastor-db-stop

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

• 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

ps aux | grep clickhouse

ps aux | grep ipfix

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

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"