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 <[email protected]> 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:[email protected]] > Sent: Monday, August 6, 2018 19:23 > To: [email protected]; [email protected] > Cc: [email protected] > Subject: Re: Fineract CN Setup issues > > How do I fix this Louis.? > > Get Outlook for iOS<https://aka.ms/o0ukef> ______________________________ > __ > From: Louis Niyongabo <[email protected]> > Sent: Monday, August 6, 2018 10:51:01 PM > To: [email protected] > Cc: [email protected] > 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:[email protected]] > Sent: Monday, August 6, 2018 19:06 > To: [email protected] > Cc: [email protected] > 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" <[email protected]> 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:[email protected]] > Sent: Monday, August 6, 2018 18:37 > To: [email protected] > Cc: [email protected] > 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" <[email protected]> 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:[email protected]] > Sent: Monday, August 6, 2018 16:45 > To: Dev <[email protected]> > Cc: [email protected] > 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 < > [email protected]> 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 > > > > > > > > > > > > > > > >
