Kiwi Syslog NG - Log to MySQL - Database schema

WiggyJiggyJed

I notice that Kiwi Syslog NG since v1.5 now supports bulk insert to additional databases, including MySQL.

I had built an process that logged to XML and then used a Scheduled Task to parse the XML and do bulk inserts into MySQL.

Since it is now natively supported, I was considering reconfiguring my logging rules to use the native functionality.

Where can I find the schema for the table (I suspect it is the same, regardless the DB engine)? I want to use my existing table, but I want to makes sure everything maps correctly before cutting over. I realize I could just create a new table, but was hoping to avoid that.

Thanks,

E

WiggyJiggyJed

so, I ended up just creating a temporary table in the same database to get the schema.

CREATE TABLE syslogd (
MsgDate date DEFAULT NULL,
MsgTime time DEFAULT NULL,
MsgPriority varchar(30) DEFAULT NULL,
MsgHostname varchar(255) DEFAULT NULL,
MsgText varchar(4096) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;