db.mariadb

[ 1 Introduction ] [ 2 Valid tags and data tables ] [ 3 Send it ] [ 4 Table structure ]

Introduction

The tags beginning with db.mariadb identify events belonging to MariaDB.

Valid tags and data tables

The full tag must have four levels. The first two are fixed as db.edb. The third level identifies the type of events sent. The fourth level indicates the event subtype.

These are the valid tags and corresponding data tables that will receive the parsers' data:

Product / Service	Tags	Data tables

Product / Service	Tags	Data tables
MariaDB Server	`db.mariadb.audit.event`	`db.mariadb.audit.event`

For more information, read more about Devo tags.

Send it

Data should be sent using the relay.

Example relay rules

         Source message: 
            Source data: 
             Source tag: 
             Target tag: db.mariadb.audit.event
Sent without syslog tag: false
        Stop processing: true

Table structure

db.mariadb.audit.event

Field	Type	Field transformation	Source field name	Extra field

Field	Type	Field transformation	Source field name	Extra field
eventdate	`timestamp`
machine	`str`
server_host	`str`	`server_host_list[length(server_host_list) - 1]`	server_host_list
syslog_info	`str`	`substring(_server_host, 0, (length(_server_host) - length(server_host) - 1))`	server_host _server_host
username	`str`
hostname	`str`
connection_id	`str`
query_id	`str`
operation	`str`
database	`str`
retcode	`str`	`object_retcode_list[length(object_retcode_list) - 1]`	object_retcode_list
object	`str`	`substring(object_retcode, 0, (length(object_retcode) - length(retcode) - 1))`	object_retcode retcode
hostchain	`str`			✓
tag	`str`			✓
rawMessage	`str`			✓

Devo latest