syslog-ng-users August 2011 archive
Main Archive Page > Month Archives  > syslog-ng-users archives
syslog-ng-users: Re: [syslog-ng] Store syslog occurrence frequen

Re: [syslog-ng] Store syslog occurrence frequency instead of adding all of them to the DB

From: Jakub Jankowski <shasta_at_nospam>
Date: Fri Aug 19 2011 - 16:57:57 GMT
To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu>

On 2011-08-19, syslogng@feystorm.net wrote:

> The idea that was mentioned is not without its flaws.
[...]
> Secondly using a 32-bit checksum of the message text to determine uniqueness
> is risky. It would be farily easy to end up with 2 different messages that
> have the same checksum. A md5 checksum would be much better, but I dont
> believe syslog-ng has a function to compute md5 sums.

One can delegate this task to the database itself. MySQL has MD5() as well
as SHA1() built in.

-- Jakub Jankowski|shasta_at_toxcorp.com|http://toxcorp.com/ GPG: FCBF F03D 9ADB B768 8B92 BB52 0341 9037 A875 942D ______________________________________________________________________________ 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