We actually had to downgrade the mysql-connector-java one - not the mysql-connector-python one
-----Original Message----- From: Andrija Panic <andrija.pa...@gmail.com> Sent: Tuesday, January 21, 2020 11:59 AM To: users <users@cloudstack.apache.org> Subject: Re: RE: Unable to authenticate in UI broken version - go to the older version. yum localinstall http://repo.mysql.com/yum/mysql-connectors-community/el/7/x86_64/mysql-connector-python-8.0.18-1.el7.x86_64.rpm 1. Did you update your system - can you check yum/apt logs if the connector was upgraded, please? 2. When was your system installed - i.e. can you confirm you have NOT installed it with that version of the connector, since I've seen cloudstack-setup-database failing with that connector version? If you system got broken due to updating the connector on the existing installation - then this warrants an email to everyone if that is the case Please do check and let me know. Thanks Andrija On Tue, 21 Jan 2020 at 18:54, Ioan Marginean <ionica.margin...@gmail.com> wrote: > 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-Trans > actionLegacy.close:657-TransactionContextInterceptor.invoke:36-Reflect > iveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92- > ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$ > Proxy129.persist:-1-ActionEventUtils.persistActionEvent:186-ActionEven > tUtils.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(DelegatingMethodAccess > orImpl.java:43) > > > at java.lang.reflect.Method.invoke(Method.java:498) > > > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflectio > n(AopUtils.java:338) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi > npoint(ReflectiveMethodInvocation.java:197) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:163) > > > at > com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionCon > textInterceptor.java:34) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:174) > > > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke > (ExposeInvocationInterceptor.java:92) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:185) > > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamic > AopProxy.java:212) > > > at com.sun.proxy.$Proxy129.persist(Unknown Source) > > > at > com.cloud.event.ActionEventUtils.persistActionEvent(ActionEventUtils.j > ava:186) > > > at > com.cloud.event.ActionEventUtils.onActionEvent(ActionEventUtils.java:9 > 8) > > > at > com.cloud.user.AccountManagerImpl.authenticateUser(AccountManagerImpl. > java:2342) > > > at sun.reflect.GeneratedMethodAccessor200.invoke(Unknown Source) > > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess > orImpl.java:43) > > > at java.lang.reflect.Method.invoke(Method.java:498) > > > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflectio > n(AopUtils.java:338) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi > npoint(ReflectiveMethodInvocation.java:197) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:163) > > > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke > (ExposeInvocationInterceptor.java:92) > > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:185) > > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamic > AopProxy.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(Defaul > tLoginAPIAuthenticatorCmd.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.cal > l(DefaultManagedContext.java:56) > > > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callW > ithContext(DefaultManagedContext.java:103) > > > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWi > thContext(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.ja > va: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(ScopedHandle > r.java:190) > > > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandle > r.java:1595) > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandle > r.java:188) > > > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandle > r.java:1253) > > > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler > .java:168) > > > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:4 > 73) > > > 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.ja > va:141) > > > at > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.j > ava:527) > > > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColle > ction.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(EatWha > tYouKill.java:247) > > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatY > ouKill.java:140) > > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKi > ll.java:131) > > > at > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.ru > n(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(U > nsafeFieldAccessorImpl.java:167) > > > at > sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(U > nsafeFieldAccessorImpl.java:171) > > > at > sun.reflect.UnsafeLongFieldAccessorImpl.set(UnsafeLongFieldAccessorImp > l.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... > > > > > > -- Andrija Panić