jgh
Members-
Posts
159 -
Joined
-
Last visited
jgh's Achievements
-
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
-
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.