I am trying to add an action "Log to database - new bulk insert" to one of my rules via the web UI.
I can't get it to work with MySQL. I have MySQL installed on the same server. When using the "Test connection", i don't get any feedback other than "Connection to database works". I get the same result whether I use correct data or not.
Also it seems like the "SQL server connection string" field is buggy. The data I have entered is hidden unless I click the field. I have however confirmed that the connection string is saved, because it is present in this text file: SolarWinds.Kiwi.Syslog.RuleProcessing.Dal.RuleProcessingDefinitionsSettings.json
All documentation I have found is related to the previous version (not NG) and it suggests using ODBC drivers and setting up System DSN. I have tried this as well, but I still have not managed to get it to work. Troubleshooting is very difficult right now because the message says that it works regardless of what I do, yet it creates no records in the DB.
Out of curiosity I tried to set it up with Microsoft SQL, and I can see that the rule is creating new records in the table. However, I can't use MS SQL in this scenario for reasons.