You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Mexina M Daniel <me...@singo.co.tz> on 2016/08/03 10:28:57 UTC

Re: Connection problem in Data import tool

Hi Yannick

Thank you

I have corrected the url in dataimport.properties and now when i
download and import, it import completely but i can not find the client
i imported in Mifos.

Regards

On 07/26/2016 03:26 PM, Yannick Awasum wrote:
> Make sure your server is running and check dataimport.properties files for
> correct endpoint.
> See:
> https://github.com/openMF/DataImportTool/blob/develop/dataimport.properties
>
> On Tue, Jul 26, 2016 at 12:49 PM, Mexina M Daniel <me...@singo.co.tz>
> wrote:
>
>> Hi Shreyaank
>>
>> I have changed the port 8009 which was used by another process and make it
>> free, when i run that command now it hives this
>>
>>
>> -------------------------------------------------------------------------------------------------------------------------------------------------
>> singo@singo-HP-ProBook-450-G2 ~/Documents/Mifos/DataImportTool $ gradle
>> clean tomcatRunWar
>> :clean
>> :pmdMain
>> :compileJava
>> warning: [options] bootstrap class path not set in conjunction with
>> -source 1.6
>> 1 warning
>> :processResources UP-TO-DATE
>> :classes
>> :war
>> :tomcatRunWar
>> Started Tomcat Server
>> The Server is running at http://localhost:8070/DataImportTool
>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>> refused
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>      at
>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>      at
>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>      at
>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>      at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>      at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>      at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>      at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>      at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>      at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>      at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>      at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>      at
>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>      at
>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>      at org.apache.tomcat.util.net
>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>      at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>      at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>      at java.lang.Thread.run(Thread.java:745)
>> Caused by: java.net.ConnectException: Connection refused
>>      at java.net.PlainSocketImpl.socketConnect(Native Method)
>>      at java.net
>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>      at java.net
>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>      at java.net
>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>      at java.net.Socket.connect(Socket.java:589)
>>      at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>      at
>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>      at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>      at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>      at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>      at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>      at
>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>      at
>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>      at
>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>      at
>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>      at
>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>      at
>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>      ... 21 more
>>> Building 85% > :tomcatRunWar
>> -------------------------------------------------------------------------------------------------------------------------------------
>>
>> On 07/26/2016 12:05 PM, Shreyaank Byadagi wrote:
>>
>>> Hi Mexina,
>>> Make sure that your not running multiple applications on the same port
>>> number.
>>>
>>> Regards
>>> Shreyaank
>>>
>>> On Tue, Jul 26, 2016 at 2:28 PM, Mexina M Daniel <me...@singo.co.tz>
>>> wrote:
>>>
>>> Hi Shreyaank
>>>> When i run "gradle clean tomcatRunWar" this is what it display in the
>>>> command prompt though it doesn't display from the beginning due to many
>>>> contents to be displayed.
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------------------------------------------
>>>> at org.gradle.internal.reflect.JavaMethod.invoke(JavaMethod.java:75)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.doExecute(AnnotationProcessingTaskFactory.java:226)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:219)
>>>>       at
>>>>
>>>> org.gradle.api.internal.project.taskfactory.AnnotationProcessingTaskFactory$StandardTaskAction.execute(AnnotationProcessingTaskFactory.java:208)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:585)
>>>>       at
>>>>
>>>> org.gradle.api.internal.AbstractTask$TaskActionWrapper.execute(AbstractTask.java:568)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:80)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:61)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:46)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.PostExecutionAnalysisTaskExecuter.execute(PostExecutionAnalysisTaskExecuter.java:35)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:64)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:58)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:52)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:53)
>>>>       at
>>>>
>>>> org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:203)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter$EventFiringTaskWorker.execute(DefaultTaskGraphExecuter.java:185)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.processTask(AbstractTaskPlanExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.AbstractTaskPlanExecutor$TaskExecutorWorker.run(AbstractTaskPlanExecutor.java:50)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskPlanExecutor.process(DefaultTaskPlanExecutor.java:25)
>>>>       at
>>>>
>>>> org.gradle.execution.taskgraph.DefaultTaskGraphExecuter.execute(DefaultTaskGraphExecuter.java:110)
>>>>       at
>>>>
>>>> org.gradle.execution.SelectedTaskExecutionAction.execute(SelectedTaskExecutionAction.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.access$000(DefaultBuildExecuter.java:23)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter$1.proceed(DefaultBuildExecuter.java:43)
>>>>       at
>>>>
>>>> org.gradle.execution.DryRunBuildExecutionAction.execute(DryRunBuildExecutionAction.java:32)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:37)
>>>>       at
>>>>
>>>> org.gradle.execution.DefaultBuildExecuter.execute(DefaultBuildExecuter.java:30)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$4.run(DefaultGradleLauncher.java:158)
>>>>       at org.gradle.internal.Factories$1.create(Factories.java:22)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:52)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuildStages(DefaultGradleLauncher.java:155)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.access$200(DefaultGradleLauncher.java:36)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:103)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher$1.create(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
>>>>       at
>>>>
>>>> org.gradle.internal.progress.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:62)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.doBuild(DefaultGradleLauncher.java:97)
>>>>       at
>>>>
>>>> org.gradle.initialization.DefaultGradleLauncher.run(DefaultGradleLauncher.java:86)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter$DefaultBuildController.run(InProcessBuildActionExecuter.java:102)
>>>>       at
>>>>
>>>> org.gradle.tooling.internal.provider.ExecuteBuildActionRunner.run(ExecuteBuildActionRunner.java:28)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ChainingBuildActionRunner.run(ChainingBuildActionRunner.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.InProcessBuildActionExecuter.execute(InProcessBuildActionExecuter.java:32)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:77)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.ContinuousBuildActionExecuter.execute(ContinuousBuildActionExecuter.java:47)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:51)
>>>>       at
>>>>
>>>> org.gradle.launcher.exec.DaemonUsageSuggestingBuildActionExecuter.execute(DaemonUsageSuggestingBuildActionExecuter.java:28)
>>>>       at
>>>> org.gradle.launcher.cli.RunBuildAction.run(RunBuildAction.java:43)
>>>>       at
>>>>
>>>> org.gradle.internal.Actions$RunnableActionAdapter.execute(Actions.java:170)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:237)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$ParseAndBuildAction.execute(CommandLineActionFactory.java:210)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:35)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.JavaRuntimeValidationAction.execute(JavaRuntimeValidationAction.java:24)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:206)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.CommandLineActionFactory$WithLogging.execute(CommandLineActionFactory.java:169)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:33)
>>>>       at
>>>>
>>>> org.gradle.launcher.cli.ExceptionReportingAction.execute(ExceptionReportingAction.java:22)
>>>>       at org.gradle.launcher.Main.doAction(Main.java:33)
>>>>       at org.gradle.launcher.bootstrap.EntryPoint.run(EntryPoint.java:45)
>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>       at
>>>>
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>>>       at
>>>>
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>       at java.lang.reflect.Method.invoke(Method.java:498)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.runNoExit(ProcessBootstrap.java:54)
>>>>       at
>>>>
>>>> org.gradle.launcher.bootstrap.ProcessBootstrap.run(ProcessBootstrap.java:35)
>>>>       at org.gradle.launcher.GradleMain.main(GradleMain.java:23)
>>>> Caused by: org.apache.catalina.LifecycleException: Protocol handler
>>>> initialization failed
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:983)
>>>>       at
>>>> org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)
>>>>       ... 153 more
>>>> Caused by: java.net.BindException: Address already in use <null>:8009
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:406)
>>>>       at org.apache.tomcat.util.net
>>>> .AbstractEndpoint.init(AbstractEndpoint.java:610)
>>>>       at
>>>> org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429)
>>>>       at
>>>> org.apache.catalina.connector.Connector.initInternal(Connector.java:981)
>>>>       ... 154 more
>>>> Caused by: java.net.BindException: Address already in use
>>>>       at java.net.PlainSocketImpl.socketBind(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)
>>>>       at java.net.ServerSocket.bind(ServerSocket.java:375)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:237)
>>>>       at java.net.ServerSocket.<init>(ServerSocket.java:181)
>>>>       at org.apache.tomcat.util.net
>>>>
>>>> .DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:49)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint.bind(JIoEndpoint.java:393)
>>>>       ... 157 more
>>>> Started Tomcat Server
>>>> The Server is running at http://localhost:8070/DataImportTool
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.CenterWorkbookPopulator.downloadAndParse(CenterWorkbookPopulator.java:58)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>> java.lang.IllegalStateException: java.net.ConnectException: Connection
>>>> refused
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:115)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.OfficeSheetPopulator.downloadAndParse(OfficeSheetPopulator.java:41)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.populator.client.ClientWorkbookPopulator.downloadAndParse(ClientWorkbookPopulator.java:51)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.downloadAndPopulate(DownloadServiceServlet.java:44)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.web.DownloadServiceServlet.doGet(DownloadServiceServlet.java:34)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
>>>>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
>>>>       at
>>>>
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
>>>>       at
>>>>
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
>>>>       at
>>>>
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
>>>>       at
>>>>
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>>>       at
>>>>
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>>>>       at
>>>>
>>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
>>>>       at
>>>>
>>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
>>>>       at org.apache.tomcat.util.net
>>>> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>>>       at
>>>>
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>>>       at java.lang.Thread.run(Thread.java:745)
>>>> Caused by: java.net.ConnectException: Connection refused
>>>>       at java.net.PlainSocketImpl.socketConnect(Native Method)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
>>>>       at java.net
>>>>
>>>> .AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
>>>>       at java.net
>>>> .AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
>>>>       at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>>>>       at java.net.Socket.connect(Socket.java:589)
>>>>       at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
>>>>       at
>>>> sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:173)
>>>>       at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>>>>       at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>>>>       at
>>>> sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:264)
>>>>       at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:367)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1105)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1513)
>>>>       at
>>>>
>>>> sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
>>>>       at
>>>> java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
>>>>       at
>>>>
>>>> sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.SimpleHttpResponse.getContent(SimpleHttpResponse.java:26)
>>>>       at
>>>>
>>>> org.openmf.mifos.dataimport.http.MifosRestClient.createAuthToken(MifosRestClient.java:111)
>>>>       ... 21 more
>>>>
>>>>> Building 85% > :tomcatRunWar
>>>>>
>>>> -------------------------------------------------------------------------------------------------------------------------------------------------------
>>>>
>>>>
>>>> On 07/26/2016 11:46 AM, Shreyaank Byadagi wrote:
>>>>
>>>> Hi Mexina,
>>>>> Please share your complete  error log, so that I can guide you.
>>>>>
>>>>> Regards
>>>>> Shreyaank
>>>>>
>>>>> On Tue, Jul 26, 2016 at 1:38 PM, Mexina M Daniel <me...@singo.co.tz>
>>>>> wrote:
>>>>>
>>>>> Hi devs
>>>>>
>>>>>> I would like someone to assist me of this problem am facing
>>>>>>
>>>>>> I have installed Data Import Tool successfully, i just have started to
>>>>>> try
>>>>>> to import clients, am facing a problem when downloading the template.
>>>>>> It
>>>>>> gives an error "java.net.ConnectException: Connection refused ".
>>>>>>
>>>>>> Also when i ran "gradle clean tomcatRunWar" it build up to 85%
>>>>>>
>>>>>> What could be the problem?
>>>>>>
>>>>>> Thanks in advance
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Mexina M Daniel
>>>>>> Lead Software Developer
>>>>>> Research & Development
>>>>>>
>>>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>>>
>>>>>> Singo Africa Limited
>>>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>>>> Salaam
>>>>>>
>>>>>> singo.co.tz
>>>>>>
>>>>>> Lets grow together
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>> Mexina M Daniel
>>>> Lead Software Developer
>>>> Research & Development
>>>>
>>>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>>>
>>>> Singo Africa Limited
>>>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es
>>>> Salaam
>>>>
>>>> singo.co.tz
>>>>
>>>> Lets grow together
>>>>
>>>>
>>>>
>> --
>> Mexina M Daniel
>> Lead Software Developer
>> Research & Development
>>
>> Tel:+255 222 618 511 | Mob: +255 712 110 791
>>
>> Singo Africa Limited
>> Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam
>>
>> singo.co.tz
>>
>> Lets grow together
>>
>>
>>
>

-- 
Mexina M Daniel
Lead Software Developer
Research & Development

Tel:+255 222 618 511 | Mob: +255 712 110 791

Singo Africa Limited
Block G,Mbezi Beach B| 7 Nakawale Road| P.O.Box 78908| 14121 Dar es Salaam

singo.co.tz

Lets grow together