OPNsense Forum

English Forums => Zenarmor (Sensei) => Topic started by: serbans on August 07, 2023, 11:03:16 AM

Title: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: serbans on August 07, 2023, 11:03:16 AM
After updating to 1.14, there is no report available/no data available in the dashboard or in the reporting, live sessions, activity explorer, etc.
Reboots performed.
Accessing the firewall via the ip address, with FQDN all fields are "network error".

Running licensed Home version, OPNSense 23.7
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on August 07, 2023, 12:45:57 PM
Hi,

The issue is fixed and a bugfix release will be shipped today.


Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: stomek on August 07, 2023, 07:22:45 PM
Good evening everyone,

have installed the bug fix relase and the 2 reported issues seems to be sorted properly.
Until now furhter anomalies could have been found - software smoothly in the entire GUI menu tree.

Have a nice evening,
Stefan
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: serbans on August 08, 2023, 04:53:38 PM
For me the patch has not corrected the fact that with an external elasticsearch database, I am still unable to see any traffic reports.

Status:
- in the settings/configuration page
    - reporting database  - elasticsearch (remote) - cannot be changed either when the engine is running or stopped
     - the field "remote url" does not contain the port information, adding it it says "saved" nd after a page reload it is gone

- in the settings data management page
     - stream reporting data to elasticsearch - I have configured the url and enabled it.

- in the dashboard page
     - regardless of the setting of the stream reporting data to elasticsearch - the setting Reporting database shows "elasticsearch". If I click on start, it shows someting starting and there is an elasticsearch locally running on the firewall.

Next step - removing the module completely and installing again.

UPDATE - reinstalled ZenArmor, still same issue, it seems that it tries a local elasticsearch instance for reports and such even if it is configured with an external one

I will try and open a ticket with Zenarmor as well.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: badbroccoli on August 08, 2023, 05:19:47 PM
Quote from: serbans on August 08, 2023, 04:53:38 PM
For me the patch has not corrected the fact that with an external elasticsearch database, I am still unable to see any traffic reports.

Status:
- in the settings/configuration page
    - reporting database  - elasticsearch (remote) - cannot be changed either when the engine is running or stopped
     - the field "remote url" does not contain the port information, adding it it says "saved" nd after a page reload it is gone

- in the settings data management page
     - stream reporting data to elasticsearch - I have configured the url and enabled it.

- in the dashboard page
     - regardless of the setting of the stream reporting data to elasticsearch - the setting Reporting database shows "elasticsearch". If I click on start, it shows someting starting and there is an elasticsearch locally running on the firewall.

Next step - removing the module completely and installing again.

I will try and open a ticket with Zenarmor as well.

I am having the same issues.

edit: ZA support claims a known issue w/ remote ES and another hotfix will be released today.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: dotlike on August 08, 2023, 05:24:06 PM
For me the hotfix solved the problem to access the Zenarmor-GUI.
The problem is that I get a lot of false positives (for NTP, DNS,...). I have to set Zenarmor to bypass mode to get online again.
I have tried to reset Zenarmor to factory defaults without success.

The worst upgrade so far  >:(
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: serbans on August 09, 2023, 08:25:06 AM
Update:

After removing all indices and data views relted to ZA from ES, managed at the third install to have the environment up and running.
Still having some issues with the reporting ("ZA detected 8 and blocked 0 potentially harmful activities" ??? ) but the ES part seems to be resolved.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: dotlike on August 09, 2023, 08:26:10 AM
Update 1.14.2 fixed my issues  :)
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on August 10, 2023, 04:37:23 PM
Hi,

@Serbans, you can see the caught Threats in Reports - Threats tab. This means that Zenarmor caught but there is no rules to block them. If you set as blocked the caught category(ies) then you will see there them as blocked.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: diba on August 10, 2023, 10:21:23 PM
Hi,

i have still the problems with reports etc. when i use an external opensearch db after the update to 1.14.2.

Data was written to the DB but no data is showen in the reüports
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: pwalczak on August 11, 2023, 10:08:27 AM
More information from my setup as well.

