[Mifos-issues] [JIRA Studio] Created: (MIFOSADMIN-24) Jasper Reports for SECDEP Are not working

68 views
Skip to first unread message

Ryan Whitney (JIRA)

unread,
Mar 14, 2010, 7:26:58 PM3/14/10
to mifos-...@lists.sourceforge.net
Jasper Reports for SECDEP Are not working
-----------------------------------------

Key: MIFOSADMIN-24
URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
Project: mifos infrastructure
Issue Type: Task
Reporter: Ryan Whitney
Priority: Blocker


Currently SECDEP cannot run their Jasper Reports. It appears to be an issue with the database connection.

Error from Jasper
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:59)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:64)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:1027)
at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:510)
at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:475)
at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:401)
at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:106)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:171)
at sun.reflect.GeneratedMethodAccessor429.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)
at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)
at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)
at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)
at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79)
at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
Mifos-...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Udai Gupta (JIRA)

unread,
Mar 15, 2010, 5:06:58 AM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57132#action_57132 ]

Udai Gupta commented on MIFOSADMIN-24:
--------------------------------------

Jeff, me and Ryan were troubleshooting the MIFOSADMIN-24 issue at SECDEP Jasper server. These were the steps we followed -

1) The log provided by Ryan indicated that JaperServer wasn't able to connect to the Production MySQL server.

2) "telnet <host> 3306" to see if the port is available, it was available.

3) "mysql -h <host> -u <user> -p<pwd>" to check if mysql client is able to connect to the server. (It was able to connect)

4) Replaced the password in dataSource to make sure the settings are correct.

5) Restarted the JasperServer, saw this error message restart "[xxxx@zzzzz init.d]$ connect /tmp/.X11-unix/X0: No such file or directory"

6) Reports parameters were appearing, which means we were able to get connected to database after restart (or password change).

7) But then we saw no reports after parameter submit, checking logs showed this error.

java.lang.InternalError: Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.access$000(X11GraphicsEnvironment.java:53)
at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:142)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:131)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:68)
at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:83)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:174)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:56)

Wasn't sure how the X11 was configured for jasperServer, so left there.

Adam Monsen (JIRA)

unread,
Mar 15, 2010, 10:18:58 AM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57134#action_57134 ]

Adam Monsen commented on MIFOSADMIN-24:
---------------------------------------

I ran:

[mifosadmin@reports ~]$ sudo /etc/init.d/secdepjasper stop

then

[mifosadmin@reports ~]$ sudo /etc/init.d/secdepjasper start

And I was just able to run a "General Ledger" reporting using 03-15-2010 for both the "from" and "to" dates.

Adam Monsen (JIRA)

unread,
Mar 15, 2010, 10:20:58 AM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Monsen reassigned MIFOSADMIN-24:
-------------------------------------

Assignee: Ryan Whitney

Ryan, please confirm that reports via JasperServer are working again.

> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Ryan Whitney

Ryan Whitney (JIRA)

unread,
Mar 15, 2010, 10:54:58 AM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57136#action_57136 ]

Ryan Whitney commented on MIFOSADMIN-24:
----------------------------------------

Yes, its working. @#(&$@(#*$@#$%@#&

At some point when its not during SECDEP's working day, I would like to try restarting this with you Adam. I did that multiple times and we kept running into the X11 error, which was throwing the error I below.

Essentially, I think we needed to restart the server once we rebuilt production (and maybe re-enter the password), but then there is something with my connection that may have been messing up the x11 requirement, which meant when we ran the reports at that time, they were having display issues.

The other error we were seeing. Also, see the attached error log

07:17:52,235 ERROR [jasperserver],http-8080-Processor21:253 - Servlet.service() for servlet jasperserver threw exception
java.lang.NoClassDefFoundError


at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:174)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:56)

at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:143)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:115)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:768)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:726)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:385)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:871)
at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:383)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:373)
at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:255)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)
at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)
at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)
at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)
at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79)
at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)

