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.