Datasource creation says: CLIENT_PLUGIN_AUTH is required

#1

Dear Team, we’re in the process of adding Lucee to one of our environments. The installs on this Apache instance are…

Lucee 5.3.2.77
MySQLVer 8.42 Distrib 5.1.73

When wse use Lucee to create a Datasource, we get this red flag warning/fail message = CLIENT_PLUGIN_AUTH is required, and the details are listed below.

Any ideas??

Hope you can assist. Thanks so much :slight_smile:

Dutch


lucee.runtime.exp.NativeException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:79) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) at lucee.runtime.db.DataSourceSupport._getConnection(DataSourceSupport.java:110) at lucee.runtime.db.DataSourceSupport.getConnection(DataSourceSupport.java:91) at lucee.runtime.tag.Admin._doVerifyDatasource(Admin.java:2866) at lucee.runtime.tag.Admin.doUpdateDatasource(Admin.java:2642) at lucee.runtime.tag.Admin._doStartTag(Admin.java:703) at lucee.runtime.tag.Admin.doStartTag(Admin.java:336) at services_datasource_create_cfm1334$cf.call(/admin/services.datasource.create.cfm:79) at etc. etc. etc. etc. etc.

#2

Hi,

For MySQL 5.1.73, Couldn’t able to create the data source with the latest MySQL connector(Extension) 8.0.14. You’ve to downgrade the MySQL extension into 5.1.20, then only you can create the data source.

1 Like