| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| en:dpi:dpi_components:qoestor:troubleshooting:start [2021/09/02 12:21] – arusnak | en:dpi:dpi_components:qoestor:troubleshooting:start [2024/07/29 12:46] (current) – removed elena.krasnobryzh |
|---|
| ====== 6 Problems and solutions ====== | |
| {{indexmenu_n>6}} | |
| |
| ==== Doesn't work, although everything was installed according to the instructions ==== | |
| |
| If you installed and configured everything according to the instructions, and the DPIUI2 “QoE Analytics” section is empty, then here is a list of steps you should follow before contacting those. support. | |
| |
| - Check the correct time and timezone settings on servers with dpiui2 and QoE Stor. Try setting a large period in dpiui2. If the matter is in the time zone, the data will appear. Set the time correctly on the dpiui2 and QoE Stor servers, restart the servers completely (<color #ed1c24>If the timezone has been changed the database must be [[en:dpi:dpi_components:qoestor:commands:start#delete_db_schema|deleted]] and [[en:dpi:dpi_components:qoestor:commands:start#create_update_database_schema|recreated]]</color>). | |
| - On the server with QoE Stor check [[en:dpi:dpi_components:qoestor:commands:start#check_if_the_database_has_been_created|if the database has been created]]. If the database is not created [[en:dpi:dpi_components:qoestor:commands:start#create_update_database_schema|create it with the command]]. | |
| - On the server with QoE Stor check [[en:dpi:dpi_components:qoestor:commands:start#check_if_there_is_data_in_the_database|if there is data in the database]]. Or see how the partitions are filled through the web interface in the QOE ANALYTICS / ADMINISTRATOR / Tablespace Information section. | |
| - Check [[en:dpi:dpi_components:qoestor:commands:start#check_if_receivers_are_running|if receivers are running]] and [[en:dpi:dpi_components:qoestor:commands:start#restarting_receivers_and_configuration|restart receivers]] if required. | |
| - On the server with QoE Stor check the receiver logs in the folder <code>/var/qoestor/backend/logs</code> There should be no errors in the logs. The rotation of the dumps and their writing to the database should be visible. | |
| - On the server with QoE Stor check [[en:dpi:dpi_components:qoestor:commands:start#check_if_the_receivers_are_listening_to_the_ports_and_if_there_is_a_connection|if ports 1500 and 1501 are listening]]. | |
| - Restart all receivers just in case [[en:dpi:dpi_components:qoestor:commands:start#restarting_receivers_and_configuration|with the command]]. | |
| - Check [[en:dpi:dpi_components:qoestor:configuration:dpi:start|the ipfix dpi export settings]] again. | |
| - On the server DPIUI2 check [[en:dpi:dpi_components:dpiui:dpiui2#настройка_подключения_к_qoe_stor|the settings for connecting the GUI to the QoE Stor]]. | |
| - On the server with QoE Stor check if the ClickHouse is running [en:dpi:dpi_components:qoestor:commands:start#check_if_the_db_is_working|with the command]]. Make sure there is enough RAM on the server. | |
| - Check the log on the server with QoE Stor <code>/var/log/clickhouse-server/clickhouse-server.err.log</code> | |
| |
| If there is a need to clear all data in the database, then on the server with QoE Stor you need | |
| - Delete database [[en:dpi:dpi_components:qoestor:commands:start#delete_db_schema|with command]]. | |
| - Recreate the database [[en:dpi:dpi_components:qoestor:commands:start#create_update_database_schema|with command]]. | |
| |
| ==== How to reduce retention period and clear data ==== | |
| |
| Data cleaning is performed by the dpiui2 module. | |
| On the server where dpiui2 is installed change the parameters in the <code>/var/www/html/dpiui2/backend/.env</code> file | |
| <code> | |
| QOESTOR_MAIN_LOG_PARTITIONS_LIFE_TIME_HOUR=2 | |
| QOESTOR_AGG_LOG_PARTITIONS_LIFE_TIME_DAYS=15 | |
| </code> | |
| Restart | |
| <code>dpiui2 queue:restart</code> | |
| |
| |
