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