Re: Default databse script for a brand new install

2024-05-31 Thread James Dailey
Adam - should this go into a tech FAQ in the documentation? Thanks Sent from Gmail Mobile On Mon, May 27, 2024 at 1:08 AM Ádám Sághy wrote: > Hi > > Based on the error log you have shared, you have misconfigured something: > > m_adhoc table should not be created in the fineract_tenants

Re: Default databse script for a brand new install

2024-05-27 Thread Ádám Sághy
HiBased on the error log you have shared, you have misconfigured something:m_adhoc table should not be created in the fineract_tenants database.Probably you have wrong configuration in the "fineract_tenants.tenants_configuration" table.You might already done it but let me share usually how it

Re: Default databse script for a brand new install

2024-05-27 Thread Joan Moreau
Hi his is absolutely incredible The tables ARE NOT created automatically by Liquid. Whatever you are all repeating. and I sent already the log of it. So my question is : How to enable the creation of the tables, or just please share the sql statement to create those table and avoid the

Re: Default databse script for a brand new install

2024-05-26 Thread Naphlin Peter
A good starting place is https://www.udemy.com/course/liquibase/ Since you are paying your money for it, you will have all the right to question if they are junks; if you still fail to understand that is. Quite frankly the people on this thread have been more than nice and genuine to you. On

Re: Default databse script for a brand new install

2024-05-26 Thread Mark Salter
On 26/05/2024 15:41, Joan Moreau wrote: Really, are you a bunch of junks ? You are being rude, I would have dropped you into my ignore bucket after your first couple of replies not answer the question asked of you. You also do not seem to be reading the many detailed answers Victor and

Re: Default databse script for a brand new install

2024-05-26 Thread Joan Moreau
Really, are you a bunch of junks ? I am genuinely asking on creating initial tables, no ine is able to say "here is the actual process" On 26 May 2024 02:28:32 VICTOR MANUEL ROMERO RODRIGUEZ wrote: :) El sáb., 25 de mayo de 2024 7:21 a. m., Joan Moreau escribió: Hi No tables are

Re: Default databse script for a brand new install

2024-05-25 Thread Mark Salter
On 25/05/2024 19:28, VICTOR MANUEL ROMERO RODRIGUEZ wrote: :) Perfect response, and more than was warranted really :-) -- Mark signature.asc Description: OpenPGP digital signature

Re: Default databse script for a brand new install

2024-05-25 Thread VICTOR MANUEL ROMERO RODRIGUEZ
:) El sáb., 25 de mayo de 2024 7:21 a. m., Joan Moreau escribió: > Hi > > No tables are created obsivously, and nothing in the docs related to > creating the initial table > > If you have a pointer to the process of creating the tables, that would be > very helpful instead of "read the doc" > >

Re: Default databse script for a brand new install

2024-05-25 Thread Joan Moreau
Hi No tables are created obsivously, and nothing in the docs related to creating the initial table If you have a pointer to the process of creating the tables, that would be very helpful instead of "read the doc" On 2024-05-15 22:32, VICTOR MANUEL ROMERO RODRIGUEZ wrote: Hello Joan,

Re: Default databse script for a brand new install

2024-05-15 Thread VICTOR MANUEL ROMERO RODRIGUEZ
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 () escribió: > Ok but how to finally be

Re: Default databse script for a brand new install

2024-05-15 Thread Joan Moreau
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

Re: Default databse script for a brand new install

2024-05-13 Thread VICTOR MANUEL ROMERO RODRIGUEZ
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

Re: Default databse script for a brand new install

2024-05-12 Thread Joan Moreau
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

Re: Default databse script for a brand new install

2024-05-07 Thread Ádám Sághy
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

Re: Default databse script for a brand new install

2024-05-07 Thread VICTOR MANUEL ROMERO RODRIGUEZ
Joan, In short words, there is no SQL script. Read the emails and references provided. Regards El mar, 7 may 2024 a las 16:38, Joan Moreau () escribió: > Hi Adam > > thank you for your answer > > But I do not see any Sql script there. > > Where exactly is the initial schema to start Fineract ?

Re: Default databse script for a brand new install

2024-05-07 Thread Joan Moreau
Hi Adam thank you for your answer But I do not see any Sql script there. Where exactly is the initial schema to start Fineract ? I am surely not the only person trying just o start the engine Thank you in advance On 7 May 2024 22:56:14 Ádám Sághy wrote: hi you can find it multiple

Re: Default databse script for a brand new install

2024-05-07 Thread Ádám Sághy
hi you can find it multiple places :) fineract-provider/src/main/resources/db/changelog is the common one, - where “tenant-store” directory contains the liquibase scripts to build the tenant store tables and entries (fineract_tenants database) - where “tenant” directory contains the liquibase

Re: Default databse script for a brand new install

2024-05-07 Thread Joan Moreau
Hi Would really appreciate to know where to find the mariadb schema to upload before starting the process For now, it asks for tables that of course do bot exist as never created Thank you very much in advance On 6 May 2024 16:38:01 Joan Moreau wrote: I copied paste all the variables ,

Re: Default databse script for a brand new install

2024-05-06 Thread Joan Moreau
I copied paste all the variables , fixing the _tenants  into _default I still get to Caused by: java.sql.SQLSyntaxErrorException: (conn=385204) Table 'fineract_tenants.m_adhoc' doesn't exist     at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289)     at

Re: Default databse script for a brand new install

2024-05-06 Thread Joan Moreau
You send me a link to XML files I just need (a) the actual (real ones !!! not some approximate names) variable to set (b) where is the damn default schema to create the initial tables On 2024-05-06 16:09, VICTOR MANUEL ROMERO RODRIGUEZ wrote: Hello Joan, Apache Fineract uses Liquibase,

Re: Default databse script for a brand new install

2024-05-06 Thread Joan Moreau
The easy way would be just to know (1) What variable to set (2) with which values for a normal user (no docker, no fancy stuff, just a Unix server and a MariadDB) (3) where is that damn mariadb schema to create to enable the app to start On 5/6/24 16:04, Joan Moreau wrote: Note: I am

Re: Default databse script for a brand new install

2024-05-06 Thread VICTOR MANUEL ROMERO RODRIGUEZ
Hello Joan, Apache Fineract uses Liquibase, take a look at: https://github.com/apache/fineract/tree/develop/fineract-provider/src/main/resources/db/changelog https://docs.liquibase.com/home.html Apache Fineract variables for MariaDB on Docker are the same as the one used for Native

Re: Default databse script for a brand new install

2024-05-06 Thread Joan Moreau
Note: I am not using docker but a normal server with a normal MariaDB (serving multiple applications) On 5/6/24 16:02, Joan Moreau wrote: 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

Re: Default databse script for a brand new install

2024-05-06 Thread Joan Moreau
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

Re: Default databse script for a brand new install

2024-05-04 Thread VICTOR MANUEL ROMERO RODRIGUEZ
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