Lookup table using data stored in MySQL?

[Roeeklinger60]

Hey,

I have some data stored in MySQL (that is updated every 60 seconds), I would like to set up an extractor that will take every message in Graylog, perform a lookup in MySQL and add this data to the message.

I have searched a bit online but did not find a real answer, what is the best way to do that?

I know I can use CRON to convert the DB into CSV every minute and use that as a lookup, but that seems like a weird way to implement this?

Thanks

[shoothub]

It’s probably the simpliest option if you don’t want to program own lookup adapter.

Or use DSV File from HTTP Adapter, if you want to use DSV file from web.
https://docs.graylog.org/en/4.0/pages/lookuptables.html#dsv-file-from-http-adapter