dprogrammer Posted March 16, 2007 Share Posted March 16, 2007 Have anybody seen this error before? I am trying to connect to jasperserver (http://localhost:8088/jasperserver) and getting this error. "WARN LoggerListener,http-8088-Processor24:55 - Authentication event AuthenticationFailureLockedEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@2eb76: RemoteIpAddress: 12x.x.x.x.; SessionId: 31C45BC1A66CDC4E3B7E9666BD55DCD1; exception: User account is locked" NOTE:This problem is related to the login problem with JasperServer from other post. Since this is a different error message and is from the log file, hence I started this new thread. Link to comment Share on other sites More sharing options...
dprogrammer Posted March 16, 2007 Author Share Posted March 16, 2007 Please ignore this post as everything is working now. I had to uninstall the jasperserver and reinstall back and it worked this time. It appears that there is a bug in jasperserver. It will not work when you have either Tomcat or MySQL preinstalled. It will only work when you install all components together. Thanks, Link to comment Share on other sites More sharing options...
csbac Posted March 18, 2007 Share Posted March 18, 2007 Hello!I had the same problem on one installation. Short version:I used a quite old mysql-connector (3.0.9, if I remember rightly). After replacing it with current 5.0.5, it did work. Longer version:I found out that the user account was correctly authenticated (wrong password gave different log message).On the other hand, the authentication object logged by acegisecurity did not log any permissions. I then found out that the only difference between the working and the non-working installation were the connector-j. Thus, I presume, the old version of the mysql jdbc driver did not return any rows from the user->role assignment table, or rather returned an error that was dropped ...? Some time later, I ported JasperServer to FirebirdSQL, and had an empty JIUserRole table in between - the error message was different (login succeeded, yet "access denied" on the JS pages themselves, no logout possible). Obviously, the "locked" problem is a bit more than just "no rows from JIUserRole". Maybe s.th. about join or union or sub-select that only "newer" versions of mysql support? Yours, Sebastian PS: I forgot to write ... I'm using JS on JBoss 4.0.4, not tomcat. Thus, I had to add the mysql-connector manually to server/name/lib.Post edited by: csbac, at: 2007/03/18 08:47 Link to comment Share on other sites More sharing options...
dprogrammer Posted March 20, 2007 Author Share Posted March 20, 2007 Thank you so much Sebastian for explaining it in detail. I hope this would benefit lot of other new comers in this field. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now