====== Commands reference ======
{{indexmenu_n>7}}

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


==== Delete DB schema  ====
<wrap em>All data will be deleted!</wrap>
<code>clickhouse-client --query="drop database qoestor"</code>

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

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



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

==== Database restart ====
<code>fastor-db-restart</code>

==== Stop the DB ====
<code>fastor-db-stop</code>



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

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

==== Check if the DB is working ====
<code>ps aux | grep clickhouse</code>

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

==== Check if the receivers are listening to the ports and if there is a connection ====
<code>netstat -nlpa | grep 1500
netstat -nlpa | grep 1501</code>

==== Check if there is data 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>