Also PR should go for the MySQL database
task createMySQLDB {
description= "Creates the MySQL Database. Needs database name to be
passed (like: -PdbName=someDBname)"
doLast {
def sql = Sql.newInstance( 'jdbc:mysql://localhost:3306/',
mysqlUser, mysqlPassword, 'com.mysql.cj.jdbc.Driver' )
sql.execute( 'create database '+"`$dbName`" )
}
}
El mar, 10 ene 2023 a las 10:07, VICTOR MANUEL ROMERO RODRIGUEZ (<
[email protected]>) escribió:
> 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
>>>
>>
