OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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" <lniyongabo@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx.INVALID] 
    Sent: Monday, August 6, 2018 16:45
    To: Dev <dev@xxxxxxxxxxxxxxxxxxx>
    Cc: myrle@xxxxxxxxxx
    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@xxxxxxxxxxxxxxxx> 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
    >
    >
    >