You can translate the question and the replies:

Setting up Denodo MySQL connection for AD user

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 MySQL version 5.7.13
12-01-2017 15:19:52 -0500

1 Answer

Hi, I think the other way to make a successful connection to MySQL database using Active directory other than setting LIBMYSQL_ENABLE_CLEARTEXTPLUGIN=1 in the environment variable is to disable pluggable authentication module while creating a connection. You can do this by including this property in JDBC connection URL: disabledAuthenticationPlugins=mysql_clear_password You can navigate to Driver Properties in Configuration tab of the data source in VDP Admin Tool and add this property in it. Hope this helps!
Denodo Team
30-01-2017 19:32:50 -0500
You must sign in to add an answer. If you do not have an account, you can register here