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

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 30

Activate new users "Login failed"

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 ?

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Activate new users "Login failed"

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

Online

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

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 30

Re: Activate new users "Login failed"

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.

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Activate new users "Login failed"

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

Online

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

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 30

Re: Activate new users "Login failed"

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

Please help smile

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Activate new users "Login failed"

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

Online

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

Hamza_DBM
Member
Registered: 2018-06-04
Posts: 30

Re: Activate new users "Login failed"

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.

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Activate new users "Login failed"

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

Online

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

eduardo
Administrator
Registered: 2016-11-01
Posts: 829
Website

Re: Activate new users "Login failed"

Hi Hamza_DBM,

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

Regards,
Eduardo

Online

Board footer

Powered by FluxBB