Re: Default databse script for a brand new install

[Ádám Sághy]

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