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
- 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"