at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)
at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)
at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101)
at org.springframework.webflow.engine.State.enter(State.java:194)
at org.springframework.webflow.engine.Transition.execute(Transition.java:227)
at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391)
at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)
at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)
at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)
at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386)
at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)
at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230)
at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)
at org.springframework.webflow.engine.Flow.resume(Flow.java:545)
at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259)
at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163)
at sun.reflect.GeneratedMethodAccessor289.invoke(Unknown Source)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy17.resumeExecution(Unknown Source)
at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)
at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)


> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Ryan Whitney

Ryan Whitney (JIRA)

unread,
Mar 15, 2010, 10:57:58 AM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ryan Whitney updated MIFOSADMIN-24:
-----------------------------------

Attachment: jasperserver.log

> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Ryan Whitney
> Priority: Blocker

> Attachments: jasperserver.log

Adam Monsen (JIRA)

unread,
Mar 15, 2010, 11:22:58 PM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Monsen resolved MIFOSADMIN-24.
-----------------------------------

Assignee: Adam Monsen (was: Ryan Whitney)
Resolution: Fixed

> Yes, its working.

Whew!

> At some point when its not during SECDEP's working day,
> I would like to try restarting this with you Adam.

Sure, anytime!

> Essentially, I think we needed to restart the server once we
> rebuilt production (and maybe re-enter the password

I don't follow. Why? (we can discuss somewhere else other than in further comments to this issue, if you'd rather)

=~=~=

Looks like the "x11-common" service is unnecessary, since JasperServer is currently working without it.

=~=~=

Have you seen this?

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=30666 ( http://tinyurl.com/ykp7udj )

You might try disabling X11 forwarding for your SSH client.

> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Adam Monsen
> Priority: Blocker
> Attachments: jasperserver.log

Ryan Whitney (JIRA)

unread,
Mar 15, 2010, 11:36:58 PM3/15/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57140#action_57140 ]

Ryan Whitney commented on MIFOSADMIN-24:
----------------------------------------

I'm fine continuing the discussion in the bug, because then we have record of this :)

So in regards to restarting the server, what we haven't done is determine what was the root cause of the issue, which appeared to be a connection issue and restarting the server or re-entering the password appeared to resolve it. It will be interesting to see if this issue arises again if we have to rebuild a box.

As for the X11 issue, which came up after the restart of Jasper, I suspect you're right Adam that it has something to do with my X11 forwarding being on for ssh. I believe when we were setting these accounts up, you had told me to put that in there with the modified ports. Do you remember why? Either way, unless there is a compelling reason for me to keep that on, I'll remove them from my ssh config.

Still, be interesting to see if restarting the jasper server with it on causes the issue that we were seeing yesterday. May just be something good to note.

> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Adam Monsen
> Priority: Blocker
> Attachments: jasperserver.log
>
>

Adam Monsen (JIRA)

unread,
Mar 16, 2010, 1:27:58 AM3/16/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=57141#action_57141 ]

Adam Monsen commented on MIFOSADMIN-24:
---------------------------------------

> which appeared to be a connection issue and restarting the server


> or re-entering the password appeared to resolve it.

Ah, I see, you re-entered the password for the secdep MySQL data
source in JasperServer. Yep, I don't know what (if anything) that
would affect.

> Do you remember why?

Nope. Could have been we were making it so remote X11 (GUI)-based
tools could be used.

> I'll remove them from my ssh config.

Sounds good.

> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Adam Monsen
> Priority: Blocker
> Attachments: jasperserver.log
>
>

jbrewster (JIRA)

unread,
Mar 25, 2010, 3:10:58 PM3/25/10
to mifos-...@lists.sourceforge.net

[ http://mifosforge.jira.com/browse/MIFOSADMIN-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

jbrewster closed MIFOSADMIN-24.
-------------------------------


> Jasper Reports for SECDEP Are not working
> -----------------------------------------
>
> Key: MIFOSADMIN-24
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-24
> Project: mifos infrastructure
> Issue Type: Task
> Reporter: Ryan Whitney

> Assignee: Adam Monsen
> Priority: Blocker
> Attachments: jasperserver.log
>
>

Reply all
Reply to author
Forward
0 new messages