Hey Juhan, Thanks for testing.
Wipe clean your Cassandra keyspaces first. I suspect that what's interferring is the keyspaces from your last run when using MariaDB. Please provide feedback how it goes. Cheers, Isaac Kamga. On Sun, Mar 31, 2019 at 10:00 AM Juhan Aasaru <[email protected]> wrote: > 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 > > >> > > > >> > > > > > >
