[Mifos-developer] Reports not working in 18.03.01

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso


Virus-free. www.avast.com

Sifiso,

May I know what the date duration is

···

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso


Virus-free. www.avast.com

Santosh,

I have tested dates varying between January last year and August 2018.

···

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

Virus-free. www.avast.com

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena

aging-repo.png

fund-repo.png

···

From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

HI Team ,
The failed reports is because of the MySQL version … error is “Sql injection error” affecting MySQL version 5.6 but works ok with version 5.5

regards

···

On Wed, Aug 1, 2018 at 12:37 PM Agness Meena agness@singo.africa wrote:

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena


From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer


Check out the vibrant tech community on one of the world’s most

engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list

mifos-developer@lists.sourceforge.net

Unsubscribe or change settings at:

https://lists.sourceforge.net/lists/listinfo/mifos-developer

Freddie Koskey

I am using mysql v 5.6 and those reports works fine locally.

Regards

Agness Meena

···

From: “Freddie Koskey” kyfredy@gmail.com
To: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:47:05
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

HI Team ,
The failed reports is because of the MySQL version … error is “Sql injection error” affecting MySQL version 5.6 but works ok with version 5.5

regards

On Wed, Aug 1, 2018 at 12:37 PM Agness Meena agness@singo.africa wrote:

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena


From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer


Check out the vibrant tech community on one of the world’s most

engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list

mifos-developer@lists.sourceforge.net

Unsubscribe or change settings at:

https://lists.sourceforge.net/lists/listinfo/mifos-developer


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

Hi Freddie,

I’m using v5.5 and its they’re not running there either on two localhost machines.

Regards,

···

From: Freddie Koskey kyfredy@gmail.com
Sent: Wednesday, August 1, 2018 11:47 AM
To: Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

HI Team ,

The failed reports is because of the MySQL version … error is “Sql injection error” affecting MySQL version 5.6 but works ok with version 5.5

regards

On Wed, Aug 1, 2018 at 12:37 PM Agness Meena agness@singo.africa wrote:

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena


From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

sifiso

I didn’t change any thing in my database or code

I got it from the normal site https://sourceforge.net/projects/mifos/files/Mifos%20X/ ,

Data tables have some issue, https://issues.apache.org/jira/browse/FINERACT-635 ,

that they are not submitted during creation…, likewise to me

Regards

Agness Meena

···

From: “sifiso” sifiso@skyburgsystems.org
To: “agness” agness@singo.africa
Sent: Wednesday, 1 August, 2018 13:16:22
Subject: RE: [Mifos-developer] Reports not working in 18.03.01

Hi Agness,

Have you changed anything on your local instance in the database or code. Where did you get the .war file that you are running yours. And just out of curiosity are your custom datatables showing any data?

Sifiso

From: Agness Meena agness@singo.africa
Sent: Wednesday, August 1, 2018 11:35 AM
To: mifos-developer mifos-developer@lists.sourceforge.net
Cc: sifiso@skyburgsystems.org
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena


From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

A few reports still throws sql injection errors with mysql 5.6 , what is the solution for this issue?

···

Denis Frimos

