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