Activate new users "Login failed"

Hamza_DBM · 2018-11-29 20:53:02

Hi guys,

I am adding some users and trying to activate them by using the activate button on the top right side which send an email with the credentials to the user. However the username and password received are not working !?
keep sending me this error: "Login attempt failed"

Is this a bug guys ?

eduardo · 2018-11-30 13:22:03

Hi Hamza_DBM,

please post the exact reportserver version (rsversion.properties).
How did you perform installation? Manual or bitnami installation? What is your activated PAM (reportserver.properties). Did you change any security configuration ?

Best regards,
Eduardo

Hamza_DBM · 2018-11-30 14:33:21

Hi eduardo,

This are the information you asked for :

Enterprise Edition:

Version: RS3.0.5-6005 (2018-10-30-10-32-54)

I had Evaluation version and then the Enterprise Edition.
The installation was done automatically bitnami not manually.

I did the upgrade few days ago , was 3.0.3.

I didn't change any security configuration.

Note: By clicking "Activate" the new user receives the email with the credentials and a link to go to Reportserver but when trying to login message : "Login attempt failed"

Thank you.

eduardo · 2018-12-01 15:38:21

Hi Hamza_DBM,

I tested the functionality in reportserver 3.0.5 and it works.

Did you give your new user or the OU where the new user resides "reportserver access" permission? Check here: https://reportserver.net/en/guides/admi … anagement/ (3.2.2. Generic rights).

ReportServer access. The ReportServer Access right controls who has access to ReportServer, i.e., on login ReportServer checks if the user has the execute (x) right.

Regards,
Eduardo

Hamza_DBM · 2018-12-03 15:42:09

Hi eduardo,

Yes I added (X) and it works now, thank you.

I have an issue with one of my test users I cant delete it. shows me an error message :

Error while committing the transaction wrote:

net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException: Error while committing the transaction
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.mapException(CatchStacktraceInterceptor.java:74)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:47)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.deleteNode(<generated>)
 at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.CGLIB$processCall$29(<generated>)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6$$FastClassByGuice$$8deb4e7e.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.CGLIB$processCall$30(<generated>)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6$$FastClassByGuice$$8deb4e7e.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.CGLIB$service$44(<generated>)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6$$FastClassByGuice$$8deb4e7e.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.security.ext.server.usermanager.UserManagerTreeHandlerImpl$$EnhancerByGuice$$ff4c8d6.service(<generated>)
 at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
 at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
 at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
 at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
 at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
 at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527)
 at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Unknown Source)
 Caused by: javax.persistence.RollbackException: Error while committing the transaction
 at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:86)
 at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:87)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 ... 31 more
 Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
 at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:67)
 ... 50 more
 Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
 at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
 at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3200)
 at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3433)
 at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:98)
 at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:451)
 at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:336)
 at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335)
 at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
 at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)
 at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:464)
 at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2905)
 at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2281)
 at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
 at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:146)
 at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
 at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:230)
 at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
 at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)
 ... 50 more
 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`bitnami_reportserver`.`rs_favorite_list`, CONSTRAINT `FK_1be2jre7ckkkf12dokmbj080v` FOREIGN KEY (`user_id`) REFERENCES `rs_user` (`id`))
 at sun.reflect.GeneratedConstructorAccessor570.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
 at com.mysql.jdbc.Util.getInstance(Util.java:387)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
 at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
 ... 67 more

Please help

eduardo · 2018-12-04 11:07:11

Hi Hamza_DBM,

this seems to be a bug in reportserver. If the user to be deleted has a "bookmarks" dadget, this is currently not possible.

This will be solved by RS-2470 in ReportServer 3.0.6, released by the end of the year.

Regards,
Eduardo

Hamza_DBM · 2018-12-04 13:30:14

Hi eduardo,

Thank you I have tried to delete the bookmarks for this user but still can't delete him, it is fine i have just one.

My second question is about the back up. Yesterday I did a back up for the database, is there anything else to back up from Reportserver !?

Is there a best way to do a back up for all ?

Thank you.

eduardo · 2018-12-04 14:26:44

Hi Hamza_DBM,

if you backup your whole bitnami directory all data will be saved including any configuration files. So for a complete backup: backup your whole bitnami directory.

Regards,
Eduardo

eduardo · 2018-12-05 12:30:02

Hi Hamza_DBM,

fyi, RS-2470 is fixed and will be included in reportserver 3.0.6.

Regards,
Eduardo

ReportServer Forum

#1 2018-11-29 20:53:02

Activate new users "Login failed"

#2 2018-11-30 13:22:03

Re: Activate new users "Login failed"

#3 2018-11-30 14:33:21

Re: Activate new users "Login failed"

#4 2018-12-01 15:38:21

Re: Activate new users "Login failed"

#5 2018-12-03 15:42:09

Re: Activate new users "Login failed"

#6 2018-12-04 11:07:11

Re: Activate new users "Login failed"

#7 2018-12-04 13:30:14

Re: Activate new users "Login failed"

#8 2018-12-04 14:26:44

Re: Activate new users "Login failed"

#9 2018-12-05 12:30:02

Re: Activate new users "Login failed"

Board footer