Joan, In short words, there is no SQL script. Read the emails and references provided.
Regards El mar, 7 may 2024 a las 16:38, Joan Moreau (<j...@grosjo.net>) escribió: > Hi Adam > > thank you for your answer > > But I do not see any Sql script there. > > Where exactly is the initial schema to start Fineract ? > > I am surely not the only person trying just o start the engine > > Thank you in advance > > > > > On 7 May 2024 22:56:14 Ádám Sághy <adamsa...@gmail.com> wrote: > >> hi >> >> you can find it multiple places :) >> >> fineract-provider/src/main/resources/db/changelog is the common one, >> - where “tenant-store” directory contains the liquibase scripts to build >> the tenant store tables and entries (fineract_tenants database) >> - where “tenant” directory contains the liquibase scripts to build the >> tenant tables (fineract_default database) >> >> Also we started to modularize the Fineract, so you might found additional >> liquibase scripts int the modules >> (like: fineract-loan/src/main/resources/db/changelog/tenant/module/loan) >> >> Liquibase is by default enabled, so it should be executed when you are >> running the application as jar or as bootRun, unless you are executing >> Fineract with "liquibase-only” profile or FINERACT_LIQUIBASE_ENABLED >> environment variable is set to FALSE. >> >> I hope it helps. >> >> The above details are applicable to the latest version of Fineract >> (apache/develop, 1.8.0 and 1.9.0 if i remember correctly ) >> >> Regards, >> Adam >> >> On 7 May 2024, at 16:47, Joan Moreau <j...@grosjo.net> wrote: >> >> Hi >> >> Would really appreciate to know where to find the mariadb schema to >> upload before starting the process >> >> For now, it asks for tables that of course do bot exist as never created >> >> Thank you very much in advance >> >> On 6 May 2024 16:38:01 Joan Moreau <j...@grosjo.net> wrote: >> >>> I copied paste all the variables , fixing the _tenants into _default >>> >>> I still get to >>> >>> Caused by: java.sql.SQLSyntaxErrorException: (conn=385204) Table >>> 'fineract_tenants.m_adhoc' doesn't exist >>> at >>> org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289) >>> at >>> org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378) >>> >>> >>> I really need to know where is the initial schema to create the required >>> tables in MariaDB >>> >>> Thank you in advance >>> >>> >>> On 5/6/24 16:19, Joan Moreau wrote: >>> >>> You send me a link to XML files >>> >>> >>> I just need >>> >>> (a) the actual (real ones !!! not some approximate names) variable to set >>> >>> (b) where is the damn default schema to create the initial tables >>> >>> >>> >>> On 2024-05-06 16:09, VICTOR MANUEL ROMERO RODRIGUEZ wrote: >>> >>> Hello Joan, >>> >>> Apache Fineract uses Liquibase, take a look at: >>> >>> >>> https://github.com/apache/fineract/tree/develop/fineract-provider/src/main/resources/db/changelog >>> https://docs.liquibase.com/home.html >>> >>> Apache Fineract variables for MariaDB on Docker are the same as the one >>> used for Native installations, just try them. Please read files included in >>> the PR that I have shared, there is a startup script on it. >>> >>> Regards >>> >>> >>> >>> >>> El lun, 6 may 2024 a las 2:04, Joan Moreau (<j...@grosjo.net>) escribió: >>> >>> Note: I am not using docker but a normal server with a normal MariaDB >>> (serving multiple applications) >>> >>> >>> On 5/6/24 16:02, Joan Moreau wrote: >>> >>> Also, the variable you mentioned do not fit the variables available in >>> the source code >>> >>> >>> In addition to teh start-up schema, where to have the actual variable to >>> set to start Fineract ? >>> >>> >>> On 5/6/24 16:00, Joan Moreau wrote: >>> >>> Thank you but that does not answer the question: >>> >>> - Where to find the initial database schema to create the initial >>> tables ? >>> >>> Thank you very much >>> >>> >>> On 5/5/24 10:20, VICTOR MANUEL ROMERO RODRIGUEZ wrote: >>> >>> Hello, >>> >>> 1. No, you can use any user that you require (root, fineract, >>> mariadbuser, customeuser, exampleuser... etc). >>> 2. Database names are defined in these variables (please notices that >>> there is a difference tenantS and tenant ) : >>> FINERACT_TENANTS_DB_NAME - For tenants database >>> FINERACT_TENANT_DEFAULT_DB_NAME - for the default database >>> 3. You are setting the values of the database in a mixed way, you have >>> set variables for the default tenant as tenants and tenants as default >>> database. >>> >>> By the way if you are using the develop branch or previous version >>> (since 1.6) mariaDB is the supported database (also PostgreSQL since >>> version 1.7.0), if you use MySQL you could face some issues. >>> >>> If you require to use MariaDB check this docker compose as reference: >>> >>> https://github.com/apache/fineract/blob/develop/docker-compose.yml >>> >>> And these are the variables linked to that docker compose. >>> >>> >>> https://github.com/apache/fineract/blob/develop/config/docker/env/fineract.env >>> >>> https://github.com/apache/fineract/blob/develop/config/docker/env/fineract-common.env >>> >>> https://github.com/apache/fineract/blob/develop/config/docker/env/fineract-mariadb.env >>> >>> In this PR you can take a look how to start the Apache Fineract jar file >>> >>> https://github.com/apache/fineract/pull/3879/files >>> >>> java -jar fineract-provider-*.jar -Duser.home=/tmp >>> -Dfile.encoding=UTF-8 -Duser.timezone=UTC -Djava.security.egd= >>> file:/dev/./urandom >>> >>> Best regards >>> >>> Victor >>> >>> >>> >>> El sáb, 4 may 2024 a las 8:55, Joan Moreau (<j...@grosjo.net>) escribió: >>> >>> Hi >>> >>> Where is stipulated the default schema of the mysql database ? >>> >>> I face 3 issues >>> >>> 1 - The software seems to need to create databases as root (?) >>> >>> 2 - It seems databases MUST be named fineract_tenants and >>> fineract_default. How to change that behavior ? >>> >>> 3 - When I put the database user to have rights on those 2 databases, it >>> ends-up with an error : >>> >>> liquibase.exception.DatabaseException: (conn=7381) Table >>> 'fineract_tenants.m_adhoc' doesn't exist [Failed SQL: (1146) ALTER TABLE >>> `fineract_tenants`.`m_adhoc` CHANGE `IsActive` `is_active` TINYINT] >>> >>> >>> How to initiate properly a brand new install ? >>> >>> I have the following script to start fineract: >>> >>> #!/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=GMT+0 >>> export FINERACT_DEFAULT_TENANTDB_HOSTNAME=localhost >>> export FINERACT_DEFAULT_TENANTDB_NAME=fineract_tenants >>> export FINERACT_DEFAULT_TENANTDB_PWD=mypassword >>> 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 >>> >>> >>> >> >> >
