jgh

tomcat willl still log to stderr/stdout logs. I've done full reinstalls of the applications of tomcat/jasperserver and of the database and still see this issue. i get the same error with postgresql as db, but the application works w/o issue.

INFO: ***************************************************** * Owasp.CsrfGuard Properties * * Logger: com.jaspersoft.jasperserver.api.security.JSCsrfLogger * NewTokenLandingPage: /jasperserver/login.html * PRNG: SHA1PRNG * SessionKey: JASPER_CSRF_SESSION_KEY * TokenLength: 96 * TokenName: JASPER_CSRF_TOKEN * Ajax: true * Rotate: true * TokenPerPage: true * Action: org.owasp.csrfguard.action.Rotate * Action: org.owasp.csrfguard.action.Redirect * Parameter: Page = /jasperserver/login.html * Action: org.owasp.csrfguard.action.Log * Parameter: Message = potential cross-site request forgery (CSRF) attack thwarted (user:%user%, ip:%remote_ip%, uri:%req uest_uri%, error:%exception_message%) coming in from localhost

pgsql works, but mysql fails when starting the app through tomcat. log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /usr/local/apache-tomcat-6.0/webapps/jasperserver/WEB-INF/logs/jasperserver.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:210) at java.io.FileOutputStream.(FileOutputStream.java:131) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:165) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:132) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:96) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:654) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:441) at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:336) at org.springframework.util.Log4jConfigurer.initLogging(Log4jConfigurer.java:72) at org.springframework.web.util.Log4jWebConfigurer.initLogging(Log4jWebConfigurer.java:151) at org.springframework.web.util.Log4jConfigListener.contextInitialized(Log4jConfigListener.java:45) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Creating ActionModelService object. Creating action model infrastructure. 2014-02-14 13:24:22,131 ERROR JDBCExceptionReporter,main:101 - Could not parse field as date 2014-02-14 13:24:22,362 ERROR ContextLoader,main:307 - Context initialization failed com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id5_0_, this_.version as version5_0_, this_.uri as uri5_0_, this_.hidden as hidden5_0_, this_.name as name5_0_, this_.label as label5_0_, this_.description as descript7_5_0_, this_.parent_folder as parent8_5_0_, this_.creation_date as creation9_5_0_, this_.update_date as update10_5_0_ from JIResourceFolder this_ where (this_.uri=?)]; SQL state [null]; error code [0]; Could not parse field as date; nested exception is java.sql.SQLException: Could not parse field as date at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getRootFolder(HibernateRepositoryServiceImpl.java:507) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolder(HibernateRepositoryServiceImpl.java:476) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$26.execute(HibernateRepositoryServiceImpl.java:1516) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolderUnsecure(HibernateRepositoryServiceImpl.java:1514) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getFolder(HibernateRepositoryServiceImpl.java:1504) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy13.getFolder(Unknown Source) at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.loadProperties(PropertiesManagementServiceImpl.java:188) at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.initialize(PropertiesManagementServiceImpl.java:96) at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:338) at com.jaspersoft.jasperserver.api.common.properties.PropertiesManagementServiceImpl.onApplicationEvent(PropertiesManagementServiceImpl.java:58) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:324) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:929) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:467) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.sql.SQLException: Could not parse field as date at org.mariadb.jdbc.internal.SQLExceptionMapper.getSQLException(SQLExceptionMapper.java:161) at org.mariadb.jdbc.MySQLResultSet.getTimestamp(MySQLResultSet.java:3508) at org.mariadb.jdbc.MySQLResultSet.getTimestamp(MySQLResultSet.java:275) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:300) at org.hibernate.type.TimestampType.get(TimestampType.java:53) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332) at org.hibernate.loader.Loader.getRow(Loader.java:1230) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603) at org.hibernate.loader.Loader.doQuery(Loader.java:724) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2161) at org.hibernate.loader.Loader.list(Loader.java:2121) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 55 more Any thoughts?

Great thanks! I started to build, and did run into an issue, though. [java] ------------------------------------------------------- [java] T E S T S [java] ------------------------------------------------------- [java] Running com.jaspersoft.jasperserver.api.common.service.impl.JdbcDriverServiceImplTest [java] Tests run: 20, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.434 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.RelativeTimestampRangeTest [java] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.098 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.DateRangeBuilderTest [java] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.02 sec [java] Running com.jaspersoft.jasperserver.api.common.service.impl.TestMultipleJarsJdbcDriver [java] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.004 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.RelativeDateRangeTest [java] Tests run: 30, Failures: 4, Errors: 0, Skipped: 0, Time elapsed: 0.416 sec <<< FAILURE! [java] Running com.jaspersoft.jasperserver.api.common.util.rd.FixedTimestampTest [java] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.028 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactoryTest [java] Tests run: 13, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec [java] Running com.jaspersoft.jasperserver.api.common.service.impl.TestJdbcDriver [java] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.004 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.FixedDateTest [java] Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.138 sec [java] Running com.jaspersoft.jasperserver.api.common.util.rd.BaseRelativeDateTest [java] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0.004 sec [java] [java] Results : [java] [java] Failed tests: [java] shouldApplyTimeZoneForWeek(com.jaspersoft.jasperserver.api.common.util.rd.RelativeDateRangeTest) [java] shouldReturnWeekInPast(com.jaspersoft.jasperserver.api.common.util.rd.RelativeDateRangeTest) [java] shouldReturnWeekInFuture(com.jaspersoft.jasperserver.api.common.util.rd.RelativeDateRangeTest) [java] shouldReturnCurrentWeek(com.jaspersoft.jasperserver.api.common.util.rd.RelativeDateRangeTest) [java] [java] Tests run: 106, Failures: 4, Errors: 0, Skipped: 3 [java] [java] [ERROR] BUILD FAILURE BUILD FAILED /usr/home/helfman/workspace/ports/databases/jasperserver/work/jasperreports-server-cp-5.5.0-src/jasperserver/buildomatic/bin/dev.xml:366: The following error occurred while executing this line: /usr/home/helfman/workspace/ports/databases/jasperserver/work/jasperreports-server-cp-5.5.0-src/jasperserver/buildomatic/bin/dev.xml:158: Java returned: 1 Total time: 1 minute 22 seconds *** [do-build] Error code 1 Have you run into anything like this? Thanks! -jgh

