RDS mysql kerberos Authentication error

Question

Trying to setup a kerberos Authentication for RDS my SQL. AD is in the same VPC as RDS instance. followed the steps in the article https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-kerberos.html 
but when i login in command line, getting the below error ERROR 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: The specified module could not be found. Pls let us know if anyone faced similar issue

Answer

Based on the error message, it looks like you are encountering an issue loading the MySQL authentication plugin 'dialog' when trying to connect to your database.

Here are a few things you could check:
1. Make sure the dialog authentication plugin is installed correctly on your MySQL server. This plugin is not bundled by default.
2. Verify the plugin file (e.g. dialog.so) exists in the plugin directory specified by your MySQL configuration.
3. Check for any permission issues preventing MySQL from loading the plugin file.
4. Try reinstalling or upgrading the dialog plugin if still not found.
5. As a test, you can try connecting with a different authentication plugin (e.g. mysql_native_password) to narrow down if it's specific to dialog.
Review your MySQL error log for additional clues on why the plugin cannot be loaded.
Here is the same error messages: https://github.com/Sequel-Ace/Sequel-Ace/issues/201

RDS mysql kerberos Authentication error

Relevant content