• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 59 subscribers
  • Views 2119 views
  • Users 0 members are here
Options
Related
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

Cant' setup SQL monitoring

akasimov
over 5 years ago

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

Parents
  • 0 over 5 years ago

    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.

Reply
  • 0 over 5 years ago

    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.

Children
No Data