I Isaac,
I pulled the changes and rebuilt the projects.
Now when I run (postgres and cassandra working locally):
java -Ddemoserver.persistent=true -Ddemoserver.provision=true
-Dcustom.cassandra.contactPoints=127.0.0.1:9042
-Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
-Ddemoserver.lite=true -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
I get an error here:
11:18:42.066 [main] INFO o.s.b.c.e.j.JettyEmbeddedServletContainer - Jetty
started on port(s) 2024 (http/1.1)
11:18:42.067 [main] INFO o.s.c.n.e.EurekaDiscoveryClientConfiguration -
Updating port to 2024
11:18:42.072 [main] INFO o.a.f.c.customer.CustomerApplication - Started
CustomerApplication in 16.423 seconds (JVM running for 17.342)
11:18:57.435 [qtp1479696465-21] INFO o.a.f.c.l.c.ServiceExceptionFilter -
Responding with a service error ServiceError{code=409, message='Application
identity-v1 already exists!'}
11:18:57.464 [Thread-16] INFO
o.s.b.c.e.AnnotationConfigEmbeddedWebApplicationContext - Closing
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@4d50efb8:
startup date [Sun Mar 31 11:12:52 EEST 2019]; parent:
org.springframework.context.annotation.AnnotationConfigApplicationContext@75a1cd57
I understand I have to use -Ddemoserver.provision=true flag to provision
the initial database so I won't be able to take that one out.
Juhan
Kontakt Isaac Kamga (<[email protected]>) kirjutas kuupäeval R, 29.
märts 2019 kell 04:17:
> Hey Juhan,
>
> I have updated the Pull request to fineract-cn-provisioner with a commit
> [1] which fixes the errors you're experiencing.
>
> I'll advise that you test using option -Ddemoserver.persistent=true and
> -Ddemoserver.lite=true and we're testing just the minimal set of services
> now. In fact,I tested and the tail of my logs showed thus
> *identity-v1 address:http://localhost:2021/identity/v1
> <
> https://www.google.com/url?q=http://localhost:2021/identity/v1&sa=D&source=hangouts&ust=1553910362598000&usg=AFQjCNEjCID96mw3LF1ZIPmjEIQkHh_LcQ
> >*
>
> *office-v1 address:http://localhost:2023/office/v1
> <
> https://www.google.com/url?q=http://localhost:2023/office/v1&sa=D&source=hangouts&ust=1553910362598000&usg=AFQjCNGjyk1BHroLddOTd0FhJUJG4zdVag
> >customer-v1
> address:http://localhost:2024/customer/v1
> <
> https://www.google.com/url?q=http://localhost:2024/customer/v1&sa=D&source=hangouts&ust=1553910362599000&usg=AFQjCNGfcoJZIxmcsX34YeEXRUzS0oC2hA
> >*
> Albeit, this error [2] turned up related to the Notifications service. Just
> ignore it for now as it will be handled down the line during extensive
> integration testing.
>
> We can keep testing using -Ddemoserver.provision=true for later too when
> we've migrated and tested the individual services.
>
> Can you kindly update your provisioner repository and test once more and
> let's keep fixing ?
>
> [1]
>
> https://github.com/Izakey/fineract-cn-provisioner/commit/b83331b723f175003ccf069764414e4ab371662c
>
> [2] https://pastebin.com/DBzNyHir
>
> Cheers,
> Isaac Kamga.
>
> On Wed, Mar 27, 2019 at 10:23 PM Isaac Kamga <[email protected]>
> wrote:
>
> > Hello Juhan,
> >
> > Thank you for taking the time to do some testing.
> >
> > On Wed, Mar 27, 2019 at 10:56 AM Juhan Aasaru <[email protected]> wrote:
> >
> >> Hi Isaac,
> >>
> >> great initiative towards pushing to PostgreSQL.
> >>
> >> I looked at your instructions and tried to run your changes locally.
> >> The sh script came in handy to quickly clone and build everything that
> was
> >> needed.
> >> But then I got confused about provisioning.
> >>
> >> Question #1: How exactly I should run demo-server? I tried the following
> >> options:
> >>
> >> 1. I didn't have postgre and cassandra running locally.
> >> java -jar -Ddemoserver.lite=true demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >>
> >> resulted
> >>
> >> org.springframework.beans.factory.BeanCreationException: Error creating
> >> bean with name 'provisionerInitializer':
> >> Invocation of init method failed; nested exception is
> >> java.lang.IllegalStateException: Could not initialize service!
> >> Caused by: org.postgresql.util.PSQLException: FATAL: database "seshat"
> >> does
> >> not exist
> >>
> >
> > I haven't done testing using this option yet.
> >
> >
> >>
> >> 2. I started posgresql (and created a database seshat) and cassandra and
> >> ran:
> >> java -Ddemoserver.provision=true -Ddemoserver.persistent=true
> >> -Dcustom.cassandra.contactPoints=127.0.0.1:9042 \
> >> -Dcassandra.cluster.user=cassandra -Dcassandra.cluster.pwd=password
> >> -Ddemoserver.lite=true -jar demo-server-0.1.0-BUILD-SNAPSHOT.jar
> >>
> >> Initially applications started up one after anther
> >> (ProvisionerApplication,
> >> RhythmApplication, OfficeApplication)
> >> but CustomerApplication threw an exception:
> >>
> >> 11:50:39.377 [qtp1424482154-21] WARN o.e.jetty.servlet.ServletHandler -
> >> org.springframework.web.util.NestedServletException: Request processing
> >> failed; nested exception is java.lang.IllegalStateException: Could not
> >> insert org.apache.fineract.cn.provisioner.tenant info!
> >> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> >> "seshat.tenants" does not exist
> >>
> >
> > Try running the same command above without the provision=true option and
> > share what you get.
> >
> > I had to create database seshat in postgresql and the can't find database
> > error went away. Down the road, also encountered the same error
> > <https://pastebin.com/qCT1T5KM> "Could not insert ....
> provisioner.tenant
> > info !"
> > I'm currently working on resolving this.
> >
> >
> >>
> >> Question #2 - do I still need to have Mysql running? I see that you
> >> haven't
> >> made code changes to identity
> >> which as I understand still uses Mysql.
> >>
> >
> > I don't think you need MySQL running to test the migrations currently
> > underway and there was no need for code changes in the identity service.
> > However, it could be helpful to see the structure of the databases in
> MySQL
> > so that it helps with debugging and testing.
> >
> > Whenever you're available, tell me so we schedule a call so I look into
> > what your experiencing too.
> >
> > Cheers,
> > Isaac Kamga.
> >
> >
> >>
> >> Kind regards
> >> Juhan
> >>
> >>
> >> Kontakt Isaac Kamga (<[email protected]>) kirjutas kuupäeval L, 23.
> >> märts 2019 kell 04:31:
> >>
> >> > Hello fineracters,
> >> >
> >> > Trust that you had a great week.
> >> >
> >> > I just finished migrating libraries PostgreSQL[1] and Test[2] from
> >> MariaDB
> >> > to PostgreSQL, mostly adapting SQL statements & database connections
> to
> >> > work with PostgreSQL and reverting back to Hibernate ORM until
> database
> >> > migrations are completed.
> >> >
> >> > I have also migrated the "minimal" services viz provisioner[3],
> >> rhythm[4],
> >> > office[5], template[6] and customer[7] from MariaDB to PostgreSQL. The
> >> > Spring datasource credentials had to be incorporated into
> >> application.yaml
> >> > files to make things work too.
> >> >
> >> > Given I updated service-starter [8] and demo-server [9], developers
> can
> >> > test the migrated services when running the *-Ddemoserver.lite=true*
> >> option
> >> > which builds the minimal set of services.
> >> >
> >> > You'll observe that some of the pull requests are heading to develop
> >> > branches ( It appears comparing changes and creating PRs towards the
> >> same
> >> > branch name from origin to upstream expires after a few minutes on
> >> > Github... weird )
> >> >
> >> > Here is a script [10] to enable anyone clone and do an
> integration-test
> >> of
> >> > the new changes using demo-server.
> >> >
> >> > Kindly test these changes and provide feedback.
> >> >
> >> > At Your Service,
> >> > Isaac Kamga.
> >> >
> >> > [1] https://github.com/apache/fineract-cn-postgresql/pull/1
> >> > [2] https://github.com/apache/fineract-cn-test/pull/7
> >> > [3] https://github.com/apache/fineract-cn-provisioner/pull/6
> >> > [4] https://github.com/apache/fineract-cn-rhythm/pull/8
> >> > [5] https://github.com/apache/fineract-cn-office/pull/9
> >> > [6] https://github.com/apache/fineract-cn-template/pull/6
> >> > [7] https://github.com/apache/fineract-cn-customer/pull/10
> >> > [8] https://github.com/apache/fineract-cn-service-starter/pull/8
> >> > [9] https://github.com/apache/fineract-cn-demo-server/pull/27
> >> > [10]
> >> >
> >> >
> >>
> https://github.com/Izakey/fineract-cn-demo-server/blob/FINCN-141/scripts/Unix/postgres-setup-lite.sh
> >> >
> >>
> >
>
