Adam - should this go into a tech FAQ in the documentation? Thanks
Sent from Gmail Mobile On Mon, May 27, 2024 at 1:08 AM Ádám Sághy <adamsa...@gmail.com> wrote: > Hi > > Based on the error log you have shared, you have misconfigured something: > > m_adhoc table should not be created in the fineract_tenants database. > > Probably you have wrong configuration in the > "fineract_tenants.tenants_configuration" table. > > You might already done it but let me share usually how it works: > > > 1. Create two databases > - Create fineract_tenants and fineract_defaultdatabases > - MariaDB (default db engine) > - Execute createDB gradle task with the following params: > - > > ./gradlew createDB -PdbName=fineract_tenants > ./gradlew createDB -PdbName=fineract_default > > - MySql > - Execute createMySQLDB gradle task with the following > params: > - > > ./gradlew createMySQLDB -PdbName=fineract_tenants > ./gradlew createMySQLDB -PdbName=fineract_default > > - Postgres > - Execute createPGDB gradle task with the following params: > - > > ./gradlew createPGDB -PdbName=fineract_tenants > ./gradlew createPGDB -PdbName=fineract_default > > > The liquibase will initialize the tables and default entries into the > 'fineract_tenants' database first (you need to create the database manually > but thats all) > > The configurations in Fineract to connect to this database: > > > - Default tenants storage database: fineract_tenants > - This database will store the tenant details and connection > information to the tenant databases > - Database driver: org.mariadb.jdbc.Driver (by default) > - To override set the > FINERACT_HIKARI_DRIVER_SOURCE_CLASS_NAMEenvironment > variable > - JDBC url: jdbc:mariadb://localhost:3306/fineract_tenants > - To override set the FINERACT_HIKARI_JDBC_URLenvironment variable > - Database username: root > - To override set the FINERACT_HIKARI_USERNAMEenvironment variable > - Database password: password > - To override set the FINERACT_HIKARI_PASSWORDenvironment variable > > After the liquibase second step to initialize the tables and default > entries in the 'fineract_default' database! > (you need to create the database but thats all!) > > This can be overriden if needed: > > - By default the liquibase scripts will create a new tenant with the > below configurations > - Default tenant identifier: default > - To override set the FINERACT_DEFAULT_TENANTDB_IDENTIFIERenvironment > variable > - Default tenant database host: localhost > - To override set the FINERACT_DEFAULT_TENANTDB_HOSTNAMEenvironment > variable > - Default tenant database port: 3306 > - To override set the FINERACT_DEFAULT_TENANTDB_PORT environment > variable > - Default tenant database username: root > - To override set the FINERACT_DEFAULT_TENANTDB_UID environment > variable > - Default tenant database password: mysql > - To override set the FINERACT_DEFAULT_TENANTDB_PWD environment > variable > - Default tenant timezone: Asia/Kolkata > - To override set the FINERACT_DEFAULT_TENANTDB_TIMEZONEenvironment > variable > - Default tenant name: fineract_default > - To override set the FINERACT_DEFAULT_TENANTDB_NAME environment > variable > - Default tenant description: Default Demo Tenant > - To override set the > FINERACT_DEFAULT_TENANTDB_DESCRIPTIONenvironment > variable > - Default tenant master password: fineract > - To override set the > FINERACT_DEFAULT_TENANTDB_MASTER_PASSWORDenvironment > variable > - IMPORTANT: During the first time the liquibase executed the > plain text password got encrypted with the provided master password > - Default tenant encryption: AES/CBC/PKCS5Padding > - To override set the FINERACT_DEFAULT_TENANTDB_ENCRYPTIONenvironment > variable > > > Please take a look and give a try on a *clean* database! > > Regards, > Adam > > Sent from my iPhone > > On 27 May 2024, at 08:48, Joan Moreau <j...@grosjo.net> wrote: > > > > Hi > > his is absolutely incredible > > The tables *ARE NOT* created automatically by Liquid. Whatever you are > all repeating. and I sent already the log of it. > > So my question is : How to enable the creation of the tables, or just > please share the sql statement to create those table and avoid the Liquid, > so called "technology". > > Thank you so much in advance > > > On 26 May 2024 22:57:31 Naphlin Peter <starna...@gmail.com> wrote: > >> A good starting place is https://www.udemy.com/course/liquibase/ >> >> Since you are paying your money for it, you will have all the right to >> question if they are junks; if you still fail to understand that is. >> >> Quite frankly the people on this thread have been more than nice and >> genuine to you. >> >> On Sun, 26 May 2024, 17:42 Joan Moreau, <j...@grosjo.net> wrote: >> >>> Really, are you a bunch of junks ? >>> >>> I am genuinely asking on creating initial tables, no ine is able to say >>> "here is the actual process" >>> >>> >>> >>> On 26 May 2024 02:28:32 VICTOR MANUEL ROMERO RODRIGUEZ < >>> victor.rom...@fintecheando.mx> wrote: >>> >>>> :) >>>> >>>> El sáb., 25 de mayo de 2024 7:21 a. m., Joan Moreau <j...@grosjo.net> >>>> escribió: >>>> >>>>> Hi >>>>> >>>>> No tables are created obsivously, and nothing in the docs related to >>>>> creating the initial table >>>>> >>>>> If you have a pointer to the process of creating the tables, that >>>>> would be very helpful instead of "read the doc" >>>>> >>>>> >>>>> >>>>> >>>>> On 2024-05-15 22:32, VICTOR MANUEL ROMERO RODRIGUEZ wrote: >>>>> >>>>> Hello Joan, >>>>> >>>>> Please read the docs. It uses Liquibase, this "technology" creates the >>>>> tables, indexes and inserts some initial data, just make sure you have >>>>> created the tenantS and the tenant databases. >>>>> >>>>> Regards >>>>> >>>>> El mié, 15 may 2024 a las 3:57, Joan Moreau (<j...@grosjo.net>) >>>>> escribió: >>>>> >>>>> Ok but how to finally be able to /start/ the engine ? >>>>> >>>>> If no sql , then how to create the databases ? Should I enter manually >>>>> each table ? This is kind of crazy, isnt'it ? >>>>> >>>>> >>>>> >>>>> On 5/14/24 00:44, VICTOR MANUEL ROMERO RODRIGUEZ wrote: >>>>> >>>>> Apache Fineract doesn't have a SQL script, that SQL script that you >>>>> are looking for is a DDL (Data Definition Language with database,table, >>>>> fields,index creation, inserts etc ). >>>>> >>>>> Apache Fineract uses Liquibase and information about this >>>>> concept/technology has been already shared. >>>>> >>>>> If you are looking for a USER like information and non from DEV/TECH, >>>>> please take a look at >>>>> https://mifosforge.jira.com/wiki/spaces/docs/pages/3559555073/Mifos+X+23.12.31+Installation+Guide+for+Windows+11+Ubuntu+22.04+Lts >>>>> >>>>> Regards >>>>> >>>>> El dom, 12 may 2024 a las 21:27, Joan Moreau (<j...@grosjo.net>) >>>>> escribió: >>>>> >>>>> Hi >>>>> >>>>> What do you mean by "no sql" ? >>>>> >>>>> Database is MariadDB, it does need a sql statement to create the table >>>>> isn´t it ? >>>>> >>>>> Finareact is git master >>>>> >>>>> scrip[t to launch is : >>>>> >>>>> #!/bin/bash >>>>> cd /data/microfinance >>>>> export FINERACT_HIKARI_USERNAME=fineract >>>>> export FINERACT_HIKARI_PASSWORD=mypassword >>>>> export FINERACT_SERVER_SSL_ENABLED=false >>>>> export FINERACT_SERVER_PORT=8080 >>>>> export FINERACT_HIKARI_DRIVER_SOURCE_CLASS_NAME=org.mariadb.jdbc.Driver >>>>> export >>>>> FINERACT_HIKARI_JDBC_URL="jdbc:mariadb://localhost:3306/fineract_tenants?serverTimezone=UTC&useLegacyDatetimeCode=f >>>>> alse&sessionVariables=time_zone=UTC" >>>>> export FINERACT_DEFAULT_TENANTDB_PORT=3306 >>>>> export FINERACT_DEFAULT_TENANTDB_UID=fineract >>>>> export FINERACT_DEFAULT_TENANTDB_TIMEZONE=UTC >>>>> export FINERACT_DEFAULT_TENANTDB_HOSTNAME=localhost >>>>> export FINERACT_DEFAULT_TENANTDB_NAME=fineract_default >>>>> export FINERACT_DEFAULT_TENANTDB_PWD=mypassword >>>>> export FINERACT_USER=fineract >>>>> export FINERACT_GROUP=fineract >>>>> export FINERACT_DEFAULT_TENANTDB_DESCRIPTION=GJ_Microfinance >>>>> export JAVA_TOOL_OPTIONS="-Xmx1G -XX:MinRAMPercentage=25 >>>>> -XX:MaxRAMPercentage=80 -XX:TieredStopAtLevel=1 -XX:+UseContainer >>>>> Support -XX:+UseStringDeduplication >>>>> --add-exports=java.naming/com.sun.jndi.ldap=ALL-UNNAMED >>>>> --add-opens=java.base/java.lan >>>>> g=ALL-UNNAMED --add-opens=java.base/java.lang.invoke=ALL-UNNAMED >>>>> --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=jav >>>>> a.base/java.security=ALL-UNNAMED >>>>> --add-opens=java.base/java.util=ALL-UNNAMED >>>>> --add-opens=java.management/javax.management= >>>>> ALL-UNNAMED --add-opens=java.naming/javax.naming=ALL-UNNAMED" >>>>> java -Dloader.path=/data/microfinance/libs/ -jar fineract-provider.jar >>>>> >>>>> >>>>> >>>>> On 5/8/24 06:53, Ádám Sághy wrote: >>>>> >>>>> hi >>>>> >>>>> i am having trouble to understand what exactly the issue you are >>>>> facing. >>>>> >>>>> there are NO sql files. Liquibase is used to set up and maintain the >>>>> tables and the initial contents of the databases and these instructions >>>>> are >>>>> in XML files. i have already told you the directories where you can find >>>>> them as well. >>>>> >>>>> fineract_tenants.m_adhoc' doesn't exist >>>>> >>>>> these exception kind of mean your configuration is incorrect due to >>>>> the default tenant database should not be the fineract_tenants. >>>>> >>>>> Please kindly share the version of Fineract you are executing and the >>>>> environment variables you are using (dont forget to change the real >>>>> username and password and url, etc for dummy one before sharing) >>>>> >>>>> Regards, >>>>> Adam >>>>> >>>>> >>>>> export FINERACT_USER=fineract >>>>> export FINERACT_GROUP=fineract >>>>> export FINERACT_DEFAULT_TENANTDB_DESCRIPTION=GJ_Microfinance >>>>> >>>>> java -Dloader.path=/data/mmicrofinance/libs/ -jar fineract-provider.jar >>>>> >>>>> >>>>> Thank you >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>> >
