Hi George,

Have you by any chance changed the passwords for MySQL root on the production server? One of the limitations of the current Pentaho implementation in MifosX is, is that the access credentials for the DB are stored inside the reports. So if you use different usernames/passwords for your root user you should also change them in your reports and update those or obviously change the password for the root user back to the standard.

We have changed the passwords in the reports for security purposes, and in the future we will also make sure reports can be run by the same user as the tenant is setup under.

--

Sander van der Heyden

CTO Musoni Services




Mobile (NL): +31 (0)6 14239505
Mobile (Kenya): +254 (0)707211284
Skype: s.vdheyden
Website: musonisystem.com
Follow us on Twitter! 
Postal address: Hillegomstraat 12-14, office 1.11, 1058 LS, Amsterdam, The Netherlands



On 16 Apr 2014, at 13:16, George Hajjar <[email protected]> wrote:

Hi guys,

I have a Dev and production server. Both running same version of mifosx and same version of mySQL. Only difference between the two servers is that production has SSL. Pentaho reports run fine on Dev but not on production.


On Wed, Apr 16, 2014 at 5:54 PM, Vishwas Babu <[email protected]> wrote:

George,

Which version of MySQL are you using?

Regards,
Vishwas


On 16 April 2014 00:19, <[email protected]> wrote:

Hi George,
Am not able to reproduce the same, for me all pentaho reports are working fine. I will available for next couple of hours you can reach me on skype: lingala.madhukar


On Wednesday, April 16, 2014 10:57:19 AM UTC+5:30, George Hajjar wrote:
Hi Vishwas,

Any update on the error I am getting in all Pentaho reports?


George

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users


------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to