[syslog-ng] mysql destinations - more options for table creation

Nik Ambrosch nik at ambrosch.com
Mon Mar 6 18:58:09 UTC 2017

Table name (macros) are not the issue, here is how I’m currently creating a table:

destination mysql {
	host("localhost") username("syslog") password("xxx")
	columns("id int(11) unsigned not null auto_increment primary key", "host varchar(40) not null", "facility varchar(20)", "priority varchar(10)", "level varchar(10)", "program text", "date date not null", "time time not null", "message text not null")

This creates a table like this:

syslog_20170306 | CREATE TABLE `syslog_20170306` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `host` varchar(40) NOT NULL,
  `facility` varchar(20) DEFAULT NULL,
  `priority` varchar(10) DEFAULT NULL,
  `level` varchar(10) DEFAULT NULL,
  `program` text,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `syslog_20170306_id_idx` (`id`),
  KEY `syslog_20170306_host_idx` (`host`),
  KEY `syslog_20170306_priority_idx` (`priority`)

That is the output from my old syslog server, the new will be using InnoDB tables, not MyISAM, as listed.  If you notice the last parameters, starting with “ENGINE” - that is where the additional parameters can be added.  in a compressed table you would append a ROW_FORMAT variable.  Here is a little information if you’re curious:


> On Mar 6, 2017, at 1:46 PM, Fekete, Róbert <robert.fekete at balabit.com> wrote:
> Hi, 
> syslog-ng can automatically create tables if you use macros in the table names. 
> As for additional options, newer syslog-ng versions have a dbd-option() that can be used to set database options when syslog-ng connects the database (it might or might not be enough for your needs), see https://www.balabit.com/documents/syslog-ng-ose-latest-guides/en/syslog-ng-ose-guide-admin/html/reference-destination-sql.html <https://www.balabit.com/documents/syslog-ng-ose-latest-guides/en/syslog-ng-ose-guide-admin/html/reference-destination-sql.html>
> HTH, 
> Robert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.balabit.hu/pipermail/syslog-ng/attachments/20170306/bc1ac8b4/attachment.html>

More information about the syslog-ng mailing list