For one of my web application (which is a syslog web frontend) I am logging syslog messages into a MariaDB database. I am not using the default Rsyslog template, I am using a different database and tables so I had to write my own template. My mysql.conf for rsyslog looks like:
For my web application I created the Log_Messages table like shown in the SQL query below. Also note I’m using a fulltext index for the log message.