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