Hello, I'm trying to set up a logstash pipeline that does an enrichment lookup via the jdbc_static plugin, calling a MariaDB database via the MySQL jdbc connector. Aside - I tried doing it initially with the MariaDB connector, but that doesn't appear to be supported at this time.
It looks like it's initially able to connect with the config as is (no complaints about the table or database, which I saw when I had minor mistakes in my configuration), but I see the following error when we get to filling the Derby database:
LogStash::Filters::Jdbc::LoaderJdbcException: Exception when filling lookup db from loader query results, original exception: Java::JavaSql::SQLNonTransientConnectionException, original message: No current connection
There's no other context given, even with log.level at 'trace'. The closest comparison to what I'm seeing was this github link:
I'm using logstash and filebeat 6.2.4, so this should be fixed/not the issue. Any idea what I might be missing? I've checked the MariaDB and it's up and running, and I can connect with the same user and password I'm configured for in the pipeline.