fluent-plugin-mssql-lookup

Fluentd filter plugin that resolves additional fields via a database lookup

In order to communicate with the SQL Server database, we use FreeTDS Consequently this will need to be installed in order to use the plugin.

A Docker image has been included that extends the Kubernetes provided one here

Requirements

fluent-plugin-filter-geoip	fluentd	ruby
1.x.x	>= 0.14.0, < 2	>= 2.1

$ gem install fluent-plugin-mssql-lookup

Add following line to your Gemfile:

gem "fluent-plugin-mssql-lookup"

And then execute:

$ bundle

The user name to use to connect to the database

db_user myuser

The password to use to connect to the database

db_password mypassword

The database server host name or ip address

db_host mydbserver

The name of the database to connect to

db_name mydb

The database port to connect to (default 1433)

db_port 1433

The SQL to execute to populate the lookup list

lookup_sql "SELECT ID, Field1, Field2 FROM mytable"

The field within the lookup list that will be used to join to the event key field

lookup_key ID

The recurring interval (in seconds) at which to refresh the lookup list (default 600)

lookup_interval 1200

The key field in the event

key id