Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin user

Solved Go to solution
Highlighted

Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin user

Expert Contributor

MySQL 5.7 is listed as supported DB version. However, Cloudera Director generates passwords not suitable for 5.7 standard. Application log is shown as follows:

[2017-01-24 22:46:13] INFO [io-thread-38] - ssh:10.3.1.154: [ main] DbProvisioner ERROR Stack Trace:
[2017-01-24 22:46:13] INFO [io-thread-38] - ssh:10.3.1.154: java.sql.SQLException: Your password does not satisfy the current policy requirements
[2017-01-24 22:46:13] INFO [io-thread-38] - ssh:10.3.1.154: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)[mysql-connec
tor-java.jar:]

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin use

Expert Contributor

Hello zhuw.bigdata,

 

This is a known issue with Director's automated generation of passwords for MySQL databases. There is a fix for it included with Director 2.3, which is due to be released soon. In the meantime, you can try adjusting the password validation level in MySQL 5.7 to LOW, instead of the default MEDIUM, and Director's passwords should be accepted.

 

Director uses ordinary random UUIDs as passwords, and they fail the MEDIUM level of MySQL password validation because they lack an uppercase letter (and may, in very rare cases, lack either a lowercase letter or a number).

3 REPLIES 3

Re: Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin use

Expert Contributor

Hello zhuw.bigdata,

 

This is a known issue with Director's automated generation of passwords for MySQL databases. There is a fix for it included with Director 2.3, which is due to be released soon. In the meantime, you can try adjusting the password validation level in MySQL 5.7 to LOW, instead of the default MEDIUM, and Director's passwords should be accepted.

 

Director uses ordinary random UUIDs as passwords, and they fail the MEDIUM level of MySQL password validation because they lack an uppercase letter (and may, in very rare cases, lack either a lowercase letter or a number).

Re: Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin use

Expert Contributor
Thanks. As a workaround, I just disable password validation via ansible script right after mysql initial installation.

Re: Cloudera Director should support password validation in MySQL 5.7.x or disable it with admin use

New Contributor

# cp /etc/my.cnf /etc/my.cnf.default
# vim /etc/my.cnf
--------------------------------
[mysqld]
# Disable password validaion plugin
validate-password=off
--------------------------------
# systemctl restart mysqld

Don't have an account?
Coming from Hortonworks? Activate your account here