[
http://mifosforge.jira.com/browse/MIFOSBI-261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
johnwoodlock resolved MIFOSBI-261.
----------------------------------
Resolution: Fixed
> 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
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
