Add rsyslog logs to MySQL

[Ayaya2024]

Expected behavior

I want to add the logs generated by rsyslog in real-time to the MySQL database

Actual behavior

There is no data in the database

Steps to reproduce the behavior

According to the example，add the following message to the rsyslog.com configuration file:
$ModLoad ommysql
. :ommysql:localhost,database_name,account,password

In addition, after installing rsyslog, I did not have the configuration file createDB.SQL explained on the official website

Environment

• rsyslog version: rsyslog: 8.32.0-1ubuntu4
• platform:
  -rsyslog-mysql version 8.32.0-1ubuntu4

[davidelang]

8.32 is many years old at this point, if it is baing maintained at all, it's by Ubuntu doing backports of some things to it. As such there has been development and fixed that may or may not be in your version. First off, try switching to the action() format, for things that are more complex (like this) they tend to make it clearer what's happening. second, are you getting any messages in mysql logs (failed login, failed insert, etc) David Lang

…

On Mon, 6 May 2024, Ayaya2024 wrote: Date: Mon, 06 May 2024 03:48:22 -0700 From: Ayaya2024 ***@***.***> Reply-To: rsyslog/rsyslog ***@***.***> To: rsyslog/rsyslog ***@***.***> Cc: Subscribed ***@***.***> Subject: [rsyslog/rsyslog] Add rsyslog logs to MySQL (Issue #5374) ### Expected behavior I want to add the logs generated by rsyslog in real-time to the MySQL database ### Actual behavior There is no data in the database ### Steps to reproduce the behavior According to the example，add the following message to the rsyslog.com configuration file: $ModLoad ommysql *.* :ommysql:localhost,database_name,account,password In addition, after installing rsyslog, I did not have the configuration file createDB.SQL explained on the official website ### Environment - rsyslog version: rsyslog: 8.32.0-1ubuntu4 - platform: <!-- Ubuntu 18.04 LTS --> -rsyslog-mysql version 8.32.0-1ubuntu4