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