Is there any reason in particular that the source distribution file was not released with the 5.5.0 Community version? Thanks! -jgh

Would you mind pasting exactly what you changed, as I am trying what you had noted, and am getting the same results with the same build failure. Your help would REALLY be appreciated! Thanks so much! Jason

Same here. I cannot find a fix, so I have not updated it for FreeBSD at this time. Any help is appreciated, however it seems that there hasn't been much traction on this front.

Hi. Thanks for the tip. After adding that line, it started to build. I did copy in my build file into the conf_source directory, as well for the pre-build. Here is my latest failure: [java] [iNFO] ------------------------------------------------------------------------ [java] [ERROR] BUILD ERROR [java] [iNFO] ------------------------------------------------------------------------ [java] [iNFO] Error building POM (may not be this project's POM). [java] [java] [java] Project ID: org.codehaus.mojo:cobertura-maven-plugin [java] [java] Reason: POM 'org.codehaus.mojo:cobertura-maven-plugin' not found in repository: Unable to download the artifact from any repository [java] [java] org.codehaus.mojo:cobertura-maven-plugin:pom:2.5-Jaspersoft [java] [java] from the specified remote repositories: [java] codehaus-plugins (http://dist.codehaus.org/), [java] central (http://repo1.maven.org/maven2), [java] JBoss (https://repository.jboss.org/nexus/content/groups/public), [java] codehaus-plugins-2 (http://repository.codehaus.org/), [java] js-repo-svn (file:///home/jgh/workspace/ports/databases/jasperserver/work/jasperreports-server-cp-5.0.0-src/jasperserver-repo), [java] SpringSource (http://repo.springsource.org/release), [java] Repo1 Maven (http://repo1.maven.org/maven2/) [java] [java] for project org.codehaus.mojo:cobertura-maven-plugin [java] [java] [java] [iNFO] ------------------------------------------------------------------------ [java] [iNFO] For more information, run Maven with the -e switch [java] [iNFO] ------------------------------------------------------------------------ [java] [iNFO] Total time: 10 seconds [java] [iNFO] Finished at: Fri Jan 04 17:04:36 PST 2013 [java] [iNFO] Final Memory: 14M/154M [java] [iNFO] ------------------------------------------------------------------------ BUILD FAILED /home/jgh/workspace/ports/databases/jasperserver/work/jasperreports-server-cp-5.0.0-src/jasperserver/buildomatic/bin/dev.xml:336: The following error occurred while executing this line: /home/jgh/workspace/ports/databases/jasperserver/work/jasperreports-server-cp-5.0.0-src/jasperserver/buildomatic/bin/dev.xml:122: Java returned: 1 Total time: 46 seconds *** [do-build] Error code 1 Stop in /home/jgh/workspace/ports/databases/jasperserver. *** [build] Error code 1

bad paste

Hi. I am unable to build from source the new version of JasperServer 5.0.0. Any help is appreciated! Attached are the error log and my build properties files.

The FreeBSD Port has been updated for Jasperserver! Enjoy, and please report and issues to jgh@FreeBSD.org, or to ports@FreeBSD.org. http://svnweb.freebsd.org/ports?view=revision&revision=303302 Post Edited by jgh at 08/29/2012 00:04

Great, thanks!

I was thinking of distributing this on SourceForge, or another mirror based solution. Would there be any issues with this?

I'm not sure if this is what you are looking for, but I have these patches in the FreeBSD port for jasperserver, that you can adopt into your application and try out. It sounds similar to what these accomplished. http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/jasperserver/files/alt-patch-jasperserver__jasperserver-war__src__main__webappAdditions__WEB-INF__classes__jasperreports.properties?rev=1.1;content-type=text%2Fplain http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/jasperserver/files/alt-patch-jasperserver__common__shared-config__applicationContext.xml?rev=1.1;content-type=text%2Fplain And from the commit log: By default, excel export prints all pages into a single excel sheet.This patch allows to have each page show up as a separate sheet inexcel.Since the default export prints all pages into a single sheet, certainfields are removed: pageHeader, pageFooter, columnHeader, columnFooterThis patch will put one page per sheet, and keep fields intact on each page.[/code]

I agree. I was able to update the software in offline mode by building my own repository, and was able to quantify it against tomcat6 with postgresql or mysql. I assume it will work with tomcat5 or tomcat7 with no additional changes. The only issue I am looking to answer at this point is what the legalities of distributing the repository I have created which the software will be built against, and do I need to include a disclaimer at this point. Any thoughts or ideas, would be great to this point.