You don't need the default template. The default template is predefined and is only shown here for reference. You need to define a new template with your contents (of course it has to render into a proper SQL statement) and call the action with template given as additional parameter. Like

*.* action(type="ommysql" server="localhost" db="rsyslog" uid="rsyslog" pwd="fake_password" templat="my_mysql_template")

And how to filter... oh man, that's soooo huge topic.
You can read the archives on this list for examples how rulesets work with rsyslog.

On 26.11.2023 14:37, Ioan Popa via rsyslog wrote:
Thank you very much, dear Mariusz.

I saw that page, but I couldn't even find the location of the default template, much less how to create my own templates. This page contains a single, lonely example ;-)

Where is the default template located? How do I create my own template? How do I specify the filtering rules as well as the target database?

Ioan


_______________________________________________
rsyslog mailing list
https://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of 
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE 
THAT.

Reply via email to