This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can't setup mySQL monitoring

Hi guys!

Can anybody help to fix ant issue with MySQL monitoring? Please see attached log.

1447.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

Parents
  • Hello,

    What version of MySQL is being monitored? 

    This error can occur when trying to connect to a 5.1 MySQL database. The MySQL 8.0.12 driver does not support 5.1 MySQL databases. In this situation our recommendation would be to try to use an older cartridge that uses a driver that still supports MySQL 5.1. Quest Support can assist with providing a compatible cartridge.

    John

  • Hi John

    Thank you for advice. We've tried with 5.1.73 and 5.6. Now I'm using a trial and don't have access to Quest Support. Do you have older version cartridge? It will be great if you could upload it on any public file share.

  • I regret that we would not be able to upload an older version of the cartridge to a public file share due to GDPR Compliance Regulations.

    The Quest Customer Representative assisting with your trial installation should be able to assist you with obtaining either the cartridge or arranging with our Support Administrators for a login into the Supportlink website.

Reply
  • I regret that we would not be able to upload an older version of the cartridge to a public file share due to GDPR Compliance Regulations.

    The Quest Customer Representative assisting with your trial installation should be able to assist you with obtaining either the cartridge or arranging with our Support Administrators for a login into the Supportlink website.

Children
No Data