Commands reference [Документация VAS Experts]
Документация VAS Experts Документация VAS Experts-mobile
in

Settings

  • Show page
  • Old revisions
  • Export to PDF
  • Fold/unfold all
  • Backlinks
  • Show page
  • Old revisions
  • Export to PDF
  • Fold/unfold all
  • Backlinks

    • Differences

    This shows you the differences between two versions of the page.

    Link to this comparison view

    Both sides previous revisionPrevious revision
    Next revision    		Previous revision
    en:dpi:dpi_components:qoestor:commands:start [2023/10/10 08:25] – external edit 127.0.0.1en:dpi:dpi_components:qoestor:commands:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
    Line 1: Line 1:
    -====== Commands reference ====== 
    -{{indexmenu_n>7}} 
      
    -==== Check if the database has been created ==== 
    -<code>clickhouse-client --query="show databases" | grep qoestor</code> 
    - 
    - 
    -==== Delete DB schema  ==== 
    -<color #ed1c24>All data will be deleted! </color> 
    -<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>