a bit [offtopic] but may not. syslog search solution for free
Hi, Our new central syslog collect&store system are almost complete and finally it is based on Syslog-ng OSE. The only issue I want to solve, is how to present those logs to the users. Originally I thought it would be enough if they will get the directories as NFS exports and they can use their favourite grep to search files, but I thought maybe I can implement some more user friendly solution. In the planning phase of the project, I've tested various solutions including Graylog, ELK and of course I'm aware of the beauty of SSB :) , but all of these solutions are too expensive for this project. Then I thought maybe if I forward the logs to some database (SQL or noSQL) I can try to find some very simple frontend for that DB provides a simple search interface for those logs. Nothing fancy is required, but AD auth should be an option. I'm sure I'm not the only one facing this issue, so I hope someone in the community can share some previous experience on this Thanks Vlad
Hi Vlad, You might want to add some requirements so others know what you are aiming at: - Are you looking for a self-hosted/on-prem solution, or would cloud solutions work? - What is the expected amount of log traffic? - Do you need commercial support? (Or why is ELK/ESK too expensive?) Cheers, Robert ________________________________________ From: syslog-ng <syslog-ng-bounces@lists.balabit.hu> on behalf of Pal, Laszlo <vlad@vlad.hu> Sent: Tuesday, September 17, 2019 09:16 To: Syslog-ng users' and developers' mailing list Subject: [syslog-ng] a bit [offtopic] but may not. syslog search solution for free CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe. Hi, Our new central syslog collect&store system are almost complete and finally it is based on Syslog-ng OSE. The only issue I want to solve, is how to present those logs to the users. Originally I thought it would be enough if they will get the directories as NFS exports and they can use their favourite grep to search files, but I thought maybe I can implement some more user friendly solution. In the planning phase of the project, I've tested various solutions including Graylog, ELK and of course I'm aware of the beauty of SSB :) , but all of these solutions are too expensive for this project. Then I thought maybe if I forward the logs to some database (SQL or noSQL) I can try to find some very simple frontend for that DB provides a simple search interface for those logs. Nothing fancy is required, but AD auth should be an option. I'm sure I'm not the only one facing this issue, so I hope someone in the community can share some previous experience on this Thanks Vlad
Hi, These are not my personal experiences, but talking to thousands of syslog-ng users at different events: * Many are happy with grep and hate anything with a GUI. It works relatively well, if you have many small log files (separated by date, host, application, etc.), but if you have lots of logs, you can't avoid message parsing and indexing for efficient search. * Splunk is one of the most popular destinations with syslog-ng. OSE users tend to use the free version, which can index up to 500MB of logs a day. * Elasticsearch is the other most popular destination. With the latest version most of the security features are included in the open source version for free, so it does not need 3rd party extensions or a commercial license any more. * Graylog is also getting popular among syslog-ng users. We can feed it with structured log messages in multiple ways: either GELF or JSON. Free, open source, but commercial extensions and support are available. * I did not test recently, but Security Onion is a nice security analytic platform which also includes log management with analysis, dashboards, etc. It's free, open source, but commercial support is available. * Logzilla is focused on Cisco network devices and automation but also works for generic log management. It is commercial software, but a free version is also available. Of course any time indexing and GUI are involved you need some extra hardware compared syslog-ng, so definitely more expensive even if you go with the free versions. Bye, Peter Czanik (CzP) <peter.czanik@oneidentity.com> Balabit (a OneIdentity company) / syslog-ng upstream https://syslog-ng.com/community/ https://twitter.com/PCzanik ________________________________ From: syslog-ng <syslog-ng-bounces@lists.balabit.hu> on behalf of Pal, Laszlo <vlad@vlad.hu> Sent: Tuesday, September 17, 2019 9:16 AM To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> Subject: [syslog-ng] a bit [offtopic] but may not. syslog search solution for free CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe. Hi, Our new central syslog collect&store system are almost complete and finally it is based on Syslog-ng OSE. The only issue I want to solve, is how to present those logs to the users. Originally I thought it would be enough if they will get the directories as NFS exports and they can use their favourite grep to search files, but I thought maybe I can implement some more user friendly solution. In the planning phase of the project, I've tested various solutions including Graylog, ELK and of course I'm aware of the beauty of SSB :) , but all of these solutions are too expensive for this project. Then I thought maybe if I forward the logs to some database (SQL or noSQL) I can try to find some very simple frontend for that DB provides a simple search interface for those logs. Nothing fancy is required, but AD auth should be an option. I'm sure I'm not the only one facing this issue, so I hope someone in the community can share some previous experience on this Thanks Vlad
Hi, Thanks for the answers. So, I definitely need an onprem solution and yes, Elastic is a good idea, however based on my previous research even the OS version is restricted to some amount of daily log. Maybe I'm wrong and in this case I may give a try again. At this point I don't know how much logs will I ingest daily but because it is more than 30K devices including core routers, firewalls and all sort of servers, I don't think any traffic limited solution will be sufficient. Graylog is a very good solution which I already tested but the "free" version is limited to something like 50 Mbyet per day. I'll check this onion thingy, thank you Peter for the heads up Vlad On Tue, Sep 17, 2019 at 10:01 AM Peter Czanik (pczanik) < Peter.Czanik@oneidentity.com> wrote:
Hi,
These are not my personal experiences, but talking to thousands of syslog-ng users at different events:
- Many are happy with grep and hate anything with a GUI. It works relatively well, if you have many small log files (separated by date, host, application, etc.), but if you have lots of logs, you can't avoid message parsing and indexing for efficient search. - Splunk is one of the most popular destinations with syslog-ng. OSE users tend to use the free version, which can index up to 500MB of logs a day. - Elasticsearch is the other most popular destination. With the latest version most of the security features are included in the open source version for free, so it does not need 3rd party extensions or a commercial license any more. - Graylog is also getting popular among syslog-ng users. We can feed it with structured log messages in multiple ways: either GELF or JSON. Free, open source, but commercial extensions and support are available. - I did not test recently, but Security Onion is a nice security analytic platform which also includes log management with analysis, dashboards, etc. It's free, open source, but commercial support is available. - Logzilla is focused on Cisco network devices and automation but also works for generic log management. It is commercial software, but a free version is also available.
Of course any time indexing and GUI are involved you need some extra hardware compared syslog-ng, so definitely more expensive even if you go with the free versions.
Bye,
Peter Czanik (CzP) <peter.czanik@oneidentity.com> Balabit (a OneIdentity company) / syslog-ng upstream https://syslog-ng.com/community/ https://twitter.com/PCzanik
------------------------------ *From:* syslog-ng <syslog-ng-bounces@lists.balabit.hu> on behalf of Pal, Laszlo <vlad@vlad.hu> *Sent:* Tuesday, September 17, 2019 9:16 AM *To:* Syslog-ng users' and developers' mailing list < syslog-ng@lists.balabit.hu> *Subject:* [syslog-ng] a bit [offtopic] but may not. syslog search solution for free
CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.
Hi,
Our new central syslog collect&store system are almost complete and finally it is based on Syslog-ng OSE. The only issue I want to solve, is how to present those logs to the users. Originally I thought it would be enough if they will get the directories as NFS exports and they can use their favourite grep to search files, but I thought maybe I can implement some more user friendly solution.
In the planning phase of the project, I've tested various solutions including Graylog, ELK and of course I'm aware of the beauty of SSB :) , but all of these solutions are too expensive for this project.
Then I thought maybe if I forward the logs to some database (SQL or noSQL) I can try to find some very simple frontend for that DB provides a simple search interface for those logs. Nothing fancy is required, but AD auth should be an option.
I'm sure I'm not the only one facing this issue, so I hope someone in the community can share some previous experience on this
Thanks Vlad
______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.balabit.com/wiki/syslog-ng-faq
On Tue, Sep 17, 2019 at 10:55:04AM +0200, Pal, Laszlo wrote:
Thanks for the answers. So, I definitely need an onprem solution and yes, Elastic is a good idea, however based on my previous research even the OS version is restricted to some amount of daily log. Maybe I'm wrong and in
It's not. By all means grab the -oss packages, they don't contain any non-free code.
participants (4)
-
Fabien Wernli
-
Pal, Laszlo
-
Peter Czanik (pczanik)
-
Robert Fekete (rfekete)