Cant' setup SQL monitoring

Question

Hi guys

Can anybody help me to understand how to fix an issue? Here is agent setupl log.

Cartridge version is 5.9.3.20, MySQL version is 5.6 (the same issue also with 5.1.73)

2019-03-28 13:49:46.578 VERBOSE [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Creating agent
2019-03-28 13:49:46.617 INFO [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Created agent
2019-03-28 13:49:46.617 VERBOSE [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Starting data collection
2019-03-28 13:49:47.212 ERROR [FglAM:IncomingMessage[4]-16] com.sma.mysql.agent.VersionInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Error retrieving server version.
java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

..remaining part of this log was attached.

dev_2019-03-28_134915_001.log

2019-03-28 13:49:46.578 VERBOSE [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Creating agent
2019-03-28 13:49:46.617 INFO    [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Created agent
2019-03-28 13:49:46.617 VERBOSE [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Starting data collection
2019-03-28 13:49:47.212 ERROR   [FglAM:IncomingMessage[4]-16] com.sma.mysql.agent.VersionInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again:  Error retrieving server version.
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.VersionInfo.refresh(VersionInfo.java:50)
	at com.sma.mysql.agent.VersionInfo.<init>(VersionInfo.java:45)
	at com.sma.mysql.util.ConnectionFactory.newFactory(ConnectionFactory.java:51)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:73)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 41 more

2019-03-28 13:49:47.434 ERROR   [FglAM:IncomingMessage[4]-16] com.sma.mysql.agent.HostInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again:  Error retrieving host info.
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.HostInfo.queryAndSetHostName(HostInfo.java:36)
	at com.sma.mysql.agent.HostInfo.<init>(HostInfo.java:25)
	at com.sma.mysql.util.ConnectionFactory.newFactory(ConnectionFactory.java:54)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:73)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 41 more

2019-03-28 13:49:47.582 ERROR   [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Failed to start data collection
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.ConnectionManager.testConnection(ConnectionManager.java:157)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:88)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 39 more

2019-03-28 13:49:47.583 VERBOSE [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Stopping data collection
2019-03-28 13:49:47.583 INFO    [FglAM:IncomingMessage[4]-16] com.quest.glue.core.agent.AgentInstance - Stopped data collection
2019-03-28 13:49:52.511 VERBOSE [FglAM:IncomingMessage[4]-17] com.quest.glue.core.agent.AgentInstance - Starting data collection
2019-03-28 13:49:52.650 ERROR   [FglAM:IncomingMessage[4]-17] com.sma.mysql.agent.VersionInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again:  Error retrieving server version.
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.VersionInfo.refresh(VersionInfo.java:50)
	at com.sma.mysql.agent.VersionInfo.<init>(VersionInfo.java:45)
	at com.sma.mysql.util.ConnectionFactory.newFactory(ConnectionFactory.java:51)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:73)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 41 more

2019-03-28 13:49:52.729 ERROR   [FglAM:IncomingMessage[4]-17] com.sma.mysql.agent.HostInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again:  Error retrieving host info.
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.HostInfo.queryAndSetHostName(HostInfo.java:36)
	at com.sma.mysql.agent.HostInfo.<init>(HostInfo.java:25)
	at com.sma.mysql.util.ConnectionFactory.newFactory(ConnectionFactory.java:54)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:73)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 41 more

2019-03-28 13:49:52.811 ERROR   [FglAM:IncomingMessage[4]-17] com.quest.glue.core.agent.AgentInstance - Failed to start data collection
java.sql.SQLNonTransientConnectionException: 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:832)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.sma.mysql.util.ConnectionFactory.newConnection(ConnectionFactory.java:129)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:149)
	at com.sma.mysql.util.ConnectionFactory.getConnection(ConnectionFactory.java:159)
	at com.sma.mysql.agent.ConnectionManager.testConnection(ConnectionManager.java:157)
	at com.sma.mysql.agent.ConnectionManager.<init>(ConnectionManager.java:88)
	at com.sma.mysql.agent.MySQLAgentImpl.startDataCollection(MySQLAgentImpl.java:126)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.glue.core.services.EquivalenceInvocationHandler.handleInvocation(EquivalenceInvocationHandler.java:60)
	at com.quest.common.proxy.AbstractEquivalenceInvocationHandler.invoke(AbstractEquivalenceInvocationHandler.java:83)
	at com.quest.glue.core.agent.AgentInteractionHandler.invoke(AgentInteractionHandler.java:188)
	at com.sun.proxy.$Proxy90.startDataCollection(Unknown Source)
	at com.quest.glue.core.agent.AgentInstance.startDataCollectionImpl(AgentInstance.java:1349)
	at com.quest.glue.core.agent.AgentInstance.startDataCollection(AgentInstance.java:1325)
	at com.quest.glue.core.agent.AgentInstance.changeState(AgentInstance.java:849)
	at com.quest.glue.core.agent.AgentInstance.setRequestedAgentState(AgentInstance.java:880)
	at com.quest.glue.core.agent.StateChangeRequestProcessor.setAgentStateUnderLock(StateChangeRequestProcessor.java:91)
	at com.quest.glue.core.agent.AgentInstance.handleStateChangeMessage(AgentInstance.java:729)
	at com.quest.glue.core.comms.handlers.SetAgentStateListener.processStateChangeRequest(SetAgentStateListener.java:32)
	at com.quest.glue.core.comms.handlers.AbstractStateChangeMessageHandler.newDownstreamMessage(AbstractStateChangeMessageHandler.java:64)
	at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.quest.common.util15.ConcurrentListenerManager$Handler.invoke(ConcurrentListenerManager.java:169)
	at com.sun.proxy.$Proxy28.newDownstreamMessage(Unknown Source)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newDownstreamMessage(AbstractIncomingQueue.java:412)
	at com.quest.glue.common.comms.queues.AbstractIncomingQueue.newMessage(AbstractIncomingQueue.java:346)
	at com.quest.glue.common.comms.queues.MultithreadedIncomingQueue$Executor.call(MultithreadedIncomingQueue.java:261)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:223)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1443)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:952)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
	... 39 more

2019-03-28 13:49:52.811 VERBOSE [FglAM:IncomingMessage[4]-17] com.quest.glue.core.agent.AgentInstance - Stopping data collection
2019-03-28 13:49:52.811 INFO    [FglAM:IncomingMessage[4]-17] com.quest.glue.core.agent.AgentInstance - Stopped data collection

John.Sakalauskas · Answer

CLIENT_PLUGIN_AUTH errors often occur when trying to a database that is not supported with the MySQL driver included in the cartridge. The 5.9.3.20 cartridge includes a MySQL connector 8.0.12 driver. As an example, cartridges such as the 5.7.5.90 cartridge include an older MySQL 5.1.39. 
 In this situation our recommendation would be to try to use an older cartridge that uses a driver that still supports older MySQL versions. Quest Support can assist with this issue. If you cannot access Quest Support, your Sales or Customer Care representative should be able to assist with obtaining an account. 
 Due to GDPR Compliance Regulations we are unable to upload a cartridge to public file hosting websites.