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