yigangchen

I installed jasper server using the jasperreports-server-5.0.1-linux-x64-installer.run installer.

Hi, I need to run jasper server 5.0.1 on https. I've got the certificates and now waht I need is import them into the existing keystore.jks, which is in jasperreports-server-5.0.1/apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes My problem is when I do the import using keytool it asks me for keystore password. I tried 'changeit' and 'changeme' but neither worked. Anybody knows what the password is or how to go about in my situation? Your help is greatly appreciated. -Yigang

Hi, I've recently installed jasper server using the jasperreports-server-5.0.1-linux-x64-installer.run installer. One of the installation requirements is to run jasper server on out existing mysql database. I migrated from postgres to mysql by following the steps as in the thread "changing jasper server from postgres to mysql" of 7/14/2012. Then I started the tomcat server: ./ctlscript.sh status tomcat In tomcat manager I saw jasperserver-pro was not running. So I started it, and saw it failing to start. The log showed this: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ilike 'organizations'' at line 12013-04-19 13:09:16,727 ERROR ContextLoader,http-9080-1:307 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-multiTenancy-web.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id7_0_, this_.tenantId as tenantId7_0_, this_.tenantAlias as tenantAl3_7_0_, this_.parentId as parentId7_0_, this_.tenantName as tenantName7_0_, this_.tenantDesc as tenantDesc7_0_, this_.tenantNote as tenantNote7_0_, this_.tenantUri as tenantUri7_0_, this_.tenantFolderUri as tenantFo9_7_0_, this_.theme as theme7_0_ from JITenant this_ where this_.tenantId ilike ?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query It appeared that the jasper server was executing the Postgres version of SQL command on mysql, and caused mysql to complain about. Anyone out there has experienced the same? any advises as how to fix/work around it? Your help is greatly appreciated,-Yigang