Great to see it solved and thanks for the feedback! On Tue, 21 Jan 2020, 20:29 Ioan Marginean, <ionica.margin...@gmail.com> wrote:
> @Sean, > > You're right, after downgrade the java connector as you pointed out, I > re-gain my UI !!! > Thank you so much! > > @Andrija, > You also were right, look what where updated on 15th... > > Jan 15 11:44:08 Updated: mysql-community-common-5.6.47-2.el7.x86_64 > Jan 15 11:44:09 Updated: mysql-community-libs-5.6.47-2.el7.x86_64 > Jan 15 11:44:15 Updated: mysql-community-client-5.6.47-2.el7.x86_64 > Jan 15 11:44:27 Updated: mysql-community-server-5.6.47-2.el7.x86_64 > Jan 15 11:44:27 Updated: mysql-connector-python-8.0.19-1.el7.x86_64 > Jan 15 11:44:27 Updated: 1:mysql-connector-java-8.0.19-1.el7.noarch > > So , related to your second point I didn't had this version before. I had > installed CS on September last year. > Even better, I can confirm that I had > mysql-connector-java-5.1.25-3.el7.noarch installed. > > On 2020/01/21 18:02:37, Sean Lair <sl...@ippathways.com> wrote: > > Yea- that's the issue. We hit it also, you need to downgrade to the > non-8.x version... run this command to downgrade, note, you need to use > "yum upgrade" since it has a different epoc: > > > > yum upgrade mysql-connector-java-5.1.25 > > > > That will put you back on version 5.1.25 > > > > If this helps, could you please comment on this Issue ID? It is good to > track the details in the Issue in GitHub: > > > > https://github.com/apache/cloudstack/issues/3826 > > > > > > > > -----Original Message----- > > From: Ioan Marginean <ionica.margin...@gmail.com> > > Sent: Tuesday, January 21, 2020 11:55 AM > > To: users@cloudstack.apache.org > > Subject: Re: RE: Unable to authenticate in UI > > > > Hi Sean, > > > > I have the following output: > > > > mysql-connector-java.noarch 1:8.0.19-1.el7 > @mysql-connectors-community > > > > On 2020/01/21 17:41:44, Sean Lair <sl...@ippathways.com> wrote: > > > We are hitting a similar error message when doing other functions. > What version of the mysql-connector-java are you running? > > > > > > yum list installed mysql-connector-java > > > > > > > > > -----Original Message----- > > > From: Ioan Marginean <ionica.margin...@gmail.com> > > > Sent: Tuesday, January 21, 2020 7:46 AM > > > To: users@cloudstack.apache.org > > > Subject: Re: Unable to authenticate in UI > > > > > > Is it possible to reset password directly into the database? > > > Thank you. > > > > > > On 2020/01/21 11:55:18, Ioan Marginean <ionica.margin...@gmail.com> > wrote: > > > > Hello, > > > > > > > > I facing a strange situation related to UI authentication. After > restart cloudstack-management I can't authenticate. The restart was needed > because I change settings related to e-mail notifications. > > > > My configuration is: CS version = 4.13, KVM. On error log I got: > > > > > > > > 2020-01-21 13:47:04,111 DEBUG [c.c.a.ApiServlet] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) ===START=== 172.16.1.106 > -- POST > > > > 2020-01-21 13:47:04,117 DEBUG [c.c.u.AccountManagerImpl] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) Attempting to log in user: > alex in domain 1 > > > > 2020-01-21 13:47:04,119 DEBUG [o.a.c.s.a.PBKDF2UserAuthenticator] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) Retrieving user: alex > > > > 2020-01-21 13:47:04,556 DEBUG [c.c.u.AccountManagerImpl] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) CIDRs from which account > 'Acct[95411505-a071-419e-bf6d-65c94971c1ad-alex]' is allowed to perform API > calls: 0.0.0.0/0,::/0 > > > > 2020-01-21 13:47:04,556 DEBUG [c.c.u.AccountManagerImpl] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) User: alex in domain 1 has > successfully logged in > > > > 2020-01-21 13:47:04,557 DEBUG [c.c.u.d.T.Transaction] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) Rolling back the > transaction: Time = 1 Name = qtp504527234-32; called by > -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92-ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$Proxy129.persist:-1-ActionEventUtils.persistActionEvent:186-ActionEventUtils.onActionEvent:98-AccountManagerImpl.authenticateUser:2342 > > > > 2020-01-21 13:47:04,559 ERROR [c.c.a.ApiServlet] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) unknown exception writing > api response > > > > com.cloud.utils.exception.CloudRuntimeException: Problem with > getting the ec attribute > > > > at > com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1454) > > > > at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) > > > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > > > at java.lang.reflect.Method.invoke(Method.java:498) > > > > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) > > > > at > com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174) > > > > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) > > > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) > > > > at com.sun.proxy.$Proxy129.persist(Unknown Source) > > > > at > com.cloud.event.ActionEventUtils.persistActionEvent(ActionEventUtils.java:186) > > > > at > com.cloud.event.ActionEventUtils.onActionEvent(ActionEventUtils.java:98) > > > > at > com.cloud.user.AccountManagerImpl.authenticateUser(AccountManagerImpl.java:2342) > > > > at sun.reflect.GeneratedMethodAccessor200.invoke(Unknown Source) > > > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > > > at java.lang.reflect.Method.invoke(Method.java:498) > > > > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) > > > > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) > > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) > > > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) > > > > at com.sun.proxy.$Proxy125.authenticateUser(Unknown Source) > > > > at com.cloud.api.ApiServer.loginUser(ApiServer.java:1073) > > > > at > com.cloud.api.auth.DefaultLoginAPIAuthenticatorCmd.authenticate(DefaultLoginAPIAuthenticatorCmd.java:172) > > > > at > com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:214) > > > > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:130) > > > > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) > > > > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) > > > > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) > > > > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:127) > > > > at com.cloud.api.ApiServlet.doPost(ApiServlet.java:94) > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:706) > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) > > > > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:852) > > > > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) > > > > at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) > > > > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190) > > > > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) > > > > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168) > > > > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) > > > > at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166) > > > > at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) > > > > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > > > > at > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:527) > > > > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126) > > > > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) > > > > at org.eclipse.jetty.server.Server.handle(Server.java:530) > > > > at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:347) > > > > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:256) > > > > at org.eclipse.jetty.io > .AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) > > > > at org.eclipse.jetty.io > .FillInterest.fillable(FillInterest.java:102) > > > > at org.eclipse.jetty.io > .ChannelEndPoint$2.run(ChannelEndPoint.java:124) > > > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247) > > > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140) > > > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) > > > > at > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:382) > > > > at > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:708) > > > > at > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:626) > > > > at java.lang.Thread.run(Thread.java:748) > > > > Caused by: java.lang.IllegalArgumentException: Can not set long > field com.cloud.event.EventVO.id to java.math.BigInteger > > > > at > sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167) > > > > at > sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171) > > > > at > sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImpl.java:102) > > > > ... 69 more > > > > 2020-01-21 13:47:04,560 DEBUG [c.c.a.ApiServlet] > (qtp504527234-32:ctx-d36239ff) (logid:b2b6e874) ===END=== 172.16.1.106 -- > POST > > > > > > > > > > > > Any help would be appreciated... > > > > > > > > > >
