Alright, my bad - so this is a different issue then...but the issue described is true with mysql-connector-python (issue with cloudstack-setup-databases)
Either way, something is broken/different with those 2 in version 8.0.19-1.el7 @Sean did you test with mysql-connector-java 8.0.18 maybe? Is the whole 8.x series broken? Thx On Tue, 21 Jan 2020 at 19:08, Sean Lair <sl...@ippathways.com> wrote: > 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ć > -- Andrija Panić
