Table of Contents
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"
Was this information helpful?