You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID> on 2018/08/06 10:32:03 UTC
Fineract CN Setup issues
Dear all,
I am trying to setup Fineract CN in a EC2 machine following the
instructions in
https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN
I am facing the below issues. I am trying to create localstore DB to build
the Jar. So i used the below command.
java -Ddemoserver.provision=true -Ddemoserver.persistent=true
-Dcustom.cassandra.contactPoints=127.0.0.1:9042
-Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
-Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
-Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
When i ran the above command, it created seshat and playground schemas in
MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
It only created 1 entry in seshat - tenants table.
Also i got the below error and server startup failed.
Could not connect to broker URL: tcp://localhost:61616. Reason:
java.net.ConnectException: Connection refused (Connection refused)
Should i install Active MQ separately.? Also, i have not installed Maria
DB. If anyone has done the setup successfully, please help us.
Thanks,
Karthik
Re: Fineract CN Setup issues
Posted by James Dailey <ja...@gmail.com>.
Hi Karthik,
Thanks. Can't seem to find the cassandra.env.
I'm on GCP and since the shell environment is "ephemeral" I also need to
make changes to the environment, and push the container images to
something... google container registry I guess.
Easier to push a docker container image, which is still in process. So,
catch 22 for me right now.
anyway... I'm wondering if anyone has gotten it running on Google Cloud
Platform (GCP).
If on GCP, I'm looking at using the java project deploy process - any idea
if that's a good way to go?
https://cloud.google.com/appengine/docs/standard/java/tools/using-maven
I think that means that if we then added the following section to the maven
POM file, it would then accept the command $mvn appengine:deploy # to
deploy a new build.
<plugin>
<groupId>com.google.cloud.tools</groupId>
<artifactId>appengine-maven-plugin</artifactId>
<version>1.3.2</version>
</plugin>
Again, I don't care where I deploy - but I do want to this project to be
easily deployed, and I urgently need an instance running with endpoints
accessible to a small team. Can anyone help me get that going?
Thanks,
James
On Tue, Nov 13, 2018 at 10:12 PM Karthik Ananthakrishnan
<ka...@beyondsquare.com.invalid> wrote:
> Hello James,
>
> I had issues in brining up the server and figured out that it was failing
> due to memory issues. So, i added swap space which helped.
>
> Can you explain what issue you are facing brining up the application in
> GC.? Have you tried comparing cassandra.yaml and env-sh files that Louis
> had emailed earlier.?
>
> Thanks,
> Karthik
>
>
> On Tue, Nov 13, 2018 at 11:38 PM James Dailey <ja...@gmail.com>
> wrote:
>
> > Hi Karthik - I'm having similar issues with cassandra on google cloud
> > platform I believe. Can you explain your approach a bit more? If you
> > already documented it somewhere, please let me know.... I'd also be happy
> > to help you document it.
> >
> > James
> >
> > On Thu, Aug 9, 2018 at 4:54 AM Karthik Ananthakrishnan
> > <ka...@beyondsquare.com.invalid> wrote:
> >
> > > Sure Issac
> > >
> > > Get Outlook for iOS<https://aka.ms/o0ukef>
> > > ________________________________
> > > From: Isaac Kamga <is...@mifos.org>
> > > Sent: Thursday, August 9, 2018 4:52:59 PM
> > > To: Dev
> > > Cc: Myrle Krantz
> > > Subject: Re: Fineract CN Setup issues
> > >
> > > Hi Karthik,
> > >
> > > Given that you've fixed both issues, could you kindly send a PR to the
> > > fims-web-app <https://github.com/apache/fineract-cn-fims-web-app>
> > > repository ?
> > >
> > > I will be thrilled to review and merge.
> > >
> > > You could also update the How To Build Fineract CN
> > > <
> > >
> >
> https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN
> > > >
> > > page on Confluence with your learnings.
> > >
> > > Cheers,
> > > Isaac Kamga.
> > >
> >
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Hello James,
I had issues in brining up the server and figured out that it was failing
due to memory issues. So, i added swap space which helped.
Can you explain what issue you are facing brining up the application in
GC.? Have you tried comparing cassandra.yaml and env-sh files that Louis
had emailed earlier.?
Thanks,
Karthik
On Tue, Nov 13, 2018 at 11:38 PM James Dailey <ja...@gmail.com>
wrote:
> Hi Karthik - I'm having similar issues with cassandra on google cloud
> platform I believe. Can you explain your approach a bit more? If you
> already documented it somewhere, please let me know.... I'd also be happy
> to help you document it.
>
> James
>
> On Thu, Aug 9, 2018 at 4:54 AM Karthik Ananthakrishnan
> <ka...@beyondsquare.com.invalid> wrote:
>
> > Sure Issac
> >
> > Get Outlook for iOS<https://aka.ms/o0ukef>
> > ________________________________
> > From: Isaac Kamga <is...@mifos.org>
> > Sent: Thursday, August 9, 2018 4:52:59 PM
> > To: Dev
> > Cc: Myrle Krantz
> > Subject: Re: Fineract CN Setup issues
> >
> > Hi Karthik,
> >
> > Given that you've fixed both issues, could you kindly send a PR to the
> > fims-web-app <https://github.com/apache/fineract-cn-fims-web-app>
> > repository ?
> >
> > I will be thrilled to review and merge.
> >
> > You could also update the How To Build Fineract CN
> > <
> >
> https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN
> > >
> > page on Confluence with your learnings.
> >
> > Cheers,
> > Isaac Kamga.
> >
>
Re: Fineract CN Setup issues
Posted by James Dailey <ja...@gmail.com>.
Hi Karthik - I'm having similar issues with cassandra on google cloud
platform I believe. Can you explain your approach a bit more? If you
already documented it somewhere, please let me know.... I'd also be happy
to help you document it.
James
On Thu, Aug 9, 2018 at 4:54 AM Karthik Ananthakrishnan
<ka...@beyondsquare.com.invalid> wrote:
> Sure Issac
>
> Get Outlook for iOS<https://aka.ms/o0ukef>
> ________________________________
> From: Isaac Kamga <is...@mifos.org>
> Sent: Thursday, August 9, 2018 4:52:59 PM
> To: Dev
> Cc: Myrle Krantz
> Subject: Re: Fineract CN Setup issues
>
> Hi Karthik,
>
> Given that you've fixed both issues, could you kindly send a PR to the
> fims-web-app <https://github.com/apache/fineract-cn-fims-web-app>
> repository ?
>
> I will be thrilled to review and merge.
>
> You could also update the How To Build Fineract CN
> <
> https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN
> >
> page on Confluence with your learnings.
>
> Cheers,
> Isaac Kamga.
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Sure Issac
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Isaac Kamga <is...@mifos.org>
Sent: Thursday, August 9, 2018 4:52:59 PM
To: Dev
Cc: Myrle Krantz
Subject: Re: Fineract CN Setup issues
Hi Karthik,
Given that you've fixed both issues, could you kindly send a PR to the
fims-web-app <https://github.com/apache/fineract-cn-fims-web-app>
repository ?
I will be thrilled to review and merge.
You could also update the How To Build Fineract CN
<https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN>
page on Confluence with your learnings.
Cheers,
Isaac Kamga.
Re: Fineract CN Setup issues
Posted by Isaac Kamga <is...@mifos.org>.
Hi Karthik,
Given that you've fixed both issues, could you kindly send a PR to the
fims-web-app <https://github.com/apache/fineract-cn-fims-web-app>
repository ?
I will be thrilled to review and merge.
You could also update the How To Build Fineract CN
<https://cwiki.apache.org/confluence/display/FINERACT/How+To+Build+Apache+Fineract+CN>
page on Confluence with your learnings.
Cheers,
Isaac Kamga.
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Dear Marcus and Others,
npm run runProd and npm run build failed due to below reasons.
1. GroupSelectComponent not declared in common.module
2. applicationDate Missing and lastModifiedBuy spelling error in
group.model.ts.
Fixed both issues and then npm runProd and build commands worked. But,
changes to proxy.conf didnt work out. So, deployed the dist contents into
nginx in the same server where backend was deployed and then i could run
the application.
Thanks for the support.
Regards,
Karthik
On Wed, Aug 8, 2018 at 1:31 PM, Karthik Ananthakrishnan <
karthik.a@beyondsquare.com> wrote:
> Thanks Marcus.. I figured out the proxy.conf but was running in dev mode.
> Will try running Prod and check. Appreciate your response and help.
>
> On 08/08/18, 12:36 PM, "Markus Geiss" <ma...@apache.org> wrote:
>
> Hey Karthik,
>
> in the source tree of the UI you will find a file called
> proxy.conf.json.
> You simply need to adjust the configured URLs and ports to point to
> your back end services.Then you can run it with 'npm run runProd'.
>
> It is recommended to either use nginx or Apache httpd to serve the
> static content. In this case you need to configure the http service to
> be a reverse proxy for the back end.
>
> Cheers
>
> Markus
>
> .::Yagni likes a DRY KISS::.
>
>
> On Tue, Aug 7, 2018 at 6:40 PM Louis Niyongabo <ln...@gmail.com>
> wrote:
>
> > Welcome, glad it worked.
> > For local deployment of client, I have no idea on how to proceed.
> > Hope someone else will pick it up and help you on this.
> > Good luck.
> > Louis
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan [mailto:karthik.a@
> beyondsquare.com.INVALID]
> > Sent: Tuesday, August 7, 2018 18:27
> > To: Dev <de...@fineract.apache.org>
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Thank you Louis for the support.
> >
> > I Unstalled Cassandra, reinstalled it and made config changes to
> yaml file
> > and server started properly and tables got created in schema.
> >
> > I have deployed Fineract CN in AWS EC2. I want to deploy the
> front-end in
> > my local machine and connect the backend deployed in AWS. What
> changes i
> > have to make in front end.?
> >
> > Regards,
> > Karthik
> >
> >
> >
> > On Mon, Aug 6, 2018 at 11:12 PM, Louis Niyongabo <
> lniyongabo@gmail.com>
> > wrote:
> >
> > > Well, I know only what I tested on my dev machine Windows 10 64
> bit.
> > > Other than setting up CASSANDRA_HOME in environment variables, I
> also
> > > changed these attached files "cassandra.yaml" and "
> cassandra-env.sh"
> > > (I appended txt to prevent them from being email-blocked) following
> > > some guidelines from Internet.
> > >
> > > Use a tool like Notepad++(plugin compare) to verify how those files
> > > are different from yours, eventually you may pick what you need to
> > > change at your end. Which OS are you running?
> > >
> > > If it doesn't work, we can discuss further off this forum tomorrow
> > morning.
> > >
> > > Regards,
> > >
> > > Louis
> > >
> > > -----Original Message-----
> > > From: Karthik Ananthakrishnan
> > > [mailto:karthik.a@beyondsquare.com.INVALID]
> > > Sent: Monday, August 6, 2018 19:23
> > > To: dev@fineract.apache.org; dev@fineract.apache.org
> > > Cc: myrle@apache.org
> > > Subject: Re: Fineract CN Setup issues
> > >
> > > How do I fix this Louis.?
> > >
> > > Get Outlook for iOS<https://aka.ms/o0ukef>
> > > ______________________________ __
> > > From: Louis Niyongabo <ln...@gmail.com>
> > > Sent: Monday, August 6, 2018 10:51:01 PM
> > > To: dev@fineract.apache.org
> > > Cc: myrle@apache.org
> > > Subject: RE: Fineract CN Setup issues
> > >
> > > The first error (datastax) seems to be related to Cassandra.
> > > I tested on Windows box, this service DataStax_DDC_Server (DataStax
> > > DDC Server 3.9.0) had to be running.
> > > Please take note that it's different from starting Cassandra from
> its
> > path.
> > >
> > > I could have Cassandra successfully started, but the service
> > > DataStax_DDC_Server would still fail to start. The setup went
> through
> > > only when the Service could start successfully.
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Karthik Ananthakrishnan
> > > [mailto:karthik.a@beyondsquare.com.INVALID]
> > > Sent: Monday, August 6, 2018 19:06
> > > To: dev@fineract.apache.org
> > > Cc: myrle@apache.org
> > > Subject: Re: Fineract CN Setup issues
> > >
> > > Below is the error I got when I deleted the DBs in Cassandra, MySQL
> > > and started the server with the given command.
> > >
> > > There was 1 failure:
> > > 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> > > org.apache.fineract.cn.api.util.InternalServerError:
> > > {"timestamp":1533561449009,"status":500,"error":"Internal Server
> > > Error","exception":"java.lang.IllegalStateException","
> > > message":"org.springfr
> > > amework.web.util.NestedServletException: Request processing
> failed;
> > > nested exception is java.lang.IllegalStateException:
> > > org.apache.fineract.cn.api.util.InternalServerError:
> > > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > > Server Error\",\"exception\":\"com.datastax.driver.core.
> > > exceptions.SyntaxError\",\"
> > > message\":\"org.springframework.web.util.NestedServletException:
> > > Request processing failed; nested exception is
> > > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable
> > > alternative at input
> > > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > > provisioner/v1/tena
> > > nts/playground/identityservice"}
> > > at
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > getAlternative(Annotat
> > > edErrorDecoder.java:78)
> > > at
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > decode(AnnotatedErrorD
> > > ecoder.java:65)
> > > at
> > > feign.SynchronousMethodHandler.executeAndDecode(
> > > SynchronousMethodHandler.jav
> > > a:138)
> > > at
> > > feign.SynchronousMethodHandler.invoke(
> SynchronousMethodHandler.java:76)
> > > at
> > > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > > ReflectiveFeign.java:103
> > > )
> > > at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> Source)
> > .
> > > .
> > > .
> > > .
> > > .
> > >
> > > 13:17:28.959 [qtp630028734-22] INFO
> > > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > > org.springframework.web.util.NestedServletException: Request
> > > processing failed; nested exception is com.datastax.driver.core.
> > > exceptions.SyntaxError:
> > > line 8:22 no viable alternative at input 'date'
> > > 13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.
> ServletHandler
> > > -
> > > org.springframework.web.util.NestedServletException: Request
> > > processing failed; nested exception is com.datastax.driver.core.
> > > exceptions.SyntaxError:
> > > line 8:22 no viable alternative at input 'date'
> > > at
> > > org.springframework.web.servlet.FrameworkServlet.
> > > processRequest(FrameworkSer
> > > vlet.java:982)
> > > at
> > > org.springframework.web.servlet.FrameworkServlet.
> > > doPost(FrameworkServlet.jav
> > > a:872)
> > > at javax.servlet.http.HttpServlet.service(
> HttpServlet.java:648)
> > > at
> > > org.springframework.web.servlet.FrameworkServlet.
> > > service(FrameworkServlet.ja
> > > va:846)
> > > at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> > >
> > >
> > > On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com>
> wrote:
> > >
> > > No idea, let's rebuild those DBs:
> > >
> > > 1. delete 'seshat' and 'playground' databases from Cassandra
> and
> > MySQL.
> > >
> > > 2. java -Ddemoserver.provision=true
> -Ddemoserver.persistent=true
> > > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > > -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=
> password
> > > -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
> > > -Dcustom.mariadb.password=mysql -jar
> > > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> > >
> > > And share the errors you get.
> > >
> > > Louis
> > >
> > >
> > > -----Original Message-----
> > > From: Karthik Ananthakrishnan
> > > [mailto:karthik.a@beyondsquare.com.INVALID]
> > > Sent: Monday, August 6, 2018 18:37
> > > To: dev@fineract.apache.org
> > > Cc: myrle@apache.org
> > > Subject: Re: Fineract CN Setup issues
> > >
> > > Thanks Louis. Will try this.
> > >
> > > Any idea, why tables are not getting created in MySQL
> playground
> > > DB schema.? Will they not be created when we start the Fineract
> server.?
> > >
> > > On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com>
> > wrote:
> > >
> > > Hi Karthik,
> > >
> > > Reference to your first email, I run into similar issues,
> down
> > > how the workaround I used on Windows,
> > >
> > > 1. For the port 61616, I was getting this error
> > > "java.io.IOException: Failed to bind to server socket:
> > > tcp://localhost:61616
> > > due to: java.net.BindException: Address already in use: JVM_Bind".
> I
> > > fixed it by changing the config file activemq.xml, from 61616 into
> 51616.
> > >
> > > 2. For Cassandra, I realized that the service must be
> running
> > > during setup. I had to change the config files cassandra.yaml and
> > > cassandra-env.sh for hostname, listen_address, rpc_address to be
> > > 127.0.0.1, along created the folder " cdc_raw" that wasn't there by
> > > default.
> > >
> > > 3. For local databases, when the services fail to start,
> > > delete the databases in Casandra and start over until the services
> run
> > successfully.
> > > Going fotward, run the second command without "
> > > -Ddemoserver.provision=true". That parameter was required to create
> > > the DBs the first time.
> > >
> > > Regards,
> > >
> > > Louis
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Karthik Ananthakrishnan
> > > [mailto:karthik.a@beyondsquare.com.INVALID]
> > > Sent: Monday, August 6, 2018 16:45
> > > To: Dev <de...@fineract.apache.org>
> > > Cc: myrle@apache.org
> > > Subject: Re: Fineract CN Setup issues
> > >
> > > Hello All,
> > >
> > > Below is the error logged when i try to start the FINERACT
> CN
> > > server with provision = true. Don't get this when i set it to
> false. I
> > > need to get the localstore created. So, not able to proceed. Can
> > > someone who has faced this and resolved help me.?
> > >
> > > There was 1 failure:
> > > 1) startDevServer(org.apache.
> fineract.cn.dev.ServiceRunner)
> > > org.apache.fineract.cn.api.util.InternalServerError:
> > > {"timestamp":1533561449009,"status":500,"error":"Internal
> > > Server
> > >
> > > Error","exception":"java.lang.IllegalStateException","
> > > message":"org.springfr
> > > amework.web.util.NestedServletException:
> > > Request processing failed; nested exception is
> > > java.lang.IllegalStateException:
> > > org.apache.fineract.cn.api.util.InternalServerError:
> > >
> > > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > > Server
> > >
> > > Error\",\"exception\":\"com.datastax.driver.core.
> > > exceptions.SyntaxError\",\"
> > > message\":\"org.springframework.web.util.NestedServletException:
> > > Request processing failed; nested exception is
> > > com.datastax.driver.core.exceptions.SyntaxError: line
> 8:22 no
> > > viable alternative at input
> > > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > > provisioner/v1/tena
> > > nts/playground/identityservice"}
> > > at
> > >
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > getAlternative(Annotat
> > > edErrorDecoder.java:78)
> > > at
> > >
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > decode(AnnotatedErrorD
> > > ecoder.java:65)
> > > at
> > >
> > > feign.SynchronousMethodHandler.executeAndDecode(
> > > SynchronousMethodHandler.jav
> > > a:138)
> > > at
> > >
> > > feign.SynchronousMethodHandler.invoke(
> SynchronousMethodHandler.java:76)
> > > at
> > >
> > > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > > ReflectiveFeign.java:103
> > > )
> > > at
> > > com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> > > Source)
> > >
> > >
> > > .'
> > > .
> > > .
> > > .
> > > 13:17:28.435 [qtp630028734-22] INFO
> > > c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name
> 'datacenter1'
> > > for
> > > DCAwareRoundRobinPolicy (if this is incorrect, please provide the
> > > correct datacenter name with DCAwareRoundRobinPolicy constructor)
> > > 13:17:28.435 [qtp630028734-22] INFO
> > > com.datastax.driver.core.Cluster - New Cassandra host /
> 127.0.0.1:9042
> > > added
> > > 13:17:28.959 [qtp630028734-22] INFO
> > > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > > org.springframework.web.util.NestedServletException:
> Request
> > > processing failed; nested exception is
> > > com.datastax.driver.core.exceptions.SyntaxError: line
> 8:22 no
> > > viable alternative at input 'date'
> > > 13:17:28.962 [qtp630028734-22] WARN
> > > o.e.jetty.servlet.ServletHandler -
> > > org.springframework.web.util.NestedServletException:
> Request
> > > processing failed; nested exception is
> > > com.datastax.driver.core.exceptions.SyntaxError: line
> 8:22 no
> > > viable alternative at input 'date'
> > > at
> > >
> > > org.springframework.web.servlet.FrameworkServlet.
> > > processRequest(FrameworkSer
> > > vlet.java:982)
> > > at
> > >
> > > org.springframework.web.servlet.FrameworkServlet.
> > > doPost(FrameworkServlet.jav
> > > a:872)
> > > at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> > > at
> > >
> > > org.springframework.web.servlet.FrameworkServlet.
> > > service(FrameworkServlet.ja
> > > va:846)
> > > at
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> > >
> > > .
> > > .
> > > .
> > > .
> > > .
> > >
> > > Caused by: org.apache.fineract.cn.api.
> util.InternalServerError:
> > > {"timestamp":1533561448970,"status":500,"error":"Internal
> > > Server
> > >
> > > Error","exception":"com.datastax.driver.core.
> exceptions.SyntaxError","
> > > messag
> > > e":"org.springframework.web.util.NestedServletException:
> > > Request processing failed; nested exception is
> > > com.datastax.driver.core.exceptions.SyntaxError: line
> 8:22 no
> > > viable alternative at input 'date'","path":"/identity/v1/
> initialize"}
> > > at
> > >
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > getAlternative(Annotat
> > > edErrorDecoder.java:78)
> > > at
> > >
> > > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > > decode(AnnotatedErrorD
> > > ecoder.java:65)
> > > at
> > >
> > > feign.SynchronousMethodHandler.executeAndDecode(
> > > SynchronousMethodHandler.jav
> > > a:138)
> > > at
> > >
> > > feign.SynchronousMethodHandler.invoke(
> SynchronousMethodHandler.java:76)
> > > at
> > >
> > > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > > ReflectiveFeign.java:103
> > > )
> > > at com.sun.proxy.$Proxy153.initialize(Unknown
> Source)
> > > at
> > >
> > > org.apache.fineract.cn.provisioner.internal.service.
> > > applications.IdentitySer
> > > viceInitializer.initializeIsis(IdentityServiceInitializer.
> java:128)
> > > ... 99 common frames omitted
> > > 13:17:29.023 [Thread-15] INFO
> > > o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext -
> > > Closing
> > >
> > > org.springframework.boot.context.embedded.
> AnnotationConfigEmbeddedWebA
> > > pp
> > > lica
> > > tionContext@11438d26:
> > > startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
> > >
> > > org.springframework.context.annotation.
> AnnotationConfigApplicationCon
> > > text@7d
> > > c5e7b4
> > >
> > >
> > > On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
> > > karthik.a@beyondsquare.com> wrote:
> > >
> > > > Dear all,
> > > >
> > > > I am trying to setup Fineract CN in a EC2 machine
> following the
> > > > instructions in
> > > https://cwiki.apache.org/confluence/display/FINERACT/
> > > > How+To+Build+Apache+Fineract+CN
> > > >
> > > > I am facing the below issues. I am trying to create
> > > localstore DB to
> > > > build the Jar. So i used the below command.
> > > >
> > > > java -Ddemoserver.provision=true
> -Ddemoserver.persistent=true
> > > > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > > > -Dcassandra.cluster.user=cassandra
> > > > -Dcassandra.cluster.pwd=password
> > -Dcustom.mariadb.host=localhost
> > > > -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql
> -jar
> > > > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> > > >
> > > > When i ran the above command, it created seshat and
> > > playground schemas
> > > > in MySQL and Cassandra. In MySQL - It didnot create any
> > > tables in playground..
> > > > It only created 1 entry in seshat - tenants table.
> > > >
> > > > Also i got the below error and server startup failed.
> > > >
> > > > Could not connect to broker URL: tcp://localhost:61616.
> Reason:
> > > > java.net.ConnectException: Connection refused (Connection
> > > refused)
> > > > Should i install Active MQ separately.? Also, i have not
> > > installed
> > > > Maria DB. If anyone has done the setup successfully,
> please
> > > help us.
> > > >
> > > > Thanks,
> > > > Karthik
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Thanks Marcus.. I figured out the proxy.conf but was running in dev mode. Will try running Prod and check. Appreciate your response and help.
On 08/08/18, 12:36 PM, "Markus Geiss" <ma...@apache.org> wrote:
Hey Karthik,
in the source tree of the UI you will find a file called proxy.conf.json.
You simply need to adjust the configured URLs and ports to point to
your back end services.Then you can run it with 'npm run runProd'.
It is recommended to either use nginx or Apache httpd to serve the
static content. In this case you need to configure the http service to
be a reverse proxy for the back end.
Cheers
Markus
.::Yagni likes a DRY KISS::.
On Tue, Aug 7, 2018 at 6:40 PM Louis Niyongabo <ln...@gmail.com> wrote:
> Welcome, glad it worked.
> For local deployment of client, I have no idea on how to proceed.
> Hope someone else will pick it up and help you on this.
> Good luck.
> Louis
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Tuesday, August 7, 2018 18:27
> To: Dev <de...@fineract.apache.org>
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Thank you Louis for the support.
>
> I Unstalled Cassandra, reinstalled it and made config changes to yaml file
> and server started properly and tables got created in schema.
>
> I have deployed Fineract CN in AWS EC2. I want to deploy the front-end in
> my local machine and connect the backend deployed in AWS. What changes i
> have to make in front end.?
>
> Regards,
> Karthik
>
>
>
> On Mon, Aug 6, 2018 at 11:12 PM, Louis Niyongabo <ln...@gmail.com>
> wrote:
>
> > Well, I know only what I tested on my dev machine Windows 10 64 bit.
> > Other than setting up CASSANDRA_HOME in environment variables, I also
> > changed these attached files "cassandra.yaml" and " cassandra-env.sh"
> > (I appended txt to prevent them from being email-blocked) following
> > some guidelines from Internet.
> >
> > Use a tool like Notepad++(plugin compare) to verify how those files
> > are different from yours, eventually you may pick what you need to
> > change at your end. Which OS are you running?
> >
> > If it doesn't work, we can discuss further off this forum tomorrow
> morning.
> >
> > Regards,
> >
> > Louis
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 19:23
> > To: dev@fineract.apache.org; dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > How do I fix this Louis.?
> >
> > Get Outlook for iOS<https://aka.ms/o0ukef>
> > ______________________________ __
> > From: Louis Niyongabo <ln...@gmail.com>
> > Sent: Monday, August 6, 2018 10:51:01 PM
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: RE: Fineract CN Setup issues
> >
> > The first error (datastax) seems to be related to Cassandra.
> > I tested on Windows box, this service DataStax_DDC_Server (DataStax
> > DDC Server 3.9.0) had to be running.
> > Please take note that it's different from starting Cassandra from its
> path.
> >
> > I could have Cassandra successfully started, but the service
> > DataStax_DDC_Server would still fail to start. The setup went through
> > only when the Service could start successfully.
> >
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 19:06
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Below is the error I got when I deleted the DBs in Cassandra, MySQL
> > and started the server with the given command.
> >
> > There was 1 failure:
> > 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561449009,"status":500,"error":"Internal Server
> > Error","exception":"java.lang.IllegalStateException","
> > message":"org.springfr
> > amework.web.util.NestedServletException: Request processing failed;
> > nested exception is java.lang.IllegalStateException:
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > Server Error\",\"exception\":\"com.datastax.driver.core.
> > exceptions.SyntaxError\",\"
> > message\":\"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
> > alternative at input
> > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > provisioner/v1/tena
> > nts/playground/identityservice"}
> > at
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
> .
> > .
> > .
> > .
> > .
> >
> > 13:17:28.959 [qtp630028734-22] INFO
> > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is com.datastax.driver.core.
> > exceptions.SyntaxError:
> > line 8:22 no viable alternative at input 'date'
> > 13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler
> > -
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is com.datastax.driver.core.
> > exceptions.SyntaxError:
> > line 8:22 no viable alternative at input 'date'
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkSer
> > vlet.java:982)
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > doPost(FrameworkServlet.jav
> > a:872)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.ja
> > va:846)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> >
> >
> > On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
> >
> > No idea, let's rebuild those DBs:
> >
> > 1. delete 'seshat' and 'playground' databases from Cassandra and
> MySQL.
> >
> > 2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
> > -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
> > -Dcustom.mariadb.password=mysql -jar
> > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >
> > And share the errors you get.
> >
> > Louis
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 18:37
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Thanks Louis. Will try this.
> >
> > Any idea, why tables are not getting created in MySQL playground
> > DB schema.? Will they not be created when we start the Fineract server.?
> >
> > On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com>
> wrote:
> >
> > Hi Karthik,
> >
> > Reference to your first email, I run into similar issues, down
> > how the workaround I used on Windows,
> >
> > 1. For the port 61616, I was getting this error
> > "java.io.IOException: Failed to bind to server socket:
> > tcp://localhost:61616
> > due to: java.net.BindException: Address already in use: JVM_Bind". I
> > fixed it by changing the config file activemq.xml, from 61616 into 51616.
> >
> > 2. For Cassandra, I realized that the service must be running
> > during setup. I had to change the config files cassandra.yaml and
> > cassandra-env.sh for hostname, listen_address, rpc_address to be
> > 127.0.0.1, along created the folder " cdc_raw" that wasn't there by
> > default.
> >
> > 3. For local databases, when the services fail to start,
> > delete the databases in Casandra and start over until the services run
> successfully.
> > Going fotward, run the second command without "
> > -Ddemoserver.provision=true". That parameter was required to create
> > the DBs the first time.
> >
> > Regards,
> >
> > Louis
> >
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 16:45
> > To: Dev <de...@fineract.apache.org>
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Hello All,
> >
> > Below is the error logged when i try to start the FINERACT CN
> > server with provision = true. Don't get this when i set it to false. I
> > need to get the localstore created. So, not able to proceed. Can
> > someone who has faced this and resolved help me.?
> >
> > There was 1 failure:
> > 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561449009,"status":500,"error":"Internal
> > Server
> >
> > Error","exception":"java.lang.IllegalStateException","
> > message":"org.springfr
> > amework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > java.lang.IllegalStateException:
> > org.apache.fineract.cn.api.util.InternalServerError:
> >
> > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > Server
> >
> > Error\",\"exception\":\"com.datastax.driver.core.
> > exceptions.SyntaxError\",\"
> > message\":\"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input
> > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > provisioner/v1/tena
> > nts/playground/identityservice"}
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> >
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> >
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> >
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at
> > com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> > Source)
> >
> >
> > .'
> > .
> > .
> > .
> > 13:17:28.435 [qtp630028734-22] INFO
> > c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1'
> > for
> > DCAwareRoundRobinPolicy (if this is incorrect, please provide the
> > correct datacenter name with DCAwareRoundRobinPolicy constructor)
> > 13:17:28.435 [qtp630028734-22] INFO
> > com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042
> > added
> > 13:17:28.959 [qtp630028734-22] INFO
> > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'
> > 13:17:28.962 [qtp630028734-22] WARN
> > o.e.jetty.servlet.ServletHandler -
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkSer
> > vlet.java:982)
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > doPost(FrameworkServlet.jav
> > a:872)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.ja
> > va:846)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> >
> > .
> > .
> > .
> > .
> > .
> >
> > Caused by: org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561448970,"status":500,"error":"Internal
> > Server
> >
> > Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","
> > messag
> > e":"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'","path":"/identity/v1/initialize"}
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> >
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> >
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> >
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at com.sun.proxy.$Proxy153.initialize(Unknown Source)
> > at
> >
> > org.apache.fineract.cn.provisioner.internal.service.
> > applications.IdentitySer
> > viceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
> > ... 99 common frames omitted
> > 13:17:29.023 [Thread-15] INFO
> > o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext -
> > Closing
> >
> > org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebA
> > pp
> > lica
> > tionContext@11438d26:
> > startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
> >
> > org.springframework.context.annotation.AnnotationConfigApplicationCon
> > text@7d
> > c5e7b4
> >
> >
> > On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
> > karthik.a@beyondsquare.com> wrote:
> >
> > > Dear all,
> > >
> > > I am trying to setup Fineract CN in a EC2 machine following the
> > > instructions in
> > https://cwiki.apache.org/confluence/display/FINERACT/
> > > How+To+Build+Apache+Fineract+CN
> > >
> > > I am facing the below issues. I am trying to create
> > localstore DB to
> > > build the Jar. So i used the below command.
> > >
> > > java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > > -Dcassandra.cluster.user=cassandra
> > > -Dcassandra.cluster.pwd=password
> -Dcustom.mariadb.host=localhost
> > > -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> > > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> > >
> > > When i ran the above command, it created seshat and
> > playground schemas
> > > in MySQL and Cassandra. In MySQL - It didnot create any
> > tables in playground..
> > > It only created 1 entry in seshat - tenants table.
> > >
> > > Also i got the below error and server startup failed.
> > >
> > > Could not connect to broker URL: tcp://localhost:61616. Reason:
> > > java.net.ConnectException: Connection refused (Connection
> > refused)
> > > Should i install Active MQ separately.? Also, i have not
> > installed
> > > Maria DB. If anyone has done the setup successfully, please
> > help us.
> > >
> > > Thanks,
> > > Karthik
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
Re: Fineract CN Setup issues
Posted by Markus Geiss <ma...@apache.org>.
Hey Karthik,
in the source tree of the UI you will find a file called proxy.conf.json.
You simply need to adjust the configured URLs and ports to point to
your back end services.Then you can run it with 'npm run runProd'.
It is recommended to either use nginx or Apache httpd to serve the
static content. In this case you need to configure the http service to
be a reverse proxy for the back end.
Cheers
Markus
.::Yagni likes a DRY KISS::.
On Tue, Aug 7, 2018 at 6:40 PM Louis Niyongabo <ln...@gmail.com> wrote:
> Welcome, glad it worked.
> For local deployment of client, I have no idea on how to proceed.
> Hope someone else will pick it up and help you on this.
> Good luck.
> Louis
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Tuesday, August 7, 2018 18:27
> To: Dev <de...@fineract.apache.org>
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Thank you Louis for the support.
>
> I Unstalled Cassandra, reinstalled it and made config changes to yaml file
> and server started properly and tables got created in schema.
>
> I have deployed Fineract CN in AWS EC2. I want to deploy the front-end in
> my local machine and connect the backend deployed in AWS. What changes i
> have to make in front end.?
>
> Regards,
> Karthik
>
>
>
> On Mon, Aug 6, 2018 at 11:12 PM, Louis Niyongabo <ln...@gmail.com>
> wrote:
>
> > Well, I know only what I tested on my dev machine Windows 10 64 bit.
> > Other than setting up CASSANDRA_HOME in environment variables, I also
> > changed these attached files "cassandra.yaml" and " cassandra-env.sh"
> > (I appended txt to prevent them from being email-blocked) following
> > some guidelines from Internet.
> >
> > Use a tool like Notepad++(plugin compare) to verify how those files
> > are different from yours, eventually you may pick what you need to
> > change at your end. Which OS are you running?
> >
> > If it doesn't work, we can discuss further off this forum tomorrow
> morning.
> >
> > Regards,
> >
> > Louis
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 19:23
> > To: dev@fineract.apache.org; dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > How do I fix this Louis.?
> >
> > Get Outlook for iOS<https://aka.ms/o0ukef>
> > ______________________________ __
> > From: Louis Niyongabo <ln...@gmail.com>
> > Sent: Monday, August 6, 2018 10:51:01 PM
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: RE: Fineract CN Setup issues
> >
> > The first error (datastax) seems to be related to Cassandra.
> > I tested on Windows box, this service DataStax_DDC_Server (DataStax
> > DDC Server 3.9.0) had to be running.
> > Please take note that it's different from starting Cassandra from its
> path.
> >
> > I could have Cassandra successfully started, but the service
> > DataStax_DDC_Server would still fail to start. The setup went through
> > only when the Service could start successfully.
> >
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 19:06
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Below is the error I got when I deleted the DBs in Cassandra, MySQL
> > and started the server with the given command.
> >
> > There was 1 failure:
> > 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561449009,"status":500,"error":"Internal Server
> > Error","exception":"java.lang.IllegalStateException","
> > message":"org.springfr
> > amework.web.util.NestedServletException: Request processing failed;
> > nested exception is java.lang.IllegalStateException:
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > Server Error\",\"exception\":\"com.datastax.driver.core.
> > exceptions.SyntaxError\",\"
> > message\":\"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
> > alternative at input
> > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > provisioner/v1/tena
> > nts/playground/identityservice"}
> > at
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
> .
> > .
> > .
> > .
> > .
> >
> > 13:17:28.959 [qtp630028734-22] INFO
> > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is com.datastax.driver.core.
> > exceptions.SyntaxError:
> > line 8:22 no viable alternative at input 'date'
> > 13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler
> > -
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is com.datastax.driver.core.
> > exceptions.SyntaxError:
> > line 8:22 no viable alternative at input 'date'
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkSer
> > vlet.java:982)
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > doPost(FrameworkServlet.jav
> > a:872)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> > at
> > org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.ja
> > va:846)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> >
> >
> > On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
> >
> > No idea, let's rebuild those DBs:
> >
> > 1. delete 'seshat' and 'playground' databases from Cassandra and
> MySQL.
> >
> > 2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
> > -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
> > -Dcustom.mariadb.password=mysql -jar
> > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >
> > And share the errors you get.
> >
> > Louis
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 18:37
> > To: dev@fineract.apache.org
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Thanks Louis. Will try this.
> >
> > Any idea, why tables are not getting created in MySQL playground
> > DB schema.? Will they not be created when we start the Fineract server.?
> >
> > On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com>
> wrote:
> >
> > Hi Karthik,
> >
> > Reference to your first email, I run into similar issues, down
> > how the workaround I used on Windows,
> >
> > 1. For the port 61616, I was getting this error
> > "java.io.IOException: Failed to bind to server socket:
> > tcp://localhost:61616
> > due to: java.net.BindException: Address already in use: JVM_Bind". I
> > fixed it by changing the config file activemq.xml, from 61616 into 51616.
> >
> > 2. For Cassandra, I realized that the service must be running
> > during setup. I had to change the config files cassandra.yaml and
> > cassandra-env.sh for hostname, listen_address, rpc_address to be
> > 127.0.0.1, along created the folder " cdc_raw" that wasn't there by
> > default.
> >
> > 3. For local databases, when the services fail to start,
> > delete the databases in Casandra and start over until the services run
> successfully.
> > Going fotward, run the second command without "
> > -Ddemoserver.provision=true". That parameter was required to create
> > the DBs the first time.
> >
> > Regards,
> >
> > Louis
> >
> >
> >
> > -----Original Message-----
> > From: Karthik Ananthakrishnan
> > [mailto:karthik.a@beyondsquare.com.INVALID]
> > Sent: Monday, August 6, 2018 16:45
> > To: Dev <de...@fineract.apache.org>
> > Cc: myrle@apache.org
> > Subject: Re: Fineract CN Setup issues
> >
> > Hello All,
> >
> > Below is the error logged when i try to start the FINERACT CN
> > server with provision = true. Don't get this when i set it to false. I
> > need to get the localstore created. So, not able to proceed. Can
> > someone who has faced this and resolved help me.?
> >
> > There was 1 failure:
> > 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> > org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561449009,"status":500,"error":"Internal
> > Server
> >
> > Error","exception":"java.lang.IllegalStateException","
> > message":"org.springfr
> > amework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > java.lang.IllegalStateException:
> > org.apache.fineract.cn.api.util.InternalServerError:
> >
> > {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> > Server
> >
> > Error\",\"exception\":\"com.datastax.driver.core.
> > exceptions.SyntaxError\",\"
> > message\":\"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input
> > 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> > provisioner/v1/tena
> > nts/playground/identityservice"}
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> >
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> >
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> >
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at
> > com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> > Source)
> >
> >
> > .'
> > .
> > .
> > .
> > 13:17:28.435 [qtp630028734-22] INFO
> > c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1'
> > for
> > DCAwareRoundRobinPolicy (if this is incorrect, please provide the
> > correct datacenter name with DCAwareRoundRobinPolicy constructor)
> > 13:17:28.435 [qtp630028734-22] INFO
> > com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042
> > added
> > 13:17:28.959 [qtp630028734-22] INFO
> > o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'
> > 13:17:28.962 [qtp630028734-22] WARN
> > o.e.jetty.servlet.ServletHandler -
> > org.springframework.web.util.NestedServletException: Request
> > processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkSer
> > vlet.java:982)
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > doPost(FrameworkServlet.jav
> > a:872)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> > at
> >
> > org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.ja
> > va:846)
> > at
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
> >
> > .
> > .
> > .
> > .
> > .
> >
> > Caused by: org.apache.fineract.cn.api.util.InternalServerError:
> > {"timestamp":1533561448970,"status":500,"error":"Internal
> > Server
> >
> > Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","
> > messag
> > e":"org.springframework.web.util.NestedServletException:
> > Request processing failed; nested exception is
> > com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> > viable alternative at input 'date'","path":"/identity/v1/initialize"}
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > getAlternative(Annotat
> > edErrorDecoder.java:78)
> > at
> >
> > org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> > decode(AnnotatedErrorD
> > ecoder.java:65)
> > at
> >
> > feign.SynchronousMethodHandler.executeAndDecode(
> > SynchronousMethodHandler.jav
> > a:138)
> > at
> >
> > feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> > at
> >
> > feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> > ReflectiveFeign.java:103
> > )
> > at com.sun.proxy.$Proxy153.initialize(Unknown Source)
> > at
> >
> > org.apache.fineract.cn.provisioner.internal.service.
> > applications.IdentitySer
> > viceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
> > ... 99 common frames omitted
> > 13:17:29.023 [Thread-15] INFO
> > o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext -
> > Closing
> >
> > org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebA
> > pp
> > lica
> > tionContext@11438d26:
> > startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
> >
> > org.springframework.context.annotation.AnnotationConfigApplicationCon
> > text@7d
> > c5e7b4
> >
> >
> > On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
> > karthik.a@beyondsquare.com> wrote:
> >
> > > Dear all,
> > >
> > > I am trying to setup Fineract CN in a EC2 machine following the
> > > instructions in
> > https://cwiki.apache.org/confluence/display/FINERACT/
> > > How+To+Build+Apache+Fineract+CN
> > >
> > > I am facing the below issues. I am trying to create
> > localstore DB to
> > > build the Jar. So i used the below command.
> > >
> > > java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > > -Dcassandra.cluster.user=cassandra
> > > -Dcassandra.cluster.pwd=password
> -Dcustom.mariadb.host=localhost
> > > -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> > > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> > >
> > > When i ran the above command, it created seshat and
> > playground schemas
> > > in MySQL and Cassandra. In MySQL - It didnot create any
> > tables in playground..
> > > It only created 1 entry in seshat - tenants table.
> > >
> > > Also i got the below error and server startup failed.
> > >
> > > Could not connect to broker URL: tcp://localhost:61616. Reason:
> > > java.net.ConnectException: Connection refused (Connection
> > refused)
> > > Should i install Active MQ separately.? Also, i have not
> > installed
> > > Maria DB. If anyone has done the setup successfully, please
> > help us.
> > >
> > > Thanks,
> > > Karthik
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
RE: Fineract CN Setup issues
Posted by Louis Niyongabo <ln...@gmail.com>.
Welcome, glad it worked.
For local deployment of client, I have no idea on how to proceed.
Hope someone else will pick it up and help you on this.
Good luck.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Tuesday, August 7, 2018 18:27
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thank you Louis for the support.
I Unstalled Cassandra, reinstalled it and made config changes to yaml file and server started properly and tables got created in schema.
I have deployed Fineract CN in AWS EC2. I want to deploy the front-end in my local machine and connect the backend deployed in AWS. What changes i have to make in front end.?
Regards,
Karthik
On Mon, Aug 6, 2018 at 11:12 PM, Louis Niyongabo <ln...@gmail.com>
wrote:
> Well, I know only what I tested on my dev machine Windows 10 64 bit.
> Other than setting up CASSANDRA_HOME in environment variables, I also
> changed these attached files "cassandra.yaml" and " cassandra-env.sh"
> (I appended txt to prevent them from being email-blocked) following
> some guidelines from Internet.
>
> Use a tool like Notepad++(plugin compare) to verify how those files
> are different from yours, eventually you may pick what you need to
> change at your end. Which OS are you running?
>
> If it doesn't work, we can discuss further off this forum tomorrow morning.
>
> Regards,
>
> Louis
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 19:23
> To: dev@fineract.apache.org; dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> How do I fix this Louis.?
>
> Get Outlook for iOS<https://aka.ms/o0ukef>
> ______________________________ __
> From: Louis Niyongabo <ln...@gmail.com>
> Sent: Monday, August 6, 2018 10:51:01 PM
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: RE: Fineract CN Setup issues
>
> The first error (datastax) seems to be related to Cassandra.
> I tested on Windows box, this service DataStax_DDC_Server (DataStax
> DDC Server 3.9.0) had to be running.
> Please take note that it's different from starting Cassandra from its path.
>
> I could have Cassandra successfully started, but the service
> DataStax_DDC_Server would still fail to start. The setup went through
> only when the Service could start successfully.
>
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 19:06
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Below is the error I got when I deleted the DBs in Cassandra, MySQL
> and started the server with the given command.
>
> There was 1 failure:
> 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561449009,"status":500,"error":"Internal Server
> Error","exception":"java.lang.IllegalStateException","
> message":"org.springfr
> amework.web.util.NestedServletException: Request processing failed;
> nested exception is java.lang.IllegalStateException:
> org.apache.fineract.cn.api.util.InternalServerError:
> {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> Server Error\",\"exception\":\"com.datastax.driver.core.
> exceptions.SyntaxError\",\"
> message\":\"org.springframework.web.util.NestedServletException:
> Request processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
> alternative at input
> 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> provisioner/v1/tena
> nts/playground/identityservice"}
> at
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source) .
> .
> .
> .
> .
>
> 13:17:28.959 [qtp630028734-22] INFO
> o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is com.datastax.driver.core.
> exceptions.SyntaxError:
> line 8:22 no viable alternative at input 'date'
> 13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler
> -
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is com.datastax.driver.core.
> exceptions.SyntaxError:
> line 8:22 no viable alternative at input 'date'
> at
> org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkSer
> vlet.java:982)
> at
> org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.jav
> a:872)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> at
> org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.ja
> va:846)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>
>
> On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
>
> No idea, let's rebuild those DBs:
>
> 1. delete 'seshat' and 'playground' databases from Cassandra and MySQL.
>
> 2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
> -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
> -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> And share the errors you get.
>
> Louis
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 18:37
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Thanks Louis. Will try this.
>
> Any idea, why tables are not getting created in MySQL playground
> DB schema.? Will they not be created when we start the Fineract server.?
>
> On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
>
> Hi Karthik,
>
> Reference to your first email, I run into similar issues, down
> how the workaround I used on Windows,
>
> 1. For the port 61616, I was getting this error
> "java.io.IOException: Failed to bind to server socket:
> tcp://localhost:61616
> due to: java.net.BindException: Address already in use: JVM_Bind". I
> fixed it by changing the config file activemq.xml, from 61616 into 51616.
>
> 2. For Cassandra, I realized that the service must be running
> during setup. I had to change the config files cassandra.yaml and
> cassandra-env.sh for hostname, listen_address, rpc_address to be
> 127.0.0.1, along created the folder " cdc_raw" that wasn't there by
> default.
>
> 3. For local databases, when the services fail to start,
> delete the databases in Casandra and start over until the services run successfully.
> Going fotward, run the second command without "
> -Ddemoserver.provision=true". That parameter was required to create
> the DBs the first time.
>
> Regards,
>
> Louis
>
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 16:45
> To: Dev <de...@fineract.apache.org>
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Hello All,
>
> Below is the error logged when i try to start the FINERACT CN
> server with provision = true. Don't get this when i set it to false. I
> need to get the localstore created. So, not able to proceed. Can
> someone who has faced this and resolved help me.?
>
> There was 1 failure:
> 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561449009,"status":500,"error":"Internal
> Server
>
> Error","exception":"java.lang.IllegalStateException","
> message":"org.springfr
> amework.web.util.NestedServletException:
> Request processing failed; nested exception is
> java.lang.IllegalStateException:
> org.apache.fineract.cn.api.util.InternalServerError:
>
> {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> Server
>
> Error\",\"exception\":\"com.datastax.driver.core.
> exceptions.SyntaxError\",\"
> message\":\"org.springframework.web.util.NestedServletException:
> Request processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable alternative at input
> 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> provisioner/v1/tena
> nts/playground/identityservice"}
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
>
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
>
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
>
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at
> com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> Source)
>
>
> .'
> .
> .
> .
> 13:17:28.435 [qtp630028734-22] INFO
> c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1'
> for
> DCAwareRoundRobinPolicy (if this is incorrect, please provide the
> correct datacenter name with DCAwareRoundRobinPolicy constructor)
> 13:17:28.435 [qtp630028734-22] INFO
> com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042
> added
> 13:17:28.959 [qtp630028734-22] INFO
> o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable alternative at input 'date'
> 13:17:28.962 [qtp630028734-22] WARN
> o.e.jetty.servlet.ServletHandler -
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable alternative at input 'date'
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkSer
> vlet.java:982)
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.jav
> a:872)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.ja
> va:846)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>
> .
> .
> .
> .
> .
>
> Caused by: org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561448970,"status":500,"error":"Internal
> Server
>
> Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","
> messag
> e":"org.springframework.web.util.NestedServletException:
> Request processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable alternative at input 'date'","path":"/identity/v1/initialize"}
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
>
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
>
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
>
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at com.sun.proxy.$Proxy153.initialize(Unknown Source)
> at
>
> org.apache.fineract.cn.provisioner.internal.service.
> applications.IdentitySer
> viceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
> ... 99 common frames omitted
> 13:17:29.023 [Thread-15] INFO
> o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext -
> Closing
>
> org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebA
> pp
> lica
> tionContext@11438d26:
> startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
>
> org.springframework.context.annotation.AnnotationConfigApplicationCon
> text@7d
> c5e7b4
>
>
> On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
> karthik.a@beyondsquare.com> wrote:
>
> > Dear all,
> >
> > I am trying to setup Fineract CN in a EC2 machine following the
> > instructions in
> https://cwiki.apache.org/confluence/display/FINERACT/
> > How+To+Build+Apache+Fineract+CN
> >
> > I am facing the below issues. I am trying to create
> localstore DB to
> > build the Jar. So i used the below command.
> >
> > java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > -Dcassandra.cluster.user=cassandra
> > -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> > -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >
> > When i ran the above command, it created seshat and
> playground schemas
> > in MySQL and Cassandra. In MySQL - It didnot create any
> tables in playground..
> > It only created 1 entry in seshat - tenants table.
> >
> > Also i got the below error and server startup failed.
> >
> > Could not connect to broker URL: tcp://localhost:61616. Reason:
> > java.net.ConnectException: Connection refused (Connection
> refused)
> > Should i install Active MQ separately.? Also, i have not
> installed
> > Maria DB. If anyone has done the setup successfully, please
> help us.
> >
> > Thanks,
> > Karthik
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Thank you Louis for the support.
I Unstalled Cassandra, reinstalled it and made config changes to yaml file
and server started properly and tables got created in schema.
I have deployed Fineract CN in AWS EC2. I want to deploy the front-end in
my local machine and connect the backend deployed in AWS. What changes i
have to make in front end.?
Regards,
Karthik
On Mon, Aug 6, 2018 at 11:12 PM, Louis Niyongabo <ln...@gmail.com>
wrote:
> Well, I know only what I tested on my dev machine Windows 10 64 bit.
> Other than setting up CASSANDRA_HOME in environment variables, I also
> changed these attached files "cassandra.yaml" and " cassandra-env.sh" (I
> appended txt to prevent them from being email-blocked) following some
> guidelines from Internet.
>
> Use a tool like Notepad++(plugin compare) to verify how those files are
> different from yours, eventually you may pick what you need to change at
> your end. Which OS are you running?
>
> If it doesn't work, we can discuss further off this forum tomorrow morning.
>
> Regards,
>
> Louis
>
> -----Original Message-----
> From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 19:23
> To: dev@fineract.apache.org; dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> How do I fix this Louis.?
>
> Get Outlook for iOS<https://aka.ms/o0ukef> ______________________________
> __
> From: Louis Niyongabo <ln...@gmail.com>
> Sent: Monday, August 6, 2018 10:51:01 PM
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: RE: Fineract CN Setup issues
>
> The first error (datastax) seems to be related to Cassandra.
> I tested on Windows box, this service DataStax_DDC_Server (DataStax DDC
> Server 3.9.0) had to be running.
> Please take note that it's different from starting Cassandra from its path.
>
> I could have Cassandra successfully started, but the service
> DataStax_DDC_Server would still fail to start. The setup went through only
> when the Service could start successfully.
>
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 19:06
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Below is the error I got when I deleted the DBs in Cassandra, MySQL and
> started the server with the given command.
>
> There was 1 failure:
> 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561449009,"status":500,"error":"Internal Server
> Error","exception":"java.lang.IllegalStateException","
> message":"org.springfr
> amework.web.util.NestedServletException: Request processing failed; nested
> exception is java.lang.IllegalStateException:
> org.apache.fineract.cn.api.util.InternalServerError:
> {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
> Error\",\"exception\":\"com.datastax.driver.core.
> exceptions.SyntaxError\",\"
> message\":\"org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
> alternative at input
> 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> provisioner/v1/tena
> nts/playground/identityservice"}
> at
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source) .
> .
> .
> .
> .
>
> 13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter -
> Unexpected exception caught
> org.springframework.web.util.NestedServletException: Request processing
> failed; nested exception is com.datastax.driver.core.
> exceptions.SyntaxError:
> line 8:22 no viable alternative at input 'date'
> 13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
> org.springframework.web.util.NestedServletException: Request processing
> failed; nested exception is com.datastax.driver.core.
> exceptions.SyntaxError:
> line 8:22 no viable alternative at input 'date'
> at
> org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkSer
> vlet.java:982)
> at
> org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.jav
> a:872)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> at
> org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.ja
> va:846)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>
>
> On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
>
> No idea, let's rebuild those DBs:
>
> 1. delete 'seshat' and 'playground' databases from Cassandra and MySQL.
>
> 2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
> -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
> -Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> And share the errors you get.
>
> Louis
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 18:37
> To: dev@fineract.apache.org
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Thanks Louis. Will try this.
>
> Any idea, why tables are not getting created in MySQL playground DB
> schema.? Will they not be created when we start the Fineract server.?
>
> On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
>
> Hi Karthik,
>
> Reference to your first email, I run into similar issues, down how
> the workaround I used on Windows,
>
> 1. For the port 61616, I was getting this error
> "java.io.IOException: Failed to bind to server socket:
> tcp://localhost:61616
> due to: java.net.BindException: Address already in use: JVM_Bind". I fixed
> it by changing the config file activemq.xml, from 61616 into 51616.
>
> 2. For Cassandra, I realized that the service must be running
> during
> setup. I had to change the config files cassandra.yaml and cassandra-env.sh
> for hostname, listen_address, rpc_address to be 127.0.0.1, along created
> the
> folder " cdc_raw" that wasn't there by default.
>
> 3. For local databases, when the services fail to start, delete the
> databases in Casandra and start over until the services run successfully.
> Going fotward, run the second command without "
> -Ddemoserver.provision=true". That parameter was required to create the DBs
> the first time.
>
> Regards,
>
> Louis
>
>
>
> -----Original Message-----
> From: Karthik Ananthakrishnan
> [mailto:karthik.a@beyondsquare.com.INVALID]
> Sent: Monday, August 6, 2018 16:45
> To: Dev <de...@fineract.apache.org>
> Cc: myrle@apache.org
> Subject: Re: Fineract CN Setup issues
>
> Hello All,
>
> Below is the error logged when i try to start the FINERACT CN
> server
> with provision = true. Don't get this when i set it to false. I need to get
> the localstore created. So, not able to proceed. Can someone who has faced
> this and resolved help me.?
>
> There was 1 failure:
> 1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
> org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561449009,"status":500,"error":"Internal Server
>
> Error","exception":"java.lang.IllegalStateException","
> message":"org.springfr
> amework.web.util.NestedServletException:
> Request processing failed; nested exception is
> java.lang.IllegalStateException:
> org.apache.fineract.cn.api.util.InternalServerError:
> {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
> Server
>
> Error\",\"exception\":\"com.datastax.driver.core.
> exceptions.SyntaxError\",\"
> message\":\"org.springframework.web.util.NestedServletException:
> Request processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable
> alternative at input
> 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/
> provisioner/v1/tena
> nts/playground/identityservice"}
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
>
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
>
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
>
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
> Source)
>
>
> .'
> .
> .
> .
> 13:17:28.435 [qtp630028734-22] INFO
> c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1'
> for
> DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct
> datacenter name with DCAwareRoundRobinPolicy constructor)
> 13:17:28.435 [qtp630028734-22] INFO
> com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042
> added
> 13:17:28.959 [qtp630028734-22] INFO
> o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable
> alternative at input 'date'
> 13:17:28.962 [qtp630028734-22] WARN
> o.e.jetty.servlet.ServletHandler -
> org.springframework.web.util.NestedServletException: Request
> processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable
> alternative at input 'date'
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkSer
> vlet.java:982)
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.jav
> a:872)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
> at
>
> org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.ja
> va:846)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>
> .
> .
> .
> .
> .
>
> Caused by: org.apache.fineract.cn.api.util.InternalServerError:
> {"timestamp":1533561448970,"status":500,"error":"Internal Server
>
> Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","
> messag
> e":"org.springframework.web.util.NestedServletException:
> Request processing failed; nested exception is
> com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no
> viable
> alternative at input 'date'","path":"/identity/v1/initialize"}
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> getAlternative(Annotat
> edErrorDecoder.java:78)
> at
>
> org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.
> decode(AnnotatedErrorD
> ecoder.java:65)
> at
>
> feign.SynchronousMethodHandler.executeAndDecode(
> SynchronousMethodHandler.jav
> a:138)
> at
>
> feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
> at
>
> feign.ReflectiveFeign$FeignInvocationHandler.invoke(
> ReflectiveFeign.java:103
> )
> at com.sun.proxy.$Proxy153.initialize(Unknown Source)
> at
>
> org.apache.fineract.cn.provisioner.internal.service.
> applications.IdentitySer
> viceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
> ... 99 common frames omitted
> 13:17:29.023 [Thread-15] INFO
> o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
>
> org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApp
> lica
> tionContext@11438d26:
> startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
>
> org.springframework.context.annotation.AnnotationConfigApplicationCon
> text@7d
> c5e7b4
>
>
> On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
> karthik.a@beyondsquare.com> wrote:
>
> > Dear all,
> >
> > I am trying to setup Fineract CN in a EC2 machine following the
> > instructions in
> https://cwiki.apache.org/confluence/display/FINERACT/
> > How+To+Build+Apache+Fineract+CN
> >
> > I am facing the below issues. I am trying to create localstore DB
> to
> > build the Jar. So i used the below command.
> >
> > java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> > -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> > -Dcassandra.cluster.user=cassandra
> > -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> > -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> > demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >
> > When i ran the above command, it created seshat and playground
> schemas
> > in MySQL and Cassandra. In MySQL - It didnot create any tables in
> playground..
> > It only created 1 entry in seshat - tenants table.
> >
> > Also i got the below error and server startup failed.
> >
> > Could not connect to broker URL: tcp://localhost:61616. Reason:
> > java.net.ConnectException: Connection refused (Connection
> refused)
> > Should i install Active MQ separately.? Also, i have not
> installed
> > Maria DB. If anyone has done the setup successfully, please help
> us.
> >
> > Thanks,
> > Karthik
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
RE: Fineract CN Setup issues
Posted by Louis Niyongabo <ln...@gmail.com>.
Well, I know only what I tested on my dev machine Windows 10 64 bit.
Other than setting up CASSANDRA_HOME in environment variables, I also
changed these attached files "cassandra.yaml" and " cassandra-env.sh" (I
appended txt to prevent them from being email-blocked) following some
guidelines from Internet.
Use a tool like Notepad++(plugin compare) to verify how those files are
different from yours, eventually you may pick what you need to change at
your end. Which OS are you running?
If it doesn't work, we can discuss further off this forum tomorrow morning.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 19:23
To: dev@fineract.apache.org; dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
How do I fix this Louis.?
Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________
From: Louis Niyongabo <ln...@gmail.com>
Sent: Monday, August 6, 2018 10:51:01 PM
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: RE: Fineract CN Setup issues
The first error (datastax) seems to be related to Cassandra.
I tested on Windows box, this service DataStax_DDC_Server (DataStax DDC
Server 3.9.0) had to be running.
Please take note that it's different from starting Cassandra from its path.
I could have Cassandra successfully started, but the service
DataStax_DDC_Server would still fail to start. The setup went through only
when the Service could start successfully.
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 19:06
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Below is the error I got when I deleted the DBs in Cassandra, MySQL and
started the server with the given command.
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springfr
amework.web.util.NestedServletException: Request processing failed; nested
exception is java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"
message\":\"org.springframework.web.util.NestedServletException: Request
processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input
'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tena
nts/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(Annotat
edErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorD
ecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.jav
a:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103
)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source) .
.
.
.
.
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter -
Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError:
line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError:
line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.jav
a:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.ja
va:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
No idea, let's rebuild those DBs:
1. delete 'seshat' and 'playground' databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true
-Dcustom.cassandra.contactPoints=127.0.0.1:9042
-Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
-Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root
-Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan
[mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 18:37
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB
schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how
the workaround I used on Windows,
1. For the port 61616, I was getting this error
"java.io.IOException: Failed to bind to server socket: tcp://localhost:61616
due to: java.net.BindException: Address already in use: JVM_Bind". I fixed
it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during
setup. I had to change the config files cassandra.yaml and cassandra-env.sh
for hostname, listen_address, rpc_address to be 127.0.0.1, along created the
folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the
databases in Casandra and start over until the services run successfully.
Going fotward, run the second command without "
-Ddemoserver.provision=true". That parameter was required to create the DBs
the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan
[mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server
with provision = true. Don't get this when i set it to false. I need to get
the localstore created. So, not able to proceed. Can someone who has faced
this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springfr
amework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal
Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"
message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input
'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tena
nts/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(Annotat
edErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorD
ecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.jav
a:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103
)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown
Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO
c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for
DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct
datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO
com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO
o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request
processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN
o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request
processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.jav
a:872)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.ja
va:846)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","messag
e":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(Annotat
edErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorD
ecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.jav
a:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103
)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentitySer
viceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplica
tionContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7d
c5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in
https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB
to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground
schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in
playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help
us.
>
> Thanks,
> Karthik
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
How do I fix this Louis.?
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Louis Niyongabo <ln...@gmail.com>
Sent: Monday, August 6, 2018 10:51:01 PM
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: RE: Fineract CN Setup issues
The first error (datastax) seems to be related to Cassandra.
I tested on Windows box, this service DataStax_DDC_Server (DataStax DDC Server 3.9.0) had to be running.
Please take note that it's different from starting Cassandra from its path.
I could have Cassandra successfully started, but the service DataStax_DDC_Server would still fail to start. The setup went through only when the Service could start successfully.
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 19:06
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Below is the error I got when I deleted the DBs in Cassandra, MySQL and started the server with the given command.
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError: {"timestamp":1533561449009,"status":500,"error":"Internal Server Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: org.apache.fineract.cn.api.util.InternalServerError: {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source) .
.
.
.
.
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
No idea, let's rebuild those DBs:
1. delete ‘seshat’ and ‘playground’ databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true -Dcustom.cassandra.contactPoints=127.0.0.1:9042 -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 18:37
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
RE: Fineract CN Setup issues
Posted by Louis Niyongabo <ln...@gmail.com>.
The first error (datastax) seems to be related to Cassandra.
I tested on Windows box, this service DataStax_DDC_Server (DataStax DDC Server 3.9.0) had to be running.
Please take note that it's different from starting Cassandra from its path.
I could have Cassandra successfully started, but the service DataStax_DDC_Server would still fail to start. The setup went through only when the Service could start successfully.
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 19:06
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Below is the error I got when I deleted the DBs in Cassandra, MySQL and started the server with the given command.
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError: {"timestamp":1533561449009,"status":500,"error":"Internal Server Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: org.apache.fineract.cn.api.util.InternalServerError: {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source) .
.
.
.
.
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
No idea, let's rebuild those DBs:
1. delete ‘seshat’ and ‘playground’ databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true -Dcustom.cassandra.contactPoints=127.0.0.1:9042 -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 18:37
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Below is the error I got when I deleted the DBs in Cassandra, MySQL and started the server with the given command.
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError: {"timestamp":1533561449009,"status":500,"error":"Internal Server Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: org.apache.fineract.cn.api.util.InternalServerError: {\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.
.
.
.
.
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
On 06/08/18, 10:24 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
No idea, let's rebuild those DBs:
1. delete ‘seshat’ and ‘playground’ databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true -Dcustom.cassandra.contactPoints=127.0.0.1:9042 -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 18:37
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
RE: Fineract CN Setup issues
Posted by Louis Niyongabo <ln...@gmail.com>.
No idea, let's rebuild those DBs:
1. delete ‘seshat’ and ‘playground’ databases from Cassandra and MySQL.
2. java -Ddemoserver.provision=true -Ddemoserver.persistent=true -Dcustom.cassandra.contactPoints=127.0.0.1:9042 -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
And share the errors you get.
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 18:37
To: dev@fineract.apache.org
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Thanks Louis. Will try this.
Any idea, why tables are not getting created in MySQL playground DB schema.? Will they not be created when we start the Fineract server.?
On 06/08/18, 9:33 PM, "Louis Niyongabo" <ln...@gmail.com> wrote:
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
RE: Fineract CN Setup issues
Posted by Louis Niyongabo <ln...@gmail.com>.
Hi Karthik,
Reference to your first email, I run into similar issues, down how the workaround I used on Windows,
1. For the port 61616, I was getting this error "java.io.IOException: Failed to bind to server socket: tcp://localhost:61616 due to: java.net.BindException: Address already in use: JVM_Bind". I fixed it by changing the config file activemq.xml, from 61616 into 51616.
2. For Cassandra, I realized that the service must be running during setup. I had to change the config files cassandra.yaml and cassandra-env.sh for hostname, listen_address, rpc_address to be 127.0.0.1, along created the folder " cdc_raw" that wasn't there by default.
3. For local databases, when the services fail to start, delete the databases in Casandra and start over until the services run successfully. Going fotward, run the second command without " -Ddemoserver.provision=true". That parameter was required to create the DBs the first time.
Regards,
Louis
-----Original Message-----
From: Karthik Ananthakrishnan [mailto:karthik.a@beyondsquare.com.INVALID]
Sent: Monday, August 6, 2018 16:45
To: Dev <de...@fineract.apache.org>
Cc: myrle@apache.org
Subject: Re: Fineract CN Setup issues
Hello All,
Below is the error logged when i try to start the FINERACT CN server with provision = true. Don't get this when i set it to false. I need to get the localstore created. So, not able to proceed. Can someone who has faced this and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy - Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter - Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan < karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to
> build the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042
> -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas
> in MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed
> Maria DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>
Re: Fineract CN Setup issues
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com.INVALID>.
Hello All,
Below is the error logged when i try to start the FINERACT CN server with
provision = true. Don't get this when i set it to false. I need to get the
localstore created. So, not able to proceed. Can someone who has faced this
and resolved help me.?
There was 1 failure:
1) startDevServer(org.apache.fineract.cn.dev.ServiceRunner)
org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561449009,"status":500,"error":"Internal Server
Error","exception":"java.lang.IllegalStateException","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
java.lang.IllegalStateException:
org.apache.fineract.cn.api.util.InternalServerError:
{\"timestamp\":1533561448970,\"status\":500,\"error\":\"Internal Server
Error\",\"exception\":\"com.datastax.driver.core.exceptions.SyntaxError\",\"message\":\"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input
'date'\",\"path\":\"/identity/v1/initialize\"}","path":"/provisioner/v1/tenants/playground/identityservice"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy196.assignIdentityManager(Unknown Source)
.'
.
.
.
13:17:28.435 [qtp630028734-22] INFO c.d.d.c.p.DCAwareRoundRobinPolicy -
Using data-center name 'datacenter1' for DCAwareRoundRobinPolicy (if this
is incorrect, please provide the correct datacenter name with
DCAwareRoundRobinPolicy constructor)
13:17:28.435 [qtp630028734-22] INFO com.datastax.driver.core.Cluster - New
Cassandra host /127.0.0.1:9042 added
13:17:28.959 [qtp630028734-22] INFO o.a.f.c.l.c.ServiceExceptionFilter -
Unexpected exception caught
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
13:17:28.962 [qtp630028734-22] WARN o.e.jetty.servlet.ServletHandler -
org.springframework.web.util.NestedServletException: Request processing
failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
.
.
.
.
.
Caused by: org.apache.fineract.cn.api.util.InternalServerError:
{"timestamp":1533561448970,"status":500,"error":"Internal Server
Error","exception":"com.datastax.driver.core.exceptions.SyntaxError","message":"org.springframework.web.util.NestedServletException:
Request processing failed; nested exception is
com.datastax.driver.core.exceptions.SyntaxError: line 8:22 no viable
alternative at input 'date'","path":"/identity/v1/initialize"}
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.getAlternative(AnnotatedErrorDecoder.java:78)
at
org.apache.fineract.cn.api.util.AnnotatedErrorDecoder.decode(AnnotatedErrorDecoder.java:65)
at
feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:138)
at
feign.SynchronousMethodHandler.invoke(SynchronousMethodHandler.java:76)
at
feign.ReflectiveFeign$FeignInvocationHandler.invoke(ReflectiveFeign.java:103)
at com.sun.proxy.$Proxy153.initialize(Unknown Source)
at
org.apache.fineract.cn.provisioner.internal.service.applications.IdentityServiceInitializer.initializeIsis(IdentityServiceInitializer.java:128)
... 99 common frames omitted
13:17:29.023 [Thread-15] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@11438d26:
startup date [Mon Aug 06 12:55:53 UTC 2018]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@7dc5e7b4
On Mon, Aug 6, 2018 at 4:02 PM, Karthik Ananthakrishnan <
karthik.a@beyondsquare.com> wrote:
> Dear all,
>
> I am trying to setup Fineract CN in a EC2 machine following the
> instructions in https://cwiki.apache.org/confluence/display/FINERACT/
> How+To+Build+Apache+Fineract+CN
>
> I am facing the below issues. I am trying to create localstore DB to build
> the Jar. So i used the below command.
>
> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> -Dcustom.cassandra.contactPoints=127.0.0.1:9042 -Dcassandra.cluster.user=cassandra
> -Dcassandra.cluster.pwd=password -Dcustom.mariadb.host=localhost
> -Dcustom.mariadb.user=root -Dcustom.mariadb.password=mysql -jar
> demo-server-0.1.0-BUILD-SNAPSHOT.jar
>
> When i ran the above command, it created seshat and playground schemas in
> MySQL and Cassandra. In MySQL - It didnot create any tables in playground..
> It only created 1 entry in seshat - tenants table.
>
> Also i got the below error and server startup failed.
>
> Could not connect to broker URL: tcp://localhost:61616. Reason:
> java.net.ConnectException: Connection refused (Connection refused)
> Should i install Active MQ separately.? Also, i have not installed Maria
> DB. If anyone has done the setup successfully, please help us.
>
> Thanks,
> Karthik
>
>
>