I have configured an external ES DB after upgrading Zenarmor to 1.14.2. It basically works but some reports don't display data.

These reports are:

I would expect to see data in at least some of them.
One more factor that can make a difference is the fact I use custom lifecycle policy and custom index names in ES. However I've made sure all mappings are defined exactly the same way as indices created by Zenarmor during the installation process.

Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: tokar86a on September 18, 2023, 09:16:47 PM
This still seems to be a problem whit this? I have ended up whit the same error. No data to display.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on September 18, 2023, 11:06:08 PM
Hi all,

1.15 has fixes for the report charts. Can you try the reports after the update?

Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: tokar86a on September 19, 2023, 07:19:59 AM
Quote from: sy on September 18, 2023, 11:06:08 PM
Hi all,

1.15 has fixes for the report charts. Can you try the reports after the update?

Still has the same problem.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: idpitt on October 21, 2023, 01:06:47 PM
Similar issues here. Running 1.15.1 on OPNSense 23.7.6 with an external elasticsearch DB. I see indexes being populated with data and some reports display info in the zenarmor GUI.     Unique local hosts for example is blank.  Activity Explorer is totally blank.  A 'reset indexes' attempt returns a failed to connect yet deleting data works. 

When I was running the elastic search locally, the reports were working fine.  I wanted to offload the database to an existing ELK server. 
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on October 21, 2023, 10:24:54 PM
Hi,

What is the Elasticsearch version?
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: idpitt on October 21, 2023, 11:44:24 PM
It's 8.1

The majority of reports are working. This is the home edition. I don't need the prefix functionality.   Are some reports/logs disabled in this set up?   The Activity Explorer and some of the time based charts ( e.g. HTTP Transactions by source over time ) are broken. The same version of Zenarmor and license against the local elasticsearch instance provides full functionality.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on October 23, 2023, 11:34:57 AM
Hi,

It is not a license limitation. Please visit non-working reports, then share a report (select Zenarmor logs check box) by following the instructions in the following link.

https://www.zenarmor.com/docs/support/reporting-bug
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: idpitt on October 23, 2023, 12:51:37 PM
Done. Thanks.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: idpitt on November 04, 2023, 10:54:44 AM
Quote from: tokar86a on September 19, 2023, 07:19:59 AM
Quote from: sy on September 18, 2023, 11:06:08 PM
Hi all,

1.15 has fixes for the report charts. Can you try the reports after the update?

Still has the same problem.
For me, this ended up being a version issue.  Elasticsearch 8.1 deprecated the use of 'interval' and changed it to 'fixed_interval'.  I went through and modified  the impacted templates under Zenarmor to restore the charts.  As part of that journey, I also created similar charts directly in Grafana to remove the need to log into the firewall all the time so that's now my primary reviewing tool. I logged the bug with Zenarmor support and they say this will be sorted in a future release.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: jbhorner on January 22, 2024, 08:56:34 PM
This is still a problem, as of 1.16.1. Understanding that this may be a version issue with Elasticsearch, 8.X and later is their latest version. (I think 8.12 is the latest as of this post's date.) Given the initiatation date of this thread, and the time that has elapsed, I'm surprised this has not been resolved.

If it is known not to work with certain versions of Elastic search, it should be checked prior to moving forward with the "external Elasticsearch" option. Worst case, don't provide the option. For individuals that are implementing Zenarmor for the first time, there will be time wasted trying to understand what is wrong--why certain reports do not display. It seems like a better solution to fix the defect, or prevent installation on a version that is known to not work correctly. Had I not stumbled on this thread (and it wasn't easy to find in a search), I would have continued to scratch my head and waste time.

Like others, I have a fundamental dislike of having my firewall/router also serving as a reporting database server.
Title: Re: Zenarmor 1.14: External Elastic database - no data available in reports
Post by: sy on January 26, 2024, 08:22:10 PM
Hi,

Thanks for the valuable feedback. I'm going to forward the suggestion to the team.