mthaddon

Turns out I'd added the jaspserver files to the wrong dir on the filesystem. The problem was this bit: - Created a folder "jasperserver" and symlinked to it from /usr/share/tomcat5.5-webapps/jasperserver - Setup a /usr/share/tomcat5.5-webapps/jasperserver.xml file that has: <Context path="/jasperserver" docBase="/usr/share/tomcat5.5-webapps/jasperserver" debug="0" privileged="true" allowLinking="true"> </Context> That should have just been the following: - Created a folder "jasperserver" and symlinked to it from /var/lib/tomcat5.5/webapps/jasperserver All working now, thanks. Tom

When I say forwarding from apache, I think I wasn't being specific enough - I'm just using: RewriteRule ^/jasperserver/(.*)$ http://localhost:8180/jasperserver/$1 [P,L] In other words, tomcat is the one serving the instance on port 8180, and I can connect to this directly and verify the error is here, not in the forwarding to apache. I guess that part of the setup isn't relevant, I was just mentioning it for completeness sake. Thanks for responding in any case, and if you have any ideas about the error message itself, let me know. Cheers, Tom

Hi Folks, I'm trying to setup jasperserver on Ubuntu 8.04 and am getting the error message in the attached log file. I've done the following: - Installed tomcat5.5, apache and mysql. Configured apache to forward requests to /jasperserver to http://localhost:8180/jasperserver - Created a folder "jasperserver" and symlinked to it from /usr/share/tomcat5.5-webapps/jasperserver - Setup a /usr/share/tomcat5.5-webapps/jasperserver.xml file that has: <Context path="/jasperserver" docBase="/usr/share/tomcat5.5-webapps/jasperserver" debug="0" privileged="true" allowLinking="true"> </Context> - Created the jasperserver DB and verified I can connect to it with the same username and password via localhost as I've defined in /usr/share/tomcat5.5-webapps/jasperserver/META-INF/context.xml - Installed libmysql-java and symlinked /usr/share/tomcat5.5/common/lib/mysql.jar -> ../../../java/mysql-connector-java-5.1.5.jar - Set TOMCAT5_SECURITY=no in /etc/default/tomcat5.5 Not sure what I'm missing. Any help appreciated. Thanks, Tom

Hi Folks, I'm in the process of trying to setup jasperserver on Ubuntu 8.04, and I've run into the following issue. I have everything setup so that I can get to the login screen in the web UI, but whenever I enter a username/password combination as defined in /etc/tomcat5.5/tomcat-users.xml I get the following error message: WARN JDBCExceptionReporter,http-8180-Processor20:77 - SQL Error: 1054, SQLState: 42S22 ERROR JDBCExceptionReporter,http-8180-Processor20:78 - Unknown column 'this_.previousPasswordChangeTime' in 'field list' WARN LoggerListener,http-8180-Processor20:55 - Authentication event AuthenticationFailureServiceExceptionEvent: admin; details: org.acegisecurity.ui.WebAuthenticationDetails@fffed504: RemoteIpAddress: 127.0.0.1; SessionId: DAB2C63D58A163633F5657FDBB69A46C; exception: JDBC exception on Hibernate data access; nested exception is org.hib ernate.exception.SQLGrammarException: could not execute query; nested exception is org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query I've confirmed that the connection details as defined in $JASPERSERVER_ROOT/META-INF/context.xml are correct (i.e. I can connect to the MySQL database using those connection details. Any ideas what I might be missing? Thanks, Tom