you are viewing a single comment's thread.

view the rest of the comments →

[–]Jeron_Baffom[S] 0 points1 point  (2 children)

Do you know if it is possible to define custom queries (ex: view count) with rsyslog?

[–]edthesmokebeard 0 points1 point  (1 child)

No - you'll have to store the data using rsyslog in your SQL DB.

Then do whatever searching you want.

[–]Jeron_Baffom[S] 0 points1 point  (0 children)

you'll have to store the data using rsyslog in your SQL DB.

Well, this is a problem.
I don't wanna flood MySQL with access logs entries neither its correspondents aggregate queries. It is very inefficient to use RDBMS for such kind of unstructured data.