====== Command reference ======
{{indexmenu_n>8}}

==== Check if the database exists ====
<code>clickhouse-client --query="show databases" | grep qoestor</code>

==== Drop database schema ====
<note warning>All data will be deleted!</note>
<code>clickhouse-client --query="drop database qoestor"</code>

==== Create or update database schema ====
<code>fastor-db-scheme</code>

==== Restart receivers and configuration ====
<code>fastor-restart</code>

==== Stop receivers ====
<code>fastor-stop</code>

==== Restart database ====
<code>fastor-db-restart</code>

==== Stop database ====
<code>fastor-db-stop</code>

==== 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 <code>systemctl restart qoestor_fullflow_0.service
systemctl restart qoestor_clickstream_0.service</code>
  * For CentOS 6 <code>service qoestor_fullflow_0 stop
service qoestor_clickstream_0 stop
service qoestor_fullflow_0 start
service qoestor_clickstream_0 start</code>

=== Stop receivers ===
  * For CentOS 7 <code>systemctl stop qoestor_fullflow_0.service
systemctl stop qoestor_clickstream_0.service</code>
  * For CentOS 6 <code>service qoestor_clickstream_0 stop
service qoestor_fullflow_0 stop</code>

==== Check if the database is running ====
<code>ps aux | grep clickhouse</code>

==== Check if receivers are running ====
<code>ps aux | grep ipfix</code>

==== Check if receivers are listening on ports and have active connections ====
<code>netstat -nlpa | grep 1500
netstat -nlpa | grep 1501</code>

==== Check if data exists in the database ====
<code>clickhouse-client --query="select count(), min(flow_start_time), max(flow_start_time) from qoestor.fullflow"</code>
<code>clickhouse-client --query="select count(), min(time), max(time) from qoestor.clickstream"</code>