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 >> > >> >
