Hi Chairul
I hope I understood your question correctly - but if you are asking where can
you set the connection parameters for the different tenant databases, please
look at the table tenant_server_connections on the database fineract_tenants
The columns schema_server, schema_server_port, schema_name,
schema_connection_parameters in that table are used to construct the connection
string for each tenant database as follows:
String jdbcUrl =
this.driverConfig.constructProtocol(tenantConnectionObj.getSchemaServer(),
tenantConnectionObj.getSchemaServerPort(),
tenantConnectionObj.getSchemaName(),
tenantConnectionObj.getSchemaConnectionParameters());
So if you want to change the server / schema name for a specific tenant, try
updating the relevant row in the table fineract_tenants.
Hope this helps
Regards
Petri
> On 5 Jan 2021, at 8:55 PM, Chairul Akmal <[email protected]> wrote:
>
> Hi Michael,
>
> Thank you so much for your response.
>
> I think my question was not clear. Sorry about that. What I meant was the
> database (DB) name for the default tenant itself, "fineract_default". Unlike
> for "fineract_tenants" that accept database url (which contains the DB name)
> as env var, FINERACT_DEFAULT_TENANTDB only accept hostname and port. So, my
> question is rather, does fineract require the tenant database to be named
> "fineract_default"? Is there a way to use different tenant DB name without
> changing the codebase?
>
> Thank you for understanding.
>
> Update: Thankfully, I have managed to connect the docker image with database
> (by naming the tenant DB `fineract_default`). There are some problem with
> database migrations where V1 failed with `(SQL State: 42S02 - Error Code:
> 1051)`, looks like related to the jdbc driver. But this is a different
> problem. :)
>
> Cheers,
> Chairul
>
> On 2021/01/04 17:32:11, Michael Vorburger <[email protected]> wrote:
>> Chairul,
>>
>> you're ALMOST ;) there - note how in
>> https://github.com/apache/fineract/blob/develop/docker-compose.yml#L45
>> there is BOTH the fineract_tenants_* but ALSO the
>> FINERACT_DEFAULT_TENANTDB_* env vars? The latter is what you are looking
>> for!
>>
>> HTH & makes sense?
>>
>> M.
>>
>> PS: Would someone be willing to contribute better documentation about this?
>> Ideally via a PR to
>> https://github.com/apache/fineract/blob/develop/README.md, or
>> https://github.com/apache/fineract/tree/develop/fineract-doc/src/docs/en.
>>
>> _______________________
>> Michael Vorburger
>> http://www.vorburger.ch
>>
>>
>> On Mon, Jan 4, 2021 at 5:42 PM Chairul Akmal <[email protected]>
>> wrote:
>>
>>> Hi folks,
>>>
>>> I am a new fineract user and have been recently trying to deploy fineract
>>> 1.4.0 on Digital Ocean. The plan that I currently have is to deploy
>>> apache/fineract docker image and connect to managed MySQL database from
>>> Digital Ocean. However, I have been struggling with connecting fineract
>>> with the non-local database.
>>>
>>> I understand that there are ways to modify the `fineract_tenants` database
>>> from environmental variables (e.g. in docker-compose.yml), however can I do
>>> the same with `fineract_default`? The way I see it, `fineract_default` is
>>> hard-coded a lot in source code and I wanted to modify it, unfortunately I
>>> can't find any documentations on fineract database setup/schema. I tried
>>> googling around for old mifos documentations but most of them are
>>> deprecated or inaccessible anymore.
>>>
>>> Cheers,
>>> Chairul
>>>
>>
