loaded for existing tomcat mysql using the installer version 1.0.1 for Linux. I am using suse linux.
App starts fine in tomcat, but when I try to login using the password I setup in the installer for jasperadmin I get a failed login credential. I checked the datasource file and mysql JSUser table and the password is the same as what I typed in.
Now the account seems locked from the error I get from the Tomcat log. Listing at end of e-mail.
How do I unlock the user?
What else can I do to troubleshoot?
Tomcat output
---------------
INFO: Find registry server-registry.xml at classpath resource
Sep 1, 2006 1:43:19 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 17559 ms
13:43:59,507 WARN LoggerListener,http-8080-Processor24:55 - Authentication event AuthenticationFailureLockedEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@fffd148a: RemoteIpAddress: 127.0.0.1; SessionId: 230F1DB5563F6A1998428045ECA8C87E; exception: User account is locked
13:43:59,515 WARN JSCommonController,http-8080-Processor24:85 - There was a login error
App starts fine in tomcat, but when I try to login using the password I setup in the installer for jasperadmin I get a failed login credential. I checked the datasource file and mysql JSUser table and the password is the same as what I typed in.
Now the account seems locked from the error I get from the Tomcat log. Listing at end of e-mail.
How do I unlock the user?
What else can I do to troubleshoot?
Tomcat output
---------------
INFO: Find registry server-registry.xml at classpath resource
Sep 1, 2006 1:43:19 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 17559 ms
13:43:59,507 WARN LoggerListener,http-8080-Processor24:55 - Authentication event AuthenticationFailureLockedEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@fffd148a: RemoteIpAddress: 127.0.0.1; SessionId: 230F1DB5563F6A1998428045ECA8C87E; exception: User account is locked
13:43:59,515 WARN JSCommonController,http-8080-Processor24:85 - There was a login error
1 Answer:
Posted on September 1, 2006 at 7:48pm
OK I solved my own problem. Might as well post the answer.
Since I ran the installer against an existing Tomcat installation, I had to manualy copy over the JDBC driver for mysql to the $CATALINA_HOME/common/lib directory. THe problem was that I took an old version that I had on my workstation called:
mysql-connector-java-3.0.9-stable-bin.jar
I downloaded the newer version:
mysql-connector-java-3.1.13-bin.jar
rstarted Tomcat and no more weired lock errors and I got into the application just fine.
Since I ran the installer against an existing Tomcat installation, I had to manualy copy over the JDBC driver for mysql to the $CATALINA_HOME/common/lib directory. THe problem was that I took an old version that I had on my workstation called:
mysql-connector-java-3.0.9-stable-bin.jar
I downloaded the newer version:
mysql-connector-java-3.1.13-bin.jar
rstarted Tomcat and no more weired lock errors and I got into the application just fine.
