[
http://mifosforge.jira.com/browse/MIFOSBI-261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy updated MIFOSBI-261:
---------------------------------
Status: Ready for Showcase (was: Ready for Testing / Resolved)
Verified on 17.03.2011
Bug has been fixed properly.
> mifos bi etl job should not require (mysql) super user privileges to run
> --------------------------------------------------------------------------
>
> Key: MIFOSBI-261
> URL: http://mifosforge.jira.com/browse/MIFOSBI-261
> Project: mifos business intelligence
> Issue Type: Bug
> Components: Data Warehouse
> Reporter: Sumit Shah
> Assignee: johnwoodlock
> Priority: Critical
> Fix For: Mifos BI 1.2 - Iteration 2, Mifos BI 1.2
>
>
> when invoking the job as a non-super user (but with ALL privs):
> see this error:
> ERROR 1227 (42000) at line 1346: Access denied; you need the SUPER privilege
> for this operation
> when invoking this file:
> /ETL/MifosDataWarehouseETL/load_mifos_datawarehouse.sql
> line 1436 begins with:
> /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE
> `SPcascade_change_to_accounts`(IN current_customer_key int, IN
> effective_date_param date, IN new_customer_key int,
> IN new_group_key int, IN new_center_key int, IN new_loan_officer_key int, IN
> new_branch_key int,
> i believe DEFINER should be CURRENT_USER
> there are other places in that file with similar code.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
