Azure Database for MySQL - AAD Authentication + ClearText Plugin

[Adam Coulter]

We are trying to use ProxySQL for caching / retry / connection pooling / etc for our PHP application. The database is hosted using Azure Database for MySQL, and the application is hosted in Azure App Services for containers.

We need to use an OAuth token to authenticate from ProxySQL to the Azure MySQL server. This token can be set in ProxySQL as a user password in clear text, using an hourly script to handle token rotation. In order to authenticate to Azure MySQL, the enable-cleartext-plugin option needs to be specified, as the OAuth token needs to be provided in clear text over a TLS connection.

We need help on how to configure this, as we seem to be stuck with how to enable the cleartext-plugin even though this GitHub issue 1168 says it has been implemented.

Also, how do we setup the client/backend user passwords to be different?

[Derek Downey]

What version of ProxySQL are you using?

Regarding this: 

Also, how do we setup the client/backend user passwords to be different?

It's not possible currently.

[Adam Coulter]

Version 2.x, try and stay up to date.

Without the ability to set different passwords, how would you suggest we proceed?

[Sakti Soumyakanta]

Is Azure AAD based authentication is still not supported by Proxysql?