Director, Project Architect**|**
ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2nd
Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob:
+255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

       ![](https://docs.google.com/uc?export=download&id=0B93BWZEmOZTsSlNfUFlpRFRFczA&revid=0B93BWZEmOZTsc0dORUJuK1VESy9LeW1hemx2VnkzSlhmKzJNPQ)

Those reports are not working with any version of mysql. I’ve tested the 3 scenarios in 5.5, 5.6 and 5.7. The issue is with the reports themselves like Freddie Koskey pointed out he managed to fix one or two of them because they were not compatible with this version of Mifos 18.03.01.

Kind regards,

Sifiso

···

From: Denis Frimos romeodenis5@gmail.com
Sent: Monday, October 15, 2018 9:31 AM
To: Mifos software development mifos-developer@lists.sourceforge.net
Cc: sifiso@skyburgsystems.org
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

A few reports still throws sql injection errors with mysql 5.6 , what is the solution for this issue?

Denis Frimos

Director, Project Architect** |** ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2nd Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob: +255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

       <img border="0" id="_x0000_i1025" src="https://docs.google.com/uc?export=download&amp;id=0B93BWZEmOZTsSlNfUFlpRFRFczA&amp;revid=0B93BWZEmOZTsc0dORUJuK1VESy9LeW1hemx2VnkzSlhmKzJNPQ">

On Wed, Aug 1, 2018 at 2:12 PM Agness Meena agness@singo.africa wrote:

sifiso

I didn’t change any thing in my database or code

I got it from the normal site https://sourceforge.net/projects/mifos/files/Mifos%20X/ ,

Data tables have some issue, https://issues.apache.org/jira/browse/FINERACT-635 ,

that they are not submitted during creation…, likewise to me

Regards

Agness Meena


From: “sifiso” sifiso@skyburgsystems.org
To: “agness” agness@singo.africa
Sent: Wednesday, 1 August, 2018 13:16:22
Subject: RE: [Mifos-developer] Reports not working in 18.03.01

Hi Agness,

Have you changed anything on your local instance in the database or code. Where did you get the .war file that you are running yours. And just out of curiosity are your custom datatables showing any data?

Sifiso

From: Agness Meena agness@singo.africa
Sent: Wednesday, August 1, 2018 11:35 AM
To: mifos-developer mifos-developer@lists.sourceforge.net
Cc: sifiso@skyburgsystems.org
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Hi sifiso

Thats true for Demo

But works fine in local(version v18.03.01 ),

see the attachment…

thanks

Regards

Agness Meena


From: sifiso@skyburgsystems.org
To: “Santosh Math” santosh@confluxtechnologies.com
Cc: “mifos-developer” mifos-developer@lists.sourceforge.net
Sent: Wednesday, 1 August, 2018 12:03:12
Subject: Re: [Mifos-developer] Reports not working in 18.03.01

Santosh,

I have tested dates varying between January last year and August 2018.

From: Santosh Math santosh@confluxtechnologies.com
Sent: Wednesday, August 1, 2018 10:47 AM
To: Sifiso Mtetwa sifiso@skyburgsystems.org
Cc: Sampath Kumar G sampath@confluxtechnologies.com; Ed Cable edcable@mifos.org; Mifos software development mifos-developer@lists.sourceforge.net
Subject: Re: Reports not working in 18.03.01

Sifiso,

May I know what the date duration is

On Wed 1 Aug, 2018, 1:52 PM , sifiso@skyburgsystems.org wrote:

Hi Santosh,

The pentaho and stretchy reports for Funds Disbursed Between Dates Summary by Office and Aging Summary (Arrears in Months) are not showing. This only occurs in v18.03.01 for only these reports and I have reproduced the same on the demo server.

Please advise.

Kind regards,

Sifiso

https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif

Virus-free. www.avast.com


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Mifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer


Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotMifos-developer mailing list
mifos-developer@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

Any Report with names which contains strings like !=, =, >, <, like , between , in , in( , is , is not , equals , not equals will fail,

The problem seems to be caused by commit CVE-2018-1290-1291-1292 , which validates **Report Name for **sql injections.

···

Denis Frimos

Director, Project Architect**|**
ICTPACK SOLUTIONS LTD.

Victoria Green Acres Complex, 2nd
Floor, New Bagamoyo Rd | P.O. Box 78178, Dar-es-salaam, Tanzania

Tel: +255 22 276 2015 | Mob:
+255 717 02 0845 | Skype: denis frimos

Website: www.ictpack.com | Follow Us: Twitter | Facebook | LinkedIn

       ![](https://docs.google.com/uc?export=download&id=0B93BWZEmOZTsSlNfUFlpRFRFczA&revid=0B93BWZEmOZTsc0dORUJuK1VESy9LeW1hemx2VnkzSlhmKzJNPQ)

@Denis
This is very helpful, And is a key word in SQL so report names with this word with fail too

Any Report with names which contains strings like !=, =, >, <, l ike , between , in , in( , is , is not , equals , not equals ,And will fail,