Hello, I think that fix should go here
https://github.com/apache/fineract/blob/develop/fineract-provider/build.gradle task createDB { description= "Creates the MariaDB Database. Needs database name to be passed (like: -PdbName=someDBname)" doLast { def sql = Sql.newInstance( 'jdbc:mariadb://localhost:3306/', mysqlUser, mysqlPassword, 'org.mariadb.jdbc.Driver' ) *sql.execute( 'create database '+"`$dbName`" )* } } Most of the time the MariaDB or MySQL in Docker or Cloud providers use utf8mb4.... but I faced the same problem in RDSAWS last weekend, so then I have to drop the DBs and create them using: CREATE database fineract_default CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE database fineract_tenants CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; About which is more secure to deploy using jar or war, you can ask yourself: which has more pieces (or software components)? that one with more components will have more risk to have a vulnerability and then the patching/evergreening process will require more effort to keep the risks managed (risks never disappear and It must have a risk acceptance/awareness/plans). Regards El mar, 10 ene 2023 a las 3:26, Kigred Developer (< [email protected]>) escribió: > Happy to I was of help. I will do a PR for this. > About the security question, I think either is okay but there are people > here more experienced than me. > I personally use the tomcat server on both local and cloud deployments and > I have not had issues. > Regards. > Wilfred. > > On Tue, 10 Jan 2023, 12:03 Ippez Robert, <[email protected]> wrote: > >> Thanks Wilfred, That has solved the problem and fineract it up and >> running. However, I was wondering if this can be included in the README.MD >> so that anyone can have a reference to when faced with the same so as to >> avoid posting the same to the dev list.. >> >> >> In reference to this, I would like someone to advise me on which method >> of deployment is secure and best for production in Windows environment:- >> 1. Deploying using the jar file and running it as a service >> 2. Deploying in tomcat using the war file >> >> Thanks and regards >> >
