I'm using Logstash to pull logs from MySQL Database server. In the Logstash configuration file, I'm using a domain-joined service account for the DB server, but I'm encountering an authentication error in the log messages. Is there any guideline indicating that domain-joined service accounts might not work, and that I need to create a SQL account instead?
Although it is technically possible to use domain-joined service accounts with MySQL, this usually requires additional configurations on the MySQL server, which can complicate the process.
The more practical and reliable solution is to create a native MySQL user account specifically for this purpose, if your organization's security policy allows it. This will simplify the integration with Logstash and reduce the likelihood of authentication issues.
Thanks for the reply, will do as you suggested,. However, any chance that you have a sample configuration file with domain account?