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" <lniyong...@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:karthi...@beyondsquare.com.INVALID] Sent: Monday, August 6, 2018 18:37 To: dev@fineract.apache.org Cc: my...@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" <lniyong...@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:karthi...@beyondsquare.com.INVALID] Sent: Monday, August 6, 2018 16:45 To: Dev <dev@fineract.apache.org> Cc: my...@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 < karthi...@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 > > >