You can translate the question and the replies:

Using MySQL and AD account for Denodo Cache

We are trying to use MySQL for Denodo Cache when we are configuring MySQL connection details in Denodo we are getting following error "Unable to establish connection Unknow error 1044" We are using AD/LDAP id create in MySQL database to connect from Denodo When I am using id created with in MySQL database connection is working, but when we are using AD id created in MySQL it is giving error. Note: Connect to database from command line using LDAP/AD id is working fine. When we tested connection we did set environment variable "export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1" on Linux server and then executef mysql -u userid -p -P port Other way of setting the same parameter from command line is using "--enable-cleartext-plugin" command line option. mysql -u userid -p -P port --enable-cleartext-plugin My question is how to set database connection property LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1 in Denodo while configuring MySQL databsae connection using LDAP/AD id or How can we pass command line option "--enable-cleartext-plugin" while setting up MySQL database in Denodo
12-01-2017 15:17:53 -0500

1 Answer

Hi, I think you need to set a property: disabledAuthenticationPlugins=mysql_clear_password in JDBC connection URL to connect to MySQL using AD. You might also want to refer to this community question in which the similar issue has been addressed: Hope this helps!
Denodo Team
30-01-2017 19:37:49 -0500
You must sign in to add an answer. If you do not have an account, you can register here